Any workaround to execute one transaction on slave

[Liang Cheng]

Hi, All
We have one MySQL8 innodb cluster environment. For some unclear reason, the cluster hit some problems. We tried to restart all servers, however the slaves could not be restarted. We checked all 3 servers, the clone is installed on slave2, but not intalled on both slave1 and primary db. We can install clone plugin on primary server, however since the group_replication is failed to start on slave1 and it's in read-only mode, we could not install clone plugin.
I think sometimes we may have other similar cases, that is, slave is missing one record and we know that if we can insert such record we can bring this broken slave back to the cluster, but it's not easy to do this, at least on MySQL8.
Please share your ideas if you know how to do(workaround) it. Thanks a lot.




2024-03-07T03:34:55.348541Z 2 [System] [MY-011511] [Repl] Plugin group_replication reported: 'This server is working as secondary member with primary member address m5128:3308.'
2024-03-07T03:34:56.349399Z 0 [Warning] [MY-013470] [Repl] Plugin group_replication reported: 'This member will start distributed recovery using clone. It is due to no ONLINE member has the missing data for recovering in its binary logs.'
2024-03-07T03:34:57.353749Z 0 [System] [MY-013471] [Repl] Plugin group_replication reported: 'Distributed recovery will transfer data using: Cloning from a remote group donor.'
2024-03-07T03:34:57.354259Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to m3127:3308, m5128:3308 on view 17097824372187244:2.'
2024-03-07T03:34:57.354703Z 32 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'
2024-03-07T03:34:57.381436Z 32 [ERROR] [MY-011569] [Repl] Plugin group_replication reported: 'Internal query: CLONE INSTANCE FROM 'mysql_innodb_cluster_1'@'m5128':3308 IDENTIFIED BY '*****' REQUIRE NO SSL; result in error. Error number: 3862'