Hello,
I hope I've posted this question in the right space/place. If not please let me know where should I post this question.
We have a mysql cluster composed for 3 servers. Almost daily (around midnight) one of the servers [random one] drops from the cluster with the following error:
[ERROR] Plugin group_replication reported: 'Member was expelled from the group due to network failures, changing member status to ERROR.'
After about 25 minutes we can see another error:
[ERROR] Plugin group_replication reported: 'Error, maximum number of retries exceeded when waiting for the internal server session state to be operating'
We have to stop the group replication and restart or stop the mysql service and restart
OS: Oracle Linux 7.3
All 3 servers are virtual machines hosted on the same physical machine so we shouldn't have any network issues.
Any help would be appreciated.
Thank you,
Andrei