MYDB01:
然后回到MYDB01
主机,在MYDB01
的mysql
库中将MYDB02
设为自己的主服务器:
mysql> change master to master_host='192.168.250.194',master_user='repl_user',master_password='repl_passwd',master_log_file='mysql-bin.000002',master_log_pos=456;
Query OK, 0 rows affected, 2 warnings (0.26 sec)
mysql>
还是接着在MYDB01
主机上启动slave
服务:
mysql> start slave;
Query OK, 0 rows affected (0.07 sec)
mysql>