lefred's blog


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

Using MySQL Workbench with MySQL Database Service

Recently (earlier today), I blogged about how to use PHPMyAdmin with a MDS instance. I also showed at the end of the video that it’s possible to open MySQL Router on the compute instance to connect from anywhere. However this has security risks of course. Therefor, it’s not recommended. If you want to connect from on-premise to your MDS instance … 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.


MySQL 8.0.22: thank you for the contributions

Wooohooo MySQL 8.0.22 has been released today ! As usual, this release contains contributions from our great Community and let me thanks all the contributors on behalf of the MySQL Team. MySQL 8.0.22 includes contributions from Denis Yarkovoy, Gord Thomson, Andrey Turbanov, Javier Matos Odut, Kan Liyong, Xiaoyu Wang, DaniĆ«l van Eeden, Krunal Bauskar, Eric Beuque and Facebook. Thank you … Read More


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


recent
categories