启动本地安装的pxc集群失败，前面的步骤都检查没错了

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

慕婉清5351156

2020-11-11

在真是的华为云linux centos7.4 上执行 systemctl start mysql@bootstrap.service 启动失败了

图片描述
● mysql@bootstrap.service - Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap
Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Wed 2020-11-11 23:28:44 CST; 14s ago
Process: 22844 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
Process: 22814 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
Process: 22355 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
Process: 22352 ExecStart=/usr/bin/mysqld_safe --basedir=/usr ${EXTRA_ARGS} (code=exited, status=1/FAILURE)
Process: 22311 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
Main PID: 22352 (code=exited, status=1/FAILURE)

Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 mysql-systemd[22355]: ERROR! mysqld_safe with PID 22352 has already exited: FAILURE
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=1
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 mysql-systemd[22814]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 mysql-systemd[22814]: ERROR! mysql already dead
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=2
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 mysql-systemd[22844]: WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 mysql-systemd[22844]: WARNING: mysql may be already dead
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 systemd[1]: Unit mysql@bootstrap.service entered failed state.
Nov 11 23:28:44 ecs-c6s-large-2-linux-20201111105913 systemd[1]: mysql@bootstrap.service failed.

写回答

2回答

慕婉清5351156

提问者

2020-11-12

问题解决了！！其他步骤按照视频一样，但是在修改 etc下配置文件的时候，没有按照视频里面把全部配置都放一起，是直接在各个配置文件上修改值的，然后第一个节点启动成功了，第二个也成功了，第三个正在弄：）

神思者

2020-11-12

有几种情况你排查一下，首先centos不能安装MySQL或者percona，这样才能安装pxc。再有你要用课程自带的安装包，官网最新安装包不一定兼容云主机。最后华为云是ARM的CPU，有很多Linux程序对ARM兼容不好。

慕婉清5351156

是新机器，没有安装mysql或者percona; 安装包是在课程git上面下载的；Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 2 On-line CPU(s) list: 0,1 Thread(s) per core: 2 Core(s) per socket: 1 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 85 Model name: Intel(R) Xeon(R) Gold 6278C CPU @ 2.60GHz Stepping: 7 CPU MHz: 2600.000 BogoMIPS: 5200.00 Hypervisor vendor: KVM Virtualization type: full L1d cache: 32K L1i cache: 32K L2 cache: 1024K L3 cache: 36608K NUMA node0 CPU(s): 0,1

2020-11-12

共1条回复

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

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

511 学习 · 217 问题

查看课程

相似问题

启动pxc集群失败

回答 2

初次安装pxc集群,第一个pxc节点正常启动，客户端也连接正常。防火墙和selinux都关闭了。但是第二个节点连接不到第一个pxc节点，配置也没有错误

回答 2

安装pxc集群报错

回答 1

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

回答 2

关于在阿里云安装PXC组建集群，安装一直失败

回答 2

打开慕课网App查看更多内容