- 21.2.1 MySQL InnoDB Cluster Requirements
- 21.2.2 Deploying a Production InnoDB Cluster
- 21.2.3 Monitoring InnoDB Cluster
- 21.2.4 Working with Instances
- 21.2.5 Working with InnoDB Cluster
- 21.2.6 Configuring InnoDB Cluster
- 21.2.7 Troubleshooting InnoDB Cluster
- 21.2.8 Upgrading an InnoDB Cluster
- 21.2.9 Tagging the Metadata
- 21.2.10 InnoDB Cluster Tips
- 21.2.11 Known Limitations
MySQL InnoDB Cluster provides a complete high availability
solution for MySQL. By using the AdminAPI 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. In this procedure
the host name
ic- is used in
examples. 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
Chapter 18, 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.
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
Chapter 22, MySQL NDB Cluster 8.0.
Section 22.1.6, “MySQL Server Using InnoDB Compared with NDB Cluster”, provides information
about the differences between the
NDB storage engines.
The following diagram shows an overview of how these technologies work together: