Best Practices for Monitoring Percona XtraDB Cluster: What Metrics Matter Most?

MySQL & MariaDB
,
1

Hi all,

I’d like to open a discussion about key metrics to monitor in a Percona XtraDB Cluster environment.

In my opinion, the following three metrics are among the most important for cluster health:

SHOW STATUS LIKE ‘wsrep_cluster_size’;
SHOW STATUS LIKE ‘wsrep_local_state_comment’;
SHOW STATUS LIKE ‘wsrep_cluster_status’;

The expected values should be:

wsrep_cluster_size: total number of nodes (e.g., 3)
wsrep_local_state_comment: should be “Synced”
wsrep_cluster_status`: should be “Primary”

Are there any other metrics you would recommend monitoring, particularly from a performance or reliability point of view?

Any insights or suggestions would be much appreciated.

2

I suggest you check out Percona Monitoring and Management. A 100% open source, and completely free solution to monitoring all things MySQL and PXC related; developed by MySQL Experts, for MySQL DBAs.