PmaControl
When Switching to GTID Breaks Replication
Field note: switching to GTID does not purge source binlogs, but CHANGE MASTER resets the replica local relay logs.
Read article →
GeoIP in PmaControl: IPv4 and IPv6 Resolution Without Reading the mmdb File on Every Request
How PmaControl resolves the geolocation of hundreds of MariaDB/MySQL servers in real time by importing GeoLite2 ranges directly into MariaDB for instant SQL lookups — IPv4 and IPv6.
Read article →
PmaControl — April 2026 Sprint Recap: 114 Commits, MySQL 8.4, Binlog Analysis, IPv6
Full recap of the April 2026 sprint: MySQL 8.4 compatibility, binlog analysis, GeoIP IPv6, UI redesign, ReadOnly role, and the roadmap ahead.
Read article →
Automatically add MariaDB / MySQL servers to PmaControl via the webservice
How to use the PmaControl REST API to automatically add, configure and monitor MariaDB / MySQL servers.
Read article →
PmaControl Internal Architecture: Aspirateur, Listener, Dot3 and 162 Tables
Deep dive into PmaControl's internal architecture: data collection, post-processing, topology and schema export.
Read article →
Analyzing Binlogs to Understand Replication Lag
New PmaControl feature: analyze master binlogs directly from the UI to diagnose MySQL/MariaDB replication lag causes.
Read article →
Deploy Master/Slave and Monitor Replication in PmaControl
Complete guide to setting up MariaDB / MySQL replication and monitoring it in PmaControl: lag, GTID, corrective actions.
Read article →
Hardening PmaControl in Production: Complete Security Guide
Practical guide to securing PmaControl in production: Apache, PHP, MariaDB, secrets, ACL, CSRF, permissions and monitoring.
Read article →
Install MySQL 8.4 on Debian 13
Complete installation guide for MySQL 8.4 LTS on Debian 13 trixie — Oracle APT repository, hardening, configuration, datadir, performance_schema.
Read article →
Maintaining PmaControl Commercial Branch: Upgrade, Rollback and Best Practices
Complete guide for maintaining PmaControl in production: upgrade procedure, checklist, migrations, rollback and best practices.
Read article →
Performance Schema and PmaControl Dashboards: Tracking Slow Queries
How PmaControl leverages performance_schema to identify slow queries, missing indexes and optimize your MariaDB / MySQL servers.
Read article →
Monitor Multi-Source Replication with PmaControl
How PmaControl handles multi-source replication: channel detection, independent monitoring, limitations and roadmap.
Read article →
Connect Telegram to PmaControl: Real-Time Alerts
Configure Telegram alerts in PmaControl: bot creation, alert types, severity-based RBAC, and automated reports.
Read article →
Install PmaControl on Debian 12
Complete installation guide for PmaControl on Debian 12 bookworm — MariaDB 10.11, Apache, PHP 8.2, commercial branch.
Read article →
Multi-Source Replication with MySQL 8.4
Aggregate multiple MySQL sources into a single multi-source replica with MySQL 8.4 — complete guide.
Read article →
MySQL 8.0 Replication: Bridging Source/Replica and Master/Slave
MySQL 8.0 renamed Master/Slave to Source/Replica. Here's how PmaControl and the Glial framework handle bidirectional compatibility.
Read article →
The Silent OOM Killer: How 768MB Session Settings Drowned 16GB of Memory
Root cause analysis of repeated MariaDB OOM kills — systemd MemoryMax, tmp_table_size=768M, RocksDB 4G cache and connection storms.
Read article →
Time-Series Aggregation: From Millions of Raw Points to Fast Queries
Design study for multi-resolution aggregation in PmaControl: raw → 1min → 1hr → 1day, with stddev for anomaly detection.
Read article →
Dot3: Mapping Complex MariaDB / MySQL Topologies
How Dot3, PmaControl's topology engine, resolves and renders MariaDB / MySQL architectures with ProxySQL, MaxScale, Galera and more.
Read article →
Galera IST: What PMM Shows vs. What Really Exists
PMM IST variables don't exist on MariaDB 10.6 Galera. Here's how to detect a real IST.
Read article →
Shared Locks and Pivot Files: Contention in PmaControl
Analysis of LOCK_EX contention on PmaControl's pivot files: flock() works but the bottleneck is real beyond 100 servers.
Read article →
Control the uncontrollable: anatomy of a DC crash
14 minutes to recover a full datacenter — timeline and lessons learned.
Read article →
PmaControl REST API: Infrastructure-as-Code for MariaDB / MySQL
PmaControl's REST API lets you manage tags, servers, SSH keys and environments through code. Here's the complete guide.
Read article →
Silent MariaDB Crashes: When Log Silence Masks Critical Failures
Forensic investigation of 6 MariaDB crashes where crash recovery exists but no OOM or segfault appears in the logs.
Read article →
PmaControl Security Audit: Hardening Roadmap
Results of an internal PmaControl security audit: SQL injections, shell_exec, CSRF, and remediation roadmap.
Read article →
MyRocks Under Load: When ALTER TABLE Triggers Corruption
MDEV-39044 correlation analysis: MyRocks corruption triggered by ALTER TABLE + memory pressure on MariaDB 10.11.
Read article →
Why 80% of SQL incidents are avoidable
Missing indexes, untested backups, silent replication drifts — our analysis.
Read article →
ProxySQL meltdown → live reroute
Real anonymised case: how Alex rewrote routing rules in 30 seconds.
Read article →