MariaDB in production: installation, Galera Cluster, replication, backups, upgrades, and where it differs from MySQL.
MariaDB has been quite active lately, the version 11.8 was already quite a step forward and apart from the changes on LTS schedule and the EOL durations, the RC 12.3 LTS is bringing some interesting changes to binlogs, pushing even further performance improvements and reliability. Instead of using the traditional flat file binlogs, they can be now integrated into InnoDB…
In this blog I will show you how you can setup a basic MariaDB Galera Cluster on Debian 11 (bullseye).If you wish to have a more general overview first you can have a look here: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ For this we have 3 servers: galera-cluster-1a/b/c. The following steps will first be executed on my first node, galera-cluster-1a still these steps have to…
Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: “Oracle Cloud Infrastructure: everything for an efficient migration“. After a welcome coffee to meet each other, Pascal Zanette shortly introduced the event and the agenda of the day. Our CTO Hervé Schweitzer presented then YaK, developed by dbi services.The idea…
I’m going to explain how to do a manual Switchover in a MariaDB HA setups using master-slave replication. In my example, let’s consider that I’ve a server01 and server02, both running on Ubuntu 20.04. server02 is currently the master, server01 the slave. We’ll perform a switchover to come back to a normal status, meaning server01 as master and server02 as…
A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Oracle OCI, MariaDB and SQLite.
Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring study for a customer, and…
Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d’Ouchy”. After a coffee and a welcome speech by Yann Neushaus, Ludovico Caldara and Flora Barriele, the event starts with 2 global sessions: A l’heure du serverless, le futur va-t-il aller aux bases de données distribuées? Franck Pachot makes a comparison between Oracle…
A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system? Lets’ quickly start an instance: mysql@vmoel:/u01/app/mysql/product/mariadb-10.3.18/bin/ [mysqld3] ./mysqld_multi…
