# 生成依赖jar mvn -f pom.xml dependency:copy-dependencies -DoutputDirectory=lib # 部署完启动一下 cd /usr/local/tomcat8/webapps/baseService/WEB-INF/classes && ./start.sh cd /usr/local/tomcat8/webapps/dsssoserver/WEB-INF/classes && ./start.sh #特别需要注意的是，还需要手动运行一下下面的函数，创建一下备份仓库！！！ Backup.CreateEsRepertory 配置IDEA JVM参数 https://blog.csdn.net/xu_kun_/article/details/80142553 ======================================================================================== MariaDB Galera Cluster环境搭建及高可用测试 https://www.cnblogs.com/vadim/p/6930697.html 云平台改造的思路 (1)采用上面的MariaDB集群。 (2)独立部署一台MariaDB 10.0.13，然后只部署SphinxSE的表，在程序中使用Db1,Db2的双源，就可以实现数据库的扩展了, 但分库分表等还需要在程序层变化,多主多从就来了。 # 更多 https://blog.csdn.net/L835311324/article/details/83627324 ======================================================================================== 高性能elasticsearch ORM开发库使用介绍 https://my.oschina.net/bboss/blog/1556866 # IDEA双开办法 ========================================================== IntelliJ IDEA 2016.03版本 选择菜单File–Setting-Appearance & behavior-System Settings 右侧Project Opening选择第一个Open project in new window 接下来你通过菜单File–Open打开项目就以新窗口方式打开了. # ======================================================================= # 放弃表空间 ALTER TABLE base_db.t_transfer_apply_status DISCARD TABLESPACE; # 将备份的表拷贝回来，然后给上主属权限 chown mysql:mysql t_transfer_apply_status.* # 还原表空间 ALTER TABLE base_db.t_transfer_apply_status IMPORT TABLESPACE; # ======================================================================== -- 修正一下登录表中原始身份证号的加密信息 update t_sys_loginperson set idcard_code=to_base64(AES_ENCRYPT(idcard_code,'DsideaL4r5t6y7u!')) where length(idcard_code)>18; -- 补全人员身份证号 update t_third_party_sample set idcard_code=AES_DECRYPT(from_base64(idcard_code),'DsideaL4r5t6y7u!') where length(idcard_code)>18; delete from t_third_party_sample where org_code is null; =========================================================================================================================================================== delete from t_third_party_sample where city_id='00000000-0000-0000-0000-000000000000' and bureau_id='00000000-0000-0000-0000-000000000000' and area_id='00000000-0000-0000-0000-000000000000'; update t_third_party_sample set idcard_code=AES_DECRYPT(from_base64(idcard_code),'DsideaL4r5t6y7u!') where length(idcard_code)>18; #API网站 https://www.eolinker.com/#/home/database/?spaceKey=qKzbz7Y8fd8d56ce838e225392cb53d58aa765d4d9731a7 select inet_aton('255.255.255.255'); select inet_ntoa(4294967295); 所以IP的表字段可以设置为INT(10)就好 ip_address alter table t_transfer_apply add operator char(36) default null comment '操作人员'; alter table t_transfer_apply add ip_address int(11) default 0 comment '操作者IP'; alter table t_sys_loginperson add operator char(36) default null comment '操作人员'; alter table t_sys_loginperson add ip_address int(11) default 0 comment '操作者IP'; alter table t_base_class add operator char(36) default null comment '操作人员'; alter table t_base_class add ip_address int(11) default 0 comment '操作者IP'; alter table t_base_organization add operator char(36) default null comment '操作人员'; alter table t_base_organization add ip_address int(11) default 0 comment '操作者IP'; alter table t_person_duty_charge add operator char(36) default null comment '操作人员'; alter table t_person_duty_charge add ip_address int(11) default 0 comment '操作者IP'; update t_sys_loginperson set operator='9B28524B-7564-45BC-B1D4-156AC6306EC8'; update t_transfer_apply set operator='9B28524B-7564-45BC-B1D4-156AC6306EC8'; update t_base_class set operator='9B28524B-7564-45BC-B1D4-156AC6306EC8'; update t_base_organization set operator='9B28524B-7564-45BC-B1D4-156AC6306EC8'; update t_person_duty_charge set operator='9B28524B-7564-45BC-B1D4-156AC6306EC8'; select inet_aton('127.0.0.1'); update t_sys_loginperson set ip_address=2130706433; update t_transfer_apply set ip_address=2130706433; update t_base_class set ip_address=2130706433; update t_base_organization set ip_address=2130706433; update t_person_duty_charge set ip_address=2130706433; ============================================================================================ 市管理员 shi1 123456 区管理员 qu14 123456 单位管理员(学校) dw33 123456 单位管理员(非学校) dw138 123456（净月开发区教辅单位0管理员） ============================================================ 添加时间戳的列 alter table t_datashare_subscribe drop update_ts; alter table t_datashare_subscribe ADD `update_ts` timestamp(0) NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '时间戳'; ============================================================ # 关于搜索elasticsearch的数据条数大于10000的坑 max_result_window的两种设置方式 curl -H "Content-Type: application/json" -XPUT 'http://10.10.14.201:9200/_all/_settings?preserve_existing=true' -d '{ "index.max_result_window" : "100000000" }' http://10.10.14.201:9200/_all/_settings/ ============================================================ # 列出所有列名 select group_concat(column_name) as cols from information_schema.columns where table_name='t_dm_area' and table_schema='base_db' #添加整数主键 alter table t_dm_zc add id_int int auto_increment Unique comment '整数主键'; https://www.cnblogs.com/BenAndWang/p/10125142.html ============================================================= -- 添加自动增长主键id alter table t_base_class_log change id_int id_int int(10) unsigned not null ; alter table t_base_class_log add log_id_int int auto_increment Unique comment '整数主键' first; =========================================================================================================== vi bin/catalina.sh if [ -z "$CATALINA_OUT" ] ; then #CATALINA_OUT="$CATALINA_BASE"/logs/catalina.out CATALINA_OUT=/dev/null fi # 指定个性化路由 https://blog.csdn.net/cnweike/article/details/38531997 mount -t nfs 10.10.14.222:/usr/local/esBackup /usr/local/esBackup ulimit -SHn 102400 centos在关机或开机时一直等待，提示A stop job is running for …… https://www.jianshu.com/p/412094e4aab0 ipv6禁用导致rpcbind服务启动失败实例 https://blog.51cto.com/hld1992/2055028 #centos7 ssh连接慢解决方法 先备份/etc/ssh/sshd_config,备份命令为 cp /etc/ssh/sshd_config /etc/ssh/sshd_config.bak vi /etc/ssh/sshd_config (编辑配置文件) 输入 / ,查找GSSAPIAuthentication 赋值为no 输入 /，查找UseDNS,赋值为 no(该项默认不启用的，要把前面的#删除掉) 最后输入!wq保存文件并退出 重启systemctl restart sshd # mysql 按序列更新字段 update t_base_organization, (select @id := 0) dm set org_pk_num = (@id := @id + 1)