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

Question

从节点启动

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 ~]#

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

Answer 1

提问者 天木涯 2019-12-18 08:40:34

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

• 神思者 #1

  本地有几个主机？什么操作系统？

• 提问者 天木涯 回复 神思者 #2

  三节点 centod7 三台机器都是能互通

• 神思者 回复 提问者 天木涯 #3

  我觉得可能有三个原因，首先是防火墙和selinux，其次是配置文件，最后是系统的原因，你用三个新的centos系统试一下

点开查看后面3条评论

Answer 2

神思者 2019-12-18 08:29:18

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

• dba菜鸟 #1

  我也是这个问题，就想问问  三节点通信设置好像没讲啊