1.数据库最好停止 保持数据一致性 数据库版本一致
2.设置主库
binlog-do-db=ufind_db 需要同步的库
# 在 /etc/my.conf [mysqld] 下添加:
server-id=101 # 配置服务ID,必需唯一
log-bin=mysql-bin # 配置添加日志,并设置日志文件名前缀
binlog-ignore-db=mysql # 添加忽略日志记录的表
binlog-ignore-db=information_schema # 添加忽略日志记录的表
加入 同步账户和密码 权限
进入mysql 命令行
show master status;
3.丛库
log-bin=mysql-bin
binlog_format=mixed
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
server-id=3
replicate-do-db=zjgl_db #告诉该slave只做target_db1数据库的更新
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
log-slave-updates=1
slave-skip-errors=all
slave-net-timeout=60
mysql> stop slave; #关闭Slave
mysql> change master to master_host='192.168.1.1',master_user='root',master_password='123456',master_log_file='mysql-bin.000004', master_log_pos=28125;
change master to master_host='192.168.16.160',master_user='root',master_password='123abc456abc',master_log_file='mysql-bin.000001', master_log_pos=2869;
mysql> start slave; #开启Slave