Infrastructure at your Service

All Posts By

Saïd Mendi

Saïd Mendi

Installing MariaDB Columnstore 1.5 on CentOS 8

By | Database Administration & Monitoring, Database management | No Comments

In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of MariaDB but rather a pluggable storage engine.  This allows to move easily data from InnoDB to ColumnStore and it is also the first version to be released as a plugin for the community Server.

Read More
Saïd Mendi

How can Docker help a MariaDB cluster for Disaster/Recovery

By | Database Administration & Monitoring | No Comments

Mistakes or accidental data deletions can sometimes happen on a productive MariaDB Galera Cluster and this can be disastrous. There are so many cases I have heard by customers and hereafter are some of the most common: – dropping one column of a table – dropping one table – updating a big table without a where clause What if it was possible to restore online a subset of data without downtime?

Read More
Saïd Mendi

PostgreSQL Meetup at CERN, Geneva, January 17, 2020

By | Database Administration & Monitoring, Postgres | No Comments

Registration Last Friday (17/01/20) I had the opportunity to go to Geneva at CERN to attend a PostgreSQL meetup. I’m really happy to write a blog about for a lot of reasons. First of all, it was about PostgreSQL (essential these days), also for the contributors as Oleg Bartunov and finally because of the organizers: Franck Pachot (old & soon new colleague by dbi-services) & Laeticia Avrot I met at the SOUG Day in Lausane.

Read More
Saïd Mendi

Deploying a MariaDB 10.4 Galera cluster with Clustercontrol

By | Database Administration & Monitoring | No Comments

What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines announced the version 1.7.4 with several new features. One of these was the support of…

Read More
Saïd Mendi

Galera Cluster 4 with MariaDB 10.4.8: part 2

By | Database Administration & Monitoring | No Comments

My previous blog was about the MariaDB Galera cluster new features (version 10.4). Now I will only focus on the streaming replication and give you an overview of all the tests I performed. How to enable streaming replication? Quite easy, there are only 2 parameters: wsrep_trx_fragment_unit and wsrep_trx_fragment_size Then you have to choose a replication unit between the followings: . bytes and the fragment size is in bytes . rows and the fragment size is…

Read More
Saïd Mendi

Galera Cluster 4 with MariaDB 10.4.8

By | Database Administration & Monitoring | No Comments

Last month, by a new customer I had to install the latest version of the MariaDB server: 10.4.8 to setup a Galera Cluster with 3 master nodes. The good news was that this version was shipped with the latest version of the Galera Plugin from Codership: Galera Cluster 4.0. As usual, installation & configuration was quitte easy. $ sudo yum -y install MariaDB-server $ sudo yum list installed|grep -i mariadb MariaDB-client.x86_64 10.4.8-1.el7.centos @mariadb-main MariaDB-common.x86_64 10.4.8-1.el7.centos…

Read More
Saïd Mendi

Rolling Upgrade of a Galera Cluster with ClusterControl

By | Database Administration & Monitoring | No Comments

Rolling Upgrade is easy In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster “Rolling Upgrade” without any loss of service. Let’s say we want to upgrade from Percona XtraDB Cluster version 5.6 to 5.7. The same procedure can be used to upgrade MariaDB (from 10.1 to 10.2 or 10.3) Prerequisites First of all, make sure that on your Galera cluster all nodes are synchronized. From the…

Read More