acl_tousu/doc/部署文档/正式环境/正式环境部署文档.md

正式环境部署文档

v1.10部署

20220815完成部署,仅更新jar包,不需更新数据库

v1.9部署

1. 老版本下线

   # 部署路径 192.168.70.125:/data1/acl
   sh stop.sh
   # 备份旧版本
   mv aclTousu.jar aclTousu.jar.bk
   

2. 备份数据库文件

   -- 备份
   create table sqmdb_rpt.acl_area_0805 as select *from sqmdb_rpt.acl_area;
   create table sqmdb_rpt.acl_city_0805 as select* from sqmdb_rpt.acl_city;
   create table sqmdb_rpt.acl_district_0805 as select *from sqmdb_rpt.acl_district;
   create table sqmdb_rpt.acl_role_0805 as select* from sqmdb_rpt.acl_role;
   create table sqmdb_rpt.acl_user_0805 as select *from sqmdb_rpt.acl_user;
   create table sqmdb_rpt.acl_user_role_0805 as select* from sqmdb_rpt.acl_user_role;
   create table sqmdb_rpt.acl_user_role_city_0805 as select * from sqmdb_rpt.acl_user_role_city;
   
   -- 如需回退操作（将正式表命名为back结尾的，然后将备份表改为正式表名）执行如下
   alter table sqmdb_rpt.acl_area rename to acl_area_back;
   alter table sqmdb_rpt.acl_city rename to acl_city_back;
   alter table sqmdb_rpt.acl_district rename to acl_district_back;
   alter table sqmdb_rpt.acl_role rename to acl_role_back;
   alter table sqmdb_rpt.acl_user rename to acl_user_back;
   alter table sqmdb_rpt.acl_user_role rename to acl_user_role_back;
   alter table sqmdb_rpt.acl_user_role_city rename to acl_user_role_city_back;
   
   alter table sqmdb_rpt.acl_area_0805 rename to acl_area;
   alter table sqmdb_rpt.acl_city_0805 rename to acl_city;
   alter table sqmdb_rpt.acl_district_0805 rename to acl_district;
   alter table sqmdb_rpt.acl_role_0805 rename to acl_role;
   alter table sqmdb_rpt.acl_user_0805 rename to acl_user;
   alter table sqmdb_rpt.acl_user_role_0805 rename to acl_user_role;
   alter table sqmdb_rpt.acl_user_role_city_0805 rename to acl_user_role_city;
   

3. 更新数据库文件

4. 上传并启动新的jar包和配置文件（注意检查配置文件环境配置）

   # 启动
   sh run.sh
   

5. 完成测试

入口测试

大屏界面-DCN访问

中屏--河北联通智慧网络运营平台 大屏--网络数据运营平台

wangyl5740 / Yunwang@2022