Deploying MySQL on OCI using OpenTofu
I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI. I will explain how to install OpenTofu and how to use it to deploy on OCI.…
JSON in MySQL HeatWave: why is data or my query not off-loaded to HeatWave Cluster ?
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…
MySQL Document Store in OCI with MySQL HeatWave
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…
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting
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.…
MySQL data archiving: another use for HeatWave Lakehouse
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…
Is MySQL HeatWave really faster ?
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…
Migrate from MariaDB to MySQL HeatWave: easier with MySQL Shell 8.2.1
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…
MySQL at DOAG 2023 – recap
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…
MySQL 8.2 Read/Write Splitting: a what cost ?
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…
MySQL Belgian Days 2024
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…
How to use MySQL 8.2 read/write splitting with Connector/Python
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…
MySQL Shell AdminAPI: different ways to call the commands… same effect?
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…
