MySQL 8.0 Enterprise High Availability

Tuesday, 07 May 2019 by Lucas Vogel

In less than five minutes you can configure a cluster of highly available MySQL Database servers with data consistency, built-in data conflict handling, node failure detection and automatic failover operations - with no manual intervention or custom tools.

Category: Enterprise Features

g the InnoDB cluster, which is required for enterprise-level high availability. We will not discuss MySQL NDB storage engine, a distributed database that requires the MySQL 8.0 Cluster CGE license and a separate install altogether.

Let's take a look at how it works.

Replication and Group Replication

Replication is the process of taking data from one server (the "master") and copying the data to one or more servers (the "slaves"). Replication is asynchronous and doesn't require continuous uptime for the replicas. MySQL Community, Standard and Enterprise support two replication types:

Synchronous replication is only available through MySQL NDB Cluster in the MySQL 8.0 Cluster GCE license.

Group replication is a shared-nothing multi-master, update-everywhere replication scheme where each server has its own copy of the data, and servers communicate to each other through message passing in its own communication layer. In this configuration, read-only transactions occur independently, but read-write operations commit only after being approved by all members of the group. Group replication provides a highly available, highly elastic, dependable MySQL service.

MySQL Router

MySQL Router is a fundamental component of a highly available MySQL Enterprise cluster, acting as a connection proxy to your cluster environment. MySQL 8.0 Router can connect to MySQL 5.x and MySQL 8.0 database servers, and customers can configure round-robin or availability strategies for data access. MySQL 8.0 Router is self-configuring on startup, providing for seamless operation.

MySQL Shell

MySQL Shell is an interactive client and code editor for MySQL 8 that also provides scripting capabilities for JavaScript and Python, and provides APIs for interacting with MySQL. Most importantly, MySQL Shell gives us access to the AdminAPI, which allows for interaction with the high availability and cluster configuration for your server environment.

MySQL Enterprise Monitor

MySQL 8.0 Enterprise Monitor comes with a Replication Dashboard that shows you the topology of your highly available MySQL cluster. Enterprise Monitor takes a deep dive into replication status on each monitored server and shows you the statuses of your nodes, logs, and group overall - a good list of information provided can be found here.

Enterprise Monitor

MySQL Enterprise High Availability

To summarize, the difference between high availability and replication between Community and Enterprise is the fact that Enterprise gives you hot backups, Enterprise Monitor for keeping an eye on things, Audit and other features. In other words, Enterprise High Availability isn't a product - it's a feature!

Looking for more information on how to set up a highly available MySQL instance? Have questions about using the NDB data engine? Reach out with your questions and we'll help you sort them out!