--How do find the list of mysql routers connecting from application servers
--to mysql database innodb cluster and their version.
--How do connect mysql shell.
MYSQL JS >\c cluadminlogin@DBSERVER_IP:3306
--Enter the password.
--Then declare the cluster variable.
MYSQL JS >var cluster =dba.getCluster();
--cluster.listRouters();
MySQL DBSERVER_IP:3306 ssl JS > cluster.listRouters();
{
"clusterName": "prodclust",
"routers": {
"APPSERVER_IP1::": {
"hostname": "APPSERVER_IP1",
"lastCheckIn": "2023-02-06 08:36:12",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.21"
},
"APPSERVER_IP2::": {
"hostname": "APPSERVER_IP2",
"lastCheckIn": "2023-02-06 08:36:12",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.24"
},
"APPSERVER_IP3::": {
"hostname": "APPSERVER_IP3",
"lastCheckIn": "2023-02-06 08:36:15",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.24"
},
"APPSERVER_IP4::": {
"hostname": "APPSERVER_IP4",
"lastCheckIn": "2023-02-06 08:36:13",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.24"
},
"APPSERVER_IP5::": {
"hostname": "APPSERVER_IP5",
"lastCheckIn": "2023-02-06 08:36:13",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.24"
},
"APPSERVER_IP6::": {
"hostname": "APPSERVER_IP6",
"lastCheckIn": "2023-02-06 08:36:12",
"roPort": 6447,
"roXPort": 6449,
"rwPort": 6446,
"rwXPort": 6448,
"version": "8.0.24"
}
}
MySQL DBSERVER_IP:3306 ssl JS >
No comments:
Post a Comment