mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 05:43:08 +01:00
0d5d8d2e7a
Since the client host can be extracted from the network connection, it can always be printed. This makes it easier to find out where a slave is replicating from. It could also be used to automatically discover slaves that are replicating from a master.
20 lines
549 B
Text
20 lines
549 B
Text
include/master-slave.inc
|
|
[connection master]
|
|
connect slave2,127.0.0.1,root,,test,$SLAVE_MYPORT2,;
|
|
connection slave2;
|
|
RESET SLAVE;
|
|
CHANGE MASTER TO master_host='127.0.0.1',master_port=MASTER_PORT,master_user='root';
|
|
START SLAVE IO_THREAD;
|
|
include/wait_for_slave_io_to_start.inc
|
|
connection master;
|
|
SHOW SLAVE HOSTS;
|
|
Server_id Host Port Master_id
|
|
3 slave2 SLAVE_PORT 1
|
|
2 localhost SLAVE_PORT 1
|
|
connection slave2;
|
|
include/stop_slave_io.inc
|
|
connection master;
|
|
SHOW SLAVE HOSTS;
|
|
Server_id Host Port Master_id
|
|
2 localhost SLAVE_PORT 1
|
|
include/rpl_end.inc
|