Infrastructure at your Service

All Posts By

Saïd Mendi

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
Saïd Mendi

In-person event (June 11,2019) Ansible Automates – Bern

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I found in my inbox an invitation from Red Hat concerning an event organized in Bern about Ansible. I heard a lot about Automation but did not really know what can or could be automated. Infrastructure? Application deployment? Networks? Containers? Cloud? All of them? So I wanted to learn more about Ansible and decided to participate!

Read More
Saïd Mendi

Welcome to M|17, part 2

By | Database Administration & Monitoring | No Comments

Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate This exam was offered free of charges to all registered attendees As I wrote over, it was really experimental because all candidates faced many problems First, as this exam was proctored, the authentification process was very, very slow, essentially due…

Read More
Saïd Mendi

Welcome to M|17

By | Database Administration & Monitoring | No Comments

Welcome to the MariaDB’s first user conference On the 11th, started at 09:00 this big event at the Conrad Hotel in New York, closed to the One World Trade Center After the short registration process where we received a full bag of goodies (mobilephone lens,Jolt charger, cap,note block,…) we could choose between 3 workshops. – Scaling and Securing MariaDB for High Availability – MariaDB ColumnStore for High Performance Analytics – Building Modern Applications with MariaDB…

Read More
Saïd Mendi

From MySQL (Oracle) to Postgres using the EDB Migration Toolkit

By | Database Administration & Monitoring | One Comment

Why should you migrate? If your current MySQL database does not offer some needed functionnalities according to your business as: – more security – more high availibilty options (hot standby) – Strong Data Warehouse capabilities If you want to consolidate the number of different instances (Postgres, MySQL, MS-SQL,…) If you want to reduce administrative costs by using fewer database platforms Which tool should you use? the migration Toolkit command-line from EnterpriseDB that can be found…

Read More