As proven again very recently by my colleague and friend Dimitri K, with the TPCC “Mystery”, sysbench made by a former colleague and friend Alexey K, is really the recommended framework to benchmark your system. I use sysbench of course to benchmark MySQL but also my OS and hardware capabilities. For those willing to benchmark MySQL 8.0 with sysbench using … Read More
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
Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary and the Secondary member of our ReplicaSet. This will be the first part of our journey to achieve HA for … Read More
As you know, today, MySQL 8.0.20 has been released. I started this new thread category with 8.0.19 (see this post). A late thanks to Guoji Ma, for a contribution to bug #95801 “show create table output can’t be executed” that was used as inspiration for the actual fix that was pushed in MySQL 8.0.18. MySQL 8.0.20, includes contributions from Daniel … Read More
Let’s continue our series of using OCI to install popular Open Source programs with MySQL 8.0. After WordPress, Drupal, it’s not the Moodle’s turn!