…mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…a node will promoted to master. There are not many requirements regarding the MySQL configuration, Pacemaker will automatically add “skip-start-slave” for a … is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication updates, it may cause failover issues. Also, …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…promote a slave as master to replace one of the masters but the replication was still catching up… so some events from the replaced master still had to…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
…MySQL Replication when your master goes down it is possible for some writes to be executed on the master, but not on the slave, which gets promoted to… Replication makes it possible to identify the objects which were changed on the Master after failover to Slave happened and they can be dumped to …
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…failover to the slave and repeat the alter table on the other server. Those online schema change are easier when a master to master topology is used. The following figure summarize the simplest HA architecture using MySQL replication. All writes are going to the master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you’ve promoted your better-ness in the meantime, you might have to do some … ALTER TABLE — a typical reason to think about master-master with failover and failback for maintenance. As…replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master…
Comment: Is DRBD the right choice for me?
July 7, 2009 By 18 Comments
…to recheck if there are any inconsistences between master and slave following failover…master crashes you should be able to catch up the events from the binary log replicated by DRBD before promoting the slave to the master…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… continue to operate independently. You can use this in master-slave mode, and it brings back failover and slave promotion issues like you have with MySQL replication, but Galera is still better than MySQL replication so…
