Mysql node群集:无法启动主节点

Question

我正在尝试基于Charles的“介绍innodb集群学习MySQL高可用性堆栈”一书为InnoDB集群进行第一次设置。当尝试用下面的行启动主节点时：

mysqld --defaults-file=primary.cnf > primary_output.txt 2>&1 &

错误倾向于暗示应用的变量是“未知的”。会发生什么事？

2022-08-22T17:44:30.625389Z 0 [System] [MY-010116] [Server] /usr/local/mysql-8.0.17-macos10.14-x86_64/bin/mysqld (mysqld 8.0.17) starting as process 29191
2022-08-22T17:44:30.629679Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for <home-dir>/gr/data/primary/ is case insensitive
2022-08-22T17:44:30.998523Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-08-22T17:44:31.002804Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_recovery_use_ssl=ON'.
2022-08-22T17:44:31.002811Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_name=bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee'.
2022-08-22T17:44:31.002817Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_start_on_boot=OFF'.
2022-08-22T17:44:31.002822Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_local_address=127.0.0.1:24901'.
2022-08-22T17:44:31.002827Z 0 [Warning] [MY-000068] [Server] unknown option '--loose-group_replication_group_see'.
2022-08-22T17:44:31.002832Z 0 [ERROR] [MY-000067] [Server] unknown variable 'ds=127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903,127.0.0.1:24904'.
2022-08-22T17:44:31.003631Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-22T17:44:31.998566Z 0 [System] [MY-010910] [Server] /usr/local/mysql-8.0.17-macos10.14-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.17)  MySQL Community Server - GPL.

以下是这些配置：

#primary.cnf
[mysqld]
datadir=<home-dir>/gr/data/primary
basedir=/usr/local/mysql-8.0.17-macos10.14-x86_64/
plugin_dir=/usr/lib/mysql/plugin/
port=24801
socket=<home-dir>/gr/primary.sock
server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
transaction_write_set_extraction=XXHASH64
loose-group_replication_recovery_use_ssl=ON
loose-group_replication_group_name="bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="127.0.0.1:24901"
loose-group_replication_group_see
ds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903,127.0.0.1:24904"
loose-group_replication_bootstrap_group=OFF


#secondary1.cnf
[mysqld]
datadir=/Users/goremo/gr/data/secondary1
basedir=/usr/local/mysql-8.0.17-macos10.14-x86_64/
plugin_dir=/usr/lib/mysql/plugin/
port=24802
socket=/Users/goremo/gr/secondary1.sock
server_id=2
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
loose-group_replication_recovery_get_public_key=ON
loose-group_replication_recovery_use_ssl=ON
loose-group_replication_group_name="bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="127.0.0.1:24902"
loose-group_replication_group_see
ds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903,127.0.0.1:24904"
loose-group_replication_bootstrap_group=OFF

#secondary2.cnf
[mysqld]
datadir=/Users/goremo/gr/data/secondary2
basedir=/usr/local/mysql-8.0.17-macos10.14-x86_64/
plugin_dir=/usr/lib/mysql/plugin/
port=24803
socket=/Users/goremo/gr/secondary2.sock
server_id=3
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
loose-group_replication_recovery_get_public_key=ON
loose-group_replication_recovery_use_ssl=ON
loose-group_replication_group_name="bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="127.0.0.1:24902"
loose-group_replication_group_see
ds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903,127.0.0.1:24904"
loose-group_replication_bootstrap_group=OFF

#secondary3.cnf
[mysqld]
datadir=/Users/goremo/gr/data/secondary3
basedir=/usr/local/mysql-8.0.17-macos10.14-x86_64/
plugin_dir=/usr/lib/mysql/plugin/
port=24804
socket=/Users/goremo/gr/secondary3.sock
server_id=4
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
loose-group_replication_recovery_get_public_key=ON
loose-group_replication_recovery_use_ssl=ON
loose-group_replication_group_name="bbbbbbbb-bbbb-cccc-dddd-eeeeeeeeeeee"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address="127.0.0.1:24902"
loose-group_replication_group_see
ds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903,127.0.0.1:24904"
loose-group_replication_bootstrap_group=OFF

注:我正在使用mac，mysql v8.0.17

Answer 1

当您可以使用InnoDB Shell将您从所有这些复杂性中抽象出来时，为什么要手动设置MySQL集群呢？

请参阅https://dev.mysql.com/doc/mysql-shell/8.0/en/deploying-production-innodb-cluster.html