MySQL数据同步

A：192.168.1.1  master

B：192.168.1.2  slave

A：

1修改配置参数：

vi /etc/my.cnf

增加：

[mysqld]

log-bin

server-id=1

sql-bin-update-same

binlog-do-db=backup //需要备份的DB

2增加访问权限：

mysql>grant all privileges on *.* to 'ctl.root'@'192.168.1.2' identified by '12345678';

mysql> update mysql.user set password=old_password('12345678') where user='ctl.root' and host='192.168.1.2';

mysql>flush privileges;

mysql>quit

3导出数据：

./mysql-install-road/bin/mysqldump –uroot –p backup>/backup.sql

B：

1导入数据

./mysql-install-road/bin/mysql –uroot –p backup </backup.sql

2 vi /etc/my.cnf

server-id=2

master-host=192.168.1.212

master-user=ctl.root

master-password=12345678

master-port=3306

master-connect-retry=10

replicate-do-db=backup

3把master&slave同时重起

4 启动slave：

mysql>slave start;

mysql>show slave status/G;

mysql>load data from master; //手动同步

A：

mysql>show master status/G;