Changes between Version 6 and Version 7 of GROUPReplicate3

Timestamp:

07/16/22 14:11:24 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate3

@@ -25 +25 @@
     --loose-group-replication-enforce-update-everywhere-checks='ON'
 }}}
+Then start mysql with '''docker exec -it nodedb1 -uroot -pmypass'''
+{{{
+mysql> create user 'repl'@'%';
+       GRANT ALL  ON * . * TO repl@'%';
+       flush privileges;
+       SET @@GLOBAL.group_replication_group_name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
+       SET @@GLOBAL.group_replication_local_address='nodedb1:33061';
+       SET @@GLOBAL.group_replication_group_seeds='nodedb1:33061,nodedb2:33061,nodedb3:33061';
+       SET @@GLOBAL.group_replication_bootstrap_group=1;
+       change master to master_user='repl' for channel 'group_replication_recovery';
+       START GROUP_REPLICATION;
+       SET @@GLOBAL.group_replication_bootstrap_group=0;
+       SELECT * FROM performance_schema.replication_group_members;
+}}}