数据库多主1丛复制

数据库多主一丛复制检查从服务器状态slave SHOW SLAVE STATUS FOR CHANNELmaster1\Gslave SHOW SLA

数据库多主一丛复制

数据库多主1丛复制

检查从服务器状态

slave > SHOW SLAVE STATUS FOR CHANNEL="master1"\Gslave > SHOW SLAVE STATUS FOR CHANNEL="master2"\G

测试,分别在两个主服务器上创建数据库,然后查看从数据库同步结果.

master1 > create database master1;master2 > create database master2;slave > show databases like 'master%';+--------------------+| Database (master%) |+--------------------+| master1            || master2            |

?

?

?