A few days ago, a customer got in touch asking how they could use Percona Monitoring and Management (PMM) to monitor the roles played by each node in an InnoDB cluster. More specifically, they wanted to check when one of the nodes changed its role from Primary to Secondary, or vice-versa. PMM allows for a high level of flexibility and customization through its support for custom queries, and we just have to be creative on how we approach the problem. In this post, we present the steps we did to test our solution, including the deployment of a 3-node InnoDB Cluster hosted in the same server (for testing) and a PMM 2 server, and connecting them together. Even though this has already been covered in other blog …[Read more]
10 Older Entries »
Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc.
Reminder: InnoDB Cluster (Group Replication, Shell & Router) in version 8.0 has had serious improvements from 5.7. Please try it out.
So, given that, and given that we want to consider how best to fulfill the need, i.e. create a DR site for our InnoDB Cluster, let’s get started.
Basically I’ll be looking at the following scenario:
InnoDB Cluster Source site with a Group Replication Disaster Recovery Site.
Now, just before we get into the nitty-gritty, here’s the scope.
Life is already hard enough, so we want as much automated as possible, so, yes, InnoDB Cluster gets some of that done, but there are other parts we will still have …[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 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]
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]
As you know, Oracle Cloud Infrastructure (aka OCI) becomes more and more popular. You can find OCI data centers almost everywhere and the price is very attractive.
Something very interesting is the possibility to have different availability domains but also different fault-domains in the same availability one !
There is an official Reference Architecture for MySQL InnoDB Cluster in OCI that I encourage you to read before deploying your MySQL HA solution …[Read more]
Last week, we had two exceptional preFOSDEM MySQL Days in Brussels. A lot of MySQL Engineers presented their work but also different MySQL Users. I will publish soon an overview of the two days, but today let me share with you an interview I did with Giedrius Jaraminas, engineering manager of MySQL team in Uber.
“MySQL is heart of the Uber infrastructure“, this is how Giedrius started his presentation “Group Replication in Uber“.
Q1: Tell us about yourself, and your experience with MySQL
A1: I am a database guy for 28 years, but I am relatively new to MySQL – I am a manager of MySQL team for only 3.5 years.
Q2: Tell us about your company, and how MySQL is used.
A2: MySQL is the main offer as a relational database, also – it is used as the …[Read more]
Here comes another MySQL release, and together with it, a set of new replication features. As usual, we would like to summarize them. And, also as usual, follow up blogs will provide further details.
- Configure Replication Applier to Require Row-based Replication only.
… Tweet Share
The schedule of the preFOSDEM Day is now available !
We had a lot of proposals to deal with. Also this is a MySQL event where we, the MySQL Team has the possibility to show to you, our Community, all what we have working on to improve MySQL but also new stuff. We also invite some of our friends from the MySQL Community to talk about their experience.
I think we did a good selection and propose you new content. We are extremely happy to have Saverio Miroddi from TicketSolve talking about MySQL 8.0, Uber talking about InnoDB Cluster, and Facebook about Binlog.
As you can see, we will have 2 rooms, where one will be dedicated mostly to SQL and Optimizer topics but also tutorials.
You can also see that this year we also want to put some spot lights to MySQL NDB Cluster. You will see what is it, how is it used and what’s new. We will also have 2 community speakers sharing their MySQL NDB knowledge: Giuseppe Maxia, …[Read more]
Presentation of some of the new features of MySQL 8.0.18 released on October 14, 2019.
What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more.
The new methods I added to the plugin are especially useful when you are considering to use MySQL InnoDB Cluster in Multi-Primary mode, but not only
Let’s have a look at these new methods:
These 4 new methods are targeting large queries or large transactions. It’s also possible to get the eventual hot spots.
Let’s see the first two that are more basic in action:
The first method …[Read more]
10 Older Entries »