MySQL主从相关配置

在主MySQL配置文件配置

1、指定复制某个数据库

主数据库配置文件添加binlog-do-db=database1

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-do-db=database1

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-do-db=database1
binlog-do-db=database2
binlog-do-db=database3

[mysqld]
server-id=1
log-bin=mysql-bin

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-ignore-db=test

微信扫描下方的二维码阅读本文