{"id":289,"date":"2013-06-14T20:40:00","date_gmt":"2013-06-14T20:40:00","guid":{"rendered":"http:\/\/39@jodohost.com\/\/blog\/"},"modified":"2013-06-14T20:40:00","modified_gmt":"2013-06-14T20:40:00","slug":"alternative-ips-with-ports-to-access-the-mssql-and-mysql-servers-through-external-tools","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/06\/14\/alternative-ips-with-ports-to-access-the-mssql-and-mysql-servers-through-external-tools\/","title":{"rendered":"Alternative IPs with ports to access the MSSQL and MySQL servers through external tools"},"content":{"rendered":"

Below are the IP addresses and ports for the respective server for external management access :-<\/p>\n

========================================================================
CL1 – Cluster-1
CL2 – Cluster-2<\/p>\n

1) MSSQL Servers
———————————————————–
Server IP Address Port
———————————————————–
CL1- MSSQL1 173.0.136.201,5201
CL1- MSSQL2 173.0.136.201,5202
CL1- MSSQL3 173.0.136.201,5203
CL1- MSSQL4 173.0.136.201,5204
CL1- MSSQL5 173.0.136.201,5205
CL1- MSSQL6 173.0.136.201,5206
CL1- MSSQL7 173.0.136.201,5207
CL1- MSSQL8 173.0.136.201,5208
CL1- MSSQL9 173.0.136.201,5209
CL1- MSSQL10 173.0.136.201,5210
CL1- MSSQL11 173.0.136.201,5211
CL1- MSSQL12 173.0.136.201,5212
CL1- MSSQL13 173.0.136.201,5213
CL2- MSSQL1 173.0.136.201,5001
CL2- MSSQL2 173.0.136.201,5002
CL2- MSSQL3 173.0.136.201,5003
CL2- MSSQL4 173.0.136.201,5004
CL2- MSSQL5 173.0.136.201,5006
CL2- MSSQLSD 173.0.136.201,5111<\/p>\n

VZSQL1 173.0.136.201 5101
OLD CL2-SDMSSQL 173.0.136.201 5401
HVSQL1 173.0.136.201 5402<\/p>\n

2) MySQL Servers
———————————————————–
Server IP Address Port
———————————————————–
CL1-MYSQL1 173.0.136.201 6117
CL1-MYSQL2 173.0.136.201 6118
CL1-MYSQL3 173.0.136.201 6119
CL1-MYSQL4 173.0.136.201 6120
CL1-MYSQL5 173.0.136.201 6121
CL1-MYSQL6 173.0.136.201 6122
CL1-MYSQL7 173.0.136.201 6123
CL1-MYSQL8 173.0.136.201 6124
CL1-MYSQL9 173.0.136.201 6125
CL1-MYSQL10 173.0.136.201 6126
CL2-MYSQL1 173.0.136.201 6001
CL2-MYSQL2 173.0.136.201 6002
CL2-MYSQL3 173.0.136.201 6003
CL2-MYSQL4 173.0.136.201 6004<\/p>\n

3) PgSQL Servers
———————————————————–
Server IP Address Port
———————————————————–
CL1-PGSQL1 173.0.136.201 7026
CL1-PGSQL2 173.0.136.201 7027
CL1-PGSQL3 173.0.136.201 7028
CL1-PGSQL4 173.0.136.201 7029
CL2-PGSQL1 173.0.136.201 7101<\/p>\n

4) Plesk Servers
———————————————————–
Server IP Address Port
———————————————————–
Plesk-MSSQL1 173.0.136.201 10001
Plesk-MYSQL1 173.0.136.201 20001<\/p>\n

]]><\/p>\n","protected":false},"excerpt":{"rendered":"

Below are the IP addresses and ports for the respective server for external management access :- ========================================================================CL1 – Cluster-1CL2 – Cluster-2 1) MSSQL Servers———————————————————–Server IP Address Port———————————————————–CL1- MSSQL1 173.0.136.201,5201CL1- MSSQL2 173.0.136.201,5202CL1- MSSQL3 173.0.136.201,5203CL1- MSSQL4 173.0.136.201,5204CL1- MSSQL5 173.0.136.201,5205CL1- MSSQL6 173.0.136.201,5206CL1- MSSQL7 173.0.136.201,5207CL1- MSSQL8 173.0.136.201,5208CL1- MSSQL9 173.0.136.201,5209CL1- MSSQL10 173.0.136.201,5210CL1- MSSQL11 173.0.136.201,5211CL1- MSSQL12 173.0.136.201,5212CL1- MSSQL13 173.0.136.201,5213CL2- MSSQL1 173.0.136.201,5001CL2- […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/289"}],"collection":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}