1

vi my.cnf

1
2
3
4

[mysqld]
log_bin=/home/sun_zeming/mysql/mysql-1/log/mysql.log
server_id = 1
binlog-do-db=tbcms

1
2
3
4

[mysqld]
log_bin=/home/sun_zeming/mysql/mysql-2/log/mysql.log
server_id = 2
binlog-do-db=tbcms

1
2

mysql> flush tables with read lock;
mysql> show master status;

1
2

mysql> change master to master_host = '192.168.100.6', master_port = 3302, master_user = 'root',
 master_password = '123456', master_log_file = 'mysql.000004', master_log_pos = 120;

1
2

mysql> change master to master_host = '192.168.100.6', master_port = 3301, master_user = 'root', 
master_password = '123456', master_log_file = 'mysql.000007', master_log_pos = 217;

1
2

mysql> start slave;
mysql> unlock tables;