For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. Is this related to the increase of microservices? In a microservices architecture, services are typically designed to…
InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!). If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages…
The fourth edition of the MySQL Cookbook, solutions for database developers and administrators is a huge book, 938 pages ! And the least we can say is that you get what you pay for ! This book is an excellent…
We are seeing increasing requests for migrations from MariaDB to MySQL. MariaDB has significantly diverged, and is no longer drop-in compatible with MySQL. To migrate from MariaDB to MySQL, an in-place upgrade is not possible. A logical dump and load…
After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle. During this event and for the…
In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018. It was…
The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community. I would like to thank all contributors on behalf…
Recently Jack asked me for a Sysbench package for OL9. In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system. Sysbench’s binary is linked with…
As you know, before FOSDEM, the MySQL Community Team organizes a 2 days conference in Brussels. During these preFOSDEM MySQL Days, attendees will have the opportunity to learn more about MySQL from Oracle’s MySQL teams and selected professionals from the…
As a MySQL database administrator, have you ever faced a brute force attack on your database server or been the target of a DDOS-like connection flow on port 3306? If so, you will quickly understand why this plugin distributed with…
If you tried to migrate live from Amazon RDS/Aurora or any other Cloud to OCI MySQL HeatWave before December 6, 2022, you may have encountered issues with Amazon to OCI asynchronous replication. See: Live Migration from Azure Database for MySQL…
In this article, I will guide you through the process of setting up a fully functional Zabbix monitoring system on Oracle Cloud Infrastructure. The deployment and configuration of the Zabbix server and web frontend, as well as the integration with…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.