|
我正在一台主机上通过启用不同端口（3307、3308、3309）构建mgr集群，但在初始化MGR第一个节点时出现问题，过程是我在第一个节点的配置文件增加mgr参数后，再次启动mysql服务时 进程被自动kill。配置文件如下： [root@localhost greatdb]# cat greatsql1/conf/my.cnf [mysqld] user = mysql basedir=/usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal datadir=/greatdb/greatsql1/data port=3307 mysqlx_port=13307 server_id=103307 log-bin log_slave_updates=1 gtid_mode=ON enforce_gtid_consistency=ON log-error=/greatdb/greatsql1/logs/greatdb.log socket=/greatdb/greatsql1/data/greatsql.socket mysqlx_socket=/greatdb/greatsql1/data/greatsqlx.socket #mgr plugin_load_add='group_replication.so' group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1" group_replication_local_address= "192.168.10.128:33071" group_replication_group_seeds= "192.168.10.128:33071,192.168.10.128:33081,192.168.10.128:33091" report-host=192.168.10.128 日志如下： 2024-03-11T12:50:53.410594Z 0 [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. 2024-03-11T12:50:53.410660Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-03-11T12:50:53.410664Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-03-11T12:50:53.410715Z 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal/bin/mysqld (mysqld 8.0.32-25) starting as process 2965 2024-03-11T12:50:53.419894Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-03-11T12:50:54.093143Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-03-11T12:50:54.152459Z 0 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2024-03-11T12:50:54.164141Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2024-03-11T12:50:54.169459Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2024-03-11T12:50:54.232518Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-03-11T12:50:54.232548Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-03-11T12:50:54.243101Z 0 [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=localhost-relay-bin' to avoid this problem. 2024-03-11T12:50:54.247332Z 0 [System] [MY-010931] [Server] /usr/local/GreatSQL-8.0.32-25-Linux-glibc2.28-x86_64-minimal/bin/mysqld: ready for connections. Version: '8.0.32-25' socket: '/greatdb/greatsql1/data/greatsql.socket' port: 3307 GreatSQL, Release 25, Revision db07cc5cb73. 2024-03-11T12:50:54.247708Z 4 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2024-03-11T12:50:54.248706Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 13307, socket: /greatdb/greatsql1/data/greatsqlx.socket 2024-03-11T12:50:54.249622Z 12 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, 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=''. 此外没有其他日志信息，我不清楚是哪里配置有问题。 |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
