Different ways to get the status:
mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status
mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster status
mysqlsh icadmin:'P4ssw0rD'@db01:3306 -- cluster status --extended=0
mysqlsh icadmin@$MYROUTER1:3306 -- cluster status --extended=1
watch -n 5 “mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status”
Set the Primary Instance (switching):
mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster set_primary_instance "db01"
Obtaining MySQL InnoDB Cluster basics:
select cluster_id, cluster_name, description, cluster_type, primary_mode, clusterset_id from mysql_innodb_cluster_metadata.clusters;
Members of our cluster:
select * from performance_schema.replication_group_members order by MEMBER_ROLE;
Local & Remote Trans Q’s:
…[Read more]