You might already have seen the announcement of the MySQL InnoDB Cluster Release Candidate (RC), available for download from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories and from dev.mysql.com. As usual, this releases contains the following three components.
- MySQL Server 5.7.17 GA (direct package download)
- MySQL Shell 1.0.8 RC (direct package download)
- MySQL Router 2.1.2 RC (direct package download)
We carefully listened to the feedback we got from the last preview release and incorporated many of the suggested changes. On top of that, we have fixed several bugs and extended existing functionalities. The most prominent are:
- MySQL Shell
- Completed the dba.rebootClusterFromCompleteOutage() function to reboot the cluster was implemented
- Allow for repetitive calls to dba.configureLocalInstance() to persist the InnoDB cluster configuration in the my.cnf file for auto-rejoin of restarted instances
- dba.configureLocalInstance() now can create a dba user user, automatic detection of my.cnf path
- Renamed dba.checkInstanceConfig() to dba.checkInstanceConfiguration() and dba.configLocalInstance() to dba.configureLocalInstance()
- Added support for IP whitelist feature of Group Replication
- Fixed SSL support
- MySQL Router
- Added new options to bootstrap command
- SSL options have been added
- X Protocol Support was added
To get a detailed list of changes and improvements please read this blog post.
Until now we have been focusing on Sandbox setups which are the easiest and straight forward way to learn and test the InnoDB cluster. During the last months, we have been getting lots of requests to also cover real-world production environment setups. Therefore we have been working on a series of blog posts that will outline how to get InnoDB cluster working on dedicated hosts (be it VMs or physical boxes).
- Setting up a Real-World Cluster
Please also review the State Diagram and a blog post that explains each state that an InnoDB cluster can get into and how a DBA can move the cluster between the different states.
We are also working on a special treat for our Windows users. The MySQL Installer will get full GUI support to create Sandbox setups as well as real-world production setups of the InnoDB cluster.
Please feel free to try this latest version and give us feedback on bugs.mysql.com