MySQL 8.0.27 introduced a new variable to control the maximum of parallel threads InnoDB can use for creating (sorting and building) secondary indexes: innodb_ddl_threads. This new variable is coupled with another new variable: innodb_ddl_buffer_size. If you have fast storage and…
In October 10th was released the latest GA version of MySQL: 8.0.27. As usual, it’s highly advised to read the release notes to get informed about the changes and bug fixed. MySQL is Open Source and each release contains contributions…
Recently, I saw many interest in understanding and getting information about database locking. MySQL InnoDB’s locking can be complex and having an overview not always simple. For more information about how InnoDB locking is working, I can only recommend this…
MySQL InnoDB Cluster is the official High Availability solution for and from MySQL. MySQL InnoDB Cluster is composed by MySQL Server, MySQL Group Replication, MySQL Router and MySQL Shell. Before InnoDB Cluster there was no standard solution for MySQL Availability…
When you use MySQL Shell with extra Python plugins (like these available on GitHub), sometimes, you could need extra Python modules. Some of my plugins require requests and prettytable for example. MySQL 8.0.26 uses embedded Python 3.9 and if your…
I’m active on multiple platforms (mail, slack, forums, …) and often, when people are looking for help, the first 5 or 10 questions are always the same: which version of MySQL are you running ? which OS ? is it…
In the previous post we saw how to easily deploy (in just some mouse clicks) MySQL Database Service on two different regions with data replicated from the source to the replica using OCI Resource Manager Stack. In this article, we…
Recently, we discovered how to setup Disaster Recovery in OCI MySQL Database Service using inbound/outbound replication. In this article we will see how we can deploy MDS replication architecture very easily using Terraform and OCI Resource Manager. The current modules…
Using a MySQL Database Service instance in OCI as an asynchronous replica is very useful. It allows testing the service with always updated data from on-premise production. It can be used in the process of migrating with minimal downtime to…
In previous posts we already saw how to export data from PostgreSQL and AWS RedShift, and import it on MySQL Database Service in OCI using MySQL Shell importTable utility: How to import data from PostgreSQL to MySQL Database Service How…
We already saw how easy it’s to deploy solutions on OCI using Terraform and Resource Manager’s Stack. I’ve published several resources available on this page. Today we will see how easy it’s to deploy Apache Superset on OCI using MySQL…
In part 1 of the series about Point-in-Time Recovery in OCI MDS, we saw how to stream the binary log to Object Storage. In this blog post, we will see how we can restore the data up to certain point.…
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.