From 0b0b9954c2d0602b1e9d0a387d2a195a790f8084 Mon Sep 17 00:00:00 2001
From: "Suren A. Chilingaryan" <csa@suren.me>
Date: Thu, 22 Mar 2018 04:37:46 +0100
Subject: Various fixes and provide ADEI admin container...
---
setup/projects/adei/vars/apps.yml | 2 +-
setup/projects/adei/vars/globals.yml | 69 +++++++++++++++++++++++++------
setup/projects/adei/vars/mysql.yml | 8 +++-
setup/projects/adei/vars/mysql_galera.yml | 1 -
setup/projects/adei/vars/volumes.yml | 8 ++--
5 files changed, 70 insertions(+), 18 deletions(-)
(limited to 'setup/projects/adei/vars')
diff --git a/setup/projects/adei/vars/apps.yml b/setup/projects/adei/vars/apps.yml
index 20cdefe..1c2aad3 100644
--- a/setup/projects/adei/vars/apps.yml
+++ b/setup/projects/adei/vars/apps.yml
@@ -1,5 +1,5 @@
apps:
- mysql: { provision: true, instantiate: false }
+ mysql: { provision: true, instantiate: true }
galera: { provision: true, instantiate: false }
# simple_mysql: { provision: false, instantiate: false }
phpmyadmin: { provision: true, instantiate: true }
diff --git a/setup/projects/adei/vars/globals.yml b/setup/projects/adei/vars/globals.yml
index 8435926..fef5a5b 100644
--- a/setup/projects/adei/vars/globals.yml
+++ b/setup/projects/adei/vars/globals.yml
@@ -24,6 +24,13 @@ adei_pod_env:
value: "${adei_revision}"
- name: "ADEI_PATH"
value: "/adei/src"
+ - name: "ADEI_CACHE_ENGINE"
+ value: "INNODB"
+ - name: "ADEI_REPOSITORY"
+ valueFrom:
+ secretKeyRef:
+ name: webdav
+ key: repo
adei_prod_env:
- name: "MYSQL_SERVER"
@@ -81,6 +88,28 @@ adei_update_env:
- name: "ADEI_CONTINUOUS_CACHING"
value: "${continuous_caching}"
+adei_admin_env:
+ - name: "ADEI_ADMIN"
+ value: "1"
+ - name: "MYSQL_SERVER"
+ value: "mysql-master.adei.svc.cluster.local"
+ - name: "ADEI_SETUP"
+ value: "${setup}"
+ - name: "ADEI_URL"
+ value: "http://adei-${setup}-debug.adei.svc.cluster.local/adei"
+ - name: "ADEI_SCHEDULER"
+ value: "${sched_parallel}"
+ - name: "ADEI_PARALLEL"
+ value: "${cache_parallel}"
+ - name: "BZR_EMAIL"
+ value: "${maintainer}"
+ - name: "ENV"
+ value: "~/.bashrc"
+ - name: "HOME"
+ value: "/data/home"
+ - name: "SHELL"
+ value: "/bin/bash"
+
adei_cache_env:
- name: "MYSQL_SERVER"
value: "mysql-master.adei.svc.cluster.local"
@@ -119,9 +148,6 @@ adei_log_cache_env:
adei_pod_vols:
- - name: adei-etc
- persistentVolumeClaim:
- claimName: adei-etc
- name: adei-src
persistentVolumeClaim:
claimName: adei-src
@@ -138,15 +164,10 @@ adei_pod_vols:
persistentVolumeClaim:
claimName: adei-log
-adei_prod_mounts:
- - name: adei-src
- subPath: prod
- mountPath: /adei/src
-
-adei_dbg_mounts:
- - name: adei-src
- subPath: dbg
- mountPath: /adei/src
+adei_admin_vols:
+ - name: adei-data
+ persistentVolumeClaim:
+ claimName: adei-data
adei_pod_mounts:
- name: adei-cfg
@@ -162,6 +183,20 @@ adei_pod_mounts:
subPath: "${setup}/apache2"
mountPath: /var/log/apache2
+adei_prod_mounts:
+ - name: adei-src
+ subPath: prod
+ mountPath: /adei/src
+
+adei_dbg_mounts:
+ - name: adei-src
+ subPath: dbg
+ mountPath: /adei/src
+
+adei_admin_mounts:
+ - name: adei-data
+ mountPath: /data
+
adei_frontends:
frontend:
name: "adei-${setup}"
@@ -246,6 +281,16 @@ adei_frontends:
mounts: "{{ adei_prod_mounts | union(adei_pod_mounts) }}"
groups: [ "adei" ]
enabled: true
+ admin:
+ name: "adei-${setup}-admin"
+ type: admin
+ replicas: 0
+ cmd: [ "/docker-entrypoint.sh", "/adei/src/scripts/system/adminer.sh" ]
+ env: "{{ adei_pod_env | union(adei_admin_env) }}"
+ vols: "{{ adei_pod_vols | union(adei_admin_vols) }}"
+ mounts: "{{ adei_dbg_mounts | union(adei_pod_mounts) | union(adei_admin_mounts) }}"
+ groups: [ "adei" ]
+ enabled: true
# Extra options:
# start_tolerance: 30
diff --git a/setup/projects/adei/vars/mysql.yml b/setup/projects/adei/vars/mysql.yml
index 3349598..cf72c90 100644
--- a/setup/projects/adei/vars/mysql.yml
+++ b/setup/projects/adei/vars/mysql.yml
@@ -27,6 +27,8 @@ mysql:
- { name: "MYSQL_PMA_PASSWORD", value: "secret@adei/pma-password" }
- { name: "MYSQL_MAX_CONNECTIONS", value: "500" }
- { name: "MYSQL_SYNC_BINLOG", value: "0" }
+ - { name: "MYSQL_BINLOG_SYNC_DELAY", value: "25000" }
+ - { name: "MYSQL_BINLOG_NODELAY_COUNT", value: "32" }
- { name: "MYSQL_FLUSH_LOG_TYPE", value: "2" }
- { name: "MYSQL_FLUSH_LOG_TIMEOUT", value: "300" }
- { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
@@ -75,10 +77,14 @@ mysql:
- { name: "MYSQL_MASTER_PASSWORD", value: "secret@adei/service-password" }
- { name: "MYSQL_PMA_PASSWORD", value: "secret@adei/pma-password" }
- { name: "MYSQL_MAX_CONNECTIONS", value: "500" }
+ - { name: "MYSQL_LOG_BIN", value: "1" }
- { name: "MYSQL_SYNC_BINLOG", value: "0" }
+ - { name: "MYSQL_LOG_SLAVE_UPDATES", value: "0" }
+ - { name: "MYSQL_BINLOG_SYNC_DELAY", value: "25000" }
+ - { name: "MYSQL_BINLOG_NODELAY_COUNT", value: "32" }
- { name: "MYSQL_FLUSH_LOG_TYPE", value: "2" }
- { name: "MYSQL_FLUSH_LOG_TIMEOUT", value: "300" }
- - { name: "MYSQL_SLAVE_WORKERS", value: "8" }
+ - { name: "MYSQL_SLAVE_WORKERS", value: "16" }
- { name: "MYSQL_SLAVE_SKIP_ERRORS", value: "1007,1008,1050,1051,1054,1060,1061,1068,1094,1146,1304,1359,1476,1537" }
- { name: "MYSQL_BINLOG_FORMAT", value: "MIXED" }
mappings:
diff --git a/setup/projects/adei/vars/mysql_galera.yml b/setup/projects/adei/vars/mysql_galera.yml
index e986268..a927e5c 100644
--- a/setup/projects/adei/vars/mysql_galera.yml
+++ b/setup/projects/adei/vars/mysql_galera.yml
@@ -71,5 +71,4 @@ galera:
- { name: "POD_NAMESPACE", value: "fieldref@metadata.namespace" }
- { name: "MYSQL_GALERA_CLUSTER", value: "galera-ss" }
mappings:
- - { name: "adei_init", mount: "/var/lib/init" }
- { name: "adei_host", path: "galera", mount: "/var/lib/mysql/data" }
diff --git a/setup/projects/adei/vars/volumes.yml b/setup/projects/adei/vars/volumes.yml
index fdceaae..15795b3 100644
--- a/setup/projects/adei/vars/volumes.yml
+++ b/setup/projects/adei/vars/volumes.yml
@@ -4,11 +4,11 @@ gids:
volumes:
adei_host: { volume: "hostraid", path: "/adei", write: true } # mysql
- adei_init: { volume: "openshift", path: "/adei/init"} # mysql
- adei_etc: { volume: "openshift", path: "/adei/etc"} # mysql (maybe)
+ adei_data: { volume: "datastore", path: "/adei", write: true } # temporary home for administrator pods
+ adei_init: { volume: "openshift", path: "/adei/init"} # simple mysql (or obsolete)
adei_src: { volume: "openshift", path: "/adei/src", write: true } # prod & debug (init creates setup links)
adei_cfg: { volume: "openshift", path: "/adei/cfg", write: true } # per-setup configs (ADEI/wiki modifies setup)
- adei_sys: { volume: "openshift", path: "/adei/sys" } # per-setup cron-jon overrides
+ adei_sys: { volume: "openshift", path: "/adei/sys", write: true } # per-setup cron-jon overrides (it seems log intensively complains if we mount the same volume read-only and read-write)
adei_tmp: { volume: "temporary", path: "/adei/tmp", write: true } # per-setup temporary files
adei_log: { volume: "temporary", path: "/adei/log", write: true } # per-replica (should be fine) temporary files
# adei_db: { volume: "databases", path: "/adei", write: true } # mysql
@@ -26,6 +26,8 @@ files:
- { osv: "adei_src", path: "/dbg", state: "directory", group: "adei", mode: "02775" }
- { osv: "adei_log", path: "/", state: "directory", group: "adei", mode: "02775" }
- { osv: "adei_tmp", path: "/", state: "directory", group: "adei", mode: "02775" }
+ - { osv: "adei_data",path: "/", state: "directory", group: "adei", mode: "02775" }
+ - { osv: "adei_data",path: "/home", state: "directory", group: "adei", mode: "02775" }
- { osv: "adei_host",path: "mysql", state: "directory", group: "adei_db", mode: "02775" }
- { osv: "adei_host",path: "galera", state: "directory", group: "adei_db", mode: "02775" }
- { osv: "adei_host",path: "mysql_master", state: "directory", group: "adei_db", mode: "02775" }
--
cgit v1.2.3