[taler-grid5k] 119/189: add docker-compose to explain-visualizer

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 90956e2970268ec95343435c6f3756e1e44b2052
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sun Apr 3 16:34:52 2022 +0200

    add docker-compose to explain-visualizer
---
 additional/README.md                              |  7 +++++++
 additional/explain-visualizer/.gitignore          |  1 +
 additional/explain-visualizer/docker-compose.yaml | 15 +++++++++++++++
 experiment/scripts/database.sh                    |  6 +++---
 4 files changed, 26 insertions(+), 3 deletions(-)

diff --git a/additional/README.md b/additional/README.md
index 82f948c..5917b37 100644
--- a/additional/README.md
+++ b/additional/README.md
@@ -46,6 +46,13 @@ be configured in `postgresql.conf`:
 
 Make sure that syslog is capable to receive bigger messages (e.g. 
`$MaxMessageSize` in rsyslog).
 
+There is also a `docker-compose` which can be used to easily spawn a database 
automatically applying
+the dump from the experiment database. To do so run the following steps (in 
its directory):
+
+* `export DUMP_FILE=<absolute-or-relative-path-to-dump>`
+* `docker-compose up -d`
+* `./explain.py logs -U taler -d taler -H localhost <log-file>`
+
 ## grafana
 
 ### Custom
diff --git a/additional/explain-visualizer/.gitignore 
b/additional/explain-visualizer/.gitignore
index 7ece9bc..8963ec6 100644
--- a/additional/explain-visualizer/.gitignore
+++ b/additional/explain-visualizer/.gitignore
@@ -1,3 +1,4 @@
 !*.py
 !*.gitignore
+!*.yaml
 *
diff --git a/additional/explain-visualizer/docker-compose.yaml 
b/additional/explain-visualizer/docker-compose.yaml
new file mode 100644
index 0000000..fb34a33
--- /dev/null
+++ b/additional/explain-visualizer/docker-compose.yaml
@@ -0,0 +1,15 @@
+version: "3.5"
+
+services:
+
+  taler-exchange:
+    image: postgres:13-alpine
+    ports:
+      - 5432:5432
+    environment:
+      POSTGRES_PASSWORD: taler
+      POSTGRES_USER: taler
+      POSTGRES_HOST_AUTH_METHOD: trust
+      POSTGRES_DB: taler
+    volumes:
+      - ${DUMP_FILE}:/docker-entrypoint-initdb.d/00-dump.sql:ro
diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index bb46d14..181a187 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -137,8 +137,8 @@ function setup_config() {
   huge_pages=on
   
   # 
(https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-MAX-WAL-SIZE)
-  min_wal_size=4GB
-  max_wal_size=16GB
+  min_wal_size=20GB
+  max_wal_size=200GB
   wal_buffers=1GB
 
   checkpoint_completion_target=0.9
@@ -159,7 +159,7 @@ function setup_config() {
 
   # Bad when turned off - Recovering db may not be possible
   # https://www.postgresql.org/docs/13/runtime-config-wal.html#GUC-FSYNC
-  fsync = off
+  fsync = on
 
   # Not so bad as when turning off fsync, but single transactions might get 
lost on crash - but
   # like they would have aborted cleanly

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.