{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["每日检查模板","每周检查内容","月末检查模板"],"not_rendered":{"charts":0,"images":0,"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":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,5,1],[6,1,10,1],[11,1,16,1],[2,2,4,2]]}
[null,"每日巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"巡检聚能云平台","云平台是否正常","1、登录云平台","未检查"]
[null,null,null,"2、查看基础架构里主机栏目下挂载的主机状态是否正常","未检查"]
[null,null,null,"3、查看基础架构里证书栏目下证书是否有过期的","未检查"]
[null,null,"服务是否正常","检查应用栏目下的已经实例化的服务是否都是正常状态（绿色）","未检查"]
[null,"巡检物理主机","网络丢包及延迟情况检查","ping -t ip  检查丢包率和网络延迟情况，ping的次数必须大于10次，取平均值","未检查"]
[null,null,"cpu及内存占用情况检查","top查看cpu及内存占用情况","未检查"]
[null,null,"物理磁盘剩余情况检查","df -m查看磁盘使用情况，使用率大于85%需要考虑扩容或者内容迁移","未检查"]
[null,null,"共享磁盘挂载情况检查","往共享磁盘中写入一个文件，再重新读取出来，确认共享磁盘可用","未检查"]
[null,null,"对外端口是否正常","1、netstat -anlp | grep 端口 查看端口是否监听状态","未检查"]
[null,"业务检查","app上直播内容检查",null,"未检查"]
[null,null,"内容注入检查",null,"未检查"]
[null,null,"业务日志检查",null,"未检查"]
[null,null,"业务服务检查",null,"未检查"]
[null,null,"同步消息检查",null,"未检查"]
[null,null,"cdn服务检查",null,"未检查"]

{"sheet":"每周检查内容","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,4,1],[5,1,7,1],[8,1,15,1]]}
[null,"每周巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"巡检聚能云平台","镜像仓库内容是否更新且可用","1、检查应用商店是否可用\n2、最新build的版本是否有镜像\n3、镜像是否能正常拉取并启动\n4、检查镜像仓库空间大小，定期清除废弃镜像及过期镜像","未检查"]
[null,null,"git同步检查","检查代码是否是否有同步上git","未检查"]
[null,null,"查看系统日志，检查是否有异常","cat /var/log/messages及cat /var/log/secure查看系统是否有异常报错","未检查"]
[null,"基础服务巡检","DNS解析服务是否正常","1、外部ping对外域名，是否能正常解析并跳转\n2、系统内部ping其他内部域名，是否能正常访问并跳转","未检查"]
[null,null,"redis服务是否正常","1、进入redis命令行\n2、用info命令查看redis状态信息","未检查"]
[null,null,"内容备份检查及灾难演练","1、检查每天是否有正常备份\n2、备份的文件是否能够作为依据恢复数据内容","未检查"]
[null,"数据库巡检","mysql数据库连接数检查","数据库命令行中执行show status like 'Threads%';查看mysql连接数","未检查"]
[null,null,"mysql数据库死锁检查","数据库命令行中执行show OPEN TABLES where In_use > 0;","未检查"]
[null,null,"检查定时备份的数据库备份是否成功","查看定时备份的数据库文件是否存在，且大小正常","未检查"]
[null,null,"mysql进程及对应日志检查","ps -ef|grep mysql查看mysql进程是否正常\nvi /var/log/mariadb/mariadb.log查看日志中是否有异常告警","未检查"]
[null,null,"pg数据库连接数检查","数据库命令行中执行select count(*) from pg_stat_activity;","未检查"]
[null,null,"pg数据库死锁检查","数据库命令行中执行select * from pg_stat_activity where dataname='数据库名' and waiting=true;","未检查"]
[null,null,"pg数据库备份检查","查看定时备份的数据库文件是否存在，且大小正常","未检查"]
[null,null,"pg数据库进程及对应日志检查","vi /var/log/postgres/pg_log.log","未检查"]
[null,"业务巡检","app上点播内容检查",null,"未检查"]

{"sheet":"月末检查模板","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,4,1]]}
[null,"每周巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"灾难恢复演练","mysql数据库备份恢复演练","用备份文件在测试环境中进行恢复，观察是否能够正常恢复数据","未检查"]
[null,null,"pg数据库备份恢复演练","用备份文件在测试环境中进行恢复，观察是否能够正常恢复数据","未检查"]
[null,null,"备份文件恢复演练","用备份的文件在测试环境中进行恢复，观察是否能正常运行","未检查"]