潘志宝
2024-11-28 047527086c061f7a5798d53566aa2f88b0f70ba7
提交 | 用户 | 时间
e7c126 1 name: ruoyi-vue-pro
H 2
3 volumes:
4     mysql: { }
5     postgres: { }
6     sqlserver: { }
7     dm8: { }
8
9 services:
10     mysql:
11         image: mysql:8.0.33
12         restart: unless-stopped
13         environment:
14             TZ: Asia/Shanghai
15             MYSQL_ROOT_PASSWORD: 123456
16             MYSQL_DATABASE: ruoyi-vue-pro
17         ports:
18             - "3306:3306"
19         volumes:
20             - mysql:/var/lib/mysql/
21             # 注入初始化脚本
22             - ./mysql/ruoyi-vue-pro.sql:/docker-entrypoint-initdb.d/init.sql:ro
23         command:
24             --default-authentication-plugin=mysql_native_password
25             --character-set-server=utf8mb4
26             --collation-server=utf8mb4_general_ci
27             --explicit_defaults_for_timestamp=true
28             --lower_case_table_names=1
29
30     postgres:
31         image: postgres:14.2
32         restart: unless-stopped
33         environment:
34             POSTGRES_USER: root
35             POSTGRES_PASSWORD: 123456
36             POSTGRES_DB: ruoyi-vue-pro
37         ports:
38             - "5432:5432"
39         volumes:
40             - postgres:/var/lib/postgresql/data
41             # 注入初始化脚本
42             - ../postgresql/quartz.sql:/docker-entrypoint-initdb.d/quartz.sql:ro
43             - ../postgresql/ruoyi-vue-pro.sql:/docker-entrypoint-initdb.d/ruoyi-vue-pro.sql:ro
44
45     oracle:
46         image: gvenzl/oracle-xe:18-slim-faststart
47         restart: unless-stopped
48         environment:
49             ## 登录信息 SID: XE user: system password: oracle
50             ORACLE_PASSWORD: oracle
51         ports:
52             - "1521:1521"
53         volumes:
54             - ../oracle/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
55             # 创建app用户: ROOT/123456@//localhost/XEPDB1
56             - ./oracle/1_create_user.sql:/docker-entrypoint-initdb.d/1_create_user.sql:ro
57             - ./oracle/2_create_schema.sh:/docker-entrypoint-initdb.d/2_create_schema.sh:ro
58
59     sqlserver:
60         image: mcr.microsoft.com/mssql/server:2017-latest
61         restart: unless-stopped
62         environment:
63             TZ: Asia/Shanghai
64             ACCEPT_EULA: "Y"
65             SA_PASSWORD: "Iailab@2024"
66         ports:
67             - "1433:1433"
68         volumes:
69             - sqlserver:/var/opt/mssql
70             - ../sqlserver/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
71             # docker compose exec sqlserver bash /tmp/create_schema.sh
72             - ./sqlserver/create_schema.sh:/tmp/create_schema.sh:ro
73
74
75     dm8:
76         # wget https://download.dameng.com/eco/dm8/dm8_20230808_rev197096_x86_rh6_64_single.tar
77         # docker load -i dm8_20230808_rev197096_x86_rh6_64_single.tar
78         image: dm8_single:dm8_20230808_rev197096_x86_rh6_64
79         restart: unless-stopped
80         environment:
81             PAGE_SIZE: 16
82             LD_LIBRARY_PATH: /opt/dmdbms/bin
83             EXTENT_SIZE: 32
84             BLANK_PAD_MODE: 1
85             LOG_SIZE: 1024
86             UNICODE_FLAG: 1
87             LENGTH_IN_CHAR: 1
88             INSTANCE_NAME: dm8_test
89         ports:
90             - "5236:5236"
91         volumes:
92             - dm8:/opt/dmdbms/data
93             - ../dm/ruoyi-vue-pro-dm8.sql:/tmp/schema.sql:ro
94             # docker compose exec dm8 bash -c "exec /opt/dmdbms/bin/disql SYSDBA/SYSDBA001 \`/tmp/schema.sql"