The important bit about the cluster is that each node should be monitored independently. There is no centralized node, the cluster is the set of active, connected nodes, and each can have a different view of the cluster. Further, many of these variables are relative to the node you query them from: for example, replication sent (from this node) and received (from writes on the rest of the cluster). Having data from all nodes helps tracking down the source of issues (i.e., where are the flow control messages coming from? Where did that 100MB transaction came from?).
Standard MySQL alerting should apply here. Percona XtraDB Cluster specific alerting should include:
Other optional alerting could be done on:
Metrics collection (i.e., long-term graphing) on the cluster should be done on:
- Queue sizes (
- Flow control (
- Number of transactions in and out of this node (
- Number of transactions in and out in bytes (
- Replication conflicts (
Percona Monitoring and Management includes two dashboards to monitor PXC:
These dashboards are available from the menu:
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.