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

How to deploy a MySQL Database Service Instance with PHPMyAdmin

I recently received several messages from developers not being comfortable with command line when they need to create schemas, tables, … They were asking me for an easy alternative when testing MDS. There is a very popular tool in the developer community to manage their databases in MySQL: PHPMyAdmin. So if you are trying MDS (MySQL Database Service in Oracle … Read More

MySQL: How many transactions were committed during an interval of time ?

The amount of transactions committed is an important information, but how could you return an accurate value? This is a question I got from my colleague Ivan, he was challenging with global status values like COM_COMMIT or HANDLER_COMMIT, then checking in innodb_metrics… but this was not accurate.

Migrate from on premise MySQL to MySQL Database Service

This post was first published on Oracle MySQL Blog. If you are running MySQL on premise, it’s maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it to stay running and safe. This awesome place is MySQL Database Service in OCI. For more information about what MDS … Read More