Error startup PXC with 1 node

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi, I can’t startup PXC with bootstrap in Centos 7 with 1 node.

This is the config file my.cnf:

[mysql]

# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
user = mysql
default-storage-engine = InnoDB
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysql.pid

# Cluster Config #
wsrep_cluster_address=gcomm://
binlog_format=ROW
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=AirePXC
wsrep_sst_method=mysqldump
#wsrep_sst_auth="sstuser:s3cr3t"
wsrep_node_name=PXC1
wsrep_node_address=127.0.0.1
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2

# MyISAM #
key-buffer-size = 32M
myisam-recover = FORCE,BACKUP

# SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
innodb-strict-mode = 1

# DATA STORAGE #
datadir = /var/lib/mysql/

# BINARY LOGGING #
log-bin = /var/lib/mysql/mysql-bin
expire-logs-days = 14
sync-binlog = 1

# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 1024
table-open-cache = 2048

# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2

Startup PXC:

systemctl start mysql@bootstrap.service

And the output error:

Job for mysql@bootstrap.service failed. See 'systemctl status mysql@bootstrap.service' and 'journalctl -xn' for details.

Error Details:

ene 14 11:03:19 localhost.localdomain mysql-systemd[25304]: ERROR! mysql pid file /var/lib/mysql/mysql.pid empty or not readable
ene 14 11:03:19 localhost.localdomain mysql-systemd[25304]: WARNING: mysql may be already dead
ene 14 11:03:19 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.
-- Subject: Unit mysql@bootstrap.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysql@bootstrap.service has failed.
-- 
-- The result is failed.
ene 14 11:03:19 localhost.localdomain systemd[1]: Unit mysql@bootstrap.service entered failed state.
ene 14 11:03:20 localhost.localdomain sshd[25272]: Failed password for root from 103.41.124.18 port 34714 ssh2
ene 14 11:03:20 localhost.localdomain sshd[25272]: Received disconnect from 103.41.124.18: 11: [preauth]
ene 14 11:03:20 localhost.localdomain sshd[25272]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=103.41.124.18 user=root
ene 14 11:03:22 localhost.localdomain unix_chkpwd[25333]: password check failed for user (root)
ene 14 11:03:22 localhost.localdomain sshd[25331]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=103.41.124.18 user=root
ene 14 11:03:22 localhost.localdomain sshd[25331]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
[root@localhost data]#

Any ideas?

2

I found the problem, I had not disabled the SELinux. :confused: