1. on all replicating slaves issue:
\nSTOP SLAVE;<\/p>\n
2. on the slave that will be master there should be no binary logs floating around. issue:
\nRESET MASTER;<\/p>\n
3. change the ip address of the new master to that of the old (or not, and update your clients instead)<\/p>\n
4. on the replicating slaves issue
\nCHANGE MASTER TO (with connection info but no log file or position)
\nthen
\nSTART SLAVE;<\/p>\n","protected":false},"excerpt":{"rendered":"
1. on all replicating slaves issue: STOP SLAVE; 2. on the slave that will be master there should be no binary logs floating around. issue: RESET MASTER; 3. change the ip address of the new master to that of the … Continue reading