O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »
If you need to include additional columns on the slave that the master doesn’t have—for example, to record timestamps or add routing or other localized data—you can add columns to a table on a s...
If a table on your slave becomes corrupt either through error or accident (e.g., a user deletes the data), you can use replication to recover the data. Do so by creating a temporary table on the maste...
If your slave stops without warning and there is an error message, consult the documentation about the likely causes of the error and perform any repairs necessary.
Once you have corrected the error,...
MySQL Cluster is a shared-nothing, distributed node architecture storage solution designed for fault tolerance and high performance. Data is stored and replicated on individual data nodes (sometimes c...
Once in a while you may encounter a replication problem that you cannot solve without outside help. Even if you do not have a support agreement in place, you can report a bug for the MySQL release you...
To pause replication, execute the following steps on each of your master servers, starting with the prime master (the first master):
On the master:
Run the FLUSH TABLES WITH READ LOCK command.
Run t...
The following is a stepwise procedure you can use when attacking replication problems.
Note: You should write down or electronically record all observations while you conduct this procedure. Seeing ...
Here are the tools required to diagnose replication problems along with a few suggestions about how and when to use each:
SHOW MASTER STATUS and SHOW SLAVE STATUS
These SQL commands are your primary ...
MySQL replication is asynchronous, a type of replication particularly suitable for modern applications such as websites.
To handle a large number of reads, sites use replication to create copies of t...
MySQL replication is a very stable feature but like any computing solution things can go wrong. Sometimes the problems are not manifested with descriptive error messages (are they ever?) and sometimes...