… with Master. To discover the difference between Master and Slave you can use excellent Maatkit tool though if you you just need to resync… having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children allowed… you do not want to shut down the master and slave. If you need quick resync of large amount of data it is…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… bug in the master‘s or slave‘s MySQL code. If you want to check the master‘s binary log or slave‘s relay log… network (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 affected…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… we apply them to MySQL replication we can use these simplified principles – we only will failover from Master to Slave but never fail back without manual intervention. We also will failover only when replication is caught up (wait for slave… on single node only such as disk failing in RAID, resync initiated, BBU starting “learning” are just some IO related examples…
Comment: MySQL Replication vs DRBD Battles
June 30, 2008 By 12 Comments
hello, we are debating DRBD vs MySqL replication. The idea would be two servers, one master, one slave running drbd. Second server would… take to resync the master with the slave? Can the slave simply become the master and the master now be considered the hot spare slave that will…
Comment: Is DRBD the right choice for me?
March 14, 2012 By 18 Comments
… experienced with MySQL replication is resyncing a master and slave on a database with high write activity. Locking the master and dumping the master database via… limiting or halting all write activity on the master. This essentially places the master ‘out of service’ which is not ideal for…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… MySQL Replication would not break in case of power failure and have single command ways to resync slave from the master (or from the slave… a lot with replication safety and deal between Google and MySQL may mean we will see results of those efforts in…
Comment: MySQL Pays attention to Bugs (Finally!)
May 21, 2009 By 5 Comments
… database adding views, triggers, stored procedures etc which is what MySQL “core” market did not need so much. At the same… since MySQL 3.23 but there is still not out of the box ways to check master is in sync with slave or resync…
