diff options
Diffstat (limited to 'srcs/m')
| -rw-r--r-- | srcs/m/Dockerfile | 14 | ||||
| -rwxr-xr-x | srcs/m/entrypoint.sh | 15 | ||||
| -rw-r--r-- | srcs/m/my.cnf | 5 | ||||
| -rw-r--r-- | srcs/m/mysql.yaml | 60 |
4 files changed, 94 insertions, 0 deletions
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 |
