feat(galera): add network queue, PK certification, and split-brain quorum diagnostics
Open
@jmrenouard is already working on this.
Since Aug 7, 2026.
enhancement
- Dominant language
- Perl
- Stars
- 9.5k
- Forks
- 1.3k
- Avg merge
- 9h 4m
- Merged PRs (30d)
- 8
Description
Summary of Changes
Add new Galera Cluster diagnostic checks to mysqltuner.pl and comprehensive unit test coverage:
-
Galera Local Send & Recv Queue Monitoring:
- Detects elevated network queue averages (
wsrep_local_send_queue_avg> 0.05 orwsrep_local_recv_queue_avg> 0.05). - Recommends checking network bandwidth and storage latency on slower nodes.
- Detects elevated network queue averages (
-
Galera Primary Key Certification Enforcement Check:
- Detects when
wsrep_certify_non_pkis set toOFF. - Recommends enabling
wsrep_certify_non_pk = ONto prevent replication inconsistencies and full cluster locks.
- Detects when
-
Galera Split-Brain Quorum Check:
- Warns when
wsrep_cluster_sizeis an even number (e.g. 2 or 4 nodes) without an arbitrator. - Recommends an odd node count (3, 5) or deploying Galera Arbitrator (
garbd) to prevent split-brain quorums.
- Warns when
Verification & Unit Tests
- New dedicated unit test file:
tests/unit_galera_enhanced.t(3/3 subtests passing). - Validated via full test suite execution (
113files,570subtests passing 100%). - Validated E2E against a live 3-node MariaDB 11.8.6 Galera Cluster topology.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.