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.
We started this trip using the MySQL InnoDB ReplicaSet where only 2 servers are sufficient but doesn’t provide automatic fail-over.
In this article we will upgrade our InnoDB ReplicaSet to …
[Read more]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 finally we had one MySQL InnoDB ReplicaSet of two …
[Read more]
In my previous post in this series I've commented on
some interesting MySQL bug reports that were added during the
second half of April. Time to move on to bugs reported in May,
2020, as we are quickly approaching MySQL Bug #100000 soon and I
want to write a separate post for this great achievement :)
Here is the list:
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 our WordPress site on OCI and using all MySQL Servers we have deployed. We don’t want to have a server idle just waiting to take over in case of an incident.
MySQL InnoDB ReplicaSet
First some words about MySQL InnoDB ReplicaSet.
The ease of use of …
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 Black, Cai Yibo, Jericho Rivera, Matti Sillanpää, Nick Pollett, Bruce Feng, Kamil Holubicky, Facebook.
Thank you all for your great contributions. MySQL is an Open Source project, GPL, and we accept contribution of course. Sometimes it’s also good to remind it
Here is the list of the contributions above:
Time for the next blog post about MySQL bugs! The previous one covered some bugs I considered
interesting in March, this one will be about community bug
reports that I've picked up since March 26, 2020. I'd better
review bug fixed in MySQL 5.7.30 instead of this, but it is still
not released, even though we know it must get some important
security fixes based on "Oracle Critical Patch Update Advisory - April
2020" recently published.
As usual, I am mostly interested in replication, …
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!
This is a request from my Japanese colleague Machiko
We will use two different compute instances:
The application server will be reachable from the Internet on port 22 (ssh) and 80 (http). The database server won’t be reachable from outside, we will have to use the application server as jumphost to install the server.
This is an overview of the proposed architecture:
Deploying 2 compute instances
The first step is to install 2 compute instances, one in the Public Subnet and one in the Private Subnet.
We first start with the application server (called myMoodle):
As the second instance will be located …
[Read more]Last Tuesday, it was the very first session of DB AMA, Morgan Tocker made a nice presentation of MySQL Performance_Schema and illustrated it with some nice queries to get Meta et Data Locks.
As those queries were not that simple to write or at least to remember, I thought it might be a good idea to add them to MySQL Shell, the best MySQL DBA Tool !
I’ve then added a new method to the check plugin:
getLocks().
Let’t see it in action:
As you can see, this is a small extension that can offers you a better view of what’s locked per transaction.
You can find several MySQL Shell Extension directly on github: …
[Read more]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!
The architecture will be the following:
We will use 2 different Availability Domains (AD), of course we could have used 3, it’s up to you.
We will install MySQL Router on the Application Server as advised, and we will modify our Drupal’s configuration to connect locally on the R/W port of the MySQL Router.
You will see that this is very easy to achieve, the most …
[Read more]
My weekdays are still busy even during this lockdown period, but
weekend is a perfect time for yet another blog post about MySQL bugs I
considered interesting. Very few followers read my posts on other topics anyway, especially if
they have the "M....DB" word...
So, here is a new list of optimizer, replication, InnoDB and few
other bugs in GA versions of MySQL that I've subscribed to since
the end of February, 2020: