Blame view

sql/tools/docker-compose.yaml 4.45 KB
2f252ffd   王彪总   feat(pay): 实现支付宝支...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
  name: ruoyi-vue-pro
  
  volumes:
      mysql: { }
      postgres: { }
      sqlserver: { }
      dm8: { }
      kingbase: { }
      opengauss: { }
  
  services:
      mysql:
          image: mysql:8.0.33
          restart: unless-stopped
          environment:
              TZ: Asia/Shanghai
              MYSQL_ROOT_PASSWORD: 123456
              MYSQL_DATABASE: ruoyi-vue-pro
          ports:
              - "3306:3306"
          volumes:
              - mysql:/var/lib/mysql/
              # 注入初始化脚本
              - ./mysql/ruoyi-vue-pro.sql:/docker-entrypoint-initdb.d/init.sql:ro
          command:
              --default-authentication-plugin=mysql_native_password
              --character-set-server=utf8mb4
              --collation-server=utf8mb4_general_ci
              --explicit_defaults_for_timestamp=true
              --lower_case_table_names=1
  
      postgres:
          image: postgres:14.2
          restart: unless-stopped
          environment:
              POSTGRES_USER: root
              POSTGRES_PASSWORD: 123456
              POSTGRES_DB: ruoyi-vue-pro
          ports:
              - "5432:5432"
          volumes:
              - postgres:/var/lib/postgresql/data
              # 注入初始化脚本
              - ../postgresql/quartz.sql:/docker-entrypoint-initdb.d/quartz.sql:ro
              - ../postgresql/ruoyi-vue-pro.sql:/docker-entrypoint-initdb.d/ruoyi-vue-pro.sql:ro
  
      oracle:
          image: gvenzl/oracle-xe:18-slim-faststart
          restart: unless-stopped
          environment:
              ## 登录信息 SID: XE user: system password: oracle
              ORACLE_PASSWORD: oracle
          ports:
              - "1521:1521"
          volumes:
              - ../oracle/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
              # 创建app用户: ROOT/123456@//localhost/XEPDB1
              - ./oracle/1_create_user.sql:/docker-entrypoint-initdb.d/1_create_user.sql:ro
              - ./oracle/2_create_schema.sh:/docker-entrypoint-initdb.d/2_create_schema.sh:ro
  
      oracle_m1:
        image: einslib/oracle-19c:19.3.0-ee-slim-faststart
        restart: unless-stopped
        environment:
          ## 登录信息 SID: FREE user: system password: oracle
          ORACLE_PASSWORD: oracle
        ports:
          - "1521:1521"
        volumes:
          - ../oracle/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
          # 创建app用户: ROOT/123456@//localhost/XEPDB1
          - ./oracle/1_create_user.sql:/docker-entrypoint-initdb.d/1_create_user.sql:ro
          - ./oracle/2_create_schema.sh:/docker-entrypoint-initdb.d/2_create_schema.sh:ro
  
      sqlserver:
          image: mcr.microsoft.com/mssql/server:2017-latest
          restart: unless-stopped
          environment:
              TZ: Asia/Shanghai
              ACCEPT_EULA: "Y"
              SA_PASSWORD: "Urbanops@2024"
          ports:
              - "1433:1433"
          volumes:
              - sqlserver:/var/opt/mssql
              - ../sqlserver/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
              # docker compose exec sqlserver bash /tmp/create_schema.sh
              - ./sqlserver/create_schema.sh:/tmp/create_schema.sh:ro
  
      dm8:
          # docker load -i dm8_20240715_x86_rh6_rq_single.tar
          image: dm8_single:dm8_20240715_rev232765_x86_rh6_64
          restart: unless-stopped
          environment:
              PAGE_SIZE: 16
              LD_LIBRARY_PATH: /opt/dmdbms/bin
              EXTENT_SIZE: 32
              BLANK_PAD_MODE: 1
              LOG_SIZE: 1024
              UNICODE_FLAG: 1
              LENGTH_IN_CHAR: 1
              INSTANCE_NAME: dm8_test
          ports:
              - "5236:5236"
          volumes:
              - dm8:/opt/dmdbms/data
              - ../dm/ruoyi-vue-pro-dm8.sql:/tmp/schema.sql:ro
  
      kingbase:
          image: kingbase_v009r001c001b0025_single_x86:v1
  #        image: kingbase_v009r001c001b0025_single_arm:v1
          restart: unless-stopped
          environment:
              DB_USER: root
              DB_PASSWORD: 123456
          ports:
              - "54321:54321"
          volumes:
              - kingbase:/home/kingbase/userdata
              - ../kingbase/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
  
      opengauss:
          image: opengauss/opengauss:5.0.0
          restart: unless-stopped
          environment:
              GS_USERNAME: root
              GS_PASSWORD: Urbanops@2024
              LD_LIBRARY_PATH: /usr/local/opengauss/lib:/usr/lib
          ports:
              - "5432:5432"
          volumes:
              - opengauss:/var/lib/opengauss
              - ../opengauss/ruoyi-vue-pro.sql:/tmp/schema.sql:ro
              # docker compose exec opengauss bash -c '/usr/local/opengauss/bin/gsql -U $GS_USERNAME -W $GS_PASSWORD -d postgres -f /tmp/schema.sql'