递归生成最近30分钟修改的文件跟文件夹 find /data/code/php/member-center-core -name '*.php' -type f -mmin -30 -exec cp --parents '{}' /tmp ';'-mmin -30 代表30分钟内修改的文件-name '*.php' 过滤php文件new下放最新代码tar -cvf new.tar new使用 scp 将文件从本地计算机上传到远程 Linux 服务器上：scp new.tar mc-qa-docker:/home/ec2-user/new.tar连接到远程主机并使用 docker cp 命令将文件复制到 Docker 容器内部：docker cp ./new.tar ecs-qa-1viu-member-center-v2-dns-1-php-fpm-member-center-aad0a1a7878596f6d701:/var/www/new.tar解压new.tartar -xvf new.tar复制new下的所有文件到指定路径cp -Rf ./new/* /var/www/htdocs/member-center

wss nginx配置 wss匹配需要包含在server{}内location /wss { add_header Access-Control-Allow-Origin *; proxy_redirect off; proxy_pass http://wss_8; proxy_set_header Host $host; proxy_set_header X-Real_IP $remote_addr; proxy_set_header X-Forwarded-For $remote_addr:$remote_port; proxy_http_version 1.1; proxy_set_header Upgrade $http_upgrade; proxy_set_header Connection "Upgrade"; }upstream跟server配置同级upstream wss_8{ server 127.0.0.1:8099; }

docker-compose 创建redis集群测试 先写一个通用的 redis.conf 配置要点如下：bind 0.0.0.0 #将绑定ip设置为 0.0.0.0 ，即不绑定ip appendonly yes #开启持久化 cluster-enabled yes #开启集群 cluster-config-file nodes.conf #集群配置文件（这个在后面搭建的时候，会自动生成，不用管，这样写就对了） cluster-node-timeout 15000 #节点超时时间建立各种文件夹，目录结构如下mkdir -p ~/docker/redis/r1/data将上一步的 redis.conf 放到 ~/docker/redis/r1 目录下cp redis.conf ~/docker/redis/r1复制6个r1 文件夹cd ~/docker/redis cp -r r1 r2 cp -r r1 r3 cp -r r1 r4 cp -r r1 r5 cp -r r1 r6进入 redis1 容器docker exec -it redis1 /bin/bash然后进入 redis1 的 redisredis-cli -h redis1将所有节点 都加入到 集群cluster meet 192.168.88.11 6379 cluster meet 192.168.88.12 6379 cluster meet 192.168.88.13 6379 cluster meet 192.168.88.14 6379 cluster meet 192.168.88.15 6379 cluster meet 192.168.88.16 6379查看 集群节点cluster nodes记录 3 个 主 master 的 节点标识主（Master） 标识 654cf8ff01d8442c8ca126537e193b365dcf34d2 192.168.88.11:6379@16379 myself,master - 0 1639642417000 3 connected 0-5461 ba793b92f620d36925c51f9269c0523c30c19a33 192.168.88.14:6379@16379 master - 0 1639642418000 4 connected cf11e46a4bb1aed1035fca9e79efc33db81162d0 192.168.88.15:6379@16379 master - 0 1639642418521 0 connected 2a791d2e6cf619612402544c57e33bcb7053a85c 192.168.88.13:6379@16379 master - 0 1639642417516 2 connected 10923-16383 c243a676e148caf8b3186fba8577e8c7e198e833 192.168.88.16:6379@16379 master - 0 1639642416000 5 connected 176957eb8a28c67c27752e120c8f38e6bd6804e9 192.168.88.12:6379@16379 master - 0 1639642417000 1 connected 5462-10922修改slaves脚本(addslots.sh)# 需要用到 从 redis 到IP 与 主redis 的节点标识 # 从 redis4 主 redis1 redis-cli -h 192.168.88.14 CLUSTER REPLICATE 654cf8ff01d8442c8ca126537e193b365dcf34d2 # 主 redis5 从 redis2 redis-cli -h 192.168.88.15 CLUSTER REPLICATE 176957eb8a28c67c27752e120c8f38e6bd6804e9 # 主 redis6 从 redis3 redis-cli -h 192.168.88.16 CLUSTER REPLICATE 2a791d2e6cf619612402544c57e33bcb7053a85c先执行 addslots.sh 再执行 slaves.sh, 先给下权限chmod -R 755 addslots.sh slaves.sh ./addslots.sh ./slaves.sh查看集群情况和节点信息docker exec -it redis1 /bin/bash redis-cli -h redis1 cluster info cluster nodes

postgresql 删除重复数据 方法一 普通方法DELETE FROM bookmarks A WHERE A.ID NOT IN ( SELECT MIN ( ID ) FROM bookmarks GROUP BY "user_id", "product_id", "is_from_vuclip" );方法二 速度快DELETE FROM bookmarks A WHERE A.ID = ANY ( ARRAY ( SELECT ID FROM ( SELECT ROW_NUMBER ( ) OVER ( PARTITION BY "user_id", "product_id", "is_from_vuclip" ), ID FROM bookmarks ) T WHERE T.ROW_NUMBER > 1 ) );

postgresql修改自增序列 ----删除前先解除 id 对该序列的依赖ALTER TABLE tablename ALTER COLUMN id SET DEFAULT null;DROP SEQUENCE IF EXISTS sequence_name;---- id_max 即 id 目前的最大值，可写为1，可通过 “SELECT MAX(id) FROM tablename” 得到CREATE SEQUENCE sequence_name START WITH id_max;ALTER TABLE tablename ALTER COLUMN id SET DEFAULT nextval('sequence_name'::regclass);示例ALTER TABLE bookmarks ALTER COLUMN id SET DEFAULT null;DROP SEQUENCE IF EXISTS bookmarks_id_seqCREATE SEQUENCE bookmarks_id_seq START WITH 42920698;ALTER TABLE bookmarks ALTER COLUMN id SET DEFAULT nextval('bookmarks_id_seq'::regclass);