Changes between Version 14 and Version 15 of GROUPReplicate3


Ignore:
Timestamp:
07/25/22 15:37:07 (2 years ago)
Author:
krit
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • GROUPReplicate3

    v14 v15  
    117117    --loose-group-replication-enforce-update-everywhere-checks='ON'
    118118}}}
    119 
    120 
     119Then, on nodedb1 use mysql cmd
     120{{{
     121mysql> create user 'repl'@'%';
     122       GRANT ALL  ON * . * TO repl@'%';
     123       flush privileges;
     124       SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
     125       SET @@GLOBAL.group_replication_local_address='192.168.81.36:33061';
     126       SET @@GLOBAL.group_replication_group_seeds='192.168.81.36:33061,192.168.81.11:33061,192.168.81.10:33061';
     127       SET @@GLOBAL.group_replication_bootstrap_group=1;
     128       change master to master_user='repl' for channel 'group_replication_recovery';
     129       START GROUP_REPLICATION;
     130       SET @@GLOBAL.group_replication_bootstrap_group=0;
     131       SELECT * FROM performance_schema.replication_group_members;
     132}}}
    121133
    122134On nodedb2 192.168.81.11, use mysql cmd to do