…SLAVE STATUS’ on this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error… executed on the slaves. Skipping around event makes master and slave potentially inconsistent and you…lot) or skip bad events as described and when use Maatkit mk-table-…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…slave to be synced with Master. To discover the difference between Master and Slave you can use excellent Maatkit…table. In the applications which are error tolerant (like handle errors properly) you may rename … sec) Records: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…Slave with delayed replication (which you already could have set up with mk-slave-delay from Maatkit. Delayed slave…Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… to see how broad is it. We let Slave to replicate with skip-slave-errors=1105 to see if we get any other problems… us to simply to hook up old MySQL 5.0 and all it slaves as a slave off new master and keep it… MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL 5.0 to 5.1 Also, Maatkit…
