… main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to… failover. With GTIDs, all the operations are straightforward: #For s2 (the new master), we remove its configuration as a slave s1> stop slave; s1> reset slave all; # For s0 s0> change master to master…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… I would recommend automated failover for large systems only. If I’m looking not at one Master-Slave pair but at 1000… – we only will failover from Master to Slave but never fail back without manual intervention. We also will failover only when replication is caught up (wait for slave to…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions… is probably the best general-purpose way to get fast failover and a bunch of other benefits (non-blocking ALTER TABLE… TCP sniffer or anything else. But if you need fast failover, you need some way to at least partially emulate a…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
… is amazing. The concern about long crash recovery times after failover with InnoDB and DRBD can be resolved. One method to… allows hierarchical replication and transparent slave failover. We are trying to redo support for hierarchical replication and transparent slave failover with global transaction IDs.
Comment: Recovery beyond data restore
August 3, 2008 By 11 Comments
…, master log pos) and global transaction IDs. This will allow slave failover to be done by running a few SQL commands with…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… etc which makes failover process tricky. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging and… without loosing last committed transactions but failover process is still complicated and you still can have slaves lagging as semi synchronous replication…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… slave and then, once done, we let the slave catch up with the master using the new table schema, we failover to the slave… failover slave are not cold Online schema changes Low impact backups Automatic failover with replication I already mentioned that for best HA levels, failover… recovery should be automatic. There are tools to manage automatic failover with replication like MMM, Flipper and Tungsten. Here, I will…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… skip the statements by stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again. This method is not really… the process because high availability tools like mmm can cause failover if you stop replication # mmm_control @production set_passive (to avoid automatic failover) 2. stop replication on the master having writer role (mysql1…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…-balancing and failover features, but these features don’t seem to measure slave lag. They seem to assume that all slaves are ready…, then the wrapper class chooses another slave. No slave is chosen more than once. If no slaves pass the tolerance test, then the… failover capability. For example tables used for logging less critical information. In this scenario, not all queries could scale out to slaves…
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… the event of a catastrophic failure. EBS Failover I have seen EBS volume failover used as a viable HA option within a… resides. Being asynchronous, there is always a potential for some slave lag, but 1-2 seconds of lost transactions (which may… datacenter and planning accordingly. Expect failures and simulate/test your failover procedures so you can be confident the next time #ec2pacolypse…
