(root@pxc-02 15:27:31)# ls -l /var/lib/mysql/
total 0
[/var/lib/mysql]
(root@pxc-02 15:27:33)# service mysql start
Starting MySQL (Percona XtraDB Cluster)....State transfer in progress, setting sleep higher
. ERROR! The server quit without updating PID file (/var/lib/mysql/pxc-02.deadbunny.lan.pid).
ERROR! MySQL (Percona XtraDB Cluster) server startup failed!
Node 1:
(root@pxc-base 15:22:40)# cat /etc/my.cnf /var/lib/ mysql /var/lib/ mysql/mysql. sock packet= 64M autoinc_ lock_mode= 2 log_file_ size=50M file_per_ table=1 storage_ engine= InnoDB method= xtrabackup- v2 auth=pxb: pxb address= gcomm:/ /10.10. 10.136, 10.10.10. 137 address= 10.10.10. 136 name=galera01 /usr/lib64/ libgalera_ smm.so limit=65535
[mysqld]
datadir=
socket=
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
skip_name_resolve
max_allowed_
binlog_format=ROW
innodb_
innodb_
innodb_
default_
wsrep_sst_
wsrep_sst_
wsrep_cluster_
wsrep_node_
wsrep_node_
wsrep_provider=
server_id=100
open_files_
[mysqld_safe] /var/log/ mysqld. log /var/run/ mysqld/ mysqld. pid
log-error=
pid-file=
(root@pxc-base 15:24:35)# service mysql bootstrap-pxc
Bootstrapping PXC (Percona XtraDB Cluster)Starting MySQL (Percona XtraDB Cluster).. SUCCESS!
-------
Node 2: /var/lib/ mysql /var/lib/ mysql/mysql. sock packet= 64M autoinc_ lock_mode= 2 log_file_ size=50M file_per_ table=1 storage_ engine= InnoDB method= xtrabackup- v2 auth=pxb: pxb address= gcomm:/ /10.10. 10.136, 10.10.10. 137 address= 10.10.10. 137 name=galera02 /usr/lib64/ libgalera_ smm.so limit=65535
(root@pxc-02 15:22:32)# cat /etc/my.cnf
[mysqld]
datadir=
socket=
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
log-bin=mysql-bin
skip_name_resolve
max_allowed_
binlog_format=ROW
innodb_
innodb_
innodb_
default_
wsrep_sst_
wsrep_sst_
wsrep_cluster_
wsrep_node_
wsrep_node_
wsrep_provider=
server_id=100
open_files_
[mysqld_safe] /var/log/ mysqld. log /var/run/ mysqld/ mysqld. pid
log-error=
pid-file=
(root@pxc-02 15:27:26)# rm -rf /var/lib/mysql/*
[/var/lib/mysql]
(root@pxc-02 15:27:31)# ls -l /var/lib/mysql/
total 0
[/var/lib/mysql] mysql/pxc- 02.deadbunny. lan.pid) .
(root@pxc-02 15:27:33)# service mysql start
Starting MySQL (Percona XtraDB Cluster)....State transfer in progress, setting sleep higher
. ERROR! The server quit without updating PID file (/var/lib/
ERROR! MySQL (Percona XtraDB Cluster) server startup failed!
----
CentOS 6.5, PXC 5.6.19