单台mysql增加节点_MySQL Group Replication 动态添加成员节点

SET SQL_LOG_BIN=0;

###创建授权用户

CREATE USER rpl_user@'%';

GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass'; #创建授权用户

###刷新权限

FLUSH PRIVILEGES;

##关闭

SET SQL_LOG_BIN=1;

###执行同步语句

CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';

###安装mysql group replication:

INSTALL PLUGIN group_replication SONAME 'group_replication.so';

mysql> SHOW PLUGINS;

| Name |Status | Type | Library | License |

| binlog | ACTIVE | STORAGE ENGINE | NULL GPL

group_replication | ACTIVE | GROUP REPLICATION | group_replication.so | GPL|

###开启兼容模式

set global group_replication_allow_local_disjoint_gtids_join=ON;

###启动

START GROUP_REPLICATION;

###查看group在线机器

mysql> SELECT * FROM performance_schema.replication_group_members;

| CHANNEL_NAME            | MEMBER_ID                            | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |

group_replication_applier | 02d70597-9f73-11e7-8a51-000c29578bd4 | node1       | 3306        | ONLINE |

group_replication_applier | b8a02335-a1bb-11e7-b39b-000c29c4cbb3 | node2       | 3306        | ONLINE |

group_replication_applier | dc19223f-a1bb-11e7-85ce-000c29826f1f | node3       | 3306        | ONLINE |

###验证node4已经加入GR集群:

group_replication_applier | dc19223f-a1bb-11e7-85ce-000c29826f1e | node4       | 3306        | ONLINE |

row in set (0.00 sec)