Another common question I receive about MySQL Shell Dump & Load Utility is how to dump a schema and load it with another name. Make a copy in fact. Dumping the Schema To do so, we need to use the…
As you know, the best way to perform logical dump for MySQL is to use MySQL Shell Dump & Load utilities. This is the most powerful option as it can dump and load in parallel (it also include many options…
MySQL InnoDB Cluster is the High Availability solution for MySQL. It delivers automatic fail-over and guarantees zero data loss (RPO=0). RPO: Recovery Point Objective describes the interval of time that might pass during a disruption before the quantity of data…
When you migrate to MySQL Database Service on Oracle Cloud Infrastructure (MDS on OCI), the easiest, fastest and recommended way it to use MySQL Dump & Load Utility. For more information check these different links: …
I’ve already provided some solutions to connect to your MDS instance, using MySQL Router, SSH tunnel, … but one of the best way if you have multiple instance to manage, is to use a VPN. This post summarize the steps…
This blog post was first published on FoggyKitchen.com. Hello fine gourmets, for my first dish in the FoggyKitchen.com, I decide to present you how to deploy WordPress on OCI using MySQL Database Service aka MDS. I wrote some Terraform recipes…
We recently saw how the new Invisible Column feature works in MySQL since 8.0.23 and how we can use it as a Primary Key for InnoDB tables when no Primary Key was defined. As I wrote earlier, a good Primary…
This article is the second part of the series related to MySQL Invisible Column started here. This post covers why Invisible Column is important for InnoDB Storage Engine. To start, let me explain briefly how InnoDB deals with Primary Key…
With the new MySQL 8.0.23, something very interesting has been released: Invisible Column. This is the first post dedicated to this new feature, I expect to write a series of 3. This one is the introduction.
The expected version 8.0.23 of MySQL has been released yesterday \o/ For new features and resolved bugs, I recommend Geir‘s traditional blog post announcing the release. Of course, as usual, this release contains contributions from our great Community and let…
If you plan to deploy a Drupal site to OCI using MySQL Database Service, there is a very easy way to perform that deployment: using OCI’s Resource Manager ! As you know, security is something very important for Oracle in…
Magento is a very popular e-commerce platform using MySQL as backend. The latest version is compatible with MySQL 8.0, however it’s not that easy to deploy. Magento has multiple dependencies like Elasticsearch for example. Additionally, the Open Source version seems…