MySQL InnoDB cluster for a sandbox environment

We have MySQL Server and MySQL Shell installed on one machine. We have ensured that MySQL Shell is able to connect to MySQL Server. So, in this section, we will create an InnoDB cluster in a sandbox environment.

Here, we will use XAdminAPI, which has built-in features that configure an InnoDB cluster on a local machine, allowing us to set up and play around with the program. Note that this method should not be used to create a production environment.

First, we need to use DBA as a global variable from the MySQL Shell AdminAPI, as follows:

> mysqlshMYSQL JS > dba.deploySandboxInstance( 4410 )

A new MySQL sandbox instance will be created on this host in C:\Users\john\MySQL\mysql-sandboxes\4410 ...

Get Advanced MySQL 8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.