Sample Header Ad - 728x90

MySQL Group Replication fails to understand "::ffff:" IP Address

0 votes
2 answers
1580 views
I'm trying to set up group replication using 3 x MySQL 8.0.16 databases, but when I start up the second Node it fails. The error log reports: [GCS] Connection attempt from IP address ::ffff:10.12.1.2 refused. Address is not in the IP whitelist. But if I add a whitelist: group_replication_ip_whitelist="::ffff:10.12.1.2"; I get: [GCS] Invalid IP or subnet mask in the whitelist: "::ffff:10.12.1.2"; Is this an issue with the server at my end, or an issue with Group Replication not understanding the IP Address? My configuration is: server_id= gtid_mode=ON enforce_gtid_consistency=ON binlog_checksum=NONE transaction_write_set_extraction=XXHASH64 group_replication_group_name="8112d18e-9e6e-11e9-a526-0e51be33883f" group_replication_start_on_boot=off group_replication_local_address= "10.12.1.1:33061" /*This is different for each one*/ group_replication_group_seeds= "10.12.1.1:33061,10.12.1.2:33061,10.12.1.3:33061" group_replication_bootstrap_group=off If I look on the first nodes error log I can see: Connection attempt from IP address ::ffff:10.12.1.2 refused. Address is not in the IP whitelist.' But again, adding it to a whitelist throws the above error about there being an invalid IP Address,
Asked by IGGt (2276 rep)
Jul 5, 2019, 01:45 PM
Last activity: May 2, 2022, 09:53 AM