Add MySQL service (for Michele and other low-volume users)

1 files changed, 21 insertions, 0 deletions

diff --git a/setup/projects/services/vars/mysql.yml b/setup/projects/services/vars/mysql.yml
new file mode 100644
index 0000000..c174b61
--- /dev/null
+++ b/setup/projects/services/vars/mysql.yml
@@ -0,0 +1,21 @@
+mysql:
+  pods:
+    mysql:
+      service: { ports: [ 3306 ] }
+      groups: [ "services_mysql" ]
+      images:
+        - stream: "openshift/mysql:5.7"
+          env:
+            - { name: "MYSQL_USER", value: "ipe" }
+            - { name: "MYSQL_PASSWORD", value: "secret@mysql/ipe-password" } 
+            - { name: "MYSQL_ROOT_PASSWORD", value: "secret@mysql/root-password" } 
+            - { name: "MYSQL_DATABASE", value: "test" }
+            - { name: "MYSQL_PMA_PASSWORD", value: "secret@mysql/pma-password" } 
+            - { name: "MYSQL_MAX_CONNECTIONS", value: "500" }
+          mappings: 
+            - { name: "db", path: "mysql", mount: "/var/lib/mysql/data" }
+          resources: {  request: { cpu: 500m, mem: 1Gi }, limit: { cpu: 2000m, mem: 4Gi } }
+          probes:
+            - { port: 3306 }
+#            - { 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'] }