Saïd Mendi

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…

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!

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…

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,…)…