[taler-grid5k] 49/73: monitor dns too, change db settings

[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 dd940498c6ba76675b751cd25ae48689479e3180
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Fri Dec 3 17:33:44 2021 +0100

    monitor dns too, change db settings
---
 configs/etc/monitor/node-exporters.yaml.tpl |  4 ++++
 experiment/scripts/database.sh              | 15 +++++++++------
 experiment/scripts/setup.sh                 |  2 +-
 notes.txt                                   |  3 +++
 4 files changed, 17 insertions(+), 7 deletions(-)

diff --git a/configs/etc/monitor/node-exporters.yaml.tpl 
b/configs/etc/monitor/node-exporters.yaml.tpl
index 3aa3bc2..d8b69ac 100644
--- a/configs/etc/monitor/node-exporters.yaml.tpl
+++ b/configs/etc/monitor/node-exporters.yaml.tpl
@@ -1,5 +1,9 @@
   - job_name: 'nodes'
     static_configs:
+    - labels:
+        component: 'dns'
+      targets:
+      - 'ns1.${DNS_ZONE}:9100'
     - labels:
         component: 'database'
       targets: 
diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index a5b180f..8f85622 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -26,24 +26,27 @@ function setup_config() {
   
   # use 25% of the available memory 
   # (https://www.postgresql.org/docs/13/runtime-config-resource.html)
-  shared_buffers=$(($(awk '/MemTotal/ {print $2}' /proc/meminfo) / 4 ))kB
+  shared_buffers=$(($(awk '/MemTotal/ {print $2}' /proc/meminfo) / 3 ))kB
   effective_cache_size=$(($(awk '/MemTotal/ {print $2}' /proc/meminfo) * 
3/4))kB
   
   # 
(https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-MAX-WAL-SIZE)
-  min_wal_size=500
-  max_wal_size=2GB 
+  min_wal_size=4GB
+  max_wal_size=8GB
   wal_buffers=16MB
   
   max_worker_processes=$(lscpu | grep "CPU(s)" | head -n 1 | awk '{print $2}')
-  max_connections=300
+  max_parallel_workers=$(($(lscpu | grep "CPU(s)" | head -n 1 | awk '{print 
$2}') * 1/2))
+  max_connections=500
+
+  max_parallel_maintenance_workers=4
   
   # out of shared memory
   max_locks_per_transaction=85
   
   # Increase work mem to lower I/O utilization (max used =~ work_mem * 
max_connections)
   # NOTE: This formula is not completely correct 
-  work_mem=128MB
-  idle_in_transaction_session_timeout=3000
+  work_mem=256MB
+  # idle_in_transaction_session_timeout=3000
   " > /etc/postgresql/13/main/exchange.conf
 
   if ! grep -q "include = 'exchange.conf'" \
diff --git a/experiment/scripts/setup.sh b/experiment/scripts/setup.sh
index 11d51d7..3a9735d 100644
--- a/experiment/scripts/setup.sh
+++ b/experiment/scripts/setup.sh
@@ -53,7 +53,7 @@ function setup_environment() {
   # Needed for envsubst to work 
   export DNS_ZONE=${DNS_ZONE}
   # Set the hostnames completely with substituting ${DNS_ZONE}
-  cat ~/.env | envsubst > .env && mv .env ~/.env
+  cat ~/.env | envsubst > /tmp/.env && mv /tmp/.env ~/.env
   # Add the environment config for following shells
   cat ~/.env | grep -v API_KEY | tee /etc/environment
 
diff --git a/notes.txt b/notes.txt
index a39ccb9..cbad953 100644
--- a/notes.txt
+++ b/notes.txt
@@ -25,3 +25,6 @@
 * ansible not working with debian 11 - install script fails - but even when 
installed manually it hangs in preparing ansible dir
 * Maybe add a grouping option, so multi command can be run on a group rather 
than manually selecting the matching nodes
 * Espec should have the permission to scp or ssh - auth forwarding?
+* jFed don't abort when e.g.
+  Exception in XML RPC call: XML RPC call for command "Status" with argv 
size=3 threw exception.(Con.ID=19)  
GeniException.XmlRpcResult=be.iminds.ilabt.jfed.lowlevel.connection.XMLRPCCallDetailsGeneral@4a087ae}
+  This is an uncritical error, pressing refresh and it work just fine again

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