MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
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
In April, I already posted an article on how to upgrade safely your MySQL InnoDB Cluster, let’s review this procedure now that MySQL 8.0.12 is out. To upgrade all the members of a MySQL InnoDB Cluster (Group), you need to keep in mind the following points: upgrade all the nodes one by one always end by the Primary Master in … Read More