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>