mysql/mariadb 集群一个启动，另外一个启动不起来

最新推荐文章于 2022-07-15 14:26:10 发布

皮糯槽的码农

最新推荐文章于 2022-07-15 14:26:10 发布

阅读量677

点赞数

分类专栏： mariadb 文章标签： mariadb

本文链接：https://blog.csdn.net/qq_38093703/article/details/110429954

版权

项目部署的MariaDB主从数据库中，一服务器启动，另一服务器无法启动。问题源于启动时的数据同步导致超时。解决方案是修改配置，增加设置，执行`systemctl daemon-reload`后再重启服务。

摘要由CSDN通过智能技术生成

mysql/mariadb 集群一个启动，另外一个启动不起来

问题截图

[root@ds2 my.cnf.d]# service mariadb start
Redirecting to /bin/systemctl start mariadb.service
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@ds2 my.cnf.d]# journalctl -xe
Dec 01 11:47:02 ds2 mysqld[28932]: 2020-12-01 11:47:02 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
Dec 01 11:47:02 ds2 mysqld[28932]: 2020-12-01 11:47:02 0 [Note] WSREP: Opened channel 'vias_mariadb_cluster'
Dec 01 11:47:02 ds2 mysqld[28932]: 2020-12-01 11:47:02 0 [Note] WSREP: Waiting for SST to complete.
Dec 01 11:47:02 ds2 mysqld[28932]: 2020-12-01 11:47:02 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
Dec 01 11:47:02 ds2 mysqld[28932]: 2020-12-01 11:47:02 0 [Note] WSREP: STATE EXCHA