Sunday, February 5, 2023

MYSQL::How do find the list of mysql routers connecting from application servers #Mysql Router Version# List of Routers

 --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

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...