Re: Group Replication doesn't like "::ffff:10.12.1.2" as an IP Address

[Krzysztof Wróblewski]

I had similar issue...
Here my notes:

As documentation says:
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-whitelisting.html

AUTOMATIC mode should authorize automatically

IPv4 (as defined in RFC 1918)
10/8 prefix (10.0.0.0 - 10.255.255.255) - Class A

But when ipv6 comes... there is no rule for ::ffff:...
I couldn't switch listener 33061 to ipv4 (which comes with GR) on CentOS 8. It was always triggerred on ipv6.

Even when you add whitelist to node no.1 during creation
dba.createCluster('mycluster',{ipWhitelist: '10.12.0.0/16'})
it doesn't propagate this whitelist through all nodes (and it could be).

You have to add it manually through all nodes (even for private network) by :
cluster.addInstance('cluster@mysql02',{ipWhitelist: '10.12.0.0/16'})

If you don't do this, you will have error like in this topic.



Edited 1 time(s). Last edit at 12/17/2019 01:48AM by Krzysztof Wróblewski.