生产搭建三节点PXC 主节点启动成功 两个从节点启动不了

来源:2-2 安装PXC组建集群

天木涯

2019-12-17

从节点启动

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

详细信息报

[root@localhost ~]# vi /etc/my.cnf
[root@localhost ~]# systemctl restart mysql
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
[root@localhost ~]# systemctl stop mysqld
[root@localhost ~]# systemctl start mysql
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
[root@localhost ~]# systemctl status mysql.service
● mysql.service - Percona XtraDB Cluster
   Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since 二 2019-12-17 22:49:21 CST; 11s ago
  Process: 31407 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
  Process: 31377 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
  Process: 30288 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
  Process: 30287 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 30121 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
 Main PID: 30287 (code=exited, status=0/SUCCESS)

12月 17 22:49:21 localhost.localdomain mysql-systemd[30288]: ERROR! mysqld_safe with PID 30287 has already exited: FAILURE
12月 17 22:49:21 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1
12月 17 22:49:21 localhost.localdomain mysql-systemd[31377]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
12月 17 22:49:21 localhost.localdomain mysql-systemd[31377]: ERROR! mysql already dead
12月 17 22:49:21 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=2
12月 17 22:49:21 localhost.localdomain mysql-systemd[31407]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
12月 17 22:49:21 localhost.localdomain mysql-systemd[31407]: WARNING: mysql may be already dead
12月 17 22:49:21 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster.
12月 17 22:49:21 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.
12月 17 22:49:21 localhost.localdomain systemd[1]: mysql.service failed.
[root@localhost ~]# ^C
[root@localhost ~]#

在虚拟机中按照课程步骤没有什么问题 在生产就出现从启动不了

写回答

2回答

天木涯

提问者

2019-12-18

不是 本地服务器 seLinux 防火墙相关端口也设置了 数据同步账号及root账号也初始化了 主节点能正常启动 从节点启不了 如果把从节点改成主节点也能启动

0
6
天木涯
回复
神思者
谢谢这么耐心的回复 问题解决了 启动将wsrep_sst_method 变更为 rsync 启动成功后 在切换成xtrabackup-v2 整个集群全部正常
2019-12-18
共6条回复

神思者

2019-12-18

你是在云主机上面设置的pxc?

0
1
dba菜鸟
我也是这个问题,就想问问 三节点通信设置好像没讲啊
2020-07-05
共1条回复

MySQL数据库集群-PXC方案,解决数据库领域疑难杂症

学习PXC,打造高价值的MySQL集群

511 学习 · 217 问题

查看课程