13.4.2 SQL Statements for Controlling Replica Servers

13.4.2.1 CHANGE MASTER TO Statement

13.4.2.2 CHANGE REPLICATION FILTER Statement

13.4.2.3 CHANGE REPLICATION SOURCE TO Statement

13.4.2.4 MASTER_POS_WAIT() Statement

13.4.2.5 RESET REPLICA | SLAVE Statement

13.4.2.6 RESET SLAVE | REPLICA Statement

13.4.2.7 SOURCE_POS_WAIT() Statement

13.4.2.8 START REPLICA | SLAVE Statement

13.4.2.9 START SLAVE | REPLICA Statement

13.4.2.10 STOP REPLICA | SLAVE Statement

13.4.2.11 STOP SLAVE | REPLICA Statement

13.4.2.12 Functions which Configure the Source List

This section discusses statements for managing replica servers. Section 13.4.1, “SQL Statements for Controlling Source Servers”, discusses statements for managing source servers.

In addition to the statements described here, SHOW REPLICA | SLAVE STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For information about these statements, see Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”, and Section 13.7.7.32, “SHOW RELAYLOG EVENTS Statement”.