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…
In the previous post, we setup a Drupal website with MySQL as backend on a different compute instance in a different subnet. Today we will increase the High Availability of our Database by transforming this single MySQL instance into a…
MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL. The solution is composed of: MySQL Server MySQL Group Replication Plugin MySQL Clone Plugin MySQL Router MySQL Shell All those components are developed and tested together…
Create a MySQL InnoDB Cluster using MySQL 8.0 has always been very easy. Certainly thanks to MySQL Shell and server enhancements like SET PERSIST and RESTART statement (see this post). The most complicated part to deal with was the existing…
Consistency during reads have been a small concern from the adopters of MySQL InnoDB Cluster (see this post and this one). This is why MySQL supports now (since 8.0.14) a new consistency model to avoid such situation when needed. Nuno…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.