I am trying to set up Percona cluster on CentOS6.5 and i followed the guide at:
I set up the first node and bootstrapped it. Everything seems correct with that node.
The problem is with second and third node. I just can’t start mySQL server.
I get this error when using this command “/etc/init.d/mysql start”
MySQL (Percona XtraDB Cluster) is not running, but lock file (/var/lock/subsys/mysql) exists [FAILED]
Starting MySQL (Percona XtraDB Cluster).The server quit without updating PID file (/usr/local/mysql/var/localhost.localdomain.pid). [FAILED]
MySQL (Percona XtraDB Cluster) server startup failed! [FAILED]
Node 2 my.cnf:
Path to Galera library
Cluster connection URL contains IPs of node#1, node#2 and node#3 wsrep_cluster_address=gcomm://192.168.70.123,192.168.70.120,192.168.70.144
In order for Galera to work correctly binlog format should be ROW
MyISAM storage engine has only experimental support
This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb_autoinc_lock_mode=2
Node #2 address
#Authentication for SST method