Installed Galera MySQL. Able to join cluster but 2nd node or 3rd node mysqld not started.

[Novex Kong]

root@950cda56ebaa:/# /etc/init.d/mysql restart --wsrep_cluster_address=gcomm://172.17.0.27,172.17.0.30,172.17.0.29 --wsrep_cluster_name=galera-cluster

 * MySQL server PID file could not be found!

Starting MySQL

............... * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

 * Failed to restart server.

root@950cda56ebaa:/# netstat -anpt | grep LISTEN

tcp        0      0 0.0.0.0:4567            0.0.0.0:*               LISTEN      -

tcp        0      0 0.0.0.0:4444            0.0.0.0:*               LISTEN      -

tcp6       0      0 :::4444                 :::*                    LISTEN      -

root@950cda56ebaa:/# netstat -anpt | grep 4567

tcp        0      0 0.0.0.0:4567            0.0.0.0:*               LISTEN      -

tcp        0      0 172.17.0.30:58712       172.17.0.27:4567        ESTABLISHED -

root@950cda56ebaa:/# mysql -p

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

root@950cda56ebaa:/#

_______________________

root@950cda56ebaa:/# cat /etc/mysql/my.cnf

[mysqld]

user            = mysql

pid-file        = /var/run/mysqld/mysqld.pid

socket          = /var/run/mysqld/mysqld.sock

port            = 3306

basedir         = /usr

datadir         = /var/lib/mysql

tmpdir          = /tmp

lc-messages-dir = /usr/share/mysql

# Galera Provider Configuration & library

wsrep_provider=/usr/lib/libgalera_smm.so

#wsrep_provider_options="gcache.size=32G"

wsrep_cluster_name=galera-cluster

# Cluster connection URL contains the IPs of node#1, node#2 and node#3

wsrep_cluster_address=gcomm://172.17.0.27,172.17.0.30,172.17.0.29

#wsrep_cluster_address=gcomm://

# Actual Node IP Address

wsrep_node_address=172.17.0.30

#wsrep_node_name="this_node_name"

# In order for Galera to work correctly binlog format should be ROW

binlog_format=ROW

# MyISAM storage engine has only experimental support

default_storage_engine=InnoDB

# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera

innodb_autoinc_lock_mode=2

# SST method

wsrep_sst_method=rsync

#wsrep_sst_auth="root:root"

________________________________

Thanks. Please anyone can help?

[Philip Stoev]

Hello,

The reason for not being able to start will be reported in the mysqld.err
log file.

Philip Stoev

--
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.