We recently saw that we can benefit from using JSON documents with MySQL HeatWave cluster in OCI (HeatWave accelerator for MySQL Database Service). However sometimes the data can’t be loaded to HeatWave Cluster or the query cannot use it. And…
Since the release of MySQL 8.0, the MySQL X Dev API has provided users with the convenient ability to utilize MySQL without the need to write a single line of SQL! MySQL X Dev API brings the support for CRUD…
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.…
The ability to store data on Object Storage and retrieve it dynamically when necessary is a notable advantage of Lakehouse when managing MySQL historical data we would like to archive. Let’s illustrate this with the following table: You can notice…
You may have come across numerous presentations showcasing MySQL HeatWave as a Query Accelerator for MySQL. However, if you have not yet had the opportunity to test it yourself (if you have, you already know the answer), allow us to…
I won’t cover reasons why you should migrate from MariaDB to MySQL, I already covered the topic in previous blogs and webinars: In this post, I will cover a new easier way to migrate using the latest MySQL Shell 8.2.1…
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…
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…
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.