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 post, I wanted to show how we could take advantage of this new feature to validate JSON values. Let’s take … Read More
We saw yesterday that when an issue (like network splitting), it’s possible to remain with a partitioned cluster where none of the partition have quorum (majority of members). For more info read 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.
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 some difficulties to build it on my test machines (rpm based as mostly everybody knows). I think this might be … Read More
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 redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many … Read More