Command Reference for Multi source replication
CHANGE MASTER ['connection_name'] TO ..
. This creates or modifies a connection to a master.SHOW SLAVE ['connection_name'] STATUS ... Show status of connection
SHOW ALL SLAVES STATUS ... Show status of all slave connections
- START SLAVE ['connection_name'...] . . . Start slave for the connection
START ALL SLAVES ... ... Start all slave connections
STOP SLAVE ['connection_name'] ... ... Stop slave for the connection
STOP ALL SLAVES ... ... Stop all Slave connections
To work with normal commands without specifying the connection name in the command line, set the default database with the following command. (this will be useful to fix issues in particular connection )
set default_master_connection=connection_name;
No comments:
Post a Comment