InnoDb Cluster on docker didn't start
Hello,
I try to create a MySql InnoDB Cluster with containers.
I have 2 VM with Ubuntu 22.04, In each I have a container with MySql 8.0.39
I want to create a cluster with the 2 containers. But I failed to create.
dba.createCluster(clusterName, {localAddress:'mysqlClstr01:3306'})
A new InnoDB Cluster will be created on instance 'mysqlClstr01:3306'.
Disabling super_read_only mode on instance 'mysqlClstr01:3306'.
Validating instance configuration at mysqlClstr01:3306...
This instance reports its own address as mysqlClstr01:3306
Instance configuration is suitable.
* Checking connectivity and SSL configuration...
Creating InnoDB Cluster 'mysqlCluster' on 'mysqlClstr01:3306'...
Adding Seed Instance...
ERROR: Unable to start Group Replication for instance 'mysqlClstr01:3306'.
The MySQL error_log contains the following messages:
2024-08-23 14:40:57.147907 [System] [MY-013587] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2024-08-23 14:40:57.148434 [System] [MY-011565] Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-08-23 14:40:57.149175 [Error] [MY-011735] Plugin group_replication reported: '[GCS] There is no local IP address matching the one configured for the local node (mysqlClstr01:3306).'
2024-08-23 14:40:57.149375 [Error] [MY-011674] Plugin group_replication reported: 'Unable to initialize the group communication engine'
2024-08-23 14:40:57.149392 [Error] [MY-011637] Plugin group_replication reported: 'Error on group communication engine initialization'
Dba.createCluster: Group Replication failed to start: MySQL Error 3096 (HY000): mysqlClstr01:3306: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer. (RuntimeError)
I tried to pass an argument in my docker-compose to set the local address group-replication-local-address without success.
My docker compose:
volumes:
mysqlData:
name: mysqlData
external: true
mysqlLog:
name: mysqlLog
external: true
services:
mysql-server-1:
env_file:
- mysql-server.env
image: mysql:8.0
container_name: mysql-server-1
volumes:
- mysqlData:/var/lib/mysql
- mysqlLog:/var/log/mysql
network_mode: host
ports:
- "3301:3306"
- "3306:3306"
- "33060:33060"
- "33061:33061"
- "33062:33062"
command: ["mysqld","--server_id=1","--binlog_checksum=NONE","--gtid_mode=ON","--enforce_gtid_consistency=ON","--log_bin","--log_replica_updates=ON","--user=mysql","--host_cache_size=0", "--authentication_policy=mysql_native_password","--group-replication-local-address='mysqlClstr01:33061'"]
restart: always
mysql-shell:
env_file:
- mysql-shell.env
image: mysql-shell
container_name: mysql-shell-1
volumes:
- ./scripts/:/scripts/
network_mode: host
Could you please help me?
Subject
Views
Written By
Posted
InnoDb Cluster on docker didn't start
51
September 06, 2024 12:41AM
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.