… – it could be network (especially if replicating over unreliable long distance networks), MySQL bugs on master or slave, hardware problems and few others…) you may want to let replication continue from the new position or resync the slaves to the master. How can you recover the…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
Sometimes MySQL Replication may run out of sync – because of its own buts … Master. To discover the difference between Master and Slave you can use excellent Maatkit tool though if you you just need to resync…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
…context availability means purely “Uptime” not redundancy. “Since Master-Master rely on replication and replication as no built-in self-healing, it is …(online device verification, replication event checksums, fast resync after a node has been offline), and I wish that MySQL Replication had the same …
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… the colo that would use mysql replication to keep as closely up to date as possible with the master server at the colo… does it take to resync the master with the slave? Can the slave simply become the master and the master now be considered the…
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… on single node only such as disk failing in RAID, resync initiated, BBU starting “learning” are just some IO related examples…
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
… best if MySQL Replication would not break in case of power failure and have single command ways to resync slave from the master (or… lot with replication safety and deal between Google and MySQL may mean we will see results of those efforts in MySQL mainline 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… example there is Replication since MySQL 3.23 but there is still not out of the box ways to check master is in sync with slave or resync…
