问题积累2

DOCKER

🐕docker打包 image参数详解
https://www.cnblogs.com/cocowool/p/make-your-own-image.html
🐕DOCKER-COMPOSE安装
https://www.jianshu.com/p/5ba9f9159696
https://www.cnblogs.com/zhaoxxnbsp/p/13065722.html

docker安装postgresql --previledge
https://blog.csdn.net/qq_35744706/article/details/124114995

Docker 时区调整方案
https://cloud.tencent.com/developer/article/1626811

MYSQL

🐕mysql运维-slave_skip_errors 从库跨过错误
https://www.cnblogs.com/shigfdengys/p/13026379.html
🐕mysql主从同步不一致解决方案
https://www.cnblogs.com/hongzuiliyu/p/13258336.html
🐕彻底解决unable to find valid certification path to requested target
https://www.bbsmax.com/A/l1dybX2Gze/
🐕各类证书问题 数据源等 数据源添加trsutCertificates=true
https://www.cnblogs.com/HKnight/p/16851786.html
🐕mysql8密码错误
指定初始文件–defaults-file=“C:\ProgramData\MySQL\MySQL Server 8.0\my.ini” MySQL80
https://blog.csdn.net/weixin_44957738/article/details/126322939
🐕解决MYSQL中文乱码问题
https://blog.csdn.net/qq_46495964/article/details/122973010
set character_set_server=utf8;
set character_set_database=utf8;
show variables like ‘%char%’;
🐕linux下创建 存储过程
https://blog.csdn.net/u013385925/article/details/75501676
delimiter $
CREATE PROCEDURE st.test(in in1 INT, out out1 INT)begin
set out1=in1;
END;
$

LINUX

🐕gitlab搭建
https://www.jianshu.com/p/0bc9b4755082
🐕搭建SSH主机间免密登录
https://blog.csdn.net/weixin_41679316/article/details/116525841
ssh-keygen -t rsa #生成公私密钥
通过ssh-copy-id同步或者手动拷贝到目标机器/root/.ssh/authorized_keys中
🐕SSH无密钥配置和配置公钥后仍需要输入密码的解决方案
https://blog.csdn.net/silentwolfyh/article/details/83656101
🐕ssh远程报错ssh_exchange_identification: read: Connection reset by peer
https://blog.51cto.com/jschu/1698421
🐕🐕登录后被添加到/etc/hosts.deny中
https://blog.csdn.net/weixin_43713498/article/details/88714734
🐕🐕创建及挂载磁盘
http://www.qishunwang.net/news_show_45421.aspx
🐕🐕使用硬盘挂载swap内存
https://www.cnblogs.com/yuanyongqiang/p/15650176.html
🐕🐕linux创建新用户并授权
https://blog.csdn.net/u9king/article/details/116261122

SHARDING

🐕概览
https://blog.csdn.net/sinat_34814635/article/details/78465631
🐕Springboot 2.3.2 多数据源和分库分表的Sharding-JDBC 4.1.1解决方案
https://blog.csdn.net/bufegar0/article/details/107732951
🐕强制路由使用手册
https://segmentfault.com/a/1190000023378981
https://my.oschina.net/liangxiao/blog/3116271
🐕源码之强制路由 原理
https://www.jianshu.com/p/644e9d6afd2c
🐕shardingjdbc—— 配置druid数据库连接池
https://blog.csdn.net/weixin_44643439/article/details/108671120
🐕Hibernate 集成会出现的问题–ddl-auto: none
https://www.jianshu.com/p/36e4d2abd052
🐕实现读写分离
https://www.cnblogs.com/huanshilang/p/12055296.html

ELK

🐕搭建
https://blog.csdn.net/weixin_38098312/article/details/80181415

ES

🐕docker搭建
https://blog.csdn.net/qq_40942490/article/details/111594267

FastDfs

🐕Nginx和FastDfs完整配置过程
https://blog.csdn.net/qq_34301871/article/details/80060235
https://github.com/happyfish100/fastdfs/wiki

OAUTH2

🐕使用SpringSecurity Oauth2.0实现自定义鉴权中心
https://www.cnblogs.com/Tassdar/p/13793892.html
🐕授权中心实现and原理
https://blog.csdn.net/sinat_40895117/article/details/85333980

SPRING

