We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector I love this new feature, but I was wondering if it was really worth it. Will the application benefit…
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…
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 Architecture To play with our Python program, we will…
During last Ubuntu Summit in Riga, I got an interesting question from Alex Lutay, engineering manager at Canonical regarding the different ways to perform some Admin API commands in MySQL Shell. He wanted to know why, in the manual and…
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…
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…
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…
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…
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…
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…
If you are deploying MySQL on containers, one of the first tasks is to find the right image. There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment. For example, when…
Many of us, old MySQL DBAs used Seconds_Behind_Source from SHOW REPLICA STATUS to find out the status and correct execution of (asynchronous) replication. Please pay attention of the new terminology. I’m sure we’ve all used the old terminology. However, MySQL…
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.