Percona Galera/MySQL Monitoring Template for Cacti

Galera/MySQL is synchronous multi-master cluster for InnoDB databases. Please refer to MySQL Monitoring Template for installation intructions.

Sample Graphs

The following sample graphs demonstrate how the data is presented.

../_images/galera_writeset_traffic.png

Galera Writeset Traffic. This graph shows the bytes of data replicated to the cluster (from this node) and received from the cluster (any other node).

../_images/galera_writeset_count.png

Galera Writeset Count. This graph shows the count of transactions replicated to the cluster (from this node) and received from cluster (any other node).

../_images/galera_writeset_size.png

Galera Writeset Size. This graph shows the average transaction size sent/received.

../_images/galera_replication_queues.png

Galera Replication Queues. The length of send and recv queues.

../_images/galera_parallelization_efficiency.png

Galera Parallelization Efficiency. This graph shows the average distances between highest and lowest seqno that are concurrently applied, commited and can be possibly applied in parallel (potential degree of parallelization).

../_images/galera_writing_conflicts.png

Galera Writing Conflicts. This graphs shows the number of local transactions being committed on this node that failed certification (some other node had a commit that conflicted with ours) – client received deadlock error on commit and also the number of local transactions in flight on this node that were aborted because they locked something an applier thread needed – deadlock error anywhere in an open transaction. The spike on the graph was created on the time of writing to the same table potentially the same rows from 2 nodes.

../_images/galera_cluster_size.png

Galera Cluster Size. This graph shows the number of members currently connected to the cluster.

../_images/galera_flow_control.png

Galera Flow Control. This graph shows the number of FC_PAUSE events sent/received. They are sent by a node when its replication queue gets too full. If a node is sending out FC messages it indicates the problem. On the graph you can observe FC sent/received when we were writing to both nodes and once we stopped writing to the current node, FC sent becomes 0 but still receiving FC messages from the neighbouring node.

IMPORTANT NOTE: the Flow Control graph can be faulty until this bug is fixed. The reason is the respective status variables are nullified on every SHOW STATUS query which means if something else runs it the Cacti script will see zeros right after that.

© Copyright 2012, Percona Inc.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
This documentation is developed in Launchpad as part of the Percona Monitoring Plugins source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.