MGR集群整体宕机后,slave节点加入集群,发现节点状态一直处于RECOVERING然后变成MISS状态,查看节点error日志有如下报错
2022-05-07T06:16:30.192155Z 25 [ERROR] [MY-010584] [Repl] Slave I/O for channel 'group_replication_recovery': error connecting to master 'mysql_innodb_cluster_2@node1:3306' - retry-time: 60 retries: 1 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection. Error_code: MY-002061
2022-05-07T06:16:30.192837Z 24 [ERROR] [MY-011582] [Repl] Plugin group_replication reported: 'There was an error when connecting to the donor server. Please check that group_replication_recovery channel credentials and all MEMBER_HOST column values of performance_schema.replication_group_members table are correct and DNS resolvable.'
2022-05-07T06:16:30.192857Z 24 [ERROR] [MY-011583] [Repl] Plugin group_replication reported: 'For details please check performance_schema.replication_connection_status table and error log messages of Slave I/O for channel group_replication_recovery.'
可以将slave节点踢出集群,再重新加入集群,问题解决
cluster.removeInstance('root@node2');
cluster.addInstance('root@node2')