MySQL Forums
Forum List  »  InnoDB clusters

MySQL Group Replication Picking up the wrong IP Address
Posted by: IGG t
Date: July 29, 2019 07:09AM

I am attempting to set up MySQL Group Replication / Innodb Cluster.

I have installed a MySQL 8.0.16 database, on a debian 9 server.

The related configuration is as below:

port = 3306
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.2.51:3307"
group_replication_group_seeds= "10.12.2.51:3307"
group_replication_bootstrap_group=off

I have set up a user, and enabled it `FOR CHANNEL 'group_replication_recovery'`

However, when I try and start Group_Replication:

start group_replication;

I simply get:

ERROR: 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.

If I look in the error Log, I can see:

Jul 29 13:31:40 db-1-1 mysqld[537]: 2019-07-29T12:31:40.627950Z 13 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Translated 'db-1-1' to 10.12.2.50'
Jul 29 13:31:40 db-1-1 mysqld[537]: 2019-07-29T12:31:40.628032Z 13 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] There is no local IP address matching the one configured for the local node (db-1-1:33061).'

The thing is, the IP Address for this server is 10.12.2.51. I have checked the server and DNS, and 10.12.2.50 is not listed anywhere. So why does MySQL think it is 10.12.2.50? The server has been restarted several times, and it makes no difference.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Group Replication Picking up the wrong IP Address
3556
July 29, 2019 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.