所有数据库的MySQL Master-Master复制.怎么样？

目标：我希望能够通过将DB添加到其中一个服务器来向复制添加新数据库;无需停止两个从站,更改配置文件,重新启动MySQL服务器,然后再次启动从站.

问：根据我的阅读,我想我可以通过在每个服务器的配置中省略任何binlog-do-db,binlog-ignore-db,replicate-do-db和replicate-ignore-db设置来实现这一点,但是我不能确定.关于如何评估Database-和Table-级别复制选项的MySQL文档让我觉得根本没有办法实现这一点.

我的/etc/mysql/my.cnf文件的相关部分复制如下.我是在正确的轨道上吗？我想要的甚至可能吗？

硕士1：

[mysqld]
binlog-format = row
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1

master-host = <master2_ip>
master-user = slave_user
master-password = <password>
master-connect-retry = 60

log-bin = /var/log/mysql/mysql-bin.log
relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index
expire_logs_days = 14
max_binlog_size = 2048M

硕士2：

[mysqld]
binlog-format = row
server-id = 2
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 2

master-host = <master1_ip>
master-user = slave_user
master-password = <password>
master-connect-retry = 60

log-bin = /var/log/mysql/mysql-bin.log
relay-log = /var/lib/mysql/slave-relay.log
relay-log-index = /var/lib/mysql/slave-relay-log.index
expire_logs_days = 14
max_binlog_size = 2048M

解决方法

log-bin = mysqld-bin
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
log-slave-updates
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=mysql
relay-log=mysqld-relay-bin

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!