mysql配置文件

###主###

server-id=1

log-bin=mysql-bin

binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=mysql

###从###

server-id=2

log-bin=mysql-bin

 

mysql> change master to

    -> master_host='192.168.189.164',

    -> master_user='tom',

    -> master_password='123',

    -> master_log_file='mysql-bin.000001',

-> master_log_pos=106;