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.