MySQL Forums
Forum List  »  InnoDB clusters

Mysql group replication..
Posted by: Steph V
Date: May 10, 2017 06:25AM

Hi There,

I've configured Mysql group replication between two servers by following the documentation found on the Mysql dev website https://dev.mysql.com/doc/refman/5.7/en/group-replication.html

Now everything were working rather well until this morning when I've noticed that my second server dropped from the group with the following error message.

How do I get the two servers to play together again ? Any help will be greatly appreciated.


2017-05-10T10:05:11.115424Z 0 [ERROR] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions:
e7ec900c-354d-11e7-a269-323934386466:1-12025 > Group transactions: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-1337,
b34598a3-2b6c-11e7-b12c-623538613236:1-40270'
2017-05-10T10:05:11.115496Z 0 [ERROR] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'
2017-05-10T10:05:11.115505Z 0 [Note] Plugin group_replication reported: 'To force this member into the group you can use the group_replication_allow_local_disjoint_gtids_join option'

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql group replication..
2835
May 10, 2017 06:25AM
1536
May 11, 2017 12:17AM
1133
May 11, 2017 11:39AM


Sorry, you can't reply to this topic. It has been closed.

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.