lefred's blog


There Are 10 Types of People in the World....

How to backup your InnoDB Cluster ?

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.


pre-FOSDEM MySQL Day 2019

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


MySQL InnoDB Cluster with 2 Data Centers for Disaster Recovery: howto – part 2

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


MySQL InnoDB Cluster with 2 Data Centers for Disaster Recovery: howto

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


MySQL InnoDB Cluster: upgrade from 8.0.11 to 8.0.12

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


recent

Last Tweets

  • RT : Conferences with MySQL this week! ,
  • RT : MySQL Routerさんは8.0.16からhttpしゃべることにしたらしいですね ,
  • RT : NDB Cluster 8.0.16-dmr has been released NDB Cluster is the distributed database combining massive scalability and high availability. It provides in-memory real-time access with transactional consistency across partitioned and distributed datasets ,
  • RT : The 8.0.16 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at . ,
  • RT : MySQL Shell 8.0.16も機能がもりもり追加されてるけど、リリースノートにも書かれてない起動オプションがしれっと追加されてる。。。どっかで開発チームのブログで説明するのかな?,
Locations of visitors to this page
categories