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.: 188.8.131.52).
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,184.108.40.206,220.127.116.11" loose-group_replication_group_seeds = "18.104.22.168:33061,22.214.171.124: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.