Hello dear friends
I’ve a problem with new node . I created new node and all of the configs is the same as other nodes and it synced by other nodes .
I used haproxy and mysqlchk script in xinetd for checking cluster in remote server ,
when I run :
in local machine I got :
HTTP/1.1 200 OK Content-Type: text/plain Connection: close Content-Length: 40 Percona XtraDB Cluster Node is synced.
till here all of things are good , but when I want to test from remote machine or run
telnet 127.0.0.1 9200
I got :
Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. HTTP/1.1 503 Service Unavailable Content-Type: text/plain Connection: close Content-Length: 44 Percona XtraDB Cluster Node is not synced. Connection closed by foreign host.
in the local working well , but the response in remote machine is incorrect ,
in the log of clustercheck script shows :
Warning: Using a password on the command line interface can be insecure. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
how can I solve it ?