{"text_format":"2","workbook":"xlsx","n_sheets":4,"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["大数据处理服务（ambari、HDP）"]
["用途","hosts","说明"]
["master","192.168.3.180 pve180","主节点"]
["slave","192.168.3.181 pve181","数据节点"]
["slave","192.168.3.182 pve182","数据节点"]
["slave","192.168.3.183 pve183","数据节点"]
["slave","192.168.3.184 pve184","数据节点"]
[]
[]
["登录地址","http://pve180:8080/","admin/admin"]

{"sheet":"地图服务","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["超图发布的项目"]
["ip","项目名称","服务地址"]
["192.168.3.221"]
["192.168.3.222"]
["192.168.3.223"]
["192.168.3.224"]
["192.168.3.225"]
["192.168.3.226"]
["192.168.3.227"]
["192.168.3.228"]
["192.168.3.229"]