From b6e0c310c410e59ae210108d33fdc66bedb7cbf1 Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@spreadspace.org>
Date: Wed, 29 Apr 2020 15:55:18 +0200
Subject: add k8s-lwl

---
 contrib/k8s-lwl/mysql-statefulset.yml | 71 +++++++++++++++++++++++++++++++++++
 1 file changed, 71 insertions(+)
 create mode 100644 contrib/k8s-lwl/mysql-statefulset.yml

(limited to 'contrib/k8s-lwl/mysql-statefulset.yml')

diff --git a/contrib/k8s-lwl/mysql-statefulset.yml b/contrib/k8s-lwl/mysql-statefulset.yml
new file mode 100644
index 0000000..92d603c
--- /dev/null
+++ b/contrib/k8s-lwl/mysql-statefulset.yml
@@ -0,0 +1,71 @@
+apiVersion: apps/v1
+kind: StatefulSet
+metadata:
+  namespace: lwl
+  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: lw-master
+      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 -sf /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:s2streamstats
+        imagePullPolicy: IfNotPresent
+        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
-- 
cgit v1.2.3