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
group_replication_local_address= ""
group_replication_group_seeds= ""

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'
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 I have checked the server and DNS, and is not listed anywhere. So why does MySQL think it is The server has been restarted several times, and it makes no difference.

Options: ReplyQuote

Written By
MySQL Group Replication Picking up the wrong IP Address
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.