mysql开启主从复制

主数据库配置：vim /etc/my.cnf
server_id=146 #一般设置ip最后一位
log-bin=mysql-bin #开启bin-log
#查看配置是否生效
show VARIABLES like '%server_id%'
show master status;
从数据库配置：vim /etc/my.cnf
server_id=132
log-bin=mysql-bin
binlog_do_db=test
#执行sql
change master to master_host='master_db_ip',master_user='root',master_password='pwd',master_log_file='mysql-bin.000001',master_log_pos=892;
#查看配置是否生效
show VARIABLES like '%server_id%'
show slave status;
stop SLAVE
start slave