1. 主从关系的同步
master端 192.168.5.10
slave端 192.168.5.4
修改master端的/etc/my.cnf文件
[mysqld]:
log-bin
server-id = 1
进入mysql
创建一个要同步的数据库abc
create database abc;
创建一个用来同步的用户,指定只能在192.168.5.4登录
grant file on *.* to bak@'192.168.5.4 identified by '123456';
grant all privileges on backup.* to bak@’192.168.5.4’ identified by ‘123456’;
flush privileges;
重启mysql
修改slave端的/etc/my.cnf文件
[mysqld]:
server_id = 2
log-bin = mysql-bin
master-host = 192.168.5.10
master-user = bak
master-password = '123456' (如果为空也要打上两个单引号)
master-port = 3306 (根据具体设置的端口号填)
master-connect-retry = 10 连接重试次数
replicate-do-db = abc 要接收的数据库名,如果有多个数据库,每个数据库一行
replicate-ignore-db=