… Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication slave the last… can run slave with –sync-binlog and –log-slave-updates so you can see what last statement was executed before the crash and then find…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…MySQL Replication you can use Maatkit to merge the changes after all, also you can review binary logs to see which updates…do transactional log recovery is invisible until you get a crash, …MySQL features which break replication. The failover node is a hot standby, it’s just not a running slave…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…Slave(s) If you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave…update statements worked differently in the new version or you run into some replication… to keep binary logs for some time, …if something happens (like MySQL crashes) you have only one…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…MySQL Replication…log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication…Replication. Slave is where you can expect more problems, especially on high end systems. Slave…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… they should be on promoted slave and slave should have –log-slave-updates enabled so it somethat has copy of master logs. In many cases I… or Slave running out of space, Slave crashing (and loosing its position on master), Replication breakage (or running out of sync) due to MySQL bugs…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…logs on NFS volume – binary logs is exactly the thing you want to survive the server crash…replication – connect the slave to this box the throughput on the Master drops to about 2800 updates…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… the error log after Slave crash while running MySQL 5.1.41 (extra virgin version without XtraDB or Percona Patches) InnoDB: In a MySQL replication slave the… print it. This database was running older MySQL version a while back which was updated to MySQL 5.1 months ago, moved to…
Comment: Thoughts on MySQL Replication
October 16, 2008 By 18 Comments
… prevent a slave from catching up in a timely fashion. The MySQL team needs to redesign replication to scan … fails (crashed table, aborted or other issue). My suggestion would be to write the query to a log file… B, but only after table B has been updated in the proper order). On the master, though, …
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…log corruption – Binary log may become corrupted and out of sync with database content. This will sometimes break replication… option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0… some of updates totally lost. The safe approach it to reclone the slaves if they crash or…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
…logs. This requires the data to be same on Master and Slave. When you restart the slave… on the slave. ROW replication will complain about ROW not exist for UPDATE or DELETE …SLAVE will not restart normally – power goes down MySQL crashes etc. If you however are using MEMORY table in replication…
