…slave s1> stop slave; s1> reset slave all; # For s0 s0> change master to master_host=’127.0.0.1′,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… later we need to promote a Slave to Master we will need to do some steps to enable all the events replicated from the master because as we… DISABLE ON SLAVE DO INSERT INTO t VALUES(YEAR(CURDATE())); These are the steps we need to do to enable on the promoted slave. We should disable the event manager on Slave with SET GLOBAL event…
Comment: When would you use SAN with MySQL ?
March 20, 2009 By 18 Comments
… multiple slaves is that you have difficulty promoting a slave to master because the other slaves are holding references to the original files in the old master‘s… other solutions mentioned above (like DRBD); however, I think the slave promotion problem is a substantial reason for the popularity of MMM…
Comment: How reliable RAID really is
July 2, 2006 By 13 Comments
… some tests I’ve done I found RAID5 to perform _faster_ or close to RAID10 on PowerEdge 2850 for example. You can… make much sense but I’m not only the person to observe this behavior. Here are some benchmarks for SQL Server… the slaves so you do not have to reclone them whenever any drive fails also this means you can promote slave to the master without running master…
Comment: Emulating global transaction ID with pt-heartbeat
November 14, 2011 By 6 Comments
Why wouldn’t you just recommend Tungsten Replicator in this case? It has global IDs and covers this case as well as normal slave-to-master promotion very well. Even when you know roughly where to look, matching logs is very tedious and could result in prolonged downtime for busy systems.
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… VIPs behaviors similar to MMM If the master fails, a new master is promoted from the slaves, no master to master setup needed. Selection of master is based on scores published by the slaves, the more up to date slaves…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… the master and you need to pick the most up to date to promote. Plus you need to recompute positions as they should be on promoted slave and slave… that and simply point slaves to the starting position of the promoted master – this is dangerous because you’re risking all slaves to be inconsistent withe…
Comment: MySQL Master-Master replication manager released
April 6, 2007 By 27 Comments
…’ll have to take a look. Sounds a little bit like lbpool. We’ve been working on automatic master promotion and it should… a series of slaves and the clients can promote a master. Then that master can fail and the clients can promote a new master. The cool thing is that since any slave can…
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
… and gets replicated to all the slaves ?” Sure… but this is a non sequitor because we’re dealing with master promotion design here. “Handling write load If your application is write intensive master-N-slave configuration will be saturated… writes this way. Each shard has a single master and two slaves that can be promoted to master. We can just create as many shards…
