… regular replication, built-into the system, which can be aided by Maatkit or Google MMM. Is that what you call “simple replication“? what… consider? is there a definite-best howto for building a master-slave duo? I sort of understand how the failover works, just not sure about how the fallen master becomes slave and resyncs and all… Any chance you would…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… clogs the binary log and slows replication down. If the load takes 4 hours on the master, it will cause the slave… code is pretty simple and I’ve included it in Maatkit just for fun. (It’s unreleased as of yet, but… can get it with the following command: “wget http://www.maatkit.org/trunk/fifo”). So how did it work? Did it…
Comment: Living with backups
November 7, 2008 By 28 Comments
… of things – good replication (and lag monitoring) – checks to ensure master and slaves are fully in sync. With maatkit now able to do non-intrusive checks we’ve been checking many replication…
Comment: MySQL Pays attention to Bugs (Finally!)
May 21, 2009 By 5 Comments
… 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 them (maatkit or Google patches have solution for…
