Consistency during reads have been a small concern from the adopters of MySQL InnoDB Cluster (see this post and this one). This is why MySQL supports now (since 8.0.14) a new consistency model to avoid such situation when needed. Nuno Carvalho and Aníbal Pinto already posted a blog series I highly encourage you to read: Group Replication – Consistency Levels … Read More
MySQL InnoDB Cluster is evolving very nicely. I realized that the MySQL Shell also improved a lot and that it has never been so easy to setup a cluster on 3 new nodes. This is a video of the updated procedure on how to install MySQL InnoDB Cluster on GNU Linux rpm based (Oracle Linux, RedHat, CentOS, Fedora, …)
This event was just awesome. We got 110 participants ! Thank you everybody and also a big thank to the speakers. Here are the slides of all the sessions: MySQL Shell – A DevOps-engineer day with MySQL’s development and administration tool, Miguel Araújo MySQL Shell : the best DBA tool ? – How to use the MySQL Shell as a … Read More
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.
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