irisdemo-demo-htap/docker-compose-hana.yml at master · intersystems-community/irisdemo-demo-htap · GitHub

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
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
# Starts the SpeedTest using SAP HANA as the backend database.

version: '3.7'

services:
#
# SAP HANA
# It takes about 7min to start! So be patient!
#
# Default username: SYSYEM
# Default password: SAPHANAPassword1
#
  hana:
    image: store/saplabs/hanaexpress:2.00.040.00.20190729.1
    hostname: hana
    container_name: hana
    init: true
    environment:
      - LOCAL_HANA_PASSSWORD=SAPHANAPassword1
    entrypoint:
      - sh
      - -c
      - echo "{\"master_password\":\"$$LOCAL_HANA_PASSSWORD\"}" > /tmp/hana_password.json; cat /tmp/hana_password.json;/run_hana --agree-to-sap-license --passwords-url file:///tmp/hana_password.json
    sysctls:
      kernel.shmmax: 1073741824
      kernel.shmmni: 524288
      kernel.shmall: 8388608
      # fs.file-max: 20000000
      # fs.aio-max-nr: 18446744073709551615
      # vm.max_map_count: 2147483647

    ulimits:
      nofile:
        soft: 1048576
        hard: 1048576
    ports:
      - "39013:39013"
      - "39017:39017"
      - "39041-39045:39041-39045"
      - "1128-1129:1128-1129"
      - "59013-59014:59013-59014"
    # I don't want SAP HANA's database outside of the container
    #  volumes:
    #   - hana-data:/hana/mounts

#
# Speed Test Master
#

  htapmaster:
    container_name: htapmaster
    hostname: htapmaster
    init: true
    image: intersystemsdc/irisdemo-demo-htap:master-version-2.8.5
    ports:
      - "10002:8080" # Where Springboot Will be listening
    environment:
      - JAVA_OPTS=-Xmx512M
      - MASTER_SPEEDTEST_TITLE=SpeedTest | SAP HANA Express 2.00.040.00.20190729.1
      - START_CONSUMERS=true
      - INGESTION_THREADS_PER_WORKER=2
      - INGESTION_BATCH_SIZE=1000
      - INGESTION_JDBC_URL=jdbc:sap://hana:39017
      - INGESTION_JDBC_USERNAME=SYSTEM
      - INGESTION_JDBC_PASSWORD=SAPHANAPassword1
      - CONSUMER_JDBC_URL=jdbc:sap://hana:39017
      - CONSUMER_JDBC_USERNAME=SYSTEM
      - CONSUMER_JDBC_PASSWORD=SAPHANAPassword1
      - CONSUMER_THREADS_PER_WORKER=1
      - CONSUMER_TIME_BETWEEN_QUERIES_IN_MILLIS=0

#
# Speed Test UI
#
  htapui:
    depends_on:
      - htapmaster
    container_name: htapui
    hostname: htapui
    image: intersystemsdc/irisdemo-demo-htap:ui-version-2.8.5
    ports:
    - "10000:4200" # Where Node Will be listening

#
# Speed Test Ingestion Worker
#
  ingest-worker1:
    depends_on:
      - htapmaster
    container_name: ingest-worker1
    hostname: ingest-worker1
    init: true
    image: intersystemsdc/irisdemo-demo-htap:hana-jdbc-ingest-worker-version-2.8.5
    ports:
      - "10003:8080" # Where Springboot Will be listening
    environment:
      - JAVA_OPTS=-Xmx512M
      - MASTER_HOSTNAME=htapmaster
      - MASTER_PORT=8080

#
# Speed Test Query Worker
#
  query-worker1:
    depends_on:
      - htapmaster
    container_name: query-worker1
    hostname: query-worker1
    init: true
    image: intersystemsdc/irisdemo-demo-htap:hana-jdbc-query-worker-version-2.8.5
    ports:
      - "10004:8080" # Where Springboot Will be listening
    environment:
      - JAVA_OPTS=-Xmx512M
      - MASTER_HOSTNAME=htapmaster
      - MASTER_PORT=8080


#
# SQL Pad is a tool that can allow us to look inside the database.
# Use it AFTER running the speed test. Open your browser at
# http://localhost:3000
#
# Log in with admin/sys
#
# Then you will be able to run queries against the database such as:
# - Select top 100 * from SpeedTest.Account
# - select TO_VARCHAR(ROUND((FREE_PHYSICAL_MEMORY) /1024/1024/1024, 2)) AS FREEMEM from PUBLIC.M_HOST_RESOURCE_UTILIZATION
#
# Useful resources:
# - https://github.com/rickbergfalk/sqlpad
# - https://blogs.sap.com/2018/03/07/connecting-docker-hxe-and-sqlpad/
#
  sqlpad:
    image: intersystemsdc/irisdemo-base-sqlpad:version-1.0.1
    hostname: 'sqlpad'
    ports:
      - '3000:3000'

    environment:
      - SQLPAD_CONNECTIONS__hana__name="SAP HANNA"
      - SQLPAD_CONNECTIONS__hana__driver=hdb
      - SQLPAD_CONNECTIONS__hana__host=hana
      - SQLPAD_CONNECTIONS__hana__hanaport=39017
      - SQLPAD_CONNECTIONS__hana__username=SYSTEM
      - SQLPAD_CONNECTIONS__hana__password=SAPHANAPassword1
    # I don't care about saving state from sqlpad
    # volumes:
    #   - sqlpad-volume:/var/lib/sqlpad


# I don't want SAP HANA's databases outside of the container
# volumes:
#   hana-data:
#   db-data: