MySQL Forums
Forum List  »  Replication

Does group replication work on WAN?
Posted by: Geroge Catalin
Date: November 23, 2017 08:16AM

I am trying to setup group replication in a AWS VPC over 2 availability zones.
I tested with a group of 3 servers in save availability zone (low latency network/LAN) and everything was ok, group was up and runing properly. I tried the same setup but this time with 2 servers in one availability zone and another server in another availability zone (hence WAN, maybe high latency?). This setup failed for the 3rd server ( a slave ). The 3rd server fails to join the group. Pasting below the error log entries :

Plugin group_replication reported: 'auto_increment_increment is set to 7'
2017-11-23T13:59:58.797014Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 3'
2017-11-23T13:59:58.797071Z 0 [Note] Plugin group_replication reported: 'state 0 action xa_init'
2017-11-23T13:59:58.812745Z 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:3307 (socket=43).'
2017-11-23T13:59:58.812763Z 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=43)!'
2017-11-23T13:59:58.812766Z 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=43)!'
2017-11-23T13:59:58.812785Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.812792Z 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:3307 (socket=43)!'
2017-11-23T13:59:58.812863Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 45'
2017-11-23T13:59:58.812912Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.829405Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.829534Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.829578Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 41'
2017-11-23T13:59:58.829609Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.845584Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.845704Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.845744Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 55'
2017-11-23T13:59:58.845772Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.861716Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.861835Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.861871Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 59'
2017-11-23T13:59:58.861898Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.877839Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.877957Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.877991Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 63'
2017-11-23T13:59:58.878023Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.893894Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.894011Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.8.14 3307'
2017-11-23T13:59:58.894045Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.8.14 3307 fd 67'
2017-11-23T13:59:58.894072Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.911539Z 0 [Note] Plugin group_replication reported: 'Success connecting using SSL.'
2017-11-23T13:59:58.911664Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.2.113 3307'
2017-11-23T13:59:58.912287Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.2.113 3307 fd 72'
2017-11-23T13:59:58.912316Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.912842Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2017-11-23T13:59:58.912873Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.88.2.113:3307 on local port: 3307. Error= 0'
2017-11-23T13:59:58.912878Z 0 [Note] Plugin group_replication reported: 'connecting to 10.88.2.41 3307'
2017-11-23T13:59:58.913327Z 0 [Note] Plugin group_replication reported: 'client connected to 10.88.2.41 3307 fd 72'
2017-11-23T13:59:58.913357Z 0 [Note] Plugin group_replication reported: 'Trying to connect using SSL.'
2017-11-23T13:59:58.914974Z 8 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-11-23T13:59:58.915237Z 0 [Note] Plugin group_replication reported: 'Error connecting using SSL 2000114 114.'
2017-11-23T13:59:58.915265Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.88.2.41:3307 on local port: 3307. Error= 0'

(going in a loop here with same connection ERROR)
(And finanlly ...)

2017-11-23T13:59:59.813708Z 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 3307'
2017-11-23T13:59:59.813764Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_terminate'
2017-11-23T13:59:59.813780Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-11-23T13:59:59.813783Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_exit'
2017-11-23T13:59:59.814772Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2017-11-23T13:59:59.814776Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-11-23T13:59:59.814813Z 0 [Warning] Plugin group_replication reported: 'read failed'
2017-11-23T13:59:59.821940Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3307'
2017-11-23T14:00:58.797097Z 3 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2017-11-23T14:00:58.797134Z 3 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2017-11-23T14:00:58.797163Z 3 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2017-11-23T14:00:58.797185Z 0 [Note] Plugin group_replication reported: 'Destroying SSL'
2017-11-23T14:00:58.797196Z 0 [Note] Plugin group_replication reported: 'Success destroying SSL'
2017-11-23T14:00:58.797243Z 3 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2017-11-23T14:00:58.797246Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2017-11-23T14:00:58.797343Z 7 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2017-11-23T14:00:58.799794Z 4 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'

Options: ReplyQuote


Subject
Views
Written By
Posted
Does group replication work on WAN?
2109
November 23, 2017 08:16AM


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.