Last week, from November 21 to 24, the DOAG Conference took place in Nuremberg, Germany. The MySQL Team was present at the Oracle booth. I attended the conference Thursday and Friday. There were 20 sessions tagged “MySQL” and one full day workshop dedicated to students. I delivered the first part of the workshop dedicated to […]

After 12 consecutive years of MySQL presence at FOSDEM, the MySQL Devroom has been rejected of the 2024 edition. The MySQL & Friends Devroom has been always very popular, almost full for each sessions and maybe the room with the most received submissions. This is also the reason why since 2017, MySQL was proposing a […]

As you know, one of the most eagerly waited features was released with MySQL 8.2: the transparent read/write splitting. In this post, we’ll look at how to use it with MySQL-Connector/Python. Architecture To play with our Python program, we will use an InnoDB Cluster. This is an overview of the cluster in MySQL Shell: JS […]

1. Preface This blog begins by introducing the current state of systemd notifications in MySQL. It then delves into how systemd notifications can be used and how they differ from other MySQL monitoring utilities like Error log, General log, etc. This blog then discusses new granular notifications added in server initialization, startup and shutdown flows, followed […]

The latest release of MySQL (October 25th, 2023) is the second Innovation Release of the most popular Open Source database. This new evolution release brings us ever closer to the very first MySQL LTS Release! This new Innovation Release already contains contributions from our great Community. MySQL 8.2.0 contains patches from Meta, Nikolai Kostrigin, Meng-Hsiu […]

We’ve been all waiting for it! It’s now available! Read/Write Splitting in MySQL !! At scale, we distribute reads between replica(s), but this has to be managed somehow in the application: pointing writes somewhere and reads somewhere else. With MySQL 8.2, MySQL Router is now able to identify reads and writes and route them to […]

Since MySQL Shell 8.1, it’s even easier to create a logical backup of your MySQL instance and store it directly in Object Storage, an internet-scale, high-performance storage platform in Oracle Cloud Infrastructure (OCI). MySQL Shell now offers the option of dumping to Object Storage Bucket using PAR (Pre-Authenticated Request). Bucket Creation The first step is […]

Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets cluster we are using is OKE (Oracle Kubernetes Engine) in OCI (Oracle Cloud Infrastructure): OKE Cluster We start by creating a Kubernetes Cluster on OCI using the Console: We select the Quick create mode: We need to name our cluster and […]

To copy a MySQL server to another server or to the cloud, there are several ways. We can distinguish between two different types of copy: The physical copy is often the fastest. However, it requires some tools to ensure that you have a consistent online backup. For example, you can use MySQL Enterprise Backup (MEB). […]

Sometimes it’s convenient to retrieve the user creation statement and to copy it to another server. However, with the new authentication method used as default since MySQL 8.0, caching_sha2_password, this can become a nightmare as the output is binary and some bytes can be hidden or decoded differently depending of the terminal and font used. […]