Toolserver:Admin:Change the replication master

Before you change the master, you need the new master position. It's usually in the server admin log, but if not, ask for it in. If the master was changed by the WMF-guys because of a schema-change it is important to wait until the (then) old master was modified by the WMF-guys too.

If the master host changed
If the master is changing, you need to reconfigure SQL-Proxy to use the new master. Then choose one of the following options, based on the replication type.

For a MySQL-replicated cluster

 * Stop the MySQL slave:
 * Change the MySQL master position:
 * Restart replication:

For a trainwreck-replicated cluster

 * Stop the appropriate trainwreck instance:
 * Wait for the reader and writer threads to exit
 * Delete the file, which will be in the   defined in.
 * Run trainwreck manually:
 * Stop it:
 * Start it properly:

Category:Admin:Database