| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connect slave2,127.0.0.1,root,,test,$SLAVE_MYPORT2,; |
| 4 |
connection slave2; |
| 5 |
RESET SLAVE; |
| 6 |
CHANGE MASTER TO master_host='127.0.0.1',master_port=MASTER_PORT,master_user='root', master_ssl_verify_server_cert=0; |
| 7 |
START SLAVE IO_THREAD; |
| 8 |
include/wait_for_slave_io_to_start.inc |
| 9 |
connection master; |
| 10 |
SHOW SLAVE HOSTS; |
| 11 |
Server_id Host Port Master_id |
| 12 |
3 slave2 SLAVE_PORT 1 |
| 13 |
2 localhost SLAVE_PORT 1 |
| 14 |
connection slave2; |
| 15 |
include/stop_slave_io.inc |
| 16 |
connection master; |
| 17 |
SHOW SLAVE HOSTS; |
| 18 |
Server_id Host Port Master_id |
| 19 |
2 localhost SLAVE_PORT 1 |
| 20 |
include/rpl_end.inc |