In MySQL 8.0.12, we introduced a new algorithm for DDLs that won’t block the table when changing its definition. The first instant operation was adding a column at the end of a table, this was a contribution from Tencent Games.…
If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI. If you already have a connection setup using a bastion to host, you…
Recently during the Swedish MySQL User Group (SMUG), I presented a session dedicated to MySQL InnoDB Primary Keys. I forgot to mention a detail that many people are not aware, but Jeremy Cole has pointed out. Primary Key always included…
Our MySQL Belgian Days were a complete success. With 120 participants, the room was packed throughout the 2 days from the first to the last session. A record for this event ! The audience was made up of customers (some…
Maintaining a production dataset at a manageable size can present a considerable challenge during the administration of a MySQL InnoDB Cluster. Old Days Back in the day when we only had one main copy of our data (the source), and…
The MySQL Belgian Days are sold-out, our event that will take place the 1st and 2nd February 2024 in Brussels seems to have already attracted a lot of interest. And this interest is justified, because here is the program for…
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.…
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…
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.