Category: MySQL Shell
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
Using MySQL Database Service for WordPress
Today we will see how to use MySQL Database Service aka MDS with WordPress. To achieve this easy task, we will use the architecture we already deployed in this article. We have then two Compute Instances on OCI, 1 running WordPress (Apache and PHP) and one running MySQL 8.0.
Testing MySQL Database Service without VPN – part 2
In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN. A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X Protocol port is something you should absolutely avoid ! So, in this article we will see another way to test … Read More
Testing MySQL Database Service without VPN
Please note that this is not recommended for any production purpose, don’t expose MySQL traffic to the Internet ! MySQL Database Service is now available, take a look at this nice introduction video:
comments