######## [umshastr@hod03]/export/umesh/server/binaries/InnoDBCluster/mysql-shell-1.0.8-rc-linux-glibc2.12-x86-64bit: export PATH=$PATH:/export/umesh/server/binaries/InnoDBCluster/mysql-5.7.17-linux-glibc2.5-x86_64/bin [umshastr@hod03]/export/umesh/server/binaries/InnoDBCluster/mysql-shell-1.0.8-rc-linux-glibc2.12-x86-64bit: bin/mysqlsh Welcome to MySQL Shell 1.0.8-rc Copyright (c) 2016, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help', '\h' or '\?' for help, type '\quit' or '\q' to exit. Currently in JavaScript mode. Use \sql to switch to SQL mode and execute queries. mysql-js> dba.deploySandboxInstance(3310) A new MySQL sandbox instance will be created on this host in /home/umshastr/mysql-sandboxes/3310 Please enter a MySQL root password for the new instance: Deploying new MySQL instance... Instance localhost:3310 successfully deployed and started. Use shell.connect('root@localhost:3310'); to connect to the instance. mysql-js> dba.deploySandboxInstance(3320) A new MySQL sandbox instance will be created on this host in /home/umshastr/mysql-sandboxes/3320 Please enter a MySQL root password for the new instance: Deploying new MySQL instance... Instance localhost:3320 successfully deployed and started. Use shell.connect('root@localhost:3320'); to connect to the instance. mysql-js> dba.deploySandboxInstance(3330) A new MySQL sandbox instance will be created on this host in /home/umshastr/mysql-sandboxes/3330 Please enter a MySQL root password for the new instance: Deploying new MySQL instance... Instance localhost:3330 successfully deployed and started. Use shell.connect('root@localhost:3330'); to connect to the instance. #### Connected 3310/3320 and 3330 and created user "bug85567" grant all on *.* to bug85567@'localhost' identified by 'mysql123' with grant option; grant all on *.* to bug85567@'%' identified by 'mysql123' with grant option; reset master; ====================================================================================== mysql-js> \connect bug85567@localhost:3310 Creating a Session to 'bug85567@localhost:3310' Enter password: Classic Session successfully established. No default schema selected. mysql-js> mysql-js> var cluster = dba.createCluster('test') A new InnoDB cluster will be created on instance 'bug85567@localhost:3310'. Creating InnoDB cluster 'test' on 'bug85567@localhost:3310'... Adding Seed Instance... Cluster successfully created. Use Cluster.addInstance() to add MySQL instances. At least 3 instances are needed for the cluster to be able to withstand up to one server failure. mysql-js> cluster.status() { "clusterName": "test", "defaultReplicaSet": { "name": "default", "primary": "localhost:3310", "status": "OK_NO_TOLERANCE", "statusText": "Cluster is NOT tolerant to any failures.", "topology": { "localhost:3310": { "address": "localhost:3310", "mode": "R/W", "readReplicas": {}, "role": "HA", "status": "ONLINE" } } } } mysql-js> cluster.addInstance('bug85567@localhost:3320') A new instance will be added to the InnoDB cluster. Depending on the amount of data on the cluster this might take from a few seconds to several hours. Please provide the password for 'bug85567@localhost:3320': Adding instance to the cluster ... The instance 'bug85567@localhost:3320' was successfully added to the cluster. mysql-js> cluster.addInstance('bug85567@localhost:3330') A new instance will be added to the InnoDB cluster. Depending on the amount of data on the cluster this might take from a few seconds to several hours. Please provide the password for 'bug85567@localhost:3330': Adding instance to the cluster ... The instance 'bug85567@localhost:3330' was successfully added to the cluster. mysql-js> cluster.status() { "clusterName": "test", "defaultReplicaSet": { "name": "default", "primary": "localhost:3310", "status": "OK", "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.", "topology": { "localhost:3310": { "address": "localhost:3310", "mode": "R/W", "readReplicas": {}, "role": "HA", "status": "ONLINE" }, "localhost:3320": { "address": "localhost:3320", "mode": "R/O", "readReplicas": {}, "role": "HA", "status": "ONLINE" }, "localhost:3330": { "address": "localhost:3330", "mode": "R/O", "readReplicas": {}, "role": "HA", "status": "ONLINE" } } } } mysql-js> ## Stopped group replication on localhost:3310 mysql-js> \connect bug85567@localhost:3320 mysql-js> cluster.status() { "clusterName": "test", "defaultReplicaSet": { "name": "default", "primary": "localhost:3320", "status": "OK_NO_TOLERANCE", "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active", "topology": { "localhost:3310": { "address": "localhost:3310", "mode": "R/O", "readReplicas": {}, "role": "HA", "status": "(MISSING)" }, "localhost:3320": { "address": "localhost:3320", "mode": "R/W", "readReplicas": {}, "role": "HA", "status": "ONLINE" }, "localhost:3330": { "address": "localhost:3330", "mode": "R/O", "readReplicas": {}, "role": "HA", "status": "ONLINE" } } } } mysql-js> \connect bug85567@localhost:3320 Creating a Session to 'bug85567@localhost:3320' Enter password: Closing old connection... Classic Session successfully established. No default schema selected. mysql-js> cluster.checkInstanceState('bug85567@localhost:3310') Please provide the password for 'bug85567@localhost:3310': Analyzing the instance replication state... The instance 'localhost:3310' is valid for the cluster. The instance is fully recoverable. { "reason": "recoverable", "state": "ok" } mysql-js> cluster.rejoinInstance('bug85567@localhost:3310') Rejoining the instance to the InnoDB cluster. Depending on the original problem that made the instance unavailable, the rejoin operation might not be successful and further manual steps will be needed to fix the underlying problem. Please monitor the output of the rejoin operation and take necessary action if the instance cannot rejoin. Please provide the password for 'bug85567@localhost:3310': Rejoining instance to the cluster ... The instance 'bug85567@localhost:3310' was successfully rejoined on the cluster. The instance 'localhost:3310' was successfully added to the MySQL Cluster. ####### Repeated same steps after wiping out with user created only in primary node, still no issues observed