Infrastructure at your Service

All Posts By

Saïd Mendi

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

MariaDB: audit plugin

By | Database Administration & Monitoring | No Comments

Why should you Audit your MySQL Instances? First to provide you a way to track user accessing sensible data Secondly to investigate on suspicious queries in all your critical databases Thirdly to comply with law and industry standards The MariaDB Audit Plugin can help you to log all or part of the server activity as: – who was connected and at which time – which databases and tables were accessed – which action/event (CONNECT, TABLE,…)…

Read More
Saïd Mendi

MySQL 8.0.0 DMR – First impression

By | Database management | One Comment

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First of all, when you remember the size of earlier versions, it is more & more gluttonous, see below mysql-5.0.96-linux-x86_64-glibc23.tar.gz    121.2M mysql-5.1.72-linux-x86_64-glibc23.tar.gz    127.8M mysql-5.5.52-linux2.6-x86_64.tar.gz            177.2M mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz    299.7M mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz   611.8M mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz is around 1Gb and uncompressed 3.6Gb (Oups…) At…

Read More