Pre-General Availability: 2023-05-24
dba global object
global object provides an entry point for creating, configuring,
and obtaining the other InnoDB objects in AdminAPI.
|InnoDB Object||Administrative Actions|
InnoDB Clusters can be created with the
InnoDB Cluster management objects can be obtained with
||ClusterSets can be created with the
When created, InnoDB ClusterSet management objects can
be obtained with the
InnoDB ReplicaSets can be created with the
InnoDB ReplicaSet management objects can be obtained with
InnoDB Cluster provides an integrated solution for high availability and scalability using InnoDB based MySQL databases. InnoDB Cluster is an alternative solution for using Group Replication, without requiring advanced MySQL expertise.
Each MySQL server instance in an InnoDB Cluster runs MySQL Group Replication, which provides the mechanism to replicate data within an InnoDB Cluster, with built-in failover. AdminAPI removes the need to work directly with Group Replication in an InnoDB Cluster. You can also set up InnoDB ClusterSet to provide disaster tolerance for InnoDB Cluster deployments by linking a primary InnoDB Cluster with one or more replicas of itself in alternate locations, such as different datacenters.
For more information, see InnoDB Cluster.
InnoDB ClusterSet provides disaster tolerance MySQL InnoDB Cluster deployments by linking a primary InnoDB Cluster with one or more replicas of itself in alternate locations.
Emergency failover between the primary InnoDB Cluster and a replica cluster in an InnoDB ClusterSet deployment can be triggered by an administrator through MySQL Shell, using AdminAPI, which is included with MySQL Shell. You can also carry out a controlled switchover from the primary cluster to a replica cluster while the primary cluster is still available, for example if a configuration change, or you require maintenance on the primary cluster.
For more information, see InnoDB ClusterSet.
InnoDB ReplicaSet enables you to administer a set of MySQL instances running asynchronous Global Transaction ID (GTID)-based replication.
An InnoDB ReplicaSet consists of a single primary and multiple secondaries, referred to as the MySQL replication source and replicas). You administer your ReplicaSets using a ReplicaSet object and the AdminAPI operations, for example to check the status of the InnoDB ReplicaSet, and manually failover to a new primary in the event of a failure.
For more information, see InnoDB ReplicaSet.