PK ©x½v v xl/_rels/workbook.xml.rels
PK 0ˆkÞ Þ xl/theme/theme1.xml
PK Uô”Z Z
xl/styles.xml
PK W|sû
xl/worksheets/sheet1.xml
FieldValue
Project Name1BEST
EnvironmentProduction
Connectivity Remarks
PK 5ÉmÓ‰? ‰? xl/worksheets/sheet2.xml
NameTypeTypeOtherOSOSOtherAppDbInfoVCPUMemoryGBOSDiskGBDataDisksGBIPSubnetVLANPortProtocolProtocolOtherDefaultGatewaySiteEnvironmentGroupUsersRemark
WEB01webRHEL 9NGINX 1.30.4416100200172.26.13.10255.255.255.0110443HTTPS172.26.13.1DC1DMZWebExternal UsersExternal public users will hit to DMZ Web via WEB-F5-VIP
WEB02webRHEL 9NGINX 1.30.4416100200172.26.13.11255.255.255.0110443HTTPS172.26.13.1DC1DMZWebExternal UsersExternal public users will hit to DMZ Web via WEB-F5-VIP
WEB03webRHEL 9NGINX 1.30.4416100200172.26.13.12255.255.255.0110443HTTPS172.26.13.1DC1DMZWebExternal UsersExternal public users will hit to DMZ Web via WEB-F5-VIP
WEB04webRHEL 9NGINX 1.30.4416100200172.26.13.13255.255.255.0110443HTTPS172.26.13.1DC1DMZWebExternal UsersExternal public users will hit to DMZ Web via WEB-F5-VIP
APP01appRHEL 9PHP 8.4832100200172.26.11.10255.255.255.01208081HTTPS172.26.11.1DC1Internal Secured ZoneAppDMZ Web will hit to App via APP-F5-VIP
APP02appRHEL 9PHP 8.4832100200172.26.11.11255.255.255.01208081HTTPS172.26.11.1DC1Internal Secured ZoneAppDMZ Web will hit to App via APP-F5-VIP
HA Proxy1haproxyOtherUbuntu 26.04 LTSHAPROXY 3.4.4416100200172.26.12.10255.255.255.01303306TCP172.26.12.1DC1Internal Secured ZoneHA ProxyApp will hit to HA Proxy Group via DB-F5-VIP
HA Proxy2haproxyOtherUbuntu 26.04 LTSHAPROXY 3.4.4416100200172.26.12.11255.255.255.01303306TCP172.26.12.1DC1Internal Secured ZoneHA ProxyApp will hit to HA Proxy Group via DB-F5-VIP
DB1databaseOtherUbuntu 26.04 LTSMySQL 9.7.2 LTS16321002000;3000172.26.12.20255.255.255.01303306TCP172.26.12.1DC1Internal Secured ZoneDBHA Proxy Group will hit to DB Group (Master-Master, ROS)
DB2databaseOtherUbuntu 26.04 LTSMySQL 9.7.2 LTS16321002000;3000172.26.12.21255.255.255.01303306TCP172.26.12.1DC1Internal Secured ZoneDBHA Proxy Group will hit to DB Group (Master-Master, ROS)
DB3databaseOtherUbuntu 26.04 LTSMySQL 9.7.2 LTS16321002000;3000172.26.12.22255.255.255.01303306TCP172.26.12.1DC1Internal Secured ZoneDBHA Proxy Group will hit to DB Group (Master-Master, ROS)
Image Repo NASstorageOtherDell PowerStore NAS5000172.26.7.100255.255.255.04002049TCP172.26.7.1DC1Internal Secured ZoneNASImage Repo NFS file share to App via NFS
Redis1databaseOtherUbuntu 26.04 LTSREDIS 8.10416100200172.26.11.12255.255.255.01206379TCP172.26.11.1DC1Internal Secured ZoneRedisApp will hit to Redis Master directly
Redis2databaseOtherUbuntu 26.04 LTSREDIS 8.10416100200172.26.11.13255.255.255.01206379TCP172.26.11.1DC1Internal Secured ZoneRedisApp will hit to Redis Master directly
Redis3databaseOtherUbuntu 26.04 LTSREDIS 8.10416100200172.26.11.14255.255.255.01206379TCP172.26.11.1DC1Internal Secured ZoneRedisApp will hit to Redis Master directly
BPM1otherBPMRHEL 9JBOSS BPM 7.13832100500172.26.11.15255.255.255.01208443TCP172.26.11.1DC1Internal Secured ZoneBPMApp will connect to BPM for Workflow Automation
BPM2otherBPMRHEL 9JBOSS BPM 7.13832100500172.26.11.16255.255.255.01208443TCP172.26.11.1DC1Internal Secured ZoneBPMApp will connect to BPM for Workflow Automation
ETL01otherETLRHEL 9IBM InfoSphere DataStage 5.4.016641005000172.26.11.17255.255.255.012031538TCP172.26.11.1DC1Internal Secured ZoneETLApp will connect to ETL and ETL will connect to DB
PK j죟õ õ xl/worksheets/sheet3.xml
NameTypeTypeOtherLbMethodLbMethodOtherIPSubnetVLANPortProtocolProtocolOtherRemark
WEB-F5-VIPf5Round Robin172.30.25.10255.255.255.0443HTTPS
APP-F5-VIPf5Least Connections172.30.25.11255.255.255.08081HTTPS
DB-F5-VIPf5Least Connections172.30.25.12255.255.255.03306TCP
BPM-F5-VIPf5OthersHA172.30.25.13255.255.255.08443HTTPS
PK úP>ñˆ
ˆ
xl/worksheets/sheet4.xml
SourceGroupViaNameTargetGroupDirectPlacementGapA_cmGapB_cm
External UsersWEB-F5-VIPWebup33
WebAPP-F5-VIPAppup33
AppETLup
AppBPM-F5-VIPBPMup
AppDB-F5-VIPHA Proxyup
AppRedisup
HA ProxyDBdown
BPMDBdown
ETLDBup7
RedisDBdown
PK “FM�à à xl/worksheets/sheet5.xml
ServerNameLabelIPSubnetVLANPortProtocol
WEB01Management IP172.26.3.10255.255.255.0200TCP
WEB02Management IP172.26.3.11255.255.255.0200TCP
WEB03Management IP172.26.3.12255.255.255.0200TCP
WEB04Management IP172.26.3.13255.255.255.0200TCP
APP01Management IP172.26.3.14255.255.255.0200TCP
APP02Management IP172.26.3.15255.255.255.0200TCP
HA Proxy1Management IP172.26.3.16255.255.255.0200TCP
HA Proxy2Management IP172.26.3.17255.255.255.0200TCP
DB1Management IP172.26.3.18255.255.255.0200TCP
DB1Backup IP172.26.6.10255.255.255.0300TCP
DB2Management IP172.26.3.19255.255.255.0200TCP
DB2Backup IP172.26.6.11255.255.255.0300TCP
DB3Management IP172.26.3.20255.255.255.0200TCP
DB3Backup IP172.26.6.12255.255.255.0300TCP
Redis1Management IP172.26.3.21255.255.255.0200TCP
Redis2Management IP172.26.3.22255.255.255.0200TCP
Redis3Management IP172.26.3.23255.255.255.0200TCP
BPM1Management IP172.26.3.24255.255.255.0200TCP
BPM2Management IP172.26.3.25255.255.255.0200TCP
ETL01Management IP172.26.3.26255.255.255.0200TCP
PK ¨Ë'âû û xl/worksheets/sheet6.xml
GroupNote
ha proxyDB-F5-LTM will send the traffics to the least conn HA Proxy node. The DB traffic routing is based on the defined algorithm in haproxy.cfg.
dbThe HA Proxy node will send the traffic to the least conn Master DB node (DB1 vs DB2). DB1 & DB2 are both Master and DB3 is ROS. The MySQL Group Replication is setup with Multi-Master & 1 ROS. The Group Replicaion will be via Backup IPs.
redisThe Redis Cluster serves the caching (Store frequent database queries or API responses to speed up page loads) and session management for user logins. The Redis-Sentinel is implemented to monitor the availability states of the Redis-Master and Redis-Replica nodes, the auto-failover to replica node will be triggered when the Redis-Master is down, one of the replica nodes will be promoted as the new Redis-Master.
PK `€ �ˆ ˆ xl/metadata.xml
PK (+þvE E xl/workbook.xml
PK JjùL L _rels/.rels
PK ÷ŽË™Ö Ö docProps/app.xml
SheetJSWorksheets6ProjectServersLoadBalancersGroupConnectionsSecondaryIPsGroupNotesPK Ö’|Z Z docProps/core.xml
PK �Dñ'½
½
[Content_Types].xml
PK ©x½v v xl/_rels/workbook.xml.relsPK 0ˆkÞ Þ ® xl/theme/theme1.xmlPK Uô”Z Z
½# xl/styles.xmlPK W|sû
B( xl/worksheets/sheet1.xmlPK 5ÉmÓ‰? ‰? ‚+ xl/worksheets/sheet2.xmlPK j죟õ õ Ak xl/worksheets/sheet3.xmlPK úP>ñˆ
ˆ
lu xl/worksheets/sheet4.xmlPK “FM�à à *€ xl/worksheets/sheet5.xmlPK ¨Ë'âû û @˜ xl/worksheets/sheet6.xmlPK `€ �ˆ ˆ qž xl/metadata.xmlPK (+þvE E &¢ xl/workbook.xmlPK JjùL L ˜¤ _rels/.relsPK ÷ŽË™Ö Ö
§ docProps/app.xmlPK Ö’|Z Z ª docProps/core.xmlPK �Dñ'½
½
š« [Content_Types].xmlPK Ù ˆ¶