MySQL Forums
Forum List  »  Replication

Group replication with NAT servers
Posted by: Serg Koroh
Date: December 06, 2017 09:33AM

Hello,

does MySQL group replication should work if I have a server behind NAT?

I have a Hetzner CX server which has eth0 interface with addr 172.31.1.100.
Hetzner provides 1:1 NAT for this server and public IP (ex.: 123.123.123.101).

I tried to setup group replication with the following IP-related settings:
loose-group_replication_local_address = "172.31.1.100:33061"
loose-group_replication_ip_whitelist = "172.31.1.100,123.123.123.101,123.123.123.102"
loose-group_replication_group_seeds = "123.123.123.101:33061,123.123.123.102:33061"

and it doesn't work, due to error:
[ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
[ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'

Replication user hostname defined as '%'.

When I tried to use the same configuration for servers without NAT - it works without any issues.

Please advice how to fix the problem or maybe MySQL doesn't support such situation.

Options: ReplyQuote


Subject
Views
Written By
Posted
Group replication with NAT servers
2034
December 06, 2017 09:33AM
768
December 07, 2017 05: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.