Answer the question
In order to leave comments, you need to log in
How to beat Percona XtraDB Cluster?
Hello. The situation is as follows: there is a cluster of 3 machines on Percona XtraDB Cluster 5.6. Initially, it was configured and tested, the data was synchronized normally, the working databases were flooded and released for production. At first everything was fine, but by the morning on the first node in the processlist there were a bunch of requests under max connection in the wsrep in pre-commit stage during long transaction status.
I turned off all the servers, turned them on in order, everything seemed to work, but then it turned out that the 1st server worked in some kind of fantasy world of its own, and the other two in its own. Info from 1st server:
mysql> show global status like '%wsrep_cluster%';
+--------------------------+--------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------+
| wsrep_cluster_conf_id | 3 |
| wsrep_cluster_size | 3 |
| wsrep_cluster_state_uuid | 2da7c277-596b-11e6-9df7-da34104b031c |
| wsrep_cluster_status | Primary |
+--------------------------+--------------------------------------+
show global status like '%wsrep_ready%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready | ON |
+---------------+-------+
mysql> show global status like '%wsrep_cluster%';
+--------------------------+--------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------+
| wsrep_cluster_conf_id | 2 |
| wsrep_cluster_size | 2 |
| wsrep_cluster_state_uuid | 2da7c277-596b-11e6-9df7-da34104b031c |
| wsrep_cluster_status | Primary |
+--------------------------+--------------------------------------+
show global status like '%wsrep_ready%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready | OFF |
+---------------+-------+
show global status like '%wsrep_cluster%';
+--------------------------+--------------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------------+
| wsrep_cluster_conf_id | 3 |
| wsrep_cluster_size | 3 |
| wsrep_cluster_state_uuid | 2da7c277-596b-11e6-9df7-da34104b031c |
| wsrep_cluster_status | Primary |
+--------------------------+--------------------------------------+
show global status like '%wsrep_ready%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wsrep_ready | OFF |
+---------------+-------+
ERROR 1047 (08S01): WSREP has not yet prepared node for application use
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question