From 58b59779441ff87b7f1b1dec10d281ff95fd5b22 Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@spreadspace.org>
Date: Fri, 23 Feb 2018 02:24:33 +0100
Subject: added mysql pod

---
 contrib/k8s-emc/mysql-secret.yml      | 11 ++++++
 contrib/k8s-emc/mysql-statefulset.yml | 71 +++++++++++++++++++++++++++++++++++
 contrib/k8s-emc/mysql-svc.yml         | 16 ++++++++
 3 files changed, 98 insertions(+)
 create mode 100644 contrib/k8s-emc/mysql-secret.yml
 create mode 100644 contrib/k8s-emc/mysql-statefulset.yml
 create mode 100644 contrib/k8s-emc/mysql-svc.yml

(limited to 'contrib')

diff --git a/contrib/k8s-emc/mysql-secret.yml b/contrib/k8s-emc/mysql-secret.yml
new file mode 100644
index 0000000..91f73be
--- /dev/null
+++ b/contrib/k8s-emc/mysql-secret.yml
@@ -0,0 +1,11 @@
+apiVersion: v1
+kind: Secret
+metadata:
+  namespace: emc
+  name: stats-mysql-root
+  labels:
+    app: mysql
+    tier: stats
+type: Opaque
+data:
+  password: Y2hhbmdlLW1lCg==  # change-me
diff --git a/contrib/k8s-emc/mysql-statefulset.yml b/contrib/k8s-emc/mysql-statefulset.yml
new file mode 100644
index 0000000..1698f0f
--- /dev/null
+++ b/contrib/k8s-emc/mysql-statefulset.yml
@@ -0,0 +1,71 @@
+apiVersion: apps/v1
+kind: StatefulSet
+metadata:
+  namespace: emc
+  name: stats-mysql
+  labels:
+    app: mysql
+    tier: stats
+spec:
+  serviceName: stats-mysql
+  replicas: 1
+  selector:
+    matchLabels:
+      app: mysql
+      tier: stats
+  updateStrategy:
+    type: RollingUpdate
+  template:
+    metadata:
+      labels:
+        app: mysql
+        tier: stats
+    spec:
+      nodeName: emc-stats
+      securityContext:
+        runAsUser: 27
+        fsGroup: 27
+      initContainers:
+      - name: prepare-mysql-volumes
+        image: busybox
+        command: ['sh', '-c', 'chown 27:27 /srv/lib && chmod 700 /srv/lib && mkdir -p /srv/tmp/log /srv/tmp/run /srv/tmp/files && ln -s /dev/stderr /srv/tmp/log/mysqld.log && chown 27:27 /srv/tmp/log/mysqld.log /srv/tmp/run /srv/tmp/files']
+        securityContext:
+          runAsUser: 0
+        volumeMounts:
+        - name: mysql-lib
+          mountPath: /srv/lib
+        - name: mysql-tmp
+          mountPath: /srv/tmp
+      containers:
+      - name: mysql
+        image: quay.io/neith00/mysql-docker@sha256:4cbb499347edd4265bf53ceda6a3bbda28bc84391d7ab768f52bc44d5c8c25f9
+        imagePullPolicy: Always
+        env:
+        - name: MYSQL_ROOT_PASSWORD
+          value: /var/run/mysql-secret/password
+        volumeMounts:
+        - name: mysql-lib
+          mountPath: /var/lib/mysql
+        - name: mysql-tmp
+          subPath: log
+          mountPath: /var/log
+        - name: mysql-tmp
+          subPath: run
+          mountPath: /var/run/mysqld
+        - name: mysql-tmp
+          subPath: files
+          mountPath: /var/lib/mysql-files/
+        - name: mysql-secret
+          mountPath: /var/run/mysql-secret/
+      volumes:
+      - name: mysql-lib
+        hostPath:
+          type: DirectoryOrCreate
+          path: /srv/stats/mysql
+      - name: mysql-tmp
+        emptyDir:
+          medium: Memory
+      - name: mysql-secret
+        secret:
+          secretName: stats-mysql-root
+          defaultMode: 0400
diff --git a/contrib/k8s-emc/mysql-svc.yml b/contrib/k8s-emc/mysql-svc.yml
new file mode 100644
index 0000000..70bcd4a
--- /dev/null
+++ b/contrib/k8s-emc/mysql-svc.yml
@@ -0,0 +1,16 @@
+apiVersion: v1
+kind: Service
+metadata:
+  namespace: emc
+  name: stats-mysql
+  labels:
+    app: mysql
+    tier: stats
+spec:
+  selector:
+    app: mysql
+    tier: stats
+  clusterIP: 172.18.242.23
+  ports:
+  - name: mysql
+    port: 3306
-- 
cgit v1.2.3