{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["主机配置","安装应用分配","迁移后环境配置"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"主机配置","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,3,0],[4,0,5,0],[6,0,13,0],[2,5,3,5]]}
["配    置"]
[null,null,"CPU","内存","存储","归属","光纤-存储（85T）","物理位置","IP","系统账号密码"]
["低配\n（小应用）","esxi65","6 CPUs x Intel(R) Xeon(R) CPU\nE5-2620 v2 @ 2.10GHz","127.93GB","2T","迁移后，共用"]
[null,"esxi67","7 CPUs x Intel(R) Xeon(R) CPU\nE5-2620 v2 @ 2.10GHz","31.93GB","2T"]
["中配\n（管理服务器）","server0","2个英特尔至强银牌4214R(2.4GHz/12-Core)","256GB","2个通用硬盘-1200GB",null,"10T","3柜27-28","192.168.3.220","root/hmedi@220","管理账号密码","账号：Administrator","密码：Admin@9000"]
[null,"server3","2个英特尔至强银牌4214R(2.4GHz/12-Core)","256GB","2个通用硬盘-1200GB",null,"10T","1柜22-23","192.168.3.223","root/hmedi@223"]
["高配\n（算力）","server2","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,null,"3柜35-38","192.168.3.222","Administrator/password"]
[null,"server6","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,null,"1柜35-38","192.168.3.226","Administrator/password","张"]
[null,"server1","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB","共用","35T\n/dev/mapper/centos-home  8.7T  185G  8.5T   3% /home","3柜30-33","192.168.3.221","root/hmedi@221"]
[null,"server4","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,"10T","1柜25-28","192.168.3.224","root/abcd@1234"]
[null,"server5","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB","交通","20T\n/dev/sdb1       8.8T  118G  8.7T   2% /home","1柜30-33","192.168.3.225","root/hmedi@225","罗"]
[null,"server7","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,"/dev/sdb2       8.7T  1.2T  7.5T   14% /home","2柜25-28","192.168.3.227","root/111111","罗"]
[null,"server8","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,"/dev/sdb2       8.7T   12G  8.7T   1% /home","2柜30-33","192.168.3.228","root/111111"]
[null,"server9","4个英特尔至强金牌5218(2.3GHz/12-Core)","384GB","5个通用硬盘-2400GB\n2个固态硬盘-480GB",null,"/dev/sdb2       8.7T   34G  8.7T   1% /home","2柜35-38","192.168.3.229","https://192.168.3.229:8006/\nroot/Dzx123!@#"]
["老服务器",{"$nulls":6},"老机房","192.168.3.4","https://192.168.3.4:8006/\nroot/Dzx123!@#"]

{"sheet":"安装应用分配","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,3,0],[4,0,8,0],[9,0,30,0],[4,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,15,1],[16,1,21,1],[23,1,24,1],[25,1,27,1],[30,1,32,1],[25,2,27,2],[30,2,32,2],[25,3,27,3],[30,3,32,3],[25,6,27,6]]}
["配    置"]
[null,null,"系统","待部署应用","已部署应用","地址","账号","备注"]
["低配\n（小应用）","esxi65","esxi",null,"1、postgresql & portainer\n2、超图server\n3、win10\n4、jupyterlab\n5、mysql\n6、h5ai\n7、kylin\n8、omt",null,null,"借给四维，交警队数据中心"]
[null,"esxi67","esxi",null,"1、道路信息采集小程序\n2、git 已经迁移\n3、四维环境\n4、住户投票系统（微信小程序）",null,null,"已满"]
["中配\n（管理服务器）","server0","centos7.6",null,"1、portainer","http://192.168.3.220:9000/#/auth","portainer/portainer","虚拟化容器管理平台"]
[{"$nulls":4},"2、nginx服务：图幅分幅编号5w\\1w不准","http://192.168.3.220:8081/tufu/index.html",null,"地图分幅编号工具"]
[{"$nulls":4},"3、kubesphere","http://192.168.3.220:30880/login","dzxiii@163.com/Dzx123!@#","k8s"]
[null,"server3","centos7.6","1、大数据管理服务器","1、apache nifi","http://192.168.3.223:8080/",null,"数据采集平台；共享单车数据交换，之后会调整到数据中台使用kafka"]
[{"$nulls":4},"1、registry","http://192.168.3.223:5000/v2/_catalog",null,"应用镜像管理"]
["高配\n（算力）","server2","win server2016",null,"1、iserver",null,null,"施工管理平台+超图节点1"]
[{"$nulls":4},"1、迁移运行施工管理平台"]
[null,"server6","win server2016","地图","nginx","https://www.hmedi02.net:16888/",null,"共享单车数据采集"]
[{"$nulls":5},"登陆名Administrator，密码好像是Dzx123!@#","放道路采集研究课题的服务端程序"]
[null,null,null,"iServer：admin/Admin123"]
[{"$nulls":4},"市政工程施工管理平台"]
[null,null,null,"智慧市政设计决策支持平台"]
[null,"server1","centos7.6","1、数据库：postgis（空间数据）","1、mysql","192.168.3.221:3306","root/root","核心数据库"]
[{"$nulls":4},"2、mongodb","mongodb://192.168.3.221:27017",null,"nifi采集支撑数据库"]
[{"$nulls":4},"3、gogs","http://192.168.3.221:10080/",null,"软件开发版本管理平台"]
[{"$nulls":4},"4、iserver","见：超图云套件部署.txt",null,"超图节点2"]
[{"$nulls":4},"5、数据库：postgresql",null,"postgres/postgres","超图数据库"]
[{"$nulls":4},"6、postgis","192.168.3.221:25432","postgres/postgres","地图分幅编号工具数据库"]
[null,"server4","centos7.6",null,null,null,"交通","给浪潮做数据中台"]
[null,"server5","centos7.6",{"$nulls":4},"应用服务器"]
[{"$nulls":5},"http://192.168.3.225:9080/iserver",null,"超图节点"]
[null,"server7","centos7.6",null,"1、四维地图","见：四维地图相关文档","交通","四维地图服务"]
[{"$nulls":4},"1、iserver","见：超图云套件部署.txt",null,"超图节点3"]
[{"$nulls":7},"浪潮数据中台"]
[null,"server8","centos7.6",null,"1、iserver","见：超图云套件部署.txt",null,"超图节点4，外网  http://111.42.156.47:806/iserver/"]
[{"$nulls":4},"geoserver图幅地图服务","http://192.168.3.228:6666/geoserver/hmedi/wms","admin/Dzx123!@#"]
[null,"server9","centos7.6",null,"1、超图imanager主节点","见：超图云套件部署.txt",null,"超图主节点"]
[{"$nulls":4},"2、iportal","见：超图云套件部署.txt",null,"超图门户"]
[{"$nulls":4},"3、iserver","见：超图云套件部署.txt",null,"超图节点5"]

{"sheet":"迁移后环境配置","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,0,18,0],[19,0,23,0],[30,0,33,0]]}
[null,"地址","端口（外）","IP","端口（内）","描述",null,null,"公网地址","账号"]
["防火墙","https://192.168.11.111",{"$nulls":6},"无","root/Dzx123!@#"]
[]
[null,"地址","端口（外）","IP","端口（内）","描述",null,null,"公网地址","账号"]
[null,"192.168.11.11","*","LAN地址","80, 443","*","*","防锁规则","无"]
[null,"192.168.11.11","*","防火墙自身",9850,"10.0.0.99","3389 (MS RDP)","数字技术分院，子网管理服务器","无"]
[null,"192.168.11.11","*","防火墙自身",9851,"10.0.0.60","3389 (MS RDP)","自建施工平台服务器","无"]
["容器管理服务器","192.168.11.11","*","防火墙自身",9443,"10.0.0.100",9443,"portainer","无"]
["给交通分院的物联网数据采集服务器","192.168.11.11","*","防火墙自身",18080,"10.0.0.55",8080,"nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9001,"10.0.0.55",9001,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9002,"10.0.0.55",9002,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9003,"10.0.0.55",9003,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9004,"10.0.0.55",9004,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9005,"10.0.0.55",9005,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9006,"10.0.0.55",9006,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9007,"10.0.0.55",9007,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9008,"10.0.0.55",9008,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9009,"10.0.0.55",9009,"单车 nifi 管理口","无"]
[null,"192.168.11.11","*","防火墙自身",9010,"10.0.0.55",9010,"单车 nifi 管理口","无"]
["数字技术分院\n核心数据库","192.168.11.11","*","防火墙自身",25432,"10.0.0.200",25432,"postgis","无"]
[null,"192.168.11.11","*","防火墙自身",3306,"10.0.0.200",3306,"mysql57","无"]
[null,"192.168.11.11","*","防火墙自身",5432,"10.0.0.200",5432,"postgres","无"]
[null,"192.168.11.11","*","防火墙自身",10080,"10.0.0.200",10080,"gogs","http://111.42.156.47:10080/"]
[null,"192.168.11.11","*","防火墙自身",10022,"10.0.0.200",10022,"gogs","http://111.42.156.47:10022/"]
["开源地图服务器","192.168.11.11","*","防火墙自身",6666,"10.0.0.56",6666,"geoserver2.19.2","分配一个"]
["超图节点","192.168.11.11","*","防火墙自身",8091,"10.0.0.53",8090,"自建iserver"]
[null,"192.168.11.11","*","防火墙自身",23751,"10.0.0.100",23751,"docker"]
["课题和应用","192.168.11.11","*","防火墙自身",8081,"10.0.0.51",8081,"nginx-webserver 静态文件服务器","分配一个"]
[null,"192.168.11.11","*","防火墙自身",10100,"10.0.0.60",10100,"自建施工平台","http://111.42.156.47:10100"]
[null,"192.168.11.11","*","防火墙自身",3443,"10.0.0.59","443 (HTTPS)","harbor","无"]
["江西施工平台","192.168.11.11","*","防火墙自身",8080,"10.0.0.50",8080,"江西web服务器","http://111.42.156.47:8080"]
[null,"192.168.11.11","*","防火墙自身",3306,"10.0.0.50",3306,"江西施工平台数据库","111.42.156.47:3306"]
[null,"192.168.11.11","*","防火墙自身",8071,"10.0.0.50",8071,"江西施工平台应用端口","http://111.42.156.47:8071"]
[null,"192.168.11.11","*","防火墙自身",8090,"10.0.0.50",8090,"江西施工平台地图服务（含一个超图节点）","http://111.42.156.47:8090"]