7 min read
Galera's multi-primary promise has a footnote: write the same row on two nodes and one transaction dies at COMMIT. How certification conflicts work, what the counters say, and how to design them out.
Database Topic Archive
MariaDB Articles
Galera clustering, InnoDB and Aria internals, replication, optimizer behavior, and MariaDB operations notes.
8 min read
MariaDB and MySQL forked over a decade ago and the operational differences are now real: incompatible GTID formats, JSON as a LONGTEXT alias, system-versioned tables, a bundled thread pool, and replication gotchas.
7 min read
ColumnStore gives MariaDB a columnar, distributed analytics engine alongside InnoDB. Here is when columnar genuinely wins, how the architecture works, and the honest limits nobody puts in the sales deck.
9 min read
MariaDB and MySQL share ancestry but their optimizers have diverged for over a decade. Here is what actually differs: optimizer_switch defaults, persistent histograms, engine-independent statistics, and a migration playbook.
8 min read
Aria is the crash-safe successor to MyISAM that MariaDB uses under the hood for internal temp tables and its own system tables. Here is how it works, how it differs from InnoDB, and why operators should care.
7 min read
Galera's synchronous replication means the whole cluster writes as fast as its slowest node. Here is how flow control works, how to read wsrep_flow_control_paused, and how to find the laggard.