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 →
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 →
How to use the PmaControl REST API to automatically add, configure and monitor MariaDB / MySQL servers.
Read article →
Deep dive into PmaControl's internal architecture: data collection, post-processing, topology and schema export.
Read article →
New PmaControl feature: analyze master binlogs directly from the UI to diagnose MySQL/MariaDB replication lag causes.
Read article →
Complete guide to setting up MariaDB / MySQL replication and monitoring it in PmaControl: lag, GTID, corrective actions.
Read article →
Practical guide to securing PmaControl in production: Apache, PHP, MariaDB, secrets, ACL, CSRF, permissions and monitoring.
Read article →
Complete guide for maintaining PmaControl in production: upgrade procedure, checklist, migrations, rollback and best practices.
Read article →
How PmaControl leverages performance_schema to identify slow queries, missing indexes and optimize your MariaDB / MySQL servers.
Read article →
How PmaControl handles multi-source replication: channel detection, independent monitoring, limitations and roadmap.
Read article →
Configure Telegram alerts in PmaControl: bot creation, alert types, severity-based RBAC, and automated reports.
Read article →
Complete installation guide for PmaControl on Debian 12 bookworm — MariaDB 10.11, Apache, PHP 8.2, commercial branch.
Read article →
Design study for multi-resolution aggregation in PmaControl: raw → 1min → 1hr → 1day, with stddev for anomaly detection.
Read article →
How Dot3, PmaControl's topology engine, resolves and renders MariaDB / MySQL architectures with ProxySQL, MaxScale, Galera and more.
Read article →
Analysis of LOCK_EX contention on PmaControl's pivot files: flock() works but the bottleneck is real beyond 100 servers.
Read article →
PmaControl's REST API lets you manage tags, servers, SSH keys and environments through code. Here's the complete guide.
Read article →
Results of an internal PmaControl security audit: SQL injections, shell_exec, CSRF, and remediation roadmap.
Read article →
PmaControl