the MySQL Team in Austin, TX
If you registerd for our tutorial, please come with a laptop able to run 3 VirtualBox VMs that you can install from a USB stick. So please make free some disk space and install the latest Virtualbox on your system.…
MySQL InnoDB Cluster : Recovery Process Monitoring with the MySQL Shell Reporting Framework
As explained in this previous post, it’s now (since 8.0.16) possible to use the MySQL Shell Reporting Framework to monitor MySQL InnoDB Cluster. Additionally, when a member of the MySQL InnoDB Cluster’s Group leaves the group for any reason, or…
Using the new MySQL Shell Reporting Framework to monitor InnoDB Cluster
With MySQL Shell 8.0.16, a new very interesting feature was released: the Reporting Framework. Jesper already blogged about it and I recommend you to read his articles if you are interested in writing your own report: I this…
What configuration settings did I change on my MySQL Server ?
This post is just a reminder on how to find which settings have been set on MySQL Server. If you have modified some settings from a configuration file or during runtime (persisted or not), these two queries will show you…
MySQL 8.0.16: how to validate JSON values in NoSQL with check constraint
As you may have noticed, MySQL 8.0.16 has been released today ! One of the major long expected feature is the support of CHECK contraints . My colleague, Dave Stokes, already posted an article explaining how this works. In this…
MySQL InnoDB Cluster : avoid split-brain while forcing quorum
Disclaimer: it’s better to never change the value of group_replication_unreachable_majority_timeout This post provides you an overview of what could happen in the worse case but may lead in a very unstable setup We saw yesterday that when an issue (like…
MySQL InnoDB Cluster – how to manage a split-brain situation
Everywhere I go to present MySQL InnoDB Cluster, during the demo of creating a cluster, many people doesn’t understand why when I’ve 2 members, my cluster is not yet tolerant to any failure.
Ripple Binlog Server for MySQL
Today I started to check ripple the new MySQL binlog server. I don’t want to give yet any feedback neither I want to answer THE question: Is this the Binlog Server we were all waiting for ? But I had…
Replace MariaDB 10.3 by MySQL 8.0
Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new…
Migrate from MariaDB to MySQL on CentOS
On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL. Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL…
MySQL InnoDB Cluster – consistency levels
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…
MySQL InnoDB Cluster – howto install it from scratch
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…
