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