In this blog post, we explore how MySQL 8.0 handles dates that are input incorrectly. This is an important topic to understand, as incorrect dates behaves differently between MySQL 5.x and MySQL 8.0. In MySQL 8.0, when using invalid values for date data types, an error is returned. This was not the case in 5.x […]

Part of the MySQL Community Advent Calendar 2022, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI: https://blogs.oracle.com/mysql/post/analyzing-queries-in-mysql-database-service https://blogs.oracle.com/mysql/post/generate-slow-query-log-mysql-heatwave-part1 https://blogs.oracle.com/mysql/post/generate-slow-query-log-mysql-heatwave-part2 In these post, we were generating a slow query log in text or JSON directly in Object Storage. For today’s post, we will […]

We recently released Read Replica for MySQL HeatWave Database Service. Read Replicas are read-only copies of the MySQL DB system in the same region. When you add Read Replicas, they are automatically distributed accross Availability Domains and/or Fault Domains. Each MySQL DB instance can have up to 18 read replicas. Read Replicas use MySQL Asynchronous […]

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 the gateway, we need to create some policy to allow the API Gateway to call […]

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 OCI Fn Application that will generate a slow query log from our MySQL Database Service […]

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 whose execution time is greater than the value of long_query_time. This file can be huge […]

Today’s MySQL Community Advent Calendar post is about JSON datatype. Let’s start with some info about how MySQL Document Store handles JSON documents. Document Store and CRUD We know that MySQL 8.0 Document Store handles JSON documents with CRUD operations. We can add, delete and modify those documents very easily: JS > db.mycollection.find() { "_id": […]

Recently, for the 3rd day of the MySQL Community Advent Calendar 2022,  I wrote an article on how to define a backup policy for MySQL Database Service in OCI using Terraform. We saw that it was possible to define tags (defined_tags and freeform_tags) in the backup_policy section of a oci_mysql_mysql_db_system resource. However, it seems that […]

For this new MySQL Advent Calendar 2022, today’s post is related on how to define a Backup Policy and a Maintenance Window when deploying a MySQL Database Service instance in OCI using Terraform. Backup Policy In the oci_mysql_mysql_db_system resource, we will add a new section called backup_policy like this: backup_policy { is_enabled = "true" retention_in_days […]

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 used by clients to verify the SSL certificates sign by this CA. Such certificates is […]