[摘要]+---------------------------+--------------------------------------+----------------------+--------...
+---------------------------+--------------------------------------+----------------------+-------------+--------------+
1 row in set (0.00 sec)
mysql>
Db2上启动group_replication:
Db2上mysql命令行上执行启动:
mysql> START GROUP_REPLICATION;
Query OK, 0 rows affected (1.02 sec)
mysql>
db1后台error log日志显示,看到db2加入进来了,进了group:
2017-01-11T07:51:40.623093Z 0 [Note] Plugin group_replication reported: 'Marking group replication view change with view_id 14841207424144277:8'
2017-01-11T07:51:40.650962Z 21 [Note] Start binlog_dump to master_thread_id(21) slave_server(12002), pos(, 4)
2017-01-11T07:51:40.687441Z 0 [Note] Plugin group_replication reported: 'The member with address bpe_service:3317 was
declared online within the replication group'
2017-01-11T07:52:40.651481Z 21 [Note] Aborted connection 21 to db: 'unconnected' user: 'repl' host: '192.168.121.111' (failed on flush_net())
再去master库db1上,查看group_replication成员,会有db2的显示,看到MEMBER_STATE都是ONLINE,表示都是MASTER:
mysql> SELECT * FROM performance_schema.replication_group_members;
+---------------------------+--------------------------------------+----------------------+-------------+--------------+
关键词:详细介绍MySQL Group Replication[Multi-Primary Mode]的搭建部署过程(图文)