PmaControl
![SQLSTATE [HY000] [2006] Galera has gone away](/image/blog/galera-has-gone-away.svg)
SQLSTATE [HY000] [2006] Galera has gone away
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 →
MaxScale: Much More Than a Reverse SQL Proxy (Part 2)
Practical guide to installing and configuring MaxScale: configuration file sections, MaxGUI, MaxCtrl and REST API for automation.
Read article →
Opinion: MariaDB (re)acquires SkySQL
Analysis of SkySQL's reacquisition by MariaDB: between AI promises and the reality of serverless multi-cloud DBaaS.
Read article →
MyISAM Is Deprecated: Time to Migrate
MyISAM is officially deprecated: the mysql system database and temporary tables have migrated. Why and how to abandon MyISAM for good.
Read article →
MaxScale: Much More Than a Reverse SQL Proxy (Part 1)
Architectural presentation of MaxScale: L7 proxy with SQL parser, multiple protocols, routers, monitors, filters and business value for enterprises.
Read article →
Bad Data Design Leads to Poor Performances: From 105 Minutes to 17 Seconds
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 →
I Beat the MariaDB Optimizer: From 94 Seconds to 55 Milliseconds
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 →
Making MariaDB Cloud Native: Decoupling Compute from Storage
Exploring cloud-native architecture for MariaDB: compute/storage decoupling via the handler API, inspired by PostgreSQL Neon and Alibaba's PolarDB.
Read article →
Toying Around with MariaDB: Query Cache Edition
Understanding MariaDB's query cache: operating modes, monitoring, efficiency ratios, Galera limitations and the MaxScale cache filter alternative.
Read article →
Opinion: Maria What?
MariaDB's visibility problem: too little known outside DBA circles, misaligned marketing, and solutions to build awareness.
Read article →
Opinion: MaxScale License Change
Analysis of MaxScale's transition from BSL to commercial license: history, impact, ProxySQL alternatives, and loss of the BSL spirit.
Read article →
Opinion: The Future of Galera Cluster
Codership's acquisition by MariaDB plc: implications for Galera Cluster, the open-source community, and competition with Oracle MySQL and PostgreSQL.
Read article →
Cybersec: MariaDB, Round 2
Advanced MariaDB hardening techniques: init_file, LUKS, systemd PrivateMounts, chattr immutability and custom SELinux policies.
Read article →
MariaDB Financial Troubles Are a Thing of the Past
MariaDB plc's financial difficulties are resolved: a look back at the crisis, the restructuring, and the prospects of renewed stability.
Read article →
Is SQL a High-Level API?
Reflection on SQL as a declarative API: unified access, built-in optimization, access controls, but also limitations and injection risks.
Read article →
Preventing Data Theft: Galera Edition
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 →
New Year Reality Check: Slowing Down to Move Forward
Against New Year resolutions: change requires intentional planning, not a simple calendar flip.
Read article →
Embrace Simplicity
A case against overengineering: from monolith to microservices, KISS principle, and why the best architecture is the simplest one that works.
Read article →
My Madeleine de Proust
Personal essay on Proust's involuntary memory: childhood memories, grandparents' bakery trips, family gratitude and sensory anchoring.
Read article →
MMQ: MariaDB as a Message Queue
Experimental concept: building an asynchronous message queue with MariaDB's Blackhole engine, replication binlog, and InnoDB triggers.
Read article →
Let's go physical(ly separated)
Applying the AAA security model to MariaDB: physical isolation through views, stored procedures, and locked accounts for defense in depth.
Read article →
Galera: Understanding Flow Control
Understanding the Flow Control mechanism in Galera: thresholds, critical wsrep variables, tuning parameters and expert recommendations.
Read article →
MariaDB: So Much More Than Just a MySQL Fork
MariaDB's history since the 2009 fork: technical divergence, dual Foundation/Corporation governance, massive adoption and continuous innovation.
Read article →