MySQL 8.0 – Operations and Optimization (in Chinese)
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…
Category MySQL 8.0
OCI MySQL Database Service – Backup Policy and Tags
Recently 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.…
Define the Backup Policy when deploying MySQL Database Service in OCI
Let’s continue the discovery of the MySQL Database Resource when deploying on Oracle Cloud Infrastructure using Terraform. Last week, we saw how to create custom configurations and define user variables. Today we will see how we can define a backup…
Define your MySQL Configuration Variables on OCI with Terraform
With Terraform OCI provider 4.90.0 (released August 24th, 2022), we have added the possibility to specify the value of editable configuration variables directly from Terraform. These variables must be defined in a resource of type oci_mysql_mysql_configuration like this: We can…
MySQL & UUIDs
More and more people are using UUID’s to identify records in their database. As you already know, for MySQL’s storage engine (InnoDB) the primary key is very important ! (for performance, memory and disk space). See the following links: …
