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

Deploying Drupal in OCI using MDS: the easy way !

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 OCI, therefor, exposing the database on the Internet is not allowed. Even if you are not using OCI, I really … Read More

Deploy Magento with MySQL Database Service in OCI

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 to require Highly Technical knowledge to be deployed correctly. If you would like to test it with MySQL Database Service … Read More