mysql主从同步随笔_MySQL

bitsCN.com

mysql主从同步随笔

 

vim /etc/my.cnf

 

server-id=1

 

log-bin=/data/binlog/mysql-bin

 

binlog-ignore-db=mysql

 

binlog-ignore-db=test

 

binlog-ignore-db=information_schema

 

flush tables with read lock;

 

show master status;

 

server-id=2

 

stop slave;

 

chage master to

 

master_host=

 

master_user=

 

master_password=

 

master_port=

 

master_log-file=

 

master_log_pos=

 

start slave;

 

show slave status;

 

bitsCN.com