You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM. This new functionality is only available in MySQL Enterprise and MySQL HeatWave. As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network (OTN): MySQL Enterprise Download. I also recommend you look at Øystein’s presentation during the Belgian MySQL Days: [1], [2]. Why use a JS function? As you may know, UUIDs are increasingly popular and their usage in MySQL is limited to the UUID V1. I already covered this in the blog post titled MySQL & ..read more

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. Then in MySQL 8.0.29 we added the possibility to add (or remove) a column anywhere in the table. For more information, please check these articles from Mayank Prasad : [1], [2] In this article, I want to focus on some dangers that could happen when using blindly this feature. Default Algorithm Since MySQL 8.0.12, for any supported DDL, the default algorithm is INSTANT ..read more

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 may experience the same problem as me, MySQL Shell complains about an invalid fingerprint detected: This error has nothing to do with the fingerprint of your user OCI Key. The problem is related to the key of your bastion host as you can see in the output window: This happens if you have changed your bastion host for example. To resolve the problem, remove the current ssh host key for t ..read more

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 in secondary indexes at the right-most column When we define a secondary index, the secondary index includes the Primary Key as the right-most column of the index. It’s silently added, meaning that it’s not visible but it’s used to point back to the record in the clustered index. This is an example with a table having a Primary Key composed of multiple columns ..read more

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 from very far away), users, contributors, community members and, of course, old friends. The atmosphere was relaxed and everyone seemed happy to be there and to be talking about MySQL. This is one of the rare opportunities to meet the MySQL developers who also operate our MySQL service on OCI and, for the first time, to meet the developers who code the unique features relating ..read more

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 one read copy (the replica) that we used to look at current and old data from our main system, we used a special trick to remove data without affecting the replica. The trick was to turn off writes to the binary log for our removal commands in the main system. External tools like pt-archiver were also able to use that trick. To stop bypass writing into the binary log ..read more

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 these 2 incredible days dedicated to MySQL. Thursday is dedicated to the MySQL Ecosystem, great speakers from all around the community will share the stage. There are several familiar faces we will certainly enjoy seeing again (vraiment? oui oui!)*. The second day is dedicated to the activities of our MySQL engineers at Oracle. The MySQL Engineering Team will be showcasing ..read more

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. I will also mention what are the required changes be able to use my previous Terraform deployment files. As an example, let’s use the modules to deploy WordPress with MySQL HeatWave Database Service: oci-wordpress-mds. Installing OpenTofu If like me you are using a RPM based Linux distro, you can find the necessary information to create the yum repository on OpenTofu’s website: $ sudo su - # cat ..read more

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 operations on JSON documents that are stored in MySQL. MySQL Document Store is ACID compliant and is compatible with everything MySQL like replication, InnoDB Cluster, … The MySQL X Dev API is available using the MySQL X Protocol, listening by default on port 33060. If you are interested in learning more about MySQL Document Store, please refer to the these presentations [1], [2], [3]. OCI ..read more

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. Today, we will not modify WordPress to split the Read and Write operations, but we will use MySQL Router 8.2.0 (see [1], [2], [3]). Architecture The architecture is simple, we will use one application server (Oracle Linux 8 on an Ampere Compute Instance) with Apache, PHP 8.2 and MySQL Router. The latest WordPress will be installed on it: You ..read more