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 Using MySQL Router with AdminAPI, InnoDB Cluster, and InnoDB ReplicaSet

6.10.1 Bootstrapping MySQL Router

6.10.2 Configuring the MySQL Router User

6.10.3 Deploying MySQL Router

6.10.4 Routing Options

6.10.5 Using ReplicaSets with MySQL Router

6.10.6 Testing InnoDB Cluster High Availability

6.10.7 Working with a Cluster's Routers

6.11 Upgrade Metadata Schema

6.12 Locking Mechanism for AdminAPI Operations

6.13 Executing SQL on Topologies

6.14 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.