Introducing InnoDB Cluster: Learning the MySQL High Availability Stack

© Charles Bell 2018

Charles BellIntroducing InnoDB Clusterhttps://doi.org/10.1007/978-1-4842-3885-1_5

5. High Availability in a Sandbox

Charles Bell¹ 

(1)

Warsaw, Virginia, USA

 

Now that you have learned more about what InnoDB Cluster is and the components that make up the feature, including Group Replication and MySQL Shell, you have enough knowledge to be able to set up a small experimental InnoDB Cluster. You will do so using the new AdminAPI via MySQL Shell.

What follows is a demonstration of deploying three servers and configuring them as a cluster via Group Replication using the X AdminAPI in the new MySQL Shell. Although that sounds like a lot of effort, it really isn’t. In fact, it’s really easy.

Let’s begin with an overview of the AdminAPI. ...