If you are using MySQL InnoDB Cluster (Group Replication) with ProxySQL, you should be familiar with the 2 functions and 1 view required in SYS Schema that ProxySQL uses to see if a node is online, partitioned or not, and if it’s lagging or not (see link1 and link2). I received recently a very valuable contribution from Bruce DeFrang that … Read More
I had the pleasure to receive a nice educative video from my colleague Narendra Singh Chauhan, working in the QA team for MySQL Replication. If you are curious to understand how all this works, please take a look at the video, like it and share it 😉
For the third year in a row, we will take advantage of the mass presence of our MySQL Engineers during FOSDEM to organize the pre-FOSDEM MySQL Day. The program of this 3rd edition is already on track, thank you to all the speakers who already confirmed their participation. Start End Event Speaker Company Topic Friday 1st February 09:30 10:00 MySQL … Read More
In the first part of this howto, I illustrated how to setup two MySQL InnoDB Cluster linked by an asynchronous replication. In that solution, I didn’t use any replication filters to ignore the replication of the InnoDB Cluster’s metadata (mysql_innodb_cluster_metadata), but I used the same metadata tables with two different clusters in it. The benefit is that this allows to … Read More
As you know, MySQL InnoDB Cluster is a High Availability solution for MySQL. However more and more people are trying to use it as a Disaster Recovery solution with 2 data centers. Natively, this is not yet supported. But it’s already possible to realize such setup if we agree with the following points: a human interaction is required in case … Read More
comments