MySQL Forums
Forum List  »  Replication

Cloning not using the replication user
Posted by: Geert Vanderkelen
Date: July 17, 2020 12:25AM

Hey,

If I understood correctly, when adding a new node to to a MySQL Group, clone would be done automatically. When setting the @@global.group_replication_clone_threshold to 1 (forcing it), it would setup the cloning for me? Setting the donor list, etc..

On a fresh instance, I see after `START GROUP_REPLICATION`, in the `clone_status`, ' Access denied for user 'test'@'127.0.0.1' (using password: NO).'.

Stoping the instance, restarting, I did the clone setup manually:


SET GLOBAL clone_valid_donor_list = '127.0.0.1:3301';
CLONE INSTANCE FROM rpl_user@127.0.0.1:3301 IDENTIFIED BY '********';

Doing then a `START GROUP_REPLICATION` it worked great.

So is this extra CLONE-setup needed? If so, can it be added to the manual (https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html), or did I miss something.

-Geert


Relevant Configuration (MySQL 8.0.20, not tested with .21 yet, on macOS):

[mysqld]
skip_name_resolve
report_host=127.0.0.1
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE

plugin_load_add='group_replication.so'
plugin_load_add='mysql_clone.so'
group_replication_group_name="abcdef01-f515-4834-88a5-2cef06cd0bfa"
group_replication_start_on_boot=off
group_replication_local_address= "127.0.0.1:33063"
group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063"
group_replication_bootstrap_group=off

Options: ReplyQuote


Subject
Views
Written By
Posted
Cloning not using the replication user
209
July 17, 2020 12:25AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.