Blog 50
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 installation guide for MySQL 8.4 LTS on Debian 13 trixie — Oracle APT repository, hardening, configuration, datadir, performance_schema.
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 →
Aggregate multiple MySQL sources into a single multi-source replica with MySQL 8.4 — complete guide.
Read article →
MySQL 8.0 renamed Master/Slave to Source/Replica. Here's how PmaControl and the Glial framework handle bidirectional compatibility.
Read article →
Root cause analysis of repeated MariaDB OOM kills — systemd MemoryMax, tmp_table_size=768M, RocksDB 4G cache and connection storms.
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 →
PMM IST variables don't exist on MariaDB 10.6 Galera. Here's how to detect a real IST.
Read article →
Analysis of LOCK_EX contention on PmaControl's pivot files: flock() works but the bottleneck is real beyond 100 servers.
Read article →
14 minutes to recover a full datacenter — timeline and lessons learned.
Read article →
PmaControl's REST API lets you manage tags, servers, SSH keys and environments through code. Here's the complete guide.
Read article →
Forensic investigation of 6 MariaDB crashes where crash recovery exists but no OOM or segfault appears in the logs.
Read article →
Results of an internal PmaControl security audit: SQL injections, shell_exec, CSRF, and remediation roadmap.
Read article →
MDEV-39044 correlation analysis: MyRocks corruption triggered by ALTER TABLE + memory pressure on MariaDB 10.11.
Read article →![SQLSTATE [HY000] [2006] Galera has gone away](/image/blog/galera-has-gone-away.svg)
MariaDB plc removes Galera from open-source in its 12.3 LTS release: analysis of the consequences for the community and thoughts on open-source sustainability.
Read article →
Missing indexes, untested backups, silent replication drifts — our analysis.
Read article →
Real anonymised case: how Alex rewrote routing rules in 30 seconds.
Read article →
Practical guide to installing and configuring MaxScale: configuration file sections, MaxGUI, MaxCtrl and REST API for automation.
Read article →
Analysis of SkySQL's reacquisition by MariaDB: between AI promises and the reality of serverless multi-cloud DBaaS.
Read article →
MyISAM is officially deprecated: the mysql system database and temporary tables have migrated. Why and how to abandon MyISAM for good.
Read article →
Architectural presentation of MaxScale: L7 proxy with SQL parser, multiple protocols, routers, monitors, filters and business value for enterprises.
Read article →
How a DATE vs INT type mismatch in a join caused a 105-minute execution time, resolved to 17 seconds with a virtual generated column.
Read article →
Performance regression after MySQL 8 to MariaDB 11.4 migration: how a LEFT JOIN anti-pattern was resolved using a CTE and the EXCEPT operator.
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 →
Understanding MariaDB's query cache: operating modes, monitoring, efficiency ratios, Galera limitations and the MaxScale cache filter alternative.
Read article →
MariaDB's visibility problem: too little known outside DBA circles, misaligned marketing, and solutions to build awareness.
Read article →
Analysis of MaxScale's transition from BSL to commercial license: history, impact, ProxySQL alternatives, and loss of the BSL spirit.
Read article →
Codership's acquisition by MariaDB plc: implications for Galera Cluster, the open-source community, and competition with Oracle MySQL and PostgreSQL.
Read article →
Advanced MariaDB hardening techniques: init_file, LUKS, systemd PrivateMounts, chattr immutability and custom SELinux policies.
Read article →
MariaDB plc's financial difficulties are resolved: a look back at the crisis, the restructuring, and the prospects of renewed stability.
Read article →
Reflection on SQL as a declarative API: unified access, built-in optimization, access controls, but also limitations and injection risks.
Read article →
The SST vulnerability in Galera: how a rogue node can trigger a full data transfer, and how wsrep_allow_list protects your cluster.
Read article →
Against New Year resolutions: change requires intentional planning, not a simple calendar flip.
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 →
Personal essay on Proust's involuntary memory: childhood memories, grandparents' bakery trips, family gratitude and sensory anchoring.
Read article →
Experimental concept: building an asynchronous message queue with MariaDB's Blackhole engine, replication binlog, and InnoDB triggers.
Read article →
Applying the AAA security model to MariaDB: physical isolation through views, stored procedures, and locked accounts for defense in depth.
Read article →
Understanding the Flow Control mechanism in Galera: thresholds, critical wsrep variables, tuning parameters and expert recommendations.
Read article →
MariaDB's history since the 2009 fork: technical divergence, dual Foundation/Corporation governance, massive adoption and continuous innovation.
Read article →
PmaControl