![GIF](https://github.com/wagnerjfr/wagnerjfr/raw/main/res/ufo.gif?raw=true)
wagnerjfr / mysql-group-replication-docker Goto Github PK
View Code? Open in Web Editor NEWSetting up Group Replication with Docker MySQL images.
License: GNU General Public License v3.0
Setting up Group Replication with Docker MySQL images.
License: GNU General Public License v3.0
Hello,
I'm having issues with setting up group replication using the readme. I'm doing this as mostly proof of concept right now.
I went along and followed with the readme, and I think there are issues with setting up group replication like this in later versions of MySQL (if you don't specify a tag). However, If I use 8.0.17 like in the CI scripts, things get further.
Now, things fail in the '2_setup_gr.sh' stage. Below is the 'stage 2' log, with afterward a log of the whole setup. Any help would be greatly appreciated.
[t3-base mysql-group-replication-docker]# bash ./travis-ci/2_setup_gr.sh
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| group_replication_applier | fc8118ab-7449-11ea-9e10-0242ac180002 | node1 | 3306 | RECOVERING | SECONDARY | 8.0.17 |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3092 (HY000) at line 1: The server is not configured properly to be an active member of the group. Please see more details on error log.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3092 (HY000) at line 1: The server is not configured properly to be an active member of the group. Please see more details on error log.
[t3-base mysql-group-replication-docker]# cat /etc/redhat-release
CentOS Linux release 8.1.1911 (Core)
[t3-base mysql-group-replication-docker]# docker -v
Docker version 19.03.8, build afacb8b
[t3-base mysql-group-replication-docker]# docker logs node1
[Entrypoint] MySQL Docker Image 8.0.17-1.1.12
[Entrypoint] Initializing database
2020-04-01T18:52:46.141660Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 20
2020-04-01T18:52:50.997951Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-01T18:52:53.225933Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
[Entrypoint] Database initialized
2020-04-01T18:52:54.694692Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 67
2020-04-01T18:52:55.504461Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:52:55.523882Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2020-04-01T18:52:55.643574Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] ignoring /docker-entrypoint-initdb.d/*
2020-04-01T18:52:57.694763Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17).
2020-04-01T18:52:59.797772Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[Entrypoint] Server shut down
[Entrypoint] MySQL init process done. Ready for start up.
[Entrypoint] Starting MySQL 8.0.17-1.1.12
2020-04-01T18:53:00.927751Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 1
2020-04-01T18:53:01.551307Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:53:01.570953Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2020-04-01T18:53:01.761451Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-04-01T18:55:32.150838Z 13 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=node1-relay-bin' to avoid this problem.
2020-04-01T18:55:32.158178Z 13 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:32.192686Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:32.192706Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:32.201722Z 15 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
[t3-base mysql-group-replication-docker]# docker logs node2
[Entrypoint] MySQL Docker Image 8.0.17-1.1.12
[Entrypoint] Initializing database
2020-04-01T18:52:47.044696Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 20
2020-04-01T18:52:51.836837Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-01T18:52:53.550702Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
[Entrypoint] Database initialized
2020-04-01T18:52:54.858329Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 67
2020-04-01T18:52:55.518572Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:52:55.536108Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2020-04-01T18:52:55.674333Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] ignoring /docker-entrypoint-initdb.d/*
2020-04-01T18:52:57.737081Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17).
2020-04-01T18:52:59.986269Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[Entrypoint] Server shut down
[Entrypoint] MySQL init process done. Ready for start up.
[Entrypoint] Starting MySQL 8.0.17-1.1.12
2020-04-01T18:53:00.995693Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 1
2020-04-01T18:53:01.630194Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:53:01.647809Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2020-04-01T18:53:01.769886Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-04-01T18:55:35.684689Z 13 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=node2-relay-bin' to avoid this problem.
2020-04-01T18:55:35.695721Z 13 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:35.736757Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:35.736781Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:35.748313Z 15 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:36.923107Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:37.949040Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:38.970938Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:39.995559Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:41.018982Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:42.044365Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:43.067350Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:44.091469Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:45.114929Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:46.139533Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:47.163241Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:48.187420Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:49.211227Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:50.235316Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:51.259852Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:52.283933Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:53.308016Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:54.331972Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:55.355366Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:56.379871Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:56.379915Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 6606'
2020-04-01T18:55:56.423545Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 6606'
2020-04-01T18:56:35.814631Z 13 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2020-04-01T18:56:35.814685Z 13 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
and the full log of the whole process:
[t3-base mysql-group-replication-docker]# git clone --depth=50 --branch=master https://github.com/wagnerjfr/mysql-group-replication-docker.git
Cloning into 'mysql-group-replication-docker'...
remote: Enumerating objects: 123, done.
remote: Total 123 (delta 0), reused 0 (delta 0), pack-reused 123
Receiving objects: 100% (123/123), 348.52 KiB | 136.00 KiB/s, done.
Resolving deltas: 100% (55/55), done.
[t3-base mysql-group-replication-docker]# export MYSQL_VERSION=8.0.17
[t3-base mysql-group-replication-docker]# docker pull mysql/mysql-server:${MYSQL_VERSION}
8.0.17: Pulling from mysql/mysql-server
Digest: sha256:f9ab5082218fc9128f00f83bc707886b65b8cdfa4b9809315d18c9140655db2f
Status: Image is up to date for mysql/mysql-server:8.0.17
docker.io/mysql/mysql-server:8.0.17
[t3-base mysql-group-replication-docker]# docker network create group1
aa23be39d4859087bca126e34657b1528191b36bc4bb6563a75967dae2f67ce0
[t3-base mysql-group-replication-docker]# bash ./travis-ci/1_create_containers.sh
f77b309afbeb22835cb082d3e25e00df9f712b9afbe0292fce7a441abc6741e9
21000c62e05b3eae97fab560a4abc79832978268476c03e97d59ff6891054b08
435e0d8335323ecb4df643f699b34edc5bc5426907a915b1a33c97c8d7d16cb4
[t3-base mysql-group-replication-docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
435e0d833532 mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 18 seconds ago Up 17 seconds (health: starting) 3306/tcp, 33060/tcp node3
21000c62e05b mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 19 seconds ago Up 18 seconds (health: starting) 3306/tcp, 33060/tcp node2
f77b309afbeb mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 20 seconds ago Up 19 seconds (health: starting) 3306/tcp, 33060/tcp node1
[t3-base mysql-group-replication-docker]# sleep 120
[t3-base mysql-group-replication-docker]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
435e0d833532 mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 2 minutes ago Up 2 minutes (healthy) 3306/tcp, 33060/tcp node3
21000c62e05b mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 2 minutes ago Up 2 minutes (healthy) 3306/tcp, 33060/tcp node2
f77b309afbeb mysql/mysql-server:8.0.17 "/entrypoint.sh --se…" 2 minutes ago Up 2 minutes (healthy) 3306/tcp, 33060/tcp node1
[t3-base mysql-group-replication-docker]# docker logs node1
[Entrypoint] MySQL Docker Image 8.0.17-1.1.12
[Entrypoint] Initializing database
2020-04-01T18:52:46.141660Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 20
2020-04-01T18:52:50.997951Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-01T18:52:53.225933Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
[Entrypoint] Database initialized
2020-04-01T18:52:54.694692Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 67
2020-04-01T18:52:55.504461Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:52:55.523882Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2020-04-01T18:52:55.643574Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] ignoring /docker-entrypoint-initdb.d/*
2020-04-01T18:52:57.694763Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17).
2020-04-01T18:52:59.797772Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[Entrypoint] Server shut down
[Entrypoint] MySQL init process done. Ready for start up.
[Entrypoint] Starting MySQL 8.0.17-1.1.12
2020-04-01T18:53:00.927751Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 1
2020-04-01T18:53:01.551307Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:53:01.570953Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2020-04-01T18:53:01.761451Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
[t3-base mysql-group-replication-docker]# bash ./travis-ci/2_setup_gr.sh
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
| group_replication_applier | fc8118ab-7449-11ea-9e10-0242ac180002 | node1 | 3306 | RECOVERING | SECONDARY | 8.0.17 |
+---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3092 (HY000) at line 1: The server is not configured properly to be an active member of the group. Please see more details on error log.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 3092 (HY000) at line 1: The server is not configured properly to be an active member of the group. Please see more details on error log.
[t3-base mysql-group-replication-docker]# cat /etc/redhat-release
CentOS Linux release 8.1.1911 (Core)
[t3-base mysql-group-replication-docker]# docker -v
Docker version 19.03.8, build afacb8b
[t3-base mysql-group-replication-docker]# docker logs node1
[Entrypoint] MySQL Docker Image 8.0.17-1.1.12
[Entrypoint] Initializing database
2020-04-01T18:52:46.141660Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 20
2020-04-01T18:52:50.997951Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-01T18:52:53.225933Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
[Entrypoint] Database initialized
2020-04-01T18:52:54.694692Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 67
2020-04-01T18:52:55.504461Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:52:55.523882Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2020-04-01T18:52:55.643574Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] ignoring /docker-entrypoint-initdb.d/*
2020-04-01T18:52:57.694763Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17).
2020-04-01T18:52:59.797772Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[Entrypoint] Server shut down
[Entrypoint] MySQL init process done. Ready for start up.
[Entrypoint] Starting MySQL 8.0.17-1.1.12
2020-04-01T18:53:00.927751Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 1
2020-04-01T18:53:01.551307Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:53:01.570953Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2020-04-01T18:53:01.761451Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-04-01T18:55:32.150838Z 13 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=node1-relay-bin' to avoid this problem.
2020-04-01T18:55:32.158178Z 13 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:32.192686Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:32.192706Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:32.201722Z 15 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
[t3-base mysql-group-replication-docker]# docker logs node2
[Entrypoint] MySQL Docker Image 8.0.17-1.1.12
[Entrypoint] Initializing database
2020-04-01T18:52:47.044696Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 20
2020-04-01T18:52:51.836837Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-04-01T18:52:53.550702Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
[Entrypoint] Database initialized
2020-04-01T18:52:54.858329Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 67
2020-04-01T18:52:55.518572Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:52:55.536108Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server - GPL.
2020-04-01T18:52:55.674333Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] ignoring /docker-entrypoint-initdb.d/*
2020-04-01T18:52:57.737081Z 10 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17).
2020-04-01T18:52:59.986269Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
[Entrypoint] Server shut down
[Entrypoint] MySQL init process done. Ready for start up.
[Entrypoint] Starting MySQL 8.0.17-1.1.12
2020-04-01T18:53:00.995693Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 1
2020-04-01T18:53:01.630194Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-04-01T18:53:01.647809Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2020-04-01T18:53:01.769886Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2020-04-01T18:55:35.684689Z 13 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=node2-relay-bin' to avoid this problem.
2020-04-01T18:55:35.695721Z 13 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:35.736757Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:35.736781Z 13 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the whitelist. It is mandatory that it is added.'
2020-04-01T18:55:35.748313Z 15 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''.
2020-04-01T18:55:36.923107Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:37.949040Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:38.970938Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:39.995559Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:41.018982Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:42.044365Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:43.067350Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:44.091469Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:45.114929Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:46.139533Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:47.163241Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:48.187420Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:49.211227Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:50.235316Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:51.259852Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:52.283933Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:53.308016Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:54.331972Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:55.355366Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node1:6606 on local port: 6606.'
2020-04-01T18:55:56.379871Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to node3:6606 on local port: 6606.'
2020-04-01T18:55:56.379915Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 6606'
2020-04-01T18:55:56.423545Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 6606'
2020-04-01T18:56:35.814631Z 13 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2020-04-01T18:56:35.814685Z 13 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
Looking at the MySQL 8 docs, none of the group replication options have --loose
as an additional prefix. Consider dropping them / updating the materials to the latest mysql 8.0 version.
I get ran the docker command exactly as mentioned in the medium article, but I get this error from my docker container and the container eventually goes down.
I've tried running a single container with this set of instructions.
docker run -d --name=node1 \
-e MYSQL_ROOT_PASSWORD=mypass \
-v data:/var/lib/mysql \
mysql/mysql-server:8.0 \
--server-id=1 \
--log-bin='mysql-bin-1.log' \
--enforce-gtid-consistency='ON' \
--log-slave-updates='ON' \
--gtid-mode='ON' \
--transaction-write-set-extraction='XXHASH64' \
--binlog-checksum='NONE' \
--master-info-repository='TABLE' \
--relay-log-info-repository='TABLE' \
--plugin-load='group_replication.so' \
--relay-log-recovery='ON' \
--group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
--group-replication-local-address="node$N:33061" \
--group-replication-group-seeds='node1:33061,node2:33061,node3:33061' \
--loose-group-replication-single-primary-mode='OFF' \
--loose-group-replication-enforce-update-everywhere-checks='ON'
And these are the logs that are generated.
[Entrypoint] MySQL Docker Image 8.0.32-1.2.11-server
[Entrypoint] Starting MySQL 8.0.32-1.2.11-server
[Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
[Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
[Warning] [MY-011069] [Server] The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
[Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
[Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
[Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
[Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
[Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
[System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
[ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
[Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
[ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2023-08-09T14:24:45.427216Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
[ERROR] [MY-010119] [Server] Aborting
[ERROR] [MY-011563] [Repl] Plugin group_replication reported: 'Unable to start Group Replication. Replication applier infrastructure is not initialized since the server was started with --initialize, --initialize-insecure or --upgrade=MINIMAL on a server upgrade.'
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
Hi @wagnerjfr,
Sorry to raise another issue so soon. When I was trying the following steps I got an error at the "START GROUP_REPLICATION;" step on node1.
I checked the other medium article as well this time but it seems to be the same set of instructions. I've also tried to reproduce this on another system(Linux and MacOS) and I was getting the same error.
mysql> START GROUP_REPLICATION;
ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
It seems that the replication settings during startup are not working :(
if I remove the replication options "--group-replication*" its working.
steven@docker2:~/docker-repository/mysql-gr-cluster$ docker -v
Docker version 19.03.12, build 48a66213fe
steven@docker2:~/docker-repository/mysql-gr-cluster$ docker-compose -v
docker-compose version 1.17.1, build unknown
steven@docker2:~/docker-repository/mysql-gr-cluster$ docker logs node1 -f
[Entrypoint] MySQL Docker Image 8.0.20-1.1.16
[Entrypoint] Initializing database
2020-06-29T12:21:08.002864Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.20) initializing of server in progress as process 20
2020-06-29T12:21:08.010617Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-06-29T12:21:16.157682Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-06-29T12:21:20.845625Z 0 [Warning] [MY-013501] [Server] Ignoring --plugin-load[_add] list as the server is running with --initialize(-insecure).
2020-06-29T12:21:26.796412Z 0 [ERROR] [MY-000067] [Server] unknown variable 'group-replication-start-on-boot=OFF'.
**2020-06-29T12:21:26.796824Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.**
2020-06-29T12:21:26.797437Z 0 [ERROR] [MY-010119] [Server] Aborting
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.