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 connectionSHOW ALL SLAVES STATUS ... Show status of all slave connections- START SLAVE ['connection_name'...] . . . Start slave for the connection
START ALL SLAVES ... ... Start all slave connectionsSTOP SLAVE ['connection_name'] ... ... Stop slave for the connectionSTOP 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