lefred's blog


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

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.


MySQL 8.0 InnoDB Cluster with WordPress in OCI – part III

With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II We started this trip using the … Read More


MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II

This article is the second part of our journey to WordPress and MySQL 8.0 High Availability on OCI. The first part can be read here. We ended part I with one webserver hosting WordPress. This WordPress was connecting locally to MySQL Router using HyperDB add-on. This add-on allows to split the reads & writes on MySQL Servers using replication. And … Read More


I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.
recent
categories