Table of Contents
- 7.1 MySQL InnoDB Cluster Requirements
- 7.2 Deploying a Production InnoDB Cluster
- 7.3 Monitoring InnoDB Cluster
- 7.4 Working with Instances
- 7.5 Working with InnoDB Cluster
- 7.6 Configuring InnoDB Cluster
- 7.7 Troubleshooting InnoDB Cluster
- 7.8 Upgrading an InnoDB Cluster
- 7.9 InnoDB Cluster Tips
- 7.10 InnoDB Cluster Limitations
MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using AdminAPI, which is included with MySQL Shell, you can easily configure and administer a group of at least three MySQL server instances to function as an InnoDB Cluster.
Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB Clusters, with built-in failover. AdminAPI removes the need to work directly with Group Replication in InnoDB Clusters, but for more information see Group Replication which explains the details.
MySQL Router can automatically configure itself based on the cluster you deploy, connecting client applications transparently to the server instances. In the event of an unexpected failure of a server instance the cluster reconfigures automatically. In the default single-primary mode, an InnoDB Cluster has a single read-write server instance - the primary. Multiple secondary server instances are replicas of the primary. If the primary fails, a secondary is automatically promoted to the role of primary. MySQL Router detects this and forwards client applications to the new primary. Advanced users can also configure a cluster to have multiple primaries.
The following diagram shows an overview of how these technologies work together:
InnoDB Cluster does not provide support for MySQL NDB Cluster. NDB Cluster
depends on the
engine as well as a number of programs specific to NDB Cluster which
are not furnished with MySQL Server 8.0;
NDB is available only as part of the MySQL
NDB Cluster distribution. In addition, the MySQL server binary
(mysqld) that is supplied with MySQL Server
8.0 cannot be used with NDB Cluster. For more information
about MySQL NDB Cluster, see MySQL NDB Cluster 8.0.
MySQL Server Using InnoDB Compared with NDB Cluster, provides
information about the differences between the