In this article, we’ll explore the step-by-step process of deploying an InnoDB Cluster on MySQL, empowering you to harness the full potential of this robust database solution
Configure instance
Configure on each instance, please repeat this action to configure the instance before join innodb cluster
dba.configureLocalInstance("root@localhost:3306");
MySQL JS > shell.connect("clusteradmin@centos-mysql-cluster-01:3306");
Create Cluster
MySQL JS > cluster = dba.createCluster('mysql_playground_cluster');
MySQL JS > var cluster = dba.getCluster();
MySQL JS > cluster.status()
Join / Add new instance to Cluster
MySQL JS > cluster.addInstance(‘clusteradmin@centos-mysql-cluster-02:3306’);
MySQL JS > cluster.addInstance('clusteradmin@centos-mysql-cluster-03:3306');
A cluster has been created with 3 nodes ( can tolerate up )
