Unable to start mysql service.

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I have followed all the steps from “https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installation” to install Percona XtraDB on my CentOS6.5 x64bit host. But when tried to start the mysql service it failed with below error,

==== [INDENT][root@localhost ~]# service mysql status
Redirecting to /bin/systemctl status mysql.service
mysql.service - Percona XtraDB Cluster
Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
Active: failed (Result: exit-code) since Wed 2015-09-23 22:44:44 EDT; 6min ago
Process: 3379 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
Process: 3352 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
Process: 2894 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
Process: 2893 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Process: 2849 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
Main PID: 2893 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/mysql.service

Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: /usr/bin/mysql-systemd: line 134: kill: (2893) - No such process
Sep 23 22:44:44 localhost.localdomain mysql-systemd[2894]: ERROR! mysqld_safe with PID 2893 has already exited: FAILURE
Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=1
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3352]: ERROR! mysql already dead
Sep 23 22:44:44 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited status=2
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Sep 23 22:44:44 localhost.localdomain mysql-systemd[3379]: WARNING: mysql may be already dead
Sep 23 22:44:44 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster.
Sep 23 22:44:44 localhost.localdomain systemd[1]: Unit mysql.service entered failed state.
[root@localhost ~]#[/INDENT] ====

Here is my my.cnf file,

==== [INDENT][root@localhost ~]# cat /etc/my.cnf

Template my.cnf for PXC

Edit to your requirements.

[mysqld]

log_bin

binlog_format = ROW
innodb_buffer_pool_size = 100M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 20M
innodb_file_per_table = 1
default_storage_engine = InnoDB
datadir = /var/lib/mysql

wsrep_cluster_address = gcomm://10.1.135.27
wsrep_provider = /usr/lib64/galera3/libgalera_smm.so

wsrep_slave_threads = 8
wsrep_cluster_name = Cluster
wsrep_node_name = Node1
wsrep_node_address = 10.1.135.27
wsrep_sst_method = rsync
wsrep_sst_auth = “sstuser:s3cret”

innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2

[mysqld_safe]
pid-file = /run/mysqld/mysql.pid
syslog

!includedir /etc/my.cnf.d[/INDENT] ====

Any idea how can I debug this?

2

Check the ownership and permissions of the directory the .pid file is being written.

Also, please sanitize your post. Removing auth info from any posting is a good idea.

3

make chonw -R mysql:mysql on your database directory (/var/lib/mysql)

then start the server with #service mysql bootstrap-pxc