… slave is not running. Here is what I’m adding. colocation col_ms_mysql_failover-ip inf: ms_mysql failover-ip order ord_failover-ip_ms_mysql inf: failover-ip ms_mysql Here is…:heartbeat:IPaddr \ params ip=”192.168.2.200″ \ operations $id=”failover-ip-operations” \ op monitor start-delay=”0″ interval=”2″ \ meta…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
Comment: Finding your MySQL High-Availability solution – Replication
January 7, 2010 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… used. — Please describe this a bit more. What does “failover to the slave” mean? How will master get synchronized with new slave scheme?
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… password for the above user max_slave_lag: The maximum allowed slave lag in seconds, if a slave lags by more than that… setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover issues. Also, the solution relies on the read_only setting on the slave so…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
… Database Size”. Yoshinori will also present “Practical Failover Design – Automated, Semi-Automated and Manual Failover”. Additional talks at the Percona Live MySQL… from on MySQL master A (and its slaves) to another MySQL master B (and its slaves) to balance the load and the…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… topologies with multiple tiers filtering and writes to some intermediary slaves people use. For me simple is best. Complex architectures are… have a lot of total memory on the slave farm. Reading from the Slaves The story heard is typically – Web applications often… most of applications having a pair of slaves (even though second slave is available for failover only 99% of the time) is more…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… find all object ids which were modified from the point slave synchronized successfully and retrieve those objects back from the new… identify the objects which were changed on the Master after failover to Slave happened and they can be dumped to local file… again from the master. This of course will require IDEMPOTENT slave mode but otherwise it should work unless you have DDL…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… the box. Also, failover with MySQL replication is far from instantaneous, you still need to wait on the slave fo the Relay… master. You now have two servers, not necessarily with the slave being ahead of the master, which can be fixed, but….e. from the master to the Slave realy log, and from the Relay log to the Slave database. When failing over and…
Comment: MySQL Replication vs DRBD Battles
June 30, 2008 By 12 Comments
… replication. The idea would be two servers, one master, one slave running drbd. Second server would never be live unless the… a failover in the event of an outage. I’m confused by what I’ve read: After a crash, the slave is… does it take to resync the master with the slave? Can the slave simply become the master and the master now be…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… which break replication. The failover node is a hot standby, it’s just not a running slave node from the database’s… CPU cycles on double caching. Even in this case DRBD slave node can’t be called hot because write load often… catch up to last few not committed transactions on the slave. We should spend some time implementing such script sometime which…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…’s list the most common ones: – MySQL replication with manual failover – Master-Master with MMM manager – Heartbeat/SAN – Heartbeat/DRBD – NDB… the way replication is implemented, only one thread on the slave can handle the write operations. If the replication master is…-cores servers and is heavily writing using multiple threads, the slaves will likely not be able to keep up. Replication is…
