January 2019
Intermediate to advanced
286 pages
7h 41m
English
A group replication plugin has a configuration option group_replication_ip_whitelist. If you set this option on server 1, then when server 2 is establishing a connection to server 1, it accepts/rejects the connection. By default, it sets the whitelist to the private networks that the server has interface on. We can specify host names, IP addresses, and Classless Inter-Domain Routing (CIDR) notation, separated by a comma. IPV6 addresses and hostname resolving to IPV6 addresses are not supported:
mysql> SET GLOBAL group_replication_ip_whitelist="1.1.1.2/24";
When we have set a specific IP addresses on a whitelist, we need to take care when a reconfiguration of the group happens, as, generally, we whitelist IP addresses ...
Read now
Unlock full access