🐕服务消费（LoadBalancerClient、Ribbon、Feign）
https://www.jianshu.com/p/562045489d9d
🐕有springboot的jar包启动类的main方法
java -cp learnnetty-0.0.1-SNAPSHOT.jar -Dloader.main=com.tq.netty.learnnetty.Test org.springframework.boot.loader.PropertiesLauncher
🐕slf4j开启debug
vm参数添加Dorg.slf4j.simpleLogger.defaultLogLevel=DEBUG
🐕jdk-8以上版本不能使用jdk.internal.misc.Unsafe报错解决
–add-opens java.base/jdk.internal.misc=ALL-UNNAMED
-Dio.netty.tryReflectionSetAccessible=true

ORACLE

🐕ORACLE各个版本下载
https://www.likecs.com/show-158503.html

HADOOP

🐕hadoop启动命令
https://www.cnblogs.com/jun1019/p/6266615.html

文档系统搭建

MINDOC官网
https://www.iminho.me/wiki/docs/mindoc/mindoc-calibre.md
🐕导出搭建calibre5
https://www.ucloud.cn/yun/63212.html
https://www.linkops.cn/wf/1724.html
yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gcc make xdg-utils wget qt4 qt4-devel qt4-x11 libpcap-devel xz-devel -y

yum -y install mesa-libGL qt5-qtquickcontrols qt5-qtdeclarative-devel libXrender libXcomposite

JAVA线上问题排查

https://www.shangmayuan.com/a/cdeb8b0b00294ae089b7a2a4.html
https://baijiahao.baidu.com/s?id=1689133047593866718&wfr=spider&for=pc

GITHUB同步远程分支

需要先设置upstream
https://blog.csdn.net/matrix_google/article/details/80676034

MYSQL

mysql的alter语句中modify，rename，change详解
https://blog.csdn.net/qq_42006733/article/details/92772745
Mysql修改字段名、修改字段类型
https://javaforall.cn/130167.html
http://c.biancheng.net/view/7584.html
postgresql 删除、增加、修改字段；修改表名，字段类型
https://blog.csdn.net/weixin_42234450/article/details/122308528
https://blog.csdn.net/weixin_41908066/article/details/111614266

SPRING

springboot之Filter的URI匹配规则
放行固定接口
https://blog.csdn.net/weixin_43933728/article/details/127905109
springboot使用之多个filter的执行顺序以及配置方式
https://www.jb51.net/article/219504.htm
filter操作parameter
http://events.jianshu.io/p/4d96087fb1bf
Springboot的Filter使用
https://blog.csdn.net/qq_27610647/article/details/88909586

REDSHIFT

redshift鉴权方式
https://docs.aws.amazon.com/zh_cn/redshift/latest/mgmt/generating-iam-credentials-steps.html
https://docs.aws.amazon.com/redshift/latest/mgmt/generating-iam-credentials-configure-jdbc-odbc.html
redshift公网访问
https://blog.csdn.net/yangspoor/article/details/107624610
datafactory连接方式
https://learn.microsoft.com/en-us/java/api/overview/azure/resourcemanager-datafactory-readme?view=azure-java-preview

GIT

非密码校验方式
git remote set-url origin https://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@github.com/github的用户名/仓库名称
maven添加私有仓库鉴权
http://t.zoukankan.com/liufarui-p-14019206.html

REST TEMPLATE

设置超时时间
https://blog.csdn.net/move_on_on/article/details/126544887
各种请求模板
https://blog.csdn.net/p812438109/article/details/107701595
https://blog.csdn.net/kusedexingfu/article/details/117431577
配置
https://blog.csdn.net/qq_16733389/article/details/124479951

JAVA

🐕java8时间，SimpleDateFormat，DateTimeFormatter
Java——日期时间（SimpleDateFormat）
https://blog.csdn.net/qq_53988670/article/details/124245390
全球化时区处理
https://blog.csdn.net/qq_23160151/article/details/107220662
DateTimeFormatter
https://backend.devrank.cn/traffic-information/7082545333712226334

MINIO

🐕minio几种访问策略
https://blog.csdn.net/lj15559275886/article/details/121441031
minio权限策略
http://blog.leanote.com/post/criss/minio%E6%9D%83%E9%99%90%E7%AD%96%E7%95%A5
利用 MinIO 轻松搭建静态资源服务
https://www.shuzhiduo.com/A/q4zVx7yj5K/
minio使用setBucketPolicy设置桶策略
https://blog.csdn.net/qq_43329216/article/details/119212835
Minio 配置访问权限
https://blog.csdn.net/weixin_42555971/article/details/128882824
dokcer安装minio
https://blog.csdn.net/qq_54673740/article/details/134731886