MySQL Forums
Forum List  »  MySQL Shell

mysql-shell: cannot create a new cluster in ubuntu multipass vm
Posted by: George Oremo
Date: August 27, 2022 04:24PM

In an attempt to create a mysql innodb cluster using mysql-shell, I have done the following:

set up an ubuntu multipass instance (ubuntu vm) to serve as an isolated server
installed mysql server (version 8.0.30) on the multipass instance
on the host I have installed mysql-shell

I have successfully run the following from the mysql-shell:

dba.checkInstanceConfiguration("cd@172.16.199.4:3306")
dba.configureInstance("cd@172.16.199.4:3306")
shell.connect("cd@172.16.199.4:3306")
I have mapped the ip address 172.16.199.4 to 'mysql-pri' in the /etc/hosts file. The same name is used for the multipass instance.

Now when I run cdCluster = dba.createCluster("cd-cluster");, I get the output below:

MySQL 172.16.199.4:3306 ssl JS > cdCluster = dba.createCluster("cd-cluster");
A new InnoDB Cluster will be created on instance 'mysql-pri:3306'.

Validating instance configuration at 172.16.199.4:3306...

This instance reports its own address as mysql-pri:3306

Instance configuration is suitable.
NOTE: Group Replication will communicate with other members using 'mysql-pri:3306'. Use the localAddress option to override.

Creating InnoDB Cluster 'cd-cluster' on 'mysql-pri:3306'...

Adding Seed Instance...
ERROR: Unable to start Group Replication for instance 'mysql-pri:3306'.
The MySQL error_log contains the following messages:
2022-08-26 19:44:50.410291 [System] [MY-013587] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-08-26 19:44:50.411856 [Error] [MY-011735] Plugin group_replication reported: '[GCS] There is no local IP address matching the one configured for the local node (mysql-pri:3306).'
2022-08-26 19:44:50.412119 [Error] [MY-011674] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2022-08-26 19:44:50.412175 [Error] [MY-011637] Plugin group_replication reported: 'Error on group communication engine initialization'
Dba.createCluster: Group Replication failed to start: MySQL Error 3096 (HY000): mysql-pri:3306: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer. (RuntimeError)
MySQL 172.16.199.4:3306 ssl JS >

What is the correction for this to allow creation of new cluster?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql-shell: cannot create a new cluster in ubuntu multipass vm
84
August 27, 2022 04:24PM


Sorry, only registered users may post in this forum.

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.