Posts tagged "mariaDB"

Upgrading MariaDB 10.11 to 11.8 on Debian 12: A Safe Master-Slave Replication Guide

Running an older database version in production is not necessarily a problem, especially when it is stable and has been running reliably for years. However, there comes a point when security updates, performance improvements, and new features make upgrading a reasonable decision. Recently, I needed to plan an upgrade of a MariaDB environment running on… Continue reading →

MariaDB 11.8 Upgrade on Debian 12, Fixing Missing Compression Provider Plugins

Upgrading a database server is usually straightforward when everything goes according to plan. Update the repository, install the new packages, restart the service, and verify that the database is running. But sometimes, a successful package installation is only half the story. Recently, I upgraded a MariaDB Master–Slave replication environment from MariaDB 10.11.19 to 11.8.9 on… Continue reading →

Reseeding MariaDB Master–Slave Replication (Non-GTID) While the Master Stays Online

MariaDB replication breaks at the worst possible time, right when you need the database to be calm, predictable, and boring. If you’re running classic (non-GTID) master–slave replication, the fastest way out of a messy drift is usually not to “skip errors” or “restart services” endlessly. The cleanest recovery is to reseed the slave from a… Continue reading →

MariaDB Master Slave Installation and Configuration on Linux Debian 12 Bookworm

MariaDB is an open-source relational database management system (RDBMS) that emerged as a fork of MySQL after concerns over its acquisition by Oracle. Developed by the original creators of MySQL, MariaDB retains compatibility with MySQL while offering additional features and enhancements. It supports ACID-compliant transactions, is known for its performance and scalability, and is widely… Continue reading →