What’s New in MariaDB Server 10.5?
MariaDB Server 10.5 is a fresh, new, and stable version from MariaDB that was released on June, 24th 2020. Let’s take a look at the features that it will bring us. More Granular Privileges With...
Online Migration from MySQL 5.6 Non-GTID to MySQL 5.7 with GTID
In this blog post, we are going to look into how to perform online migration from MySQL 5.6 standalone setup to a new replication set running on MySQL 5.7, deployed and managed by ClusterControl. The...
Handling Replication Issues from non-GTID to GTID MariaDB Database Clusters
We recently ran into an interesting customer support case involving a MariaDB replication setup. We spent a lot of time researching this problem and thought it would be worth sharing this with you in this...
How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID
Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. Although it was fairly straightforward to replicate from a standalone MySQL server...
Top Mistakes to Avoid in MySQL Replication
Setting up replication in MySQL is easy, but managing it in production has never been an easy task. Even with the newer GTID auto-positioning, it still can go wrong if you don’t know what you...
MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions
For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...
MySQL Slave Promotion With and Without Using GTID
MySQL Replication can be fragile: whenever it encounters a connectivity error, it will retry and if it is a serious error, it will simply stop. Obviously in the latter case, you will need to repair...
Multi-Source Replication with MariaDB Galera Cluster
MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So it is possible to use a MariaDB Cluster as an aggregator for many single-instance MariaDB...