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 →
Deep dive into PmaControl's internal architecture: data collection, post-processing, topology and schema export.
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 →
Architectural presentation of MaxScale: L7 proxy with SQL parser, multiple protocols, routers, monitors, filters and business value for enterprises.
Read article →
Exploring cloud-native architecture for MariaDB: compute/storage decoupling via the handler API, inspired by PostgreSQL Neon and Alibaba's PolarDB.
Read article →
Reflection on SQL as a declarative API: unified access, built-in optimization, access controls, but also limitations and injection risks.
Read article →
A case against overengineering: from monolith to microservices, KISS principle, and why the best architecture is the simplest one that works.
Read article →
PmaControl