tryyourbest0928的博客

mysql更新部分表

tryyourbest0928 — Tue, 04 Apr 2023 17:11:17 +0800

场景举例，AB两个mysql数据库，数据库之间网络不通，且数据库中表不完全相同，现需要将A库的部分表更新至B中，操作如下。2.备份所需的多个表。

docker部署geoserver

tryyourbest0928 — Fri, 02 Sep 2022 10:37:09 +0800

docker 部署geoserver2.21.1

docker日志/var/lib/docker/containers/json.log清理

tryyourbest0928 — Wed, 22 Jun 2022 15:54:17 +0800

docker 日志

FATAL ERROR: Ineffective mark-compacts near heap limit Allocation failed - JavaScript heap out of me

tryyourbest0928 — Wed, 23 Feb 2022 15:08:56 +0800

说明：仅提供一种解决思路解决方式：更新node版本，由node:12.18.0-alpine3.11更新为node:14.17.6-alpine3.11 # cicd报错 Step 13/16 : RUN npm run --silent build-local <--- Last few GCs ---> [16:0x5638df093f60] 166359 ms: Mark-sweep 2041.2 (2050.9) -> 2040.5 (2050.9) MB, 3565.

ubuntu 文件删除后磁盘没有释放

tryyourbest0928 — Wed, 12 Jan 2022 11:40:33 +0800

磁盘满了，删除文件后df发现没有变化 (base) root@xddz:~# df -h Filesystem Size Used Avail Use% Mounted on udev 32G 0 32G 0% /dev tmpfs 6.3G 2.8M 6.3G 1% /run /dev/sdb1 .

常用网站地址

tryyourbest0928 — Mon, 10 Jan 2022 16:16:48 +0800

# gitlab-ci https://docs.gitlab.com/ee/ci/yaml/#cache # docker-hub https://hub.docker.com/_/alpine?tab=tags # aliyun 镜像仓库 https://mirrors.aliyun.com/alpine/v3.15/main https://dl-cdn.alpinelinux.org/alpine/v3.15/community

离线更新单个docker

tryyourbest0928 — Tue, 21 Dec 2021 16:27:15 +0800

#! /bin/bash # sh front-offline-update.sh load | sh front-offline-update.sh save # sh single-front-offline-update.sh save front_name | sh single-front-offline-update.sh load front_name port # update the ezstudio_fronts if [ "$1" = "save" ] then docker

批量离线更新docker服务

tryyourbest0928 — Tue, 21 Dec 2021 16:11:27 +0800

#! /bin/bash # sh front-offline-update.sh load | sh front-offline-update.sh save # update the ezstudio_fronts ezstudio_fronts=("ez_scene" "ez_lib_front") front_count=`expr ${#ezstudio_fronts[*]} - 1` if [ "$1" = "save" ] then for i in $(seq 0 $front_co

阿里云ecs从内网连接不上云mysql

tryyourbest0928 — Tue, 21 Dec 2021 10:43:05 +0800

阿里云ecs内网连接不上mysql内网地址白名单和防火墙都设置了，vpc也是同一个vpc 后来检查发现，是mysql的内网地址网段和docker的默认网段冲突了，改一下docker的默认网段就好了 # docker默认 172.17.0.1 # 修改或新增daemon.json文件 [root@juluo-databases ~]# cat /etc/docker/daemon.json { "bip":"192.168.0.1/24" } [root@juluo-databases ~]#.

docker-compose离线安装

tryyourbest0928 — Mon, 20 Dec 2021 10:57:02 +0800

# download https://github.com/docker/compose/releases/tag/v2.2.0 mv docker-compose-linux-x86_64 /usr/bin/docker-compose [root@front-master ~]# chmod +x /usr/bin/docker-compose [root@front-master ~]# docker-compose -v Docker Compose version v2.2.0 [root@fr

postgis-docker

tryyourbest0928 — Wed, 08 Dec 2021 14:46:37 +0800

