Socket file isn't created after reboot.


Sometimes when node is shutdown not gracefully (power off). After boot it automatically starts a mysql. But a node state becomes:
Active: activating (start-post).

It doesn’t changes and mysql doesn’t work.

mysql -u root -p

Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

The file /var/lib/mysql/mysql.sock isn’t exists! Why it happens and how to start a node properly after crash failure (Other two nodes isn’t crashed and works properly but the crashed node have a problem)? Crashed node can’t connect to the working nodes. The can be connected together only if I stop all nodes and start them.


Sounds like some mistake in the configuration file - can you attach my.cnf from all nodes? Please attach also this node error log, it should explain why the node cannot connect the cluster peers. And it won’t create the socket file before it can properly join the other nodes, as the Galera connectivity is being established before the main MySQL is initialized.