代码拉取完成，页面将自动刷新
简体中文 | English
💻LuckysheetServer docker部署启动模板。
C:\Users\Administrator\Desktop\lsheet>tree /f
│
│ docker-compose.yml #部署文件
│
├─java-server
│ application-dev.yml #项目配置
│ application.yml #项目配置
│ web-lockysheet-server.jar #项目
│
├─nginx
│ │ nginx.conf #nginx配置
│ │
│ ├─html #nginx静态文件夹
| | index.html # Luckysheet demo
| |
│ └─logs #nginx日志文件夹
├─postgres
│ │ init.sql #postgre初始化文件
│ │
│ └─data #postgres数据文件夹
└─redis
│ redis.conf #redis配置文件
│
├─data #redis数据文件夹
└─logs #redis日志文件夹
安装 docker
安装 curl
yum install curl
chmod a+rwx ./redis/logs/
docker-compose build
docker-compose up -d
docker ps
docker exec -it 容器ID redis-cli -a '123456'
#进入容器
docker exec -ti postgres /bin/bash
#登陆postgres
psql -U postgres
#列出全部数据库
\l
#切换数据库
\c luckysheetdb
#列出全部表名
\dt
#查看表数据
select * from luckysheet;
curl http://172.19.0.4:9004/luckysheet/test/constant?param=123
curl http://172.19.0.101/luckysheet/test/constant?param=123
http://xx.100.104.9/luckysheet/test/constant?param=123
访问Luckysheet demo
＃ 静态demo
http://xx.100.104.9
＃ 协同编辑模式
http://xx.100.104.9?share
#运行用户
#user nobody;
#开启进程数 <=CPU数
worker_processes 1;
#错误日志保存位置
error_log /var/log/nginx/error.log;
#进程号保存文件
pid /var/log/nginx/nginx.pid;
#等待事件
events {
#Linux下打开提高性能
#use epoll;
#每个进程最大连接数（最大连接=连接数x进程数）
worker_connections 1024;
}
http {
#文件扩展名与文件类型映射表
include mime.types;
#默认文件类型
default_type application/octet-stream;
#日志文件输出格式 这个位置相于全局设置
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
#请求日志保存位置
access_log /var/log/nginx/access.log main;
#打开发送文件
sendfile on;
#tcp_nopush on;
#keepalive_timeout 0;
keepalive_timeout 65;
#打开gzip压缩
#gzip on;
gzip on;
gzip_min_length 1k;
gzip_buffers 16 64k;
gzip_http_version 1.0;
gzip_comp_level 7;
#DO NOT zip pics
gzip_types text/plain application/x-javascript text/javascript application/x-httpd-php text/css text/xml text/jsp application/eot application/ttf application/otf application/svg application/woff;
gzip_vary on;
gzip_disable "MSIE [1-6].";
#websocket
map $http_upgrade $connection_upgrade {
default upgrade;
'' close;
}
#设定负载均衡的服务器列表
upstream luckysheetserver {
server 172.19.0.4:9004 weight=1;
}
#第一个虚拟主机
server {
#监听IP端口
listen 80;
#主机名
server_name localhost;
#设置字符集
#charset koi8-r;
#本虚拟server的访问日志 相当于局部变量
#access_log logs/host.access.log main;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-Server $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
location /luckysheet/websocket/luckysheet {
proxy_pass http://luckysheetserver/luckysheet/websocket/luckysheet;
proxy_set_header Host $host;
proxy_set_header X-real-ip $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_connect_timeout 1800s;
proxy_read_timeout 600s;
proxy_send_timeout 600s;
#websocket
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
}
location /luckysheet/ {
proxy_pass http://luckysheetserver;
proxy_connect_timeout 1800;
proxy_read_timeout 600;
}
location / {
root /usr/share/nginx/html/;
index index.html index.htm;
proxy_connect_timeout 1800;
proxy_read_timeout 600;
#websocket
proxy_http_version 1.1;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "upgrade";
}
#动静分离
location ~ .*\.(html|js|css|jpg|txt)?$ {
root /usr/share/nginx/html/;
#expires 3d;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root /usr/share/nginx/html/;
}
}
}
bind *
protected-mode no
port 6379
tcp-backlog 511
timeout 0
tcp-keepalive 300
supervised no
pidfile /usr/local/redis/redis.pid
loglevel notice
logfile /usr/local/redis/logs.log
databases 16
save 900 1
save 300 10
save 60 10000
stop-writes-on-bgsave-error yes
rdbcompression yes
rdbchecksum yes
dbfilename dump.rdb
dir /usr/local/redis/data/
slave-serve-stale-data yes
repl-diskless-sync no
repl-diskless-sync-delay 5
repl-disable-tcp-nodelay no
slave-priority 100
maxmemory 500mb
maxmemory-policy noeviction
appendonly no
appendfilename "appendonly.aof"
appendfsync everysec
no-appendfsync-on-rewrite no
auto-aof-rewrite-percentage 100
auto-aof-rewrite-min-size 64mb
aof-load-truncated yes
lua-time-limit 5000
slowlog-log-slower-than 10000
slowlog-max-len 128
latency-monitor-threshold 0
notify-keyspace-events ""
hash-max-ziplist-entries 512
hash-max-ziplist-value 64
list-max-ziplist-size -2
list-compress-depth 0
set-max-intset-entries 512
zset-max-ziplist-entries 128
zset-max-ziplist-value 64
hll-sparse-max-bytes 3000
activerehashing yes
client-output-buffer-limit normal 0 0 0
client-output-buffer-limit slave 256mb 64mb 60
client-output-buffer-limit pubsub 32mb 8mb 60
hz 10
aof-rewrite-incremental-fsync yes
requirepass 123456
CREATE DATABASE luckysheetdb;
\c luckysheetdb;
DROP SEQUENCE IF EXISTS "public"."luckysheet_id_seq";
CREATE SEQUENCE "public"."luckysheet_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9999999999999
START 1
CACHE 10;
DROP TABLE IF EXISTS "public"."luckysheet";
CREATE TABLE "luckysheet" (
"id" int8 NOT NULL,
"block_id" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
"index" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
"list_id" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
"status" int2 NOT NULL,
"json_data" jsonb,
"order" int2,
"is_delete" int2
);
CREATE INDEX "block_id" ON "public"."luckysheet" USING btree (
"block_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"list_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "index" ON "public"."luckysheet" USING btree (
"index" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"list_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "is_delete" ON "public"."luckysheet" USING btree (
"is_delete" "pg_catalog"."int2_ops" ASC NULLS LAST
);
CREATE INDEX "list_id" ON "public"."luckysheet" USING btree (
"list_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "order" ON "public"."luckysheet" USING btree (
"list_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"order" "pg_catalog"."int2_ops" ASC NULLS LAST
);
CREATE INDEX "status" ON "public"."luckysheet" USING btree (
"list_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"status" "pg_catalog"."int2_ops" ASC NULLS LAST
);
ALTER TABLE "public"."luckysheet" ADD CONSTRAINT "luckysheet_pkey" PRIMARY KEY ("id");
INSERT INTO "public"."luckysheet" VALUES (nextval('luckysheet_id_seq'), 'fblock', '1', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 1, '{"row":84,"name":"Sheet1","chart":[],"color":"","index":"1","order":0,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 0, 0);
INSERT INTO "public"."luckysheet" VALUES (nextval('luckysheet_id_seq'), 'fblock', '2', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 0, '{"row":84,"name":"Sheet2","chart":[],"color":"","index":"2","order":1,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 1, 0);
INSERT INTO "public"."luckysheet" VALUES (nextval('luckysheet_id_seq'), 'fblock', '3', '1079500#-8803#7c45f52b7d01486d88bc53cb17dcd2c3', 0, '{"row":84,"name":"Sheet3","chart":[],"color":"","index":"3","order":2,"column":60,"config":{},"status":0,"celldata":[],"ch_width":4748,"rowsplit":[],"rh_height":1790,"scrollTop":0,"scrollLeft":0,"visibledatarow":[],"visibledatacolumn":[],"jfgird_select_save":[],"jfgrid_selection_range":{}}', 2, 0);
version: "2"
services:
nginx:
image: nginx:latest
#restart: always
container_name: nginx
environment:
- TZ=Asia/Shanghai
ports:
- "80:80"
- "443:443"
volumes:
- ./nginx/nginx.conf:/etc/nginx/nginx.conf
- ./nginx/logs:/var/log/nginx/
- ./nginx/html:/usr/share/nginx/html/
- /etc/localtime:/etc/localtime
networks:
extnetwork:
ipv4_address: 172.19.0.101
redis:
image: redis:latest
container_name: redis
#restart: always
environment:
- TZ=Asia/Shanghai
command: redis-server /usr/local/etc/redis/redis.conf --requirepass 123456
ports:
- "6379:6379"
volumes:
- ./redis/data:/usr/local/redis/data/
- ./redis/logs:/usr/local/redis/
- ./redis/redis.conf:/usr/local/etc/redis/redis.conf
- /etc/localtime:/etc/localtime
networks:
extnetwork:
ipv4_address: 172.19.0.2
postgres:
image: postgres:12
#restart: always
privileged: true
container_name: postgres
ports:
- 5432:5432
environment:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: 123456
PGDATA: /var/lib/postgresql/data/pgdata
volumes:
- ./postgres/data:/var/lib/postgresql/data/pgdata
- ./postgres/init.sql:/docker-entrypoint-initdb.d/init.sql
- /etc/localtime:/etc/localtime
networks:
extnetwork:
ipv4_address: 172.19.0.3
web-server:
image: java:8
#restart: always
privileged: true
ports:
- 9004:9004
volumes:
- ./java-server/web-lockysheet-server.jar:/usr/local/luckysheet-server/app.jar
- ./java-server/application.yml:/usr/local/luckysheet-server/application.yml
- ./java-server/application-dev.yml:/usr/local/luckysheet-server/application-dev.yml
- /etc/localtime:/etc/localtime
command: [
'java',
'-Xmx200m',
'-jar',
'/usr/local/luckysheet-server/app.jar',
'--spring.config.location=/usr/local/luckysheet-server/application.yml,/usr/local/luckysheet-server/application-dev.yml'
]
networks:
extnetwork:
ipv4_address: 172.19.0.4
networks:
extnetwork:
ipam:
config:
- subnet: 172.19.0.0/16
gateway: 172.19.0.1
注：
# 进入容器
docker exec -ti 容器ID /bin/bash
# 进入容器内redis
docker exec -it 容器ID redis-cli -a '123456'
# 登陆docker查看日志
docker logs --tail 300 -f 容器ID
# 设置文件夹权限
chmod a+rwx 目标
有关详细信息，请查阅附件的LICENSE文件。原始作者保留Apache 2.0许可未明确授予的所有权利。
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。