Re: Second Instance in group replication failing

[Frederic Descamps]

Hi,

could you check in the mysql log file if you have such string:
Plugin group_replication reported: ‘[GCS] Added automatically IP ranges

and what is the end of the sentence if you have it?

You should avoid 127.0.0.1 in the seed and just add the node name, like node1 or node2 with the port. so the entry should look like this: (for node1 for example)

loose-group_replication_local_address= "node1:33061"
loose-group_replication_group_seeds= "node1:33061,node2:33061,node3:33061"

of course the ip returned (resolved) by ping node1 should be the same on node1 and on node2... This means that if you are on node1 (which has eth0 192.168.1.1 for example), ping node1 should return 192.168.1.1 and not 127.0.0.1. So ping node1 on node2 will also return 192.168.1.1.

if you use them all on the same machine then for your "node1" you should have something like this:

loose-group_replication_local_address= "127.0.0.1:33061"
loose-group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063"

on node2:

loose-group_replication_local_address= "127.0.0.1:33062"
loose-group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063"

and on node3:

loose-group_replication_local_address= "127.0.0.1:33063"
loose-group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063"

Cheers.