4.postgis ### postgis ### postgis docker pull postgis/postgis:12-3.1-alpine docker run -t --name postgresql --restart always -e POSTGRES_USER='postgres' -e POSTGRES_PASSWORD=JsoSVUhhrXHqksSE -e ALLOW_IP_RANGE=0.0.0.0/0 -p 7803:5432 -d postgis/postgis:12-3

centos7.5 离线安装docker

tryyourbest0928 — Thu, 11 Nov 2021 14:36:41 +0800

docker_offline_install.sh #! /bin/sh cd /var/ctdna/ mv /tmp/docker-20.10.7.tgz . tar zxf docker-20.10.7.tgz ls -l docker-20.10.7.tgz cp docker/* /usr/bin/ touch /etc/systemd/system/docker.service echo "[Unit] Description=Docker Application Container Engine

前端js css文件报错net::ERR_SSL_PROTOCOL_ERROR

tryyourbest0928 — Fri, 05 Nov 2021 11:05:06 +0800

项目部署无法使用域名，测试部署后的前端发现界面css、js文件无法展示，报错net::ERR_SSL_PROTOCOL_ERROR 处理方式如下：删除index.html文件中的 --content=“upgrade-insecure-requests” ...

dockerfile 修改镜像源站

tryyourbest0928 — Thu, 04 Nov 2021 15:26:54 +0800

# dockerfile FROM node:12.18.0-alpine3.11 ARG NPM_RUN_ARG=build # 修改镜像源 RUN echo -e http://mirrors.ustc.edu.cn/alpine/v3.11/main/ > /etc/apk/repositories RUN apk add nginx tzdata RUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

linux CPU详细信息

tryyourbest0928 — Mon, 25 Oct 2021 14:55:00 +0800

一个docker内不同参数执行个npm run

tryyourbest0928 — Thu, 21 Oct 2021 16:45:10 +0800

/www/wwwroot # cat Dockerfile FROM node:12.18.0-alpine3.11 ARG NPM_RUN_ARG=build ARG NPM_RUN_ARG_TWO=build-storybook RUN apk add nginx tzdata RUN ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime ADD . /www/wwwroot/ WORKDIR /www/wwwroot/ #RUN ya

批量修改centos7 ssh多端口

tryyourbest0928 — Tue, 12 Oct 2021 10:30:16 +0800

vim /etc/ssh/sshd_config Port 22 Port 51810 service sshd restart # 连接测试 ssh -p 51810 192.168.23.10

centos7下haproxy2.1.10安装+nginx1.18tar包安装

tryyourbest0928 — Mon, 11 Oct 2021 14:08:19 +0800

# 安装所需依赖 yum -y install gcc openssl-devel pcre-devel systemd-devel # 下载安装包 wget -c https://www.haproxy.org/download/2.1/src/haproxy-2.1.10.tar.gz tar zxf haproxy-2.1.10.tar.gz -C /usr/local/ cd /usr/local/haproxy-2.1.10/ make TARGET=linux-glibc sudo make i

docker-rabbitmq+redis+postgreSQL+mysql+mongo

tryyourbest0928 — Sat, 09 Oct 2021 14:08:57 +0800

runlike -p rabbitmq-server docker run -d -p 7803:6379 --name juluo-redis -v /export/redis/config/redis.conf:/etc/redis/redis.conf -v /export/redis/data:/data redis:5.0.14 redis-server /etc/redis/redis.conf --appendonly yes docker run -d --name juluo-

for+if+var

tryyourbest0928 — Thu, 23 Sep 2021 13:38:13 +0800

grep -n ^_id mongo.txt | awk -F: '{print $1}' > num.txt table_count=`cat -n tables.txt | awk '{print $1}' | tail -n 1` target_row_count=`wc -l num.txt | awk '{print $1}'` for ((i=1; i<=$target_row_count; i++)); do for ((j=1; j<=$table_count; j