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 Statement

13.4.2.6 RESET SLAVE Statement

13.4.2.7 SOURCE_POS_WAIT() Statement

13.4.2.8 START REPLICA Statement

13.4.2.9 START SLAVE Statement

13.4.2.10 STOP REPLICA Statement

13.4.2.11 STOP SLAVE 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 STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For information about these statements, see Section 13.7.7.35, “SHOW REPLICA STATUS Statement”, and Section 13.7.7.32, “SHOW RELAYLOG EVENTS Statement”.