GreatSQL shell 8.0.32-25 配置MGR,
执行添加节点命令add_instance(报错
报错内容为:
MySQL 192.168.169.213:3306 ssl Py > c.add_instance('well@192.168.169.214:3306');
WARNING: A GTID set check of the MySQL instance at 'g8214:3306' determined that it contains transactions that do not originate from the cluster, which must be discarded before it can join the cluster.
g8214:3306 has the following errant GTIDs that do not exist in the cluster:
a859bb20-18ab-11ef-ae14-005056ab76d4:1
WARNING: Discarding these extra GTID events can either be done manually or by completely overwriting the state of g8214:3306 with a physical snapshot from an existing cluster member. To use this method by default, set the 'recoveryMethod' option to 'clone'.
Having extra GTID events is not expected, and it is recommended to investigate this further and ensure that the data can be removed prior to choosing the clone recovery method.
Please select a recovery method [C]lone/[A]bort (default Abort): clone
Validating instance configuration at 192.168.169.214:3306...
This instance reports its own address as g8214:3306
Instance configuration is suitable.
NOTE: Group Replication will communicate with other members using 'g8214:3306'. Use the localAddress option to override.
A new instance will be added to the InnoDB Cluster. Depending on the amount of
data on the cluster this might take from a few seconds to several hours.
Adding instance to the cluster...
ERROR: Unable to start Group Replication for instance 'g8214:3306'.
The MySQL error_log contains the following messages:
2024-05-23 11:00:17.582301 [System] [MY-013587] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2024-05-23 11:00:17.584210 [Warning] [MY-011735] Plugin group_replication reported: '[GCS] Peer address "g8213:3306" is not valid.'
2024-05-23 11:00:17.584233 [Error] [MY-011735] Plugin group_replication reported: '[GCS] None of the provided peer address is valid.'
2024-05-23 11:00:17.584895 [Error] [MY-011674] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2024-05-23 11:00:17.584915 [Error] [MY-011637] Plugin group_replication reported: 'Error on group communication engine initialization'
ERROR: RuntimeError: Group Replication failed to start: MySQL Error 3096 (HY000): g8214:3306: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
Traceback (most recent call last):
File "<string>", line 1, in <module>
RuntimeError: Cluster.add_instance: Group Replication failed to start: MySQL Error 3096 (HY000): g8214:3306: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
处理办法:
在各个节点中/etc/hosts添加各主机名解析,重新执行即可完成节点添加。
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作