From 61395fc0ab992631d967dd6718dfa0db527d422c Mon Sep 17 00:00:00 2001
From: Charles Cabergs <me@cacharle.xyz>
Date: Sun, 18 Oct 2020 15:50:36 +0200
Subject: Please end my suffuring

---
 srcs/m/Dockerfile    | 14 ++++++++++++
 srcs/m/entrypoint.sh | 15 +++++++++++++
 srcs/m/my.cnf        |  5 +++++
 srcs/m/mysql.yaml    | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 4 files changed, 94 insertions(+)
 create mode 100644 srcs/m/Dockerfile
 create mode 100755 srcs/m/entrypoint.sh
 create mode 100644 srcs/m/my.cnf
 create mode 100644 srcs/m/mysql.yaml

(limited to 'srcs/m')

diff --git a/srcs/m/Dockerfile b/srcs/m/Dockerfile
new file mode 100644
index 0000000..e66095e
--- /dev/null
+++ b/srcs/m/Dockerfile
@@ -0,0 +1,14 @@
+FROM alpine
+
+RUN apk update && \
+    apk upgrade && \
+	apk add mysql mysql-client --no-cache
+
+
+COPY entrypoint.sh /entrypoint.sh
+RUN chmod +x /entrypoint.sh
+COPY my.cnf /etc/mysql/my.cnf
+
+EXPOSE 3306
+
+CMD ["/entrypoint.sh"]
diff --git a/srcs/m/entrypoint.sh b/srcs/m/entrypoint.sh
new file mode 100755
index 0000000..ab9a3d9
--- /dev/null
+++ b/srcs/m/entrypoint.sh
@@ -0,0 +1,15 @@
+#!/bin/sh
+
+mkdir -p /run/mysqld
+mkdir -p /var/lib/mysql
+
+mysql_install_db --user=root --datadir=/var/lib/mysql > /dev/null
+
+/usr/bin/mysqld --user=root --datadir=/var/lib/mysql --bootstrap <<EOF
+CREATE DATABASE wordpressdb;
+CREATE USER 'wordpressuser'@'%' IDENTIFIED BY 'wordpresspass';
+GRANT ALL PRIVILEGES ON wordpressdb.* TO 'wordpressuser'@'%' IDENTIFIED BY 'wordpresspass';
+FLUSH PRIVILEGES;
+EOF
+
+exec /usr/bin/mysqld --user=root --datadir=/var/lib/mysql
diff --git a/srcs/m/my.cnf b/srcs/m/my.cnf
new file mode 100644
index 0000000..4f5e2c6
--- /dev/null
+++ b/srcs/m/my.cnf
@@ -0,0 +1,5 @@
+[mysqld]
+user = root
+port = 3306
+datadir = /var/lib/mysql
+log-bin = /var/lib/mysql/mysql-bin
diff --git a/srcs/m/mysql.yaml b/srcs/m/mysql.yaml
new file mode 100644
index 0000000..ead25b4
--- /dev/null
+++ b/srcs/m/mysql.yaml
@@ -0,0 +1,60 @@
+apiVersion: apps/v1
+kind: Deployment
+metadata:
+  name: mysql-deployment
+  labels:
+    app: mysql
+spec:
+  selector:
+    matchLabels:
+      app: mysql
+  replicas: 1
+  strategy:
+    rollingUpdate:
+      maxSurge: 1
+  template:
+    metadata:
+      labels:
+        app: mysql
+    spec:
+      containers:
+        - image: cacharle-mysql
+          imagePullPolicy: Never
+          name: cacharle-mysql-container
+      #     volumeMounts:
+      #       - name: mysql-volume
+      #         mountPath: /var/lib/data
+      # volumes:
+      #   - name: mysql-volume
+      #     persistentVolumeClaim:
+      #       claimName: mysql-volume
+
+---
+
+apiVersion: v1
+kind: Service
+metadata:
+  name: mysql-service
+spec:
+  type: LoadBalancer
+  ports:
+    - name: mysql
+      port: 3306
+      targetPort: 3306
+  selector:
+    app: mysql
+
+# ---
+#
+# apiVersion: v1
+# kind: PersistentVolumeClaim
+# metadata:
+#   name: mysql-volume
+#   labels:
+#     app: mysql
+# spec:
+#   accessModes:
+#     - ReadWriteOnce  # read/write by one pod
+#   resources:
+#     requests:
+#       storage: 1Gi
-- 
cgit