Mysql主从同步

#主配置：
server-id=1
log-bin=mysql-bin

max_binlog_size = 500M

binlog-do-db=yourdb

binlog-ignore-db=mysql

#从配置：
server-id=2
log-bin=mysql-bin
replicate-do-db=yourdb

步骤：

查看主库状态：
show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 | 666 | yourdb | |
+------------------+----------+--------------+------------------+

change master to master_host='192.168.1.2', master_user='slaveuser', master_password='password',master_log_file='mysql-bin.000001', master_log_pos=666;

查看从库状态：
show slave status;

取消主从：

主:reset master;

从:stop slave;reset slave all;