Local volumes and StatefulSet to provision Master/Slave MySQL and Galera cluster

1 files changed, 0 insertions, 66 deletions

diff --git a/setup/projects/adei/vars/galera.yml b/setup/projects/adei/vars/galera.yml
deleted file mode 100644
index ea64daa..0000000
--- a/setup/projects/adei/vars/galera.yml
+++ /dev/null
@@ -1,66 +0,0 @@
-galera_app:
-  name: galera
-  provision: true
-  instantiate: false
-  pods:
-    galera:
-      kind: StatefulSet
-      service: { ports: [ 3306 ] }
-      sched: { replicas: 3, strategy: "Recreate", restrict: { fat_storage: "1" } }
-      update: { strategy: RollingUpdate, min_ready: 30 }
-      affinity: 
-        nodeAffinity:
-          requiredDuringSchedulingIgnoredDuringExecution: 
-            nodeSelectorTerms:
-            - matchExpressions:
-              - { key: "hostid", operator: "In", values: [ "1", "2", "3" ] }
-      groups: [ "adei_db" ]
-      images:
-        - image: "chsa/mysql-galera:5.7"
-          command: [ "run-mysqld-galera" ]
-          ports: [ 3306, 4444, 4567, 4568 ]
-          env:
-            - { name: "MYSQL_ROOT_PASSWORD", value: "secret@adei/adei-password" } 
-            - { name: "MYSQL_USER", value: "adei" }
-            - { name: "MYSQL_USER_PRIV_SUPER", value: "1" }
-            - { name: "MYSQL_PASSWORD", value: "secret@adei/adei-password" } 
-            - { name: "MYSQL_DATABASE", value: "adei" }
-            - { name: "MYSQL_EXTRADB", value: "adei_%" }
-            - { name: "MYSQL_GALERA_USER", value: "xtrabackup_sst" }
-            - { name: "MYSQL_GALERA_PASSWORD", value: "secret@adei/service-password" }
-          mappings: 
-            - { name: "adei_init", mount: "/var/lib/init" }
-            - { name: "adei_host", path: "galera", mount: "/var/lib/mysql/data" }
-          resources: {  request: { cpu: 2000m, mem: 4Gi }, limit: { cpu: 6000m, mem: 32Gi } }
-#          probes:
-#            - { type: "liveness", port: 3306 }
-#            - { type: "readiness", command: [ /bin/sh, -i, -c, MYSQL_PWD="$MYSQL_PASSWORD" mysql -h 127.0.0.1 -u $MYSQL_USER -D $MYSQL_DATABASE, -e 'SELECT 1' ], delay: "15", timeout: "5" }
-
-
-    grecovery:
-      sched: { replicas: 0, strategy: "Recreate", restrict: { fat_storage: "1" } }
-      affinity: 
-        nodeAffinity:
-          requiredDuringSchedulingIgnoredDuringExecution: 
-            nodeSelectorTerms:
-            - matchExpressions:
-              - { key: "hostid", operator: "In", values: [ "1", "2", "3" ] }
-      groups: [ "adei_db" ]
-      images:
-        - image: "chsa/mysql-galera:5.7"
-          command: [ "run-mysqld-manager" ]
-          ports: [ 3306, 4444, 4567, 4568 ]
-          env:
-            - { name: "MYSQL_ROOT_PASSWORD", value: "secret@adei/adei-password" } 
-            - { name: "MYSQL_USER", value: "adei" }
-            - { name: "MYSQL_USER_PRIV_SUPER", value: "1" }
-            - { name: "MYSQL_PASSWORD", value: "secret@adei/adei-password" } 
-            - { name: "MYSQL_DATABASE", value: "adei" }
-            - { name: "MYSQL_EXTRADB", value: "adei_%" }
-            - { name: "MYSQL_GALERA_USER", value: "xtrabackup_sst" }
-            - { name: "MYSQL_GALERA_PASSWORD", value: "secret@adei/service-password" }
-            - { 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" }