Percona XtraDB Cluster 5.6.x

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

I been facing problem with Percona nod2 when it came up it has sync everything from node1 it was working fine.

But suddenly the mysql connection was lost and while trying the same i am getting below error

[root@frdb ~]# tail -F /var/lib/mysql/domain.hostname.com.err
2016-08-27 01:33:10 27571 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2016-08-27 01:33:10 27571 [Note] WSREP: Shifting OPEN → CLOSED (TO: 64088)
2016-08-27 01:33:10 27571 [Note] WSREP: RECV thread exiting 0: Success
2016-08-27 01:33:10 27571 [Note] WSREP: recv_thread() joined.
2016-08-27 01:33:10 27571 [Note] WSREP: Closing replication queue.
2016-08-27 01:33:10 27571 [Note] WSREP: Closing slave action queue.
2016-08-27 01:33:10 27571 [Note] WSREP: /usr/sbin/mysqld: Terminated.
160827 01:33:10 mysqld_safe Number of processes running now: 0
160827 01:33:10 mysqld_safe WSREP: not restarting wsrep node automatically
160827 01:33:10 mysqld_safe mysqld from pid file /var/lib/mysql/domain.hostname.com.pid ended

2

Hello Solitude,

This tail of the error log is definitely too little to see the whole picture. When cluster issues are investigated, usually full error logs from all the nodes are needed. You may attach them as file attachments.