Chapter 6 MySQL AdminAPI

Table of Contents

6.1 Using MySQL AdminAPI

6.2 Installing AdminAPI Software Components

6.2.1 Configuring the Host Name

6.2.2 Connecting to Server Instances

6.2.3 Persisting Settings

6.3 Retrieving a Handler Object

6.4 Creating User Accounts for AdminAPI

6.5 Verbose Logging

6.6 Finding the Primary

6.7 Scripting AdminAPI

6.8 AdminAPI MySQL Sandboxes

6.8.1 Deploying Sandbox Instances

6.8.2 Managing Sandbox Instances

6.8.3 Setting up InnoDB Cluster and MySQL Router

6.9 Tagging Metadata

6.10 Upgrade Metadata Schema

6.11 Locking Mechanism for AdminAPI Operations

6.12 Executing SQL on Topologies

6.13 Replication Compatibility Checks

This chapter covers MySQL AdminAPI, provided with MySQL Shell, which enables you to administer MySQL instances, using them to create InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet deployments, and integrating MySQL Router.