lefred's blog

There Are 10 Types of People in the World....

How to copy a MySQL user to OCI MDS ?

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: https://mysqlserverteam.com/mysql-shell-dump-load-part-1-demo/ https://mysqlserverteam.com/mysql-shell-dump-load-part-2-benchmarks/ https://mysqlserverteam.com/mysql-shell-dump-load-part-3-load-dump/ https://docs.oracle.com/en-us/iaas/mysql-database/doc/importing-and-exporting-databases.html http://dasini.net/blog/2020/12/17/mysql-shell-the-new-era/ https://blogs.oracle.com/mysql/migrate-from-on-premise-mysql-to-mysql-database-service MySQL Shell performs all the checks required also for copying users to MDS when using util.dumpInstance()method. This is the … Read More

Using OpenVPN with MySQL Database Service

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 on how to deploy Open VPN and configure your VCN to use it. So, in OCI, we have already some … Read More

Deploy WordPress on OCI using MDS – updated version

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 that you can find on my GitHub repository: oci-wordpress-mds. In this first post, I will show how easy it’s to … Read More

MySQL Invisible Column: part III

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 Key is important for InnoDB (storage, IOPS, secondary indexes, memory…) but there is another important domain where a Primary Key … Read More

MySQL Invisible Column: part II

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 and why an good primary key is important. And finally, why having a Primary Key is also important. How does … Read More