Comment 2 for bug 1362830

Revision history for this message
Ernie Souhrada (ernest-souhrada) wrote :

Node 1:

(root@pxc-base 15:22:40)# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
skip_name_resolve
max_allowed_packet=64M
binlog_format=ROW
innodb_autoinc_lock_mode=2
innodb_log_file_size=50M
innodb_file_per_table=1
default_storage_engine=InnoDB
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=pxb:pxb
wsrep_cluster_address=gcomm://10.10.10.136,10.10.10.137
wsrep_node_address=10.10.10.136
wsrep_node_name=galera01
wsrep_provider=/usr/lib64/libgalera_smm.so
server_id=100
open_files_limit=65535

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

(root@pxc-base 15:24:35)# service mysql bootstrap-pxc
Bootstrapping PXC (Percona XtraDB Cluster)Starting MySQL (Percona XtraDB Cluster).. SUCCESS!

-------

Node 2:
(root@pxc-02 15:22:32)# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
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_packet=64M
binlog_format=ROW
innodb_autoinc_lock_mode=2
innodb_log_file_size=50M
innodb_file_per_table=1
default_storage_engine=InnoDB
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=pxb:pxb
wsrep_cluster_address=gcomm://10.10.10.136,10.10.10.137
wsrep_node_address=10.10.10.137
wsrep_node_name=galera02
wsrep_provider=/usr/lib64/libgalera_smm.so
server_id=100
open_files_limit=65535

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

(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]
(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!

----
CentOS 6.5, PXC 5.6.19