…with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is…stand longer fallback time (as with DRBD) but would not like to have lost transactions which may happen with async replication. …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and… from the server if it gets too delayed with replication (or if replication breaks) so you do not have to do it…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
…-level replication to maintain a standby/failover MySQL system, and there was a failover that didn’t work; both the primary and fallback… replication. DRBD would behave just the same way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL… my experience, the types of errors that will propagate through replication are much more common than those that’ll be isolated…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… for master-N-slaves systems but I find Master-Master replication much better approach in many cases. Kevin Writes “It requires… of Master-Master replication are the following It is more simple especially if you just write to one node fallback and recovery… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… performance. DRBD however could be used together with MySQL Replication to increase High Availability – MySQL Replicaion is asynchronous so if master is lost… if master is replicated by DRBD you can avoid loosing any tranactions. It also greatly simplifies slave fallback which can be as…
