MySQL Forums
Forum List  »  InnoDB clusters

One node of cluster does not rejoin after reboot
Posted by: Mirko Lübcke
Date: April 18, 2024 08:32AM

Hi guys,

i have built a cluster and added three members (2*Win2019 1*Win10). I set the option "autoRejoinTries" to 12 and the option "exitStateAction" to "ABORT_SERVER".

The cluster works fine, i can reboot one of the win2019 machines and they reconnect/rejoin the cluster correctly. But if i reboot the win10 machine, it does not rejoin. It stays in state "offline" with the instance error "group replication is stopped".

------------------------

"topology": {
"MEMBER1:3306": {
"address": "MEMBER1:3306",
"instanceErrors": [
"NOTE: group_replication is stopped."
],
"memberRole": "SECONDARY",
"memberState": "OFFLINE",
"mode": "n/a",
"readReplicas": {},
"role": "HA",
"status": "(MISSING)",
"version": "8.0.36"
},
"MEMBER2:3306": {
"address": "MEMBER2:3306",
"memberRole": "PRIMARY",
"mode": "R/W",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.0.36"
},
"MEMBER3:3306": {
"address": "MEMBER3:3306",
"memberRole": "SECONDARY",
"mode": "R/O",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.0.36"
}
},
"topologyMode": "Single-Primary"

----------------------

Does anyone have a clue, what could be the error? I even set the option explicit to the single instances by "setInstanceOption" but it made no difference.


Regards, Mirko

Options: ReplyQuote


Subject
Views
Written By
Posted
One node of cluster does not rejoin after reboot
237
April 18, 2024 08:32AM


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.