步原集群数据。
?
reset master;
?
set global gtid_purge = '2c7b4762-5963-5789-acdd-047677b98a9d:1-32876403:33576383-33576398'
-- 设置MGR相关参数
set global binlog_checksum = NONE;
?
set global group_replication_group_name = '2c7b4762-5963-5789-acdd-047677b98a9d';
?
set global group_replication_local_address = '192.168.4.35:23816';
?
set global group_replication_group_seeds = "192.168.4.35:23309";
?
set global group_replication_bootstrap_group = off;
?
set global group_replication_single_primary_mode = 0;
?
set global group_replication_enforce_update_everywhere_checks = 0;
?
set global group_replication_unreachable_majority_timeout = 120;
?
set global group_replication_enforce_update_everywhere_checks = 1;
?
-- 启动集群
?
start group_replication
?
-- 尝试执行UDF:group_replication_get_communication_protocol:
?
SELECT group_replication_get_communication_protocol();
+------------------------------------------------+
| group_replication_get_communication_protocol() |
+------------------------------------------------+
| 5.7.14 |
+------------------------------------------------+
?
-- MySQL 8.0.16 加入由全部节点均为5.7.25版本,自动将通讯协议降成了5.7.14,以便相互通讯兼容。
?
-- 同时也说明 MySQL的通信协议版本可能和MySQL实例版本有可能不是一致的哦(这点还需要论证下,不敢打包票)
?
-- 注意:如果出现以下错误,原因是执行UDF,必须要在集群成员均为Online对的状态下才可执行
-- ERROR 1123 (HY000): Can't initialize function 'group_replication_get_communication_protocol'; A member is joining the group, wait for it to be ONLINE.' -- 查看集群节点状态:
[performance_schema]> select * from replication_group_members;
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| group_replication_applier | 6990a8f4-777c-11e9-a906-20040fecc760 | node004035 | 3816 | ONLINE | SECONDARY | 8.0.16 |
| group_replication_applier | cc11c7de-446a-11e9-ae80-20040fecc760 | node004035 | 3309 | ONLINE | SECONDARY | 5.7.25 |
| group_replication_applier | cc830e26-446a-11e9-be34-20040fed73f8 | node004036 | 3309 | ONLINE | SECONDARY | 5.7.25 |
| group_replication_applier | cc88974a-446a-11e9-9e99-20040fed8fd8 | node004034 | 3309 | ONLINE | PRIMARY | 5.7.25 |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
搭建完成,均手工测试,数据可正常同步及读取。测试数据就不在这里介绍,可自行玩耍。
|