unable to create cluster from shell

[anweshtupili]

i am getting following log at mysql-shell:

indb_mysql-shell.1.va7hr5ktk1wu@node1 | mysqlx: [Warning] Using a password on the command line interface can be insecure.
indb_mysql-shell.1.va7hr5ktk1wu@node1 | Setting up InnoDB cluster...
indb_mysql-shell.1.va7hr5ktk1wu@node1 |
indb_mysql-shell.1.va7hr5ktk1wu@node1 | The InnoDB cluster could not be created.
indb_mysql-shell.1.va7hr5ktk1wu@node1 |
indb_mysql-shell.1.va7hr5ktk1wu@node1 | Error: Dba.createCluster: ERROR: Error starting cluster: 'mysql-server-1:3306' - Query failed. MySQL Error (3096): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.. Query: START group_replication
indb_mysql-shell.1.va7hr5ktk1wu@node1 | {
indb_mysql-shell.1.va7hr5ktk1wu@node1 | "message": "Dba.createCluster: ERROR: Error starting cluster: 'mysql-server-1:3306' - Query failed. MySQL Error (3096): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.. Query: START group_replication",
indb_mysql-shell.1.va7hr5ktk1wu@node1 | "type": "RuntimeError"
indb_mysql-shell.1.va7hr5ktk1wu@node1 | }mysqlx: [Warning] Using a password on the command line interface can be insecure.

[neumayer]

Can you post the docker and docker-compose versions you are using?

I have the following, and can start everything with a simple "docker-compose up":
docker-compose version 1.23.2
Docker version 18.09.0-ce

What calls did you make exactly?

[anweshtupili]

version: "3"
services:
mysql-server-1:
env_file:
- mysql-server.env
image: mysql/mysql-server:8.0.12
deploy:
mode: "replicated"
replicas: 1
placement:
constraints: [node.hostname == node1]
ports:
- "3301:3306"
command:
[
"mysqld",
"--server_id=1",
"--binlog_checksum=NONE",
"--gtid_mode=ON",
"--enforce_gtid_consistency=ON",
"--log-bin=mysql-bin-1.log",
"--relay-log=39a710b3235d-relay-bin",
"--log_slave_updates=ON",
"--master_info_repository=TABLE",
"--relay_log_info_repository=TABLE",
"--transaction_write_set_extraction=XXHASH64",
"--user=mysql",
"--skip-host-cache",
"--skip-name-resolve",
"--plugin-load=group_replication.so",
"--relay-log-recovery=ON",
"--group-replication-start-on-boot=OFF ",
"--group-replication-group-name=aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee",
"--group-replication-local-address=mysql-server-1:13306 ",
"--group-replication-group-seeds=mysql-server-1:13306,mysql-server-2:13306,mysql-server-3:13306",
"--loose-group-replication-single-primary-mode=OFF ",
"--loose-group-replication-enforce-update-everywhere-checks=ON",
"--default_authentication_plugin=mysql_native_password",
]
networks:
- ydel_net

mysql-server-2:
env_file:
- mysql-server.env
image: mysql/mysql-server:8.0.12
deploy:
mode: "replicated"
replicas: 1
placement:
constraints: [node.hostname == node2]
command:
[
"mysqld",
"--server_id=2",
"--binlog_checksum=NONE",
"--gtid_mode=ON",
"--enforce_gtid_consistency=ON",
"--log-bin=mysql-bin-1.log",
"--log_slave_updates=ON",
"--master_info_repository=TABLE",
"--relay_log_info_repository=TABLE",
"--transaction_write_set_extraction=XXHASH64",
"--user=mysql",
"--skip-host-cache",
"--skip-name-resolve",
"--plugin-load=group_replication.so",
"--relay-log-recovery=ON",
"--group-replication-start-on-boot=OFF ",
"--group-replication-group-name=aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee",
"--group-replication-local-address=mysql-server-1:13306 ",
"--group-replication-group-seeds=mysql-server-1:13306,mysql-server-2:13306,mysql-server-3:13306",
"--loose-group-replication-single-primary-mode=OFF ",
"--loose-group-replication-enforce-update-everywhere-checks=ON",
"--default_authentication_plugin=mysql_native_password",
]
ports:
- "3302:3306"
networks:
- ydel_net

mysql-server-3:
env_file:
- mysql-server.env
image: mysql/mysql-server:8.0.12
deploy:
mode: "replicated"
replicas: 1
placement:
constraints: [node.hostname == node3]
command:
[
"mysqld",
"--server_id=3",
"--binlog_checksum=NONE",
"--gtid_mode=ON",
"--enforce_gtid_consistency=ON",
"--log-bin=mysql-bin-1.log",
"--log_slave_updates=ON",
"--master_info_repository=TABLE",
"--relay_log_info_repository=TABLE",
"--transaction_write_set_extraction=XXHASH64",
"--user=mysql",
"--skip-host-cache",
"--skip-name-resolve",
"--plugin-load=group_replication.so",
"--relay-log-recovery=ON",
"--group-replication-start-on-boot=OFF ",
"--group-replication-group-name=aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee",
"--group-replication-local-address=mysql-server-1:13306 ",
"--group-replication-group-seeds=mysql-server-1:13306,mysql-server-2:13306,mysql-server-3:13306",
"--loose-group-replication-single-primary-mode=OFF ",
"--loose-group-replication-enforce-update-everywhere-checks=ON",
"--default_authentication_plugin=mysql_native_password",
]
ports:
- "3303:3306"
networks:
- ydel_net

mysql-shell:
env_file:
- mysql-shell.env
image: neumayer/mysql-shell-batch
volumes:
- ./scripts/:/scripts/
depends_on:
- mysql-server-1
- mysql-server-2
- mysql-server-3
restart: on-failure
networks:
- ydel_net

mysql-router:
env_file:
- mysql-router.env
image: mysql/mysql-router:8.0
deploy:
mode: "replicated"
replicas: 1
placement:
constraints: [node.hostname == node3]
ports:
- "6446:6446"
depends_on:
- mysql-server-1
- mysql-server-2
- mysql-server-3
- mysql-shell
restart: on-failure
networks:
- ydel_net

networks:
ydel_net:
external: true

[anweshtupili]

I'm using docker stack deploy -c file.yml command to run the compose file and my docker version is :18.09.0,

[neumayer]

You are using a custom network? It depends a lot on how that network is created and if it fits your needs.

Does the compose file work with docker-compose? Docker-compose creates the network automatically if not overwritten, this is what the example covers.