mysql> SHOW GLOBAL VARIABLES LIKE 'group_replication%list';
+--------------------------------+-----------+
| Variable_name | Value |
+--------------------------------+-----------+
| group_replication_ip_allowlist | AUTOMATIC |
| group_replication_ip_whitelist | AUTOMATIC |
+--------------------------------+-----------+
2 rows in set (0.01 sec)
ACL of replication looks expected.
mysql> SHOW GLOBAL VARIABLES LIKE 'group_ replication% list'; ------- ------- ------- -----+- ------- ---+ ------- ------- ------- -----+- ------- ---+ on_ip_allowlist | AUTOMATIC | on_ip_whitelist | AUTOMATIC | ------- ------- ------- -----+- ------- ---+
+------
| Variable_name | Value |
+------
| group_replicati
| group_replicati
+------
2 rows in set (0.01 sec)
mysql> SELECT user, host FROM mysql.user; ------- ------- ------- +------ ------- --+ ------- ------- ------- +------ ------- --+ cluster_ 1000 | % | ------- ------- ------- +------ ------- --+
+------
| user | host |
+------
| mysql_innodb_
| clusteruser | 172.31.20.6 |
| clusteruser | 172.31.3.41 |
| clusteruser | 172.31.36.189 |
| clusteruser | localhost |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------
10 rows in set (0.00 sec)