… difference between Master and Slave you can use excellent Maatkit tool though if you you just need to resync small single table… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed… not want to shut down the master and slave. If you need quick resync of large amount of data it is much…

… (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others. In any case… from the new position or resync the slaves to the master. How can you recover the slave ? As all slaves are likely to be… to resync them. Last method works in particularly well in case you can afford to run for a while with slaves which…