Re: Using InnoDB Cluster Commands In “Batch” Mode

[Frederic Descamps]

Hi Neil,

Thank you for using MySQL InnoDB Cluster.

First of all, don't forget to always use the latest version of MySQL Shell, 8.0.16 for the moment.

And you will be able to achieve what you need like this :

[root@mysql1 ~]# mysqlsh clusteradmin@mysql1 -- cluster status
{
"clusterName": "fred",
"defaultReplicaSet": {
"name": "default",
"primary": "mysql1:3306",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"mysql1:3306": {
"address": "mysql1:3306",
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"version": "8.0.16"
},
"mysql2:3306": {
"address": "mysql2:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"version": "8.0.16"
},
"mysql3:3306": {
"address": "mysql3:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE",
"version": "8.0.16"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "mysql1:3306"
}


please see: https://mysqlserverteam.com/mysql-shell-api-command-line-integration-for-devops/

Best regards,



Edited 1 time(s). Last edit at 06/21/2019 02:30AM by Frederic Descamps.