More and more people are requesting how they could connect to MySQL without using a password but using a SSL certificate. Known as X509. CA Certificate A CA certificate is a digital certificate issued by a certificate authority (CA). It’s…
Today I upgraded my home computers to Fedora 37. I’m using some software that don’t have any rpm available for Fedora 37. Some of these applications, I used them every day and I couldn’t work on my machine without them.…
Hello dear MySQL Community ! As you may already know FOSDEM 2023 is again going to be held in-person. FOSDEM will take place February 4th and 5th 2023. We have also decided to put our pre-FOSDEM MySQL Day on track…
Next week, November 16th, I will participate to the MySQL Innovation and Cloud Virtual Day in French. My colleagues will present what’s new in MySQL 8.0.31 and also summarize all the big news that was announced at Oracle Cloud World…
Recently, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI: In these post, we were generating a slow query log in text or JSON directly in Object Storage.…
With the latest MySQL release (8.0.31), MySQL adds support for the SQL standard INTERSECT and EXCEPT table operators. Let’s have a look how to use them. We will use the following table: For our team meeting, we will order tacos…
Once again, the latest version of MySQL 8.0 includes several contributions from the MySQL Community. MySQL 8.0.31 was released on October 11th 2022. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! This…
In the previous part, we created our application and our 2 functions. Now we need to create an API Gateway to be able to call these functions from outside OCI. Using a third party scheduler, our laptop, etc… Before creating…
In my previous post, I explained how to deal with Performance_Schema and Sys to identify the candidates for Query Optimization but also to understand the workload on the database. In this article, we will see how we can create an…
If like me you are an old experienced MySQL DBA, to analyze your MySQL workload, you certainly have used the slow query log with long_query_time set to 0. The slow query log is a file that contains all the queries…
Let’s continue our journey of deploying the MySQL Database System on OCI with Terraform.This time we will see how we can use a backup (see [1] and [2]) as a source (initial data) for a new instance. Within the oci_mysql_mysql_db_system…
Today I would share a nice book related to MySQL 8.0 for our Chinese users. The original title of this book by Scott Yao, is MySQL 8.0 运维与优化 I had the chance to read parts of the book before it…
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.