Recipe to promote a slave to a master for simple replication.

On Master:

1. FLUSH LOGS;

On Slave:

1. STOP SLAVE;
2. RESET MASTER;
3. Optional: CHANGE MASTER TO MASTER_HOST='';ql

Failing over from one node to the other:

Both nodes have been configured with the slave replication access as well as root and joomla access. If you do not know the info look in /mysql_data/master.info on the current master for those values.

On the slave:

mysql> stop slave io_thread;
mysql> show process list.

You want to wait until you see "Has ( Read more... )