Chapter 6 Using MySQL AdminAPI

Table of Contents

6.1 MySQL AdminAPI

6.2 MySQL InnoDB Cluster

6.2.1 MySQL InnoDB Cluster Requirements

6.2.2 Deploying a Production InnoDB Cluster

6.2.3 Monitoring InnoDB Cluster

6.2.4 Working with Instances

6.2.5 Working with InnoDB Cluster

6.2.6 Configuring InnoDB Cluster

6.2.7 Troubleshooting InnoDB Cluster

6.2.8 Upgrading an InnoDB Cluster

6.2.9 Tagging the Metadata

6.2.10 InnoDB Cluster Tips

6.2.11 Known Limitations

6.3 MySQL InnoDB ReplicaSet

6.3.1 Introducing InnoDB ReplicaSet

6.3.2 Deploying InnoDB ReplicaSet

6.3.3 Adding Instances to a ReplicaSet

6.3.4 Adopting an Existing Replication Set Up

6.3.5 Working with InnoDB ReplicaSet

6.4 MySQL Router

6.4.1 Bootstrapping MySQL Router

6.4.2 Using AdminAPI and MySQL Router

6.5 AdminAPI MySQL Sandboxes

This chapter covers MySQL AdminAPI, provided with MySQL Shell, which enables you to administer MySQL instances, using them to create InnoDB Clusters, InnoDB ReplicaSets, and integrating MySQL Router.