Hi,
i am getting this error when starting the service of mysql
my xtradb cluster version is 55-5.5.34-25.9.607
MySQL (Percona XtraDB Cluster) is not running, but lock fil[FAILED]lock/subsys/mysql) exists
Starting MySQL (Percona XtraDB Cluster)…The server quit [FAILED]updating PID file (/var/lib/mysql/node3.pid).
MySQL (Percona XtraDB Cluster) server startup failed! [FAILED]
here it is my.cnf file
[mysqld]
datadir=/var/lib/mysql
user=mysql
Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
Cluster connection URL contains the IPs of node#1, node#2 and node#3
PXC is more similar to normal MySQL then NDB cluster. Not sure what you mean here by a client, but each PXC node is equal and you can connect to any of them using mysql client tool.
140113 16:27:52 [Note] WSREP: gcomm: connecting to group 'my_centos_cluster', peer '192.168.8.24:,192.168.8.23:,192.168.8.22:'
140113 16:27:55 [Warning] WSREP: no nodes coming from prim view, prim not possible
140113 16:28:25 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():141
Look at the messages above, it seems clear that proper connection between this node (192.168.8.24) and the other nodes (192.168.8.23 and 192.168.8.22) cannot be established. Check the firewall rules, check if you can connect to required TCP ports manually. For example when I test ports from one node to another:
[root@pxc1 ~]# nmap -sT -p 3306,4567 10.0.2.15
Starting Nmap 5.51 ( http://nmap.org ) at 2014-01-16 13:08 UTC
Nmap scan report for 10.0.2.15
Host is up (0.00025s latency).
PORT STATE SERVICE
3306/tcp open mysql
4567/tcp open tram