MySQL Forums
Forum List  »  Replication

fail to run clone command on mysql8.0.31
Posted by: Liang Cheng
Date: March 14, 2024 05:49AM

Hi,
I'm trying to make clone work on my local test environment.
I have two mysql servers, one run as primary and another run as slave.
1. First, I create the one account named 'clone_user' for clone
mysql> show grants for clone_user;
+-----------------------------------------------------------+
| Grants for clone_user@% |
+-----------------------------------------------------------+
| GRANT USAGE ON *.* TO `clone_user`@`%` |
| GRANT BACKUP_ADMIN,CLONE_ADMIN ON *.* TO `clone_user`@`%` |
+-----------------------------------------------------------+
2. While group_replication is running on slave, I run clone command. It failed
mysql> clone instance from clone_user@10.50.10.249:3308 identified by '***';
ERROR 3875 (HY000): The clone operation cannot be executed when Group Replication is running.

3. So I stop group_replication and reset slave
mysql> stop group_replication;
Query OK, 0 rows affected (4.08 sec)

mysql> reset slave;
Query OK, 0 rows affected, 1 warning (0.03 sec)
4. Run clone again, it fails again because the slave is on super-read-only mode

mysql> clone instance from clone_user@10.50.10.249:3308 identified by '***';
ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement

Please help if you have any idea. Thank you very much

Options: ReplyQuote


Subject
Views
Written By
Posted
fail to run clone command on mysql8.0.31
230
March 14, 2024 05:49AM


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.