percona.yaml

kind: ConfigMap
apiVersion: v1
metadata:
  name: percona-config
data:
  mysql-root-password: "JdUDnZyTsL"
  discovery-service: "etcd-client:2379"
  cluster-name: "k8scluster"
  xtrabackup-password: "p9jwtcv3WX"
  mysql-proxy-user: "proxyuser"
  mysql-proxy-password: "XTg1o9g8aP"

---
apiVersion: v1
kind: ReplicationController
metadata:
 name: pxc-rc
spec:
 replicas: 3 # tells deployment to run N pods matching the template
 selector:
   app: pxc-app
 template: # create pods using pod definition in this template
   metadata:
     name: pxc
     labels:
       app: pxc-app
   spec:
     containers:
     - name: percona-xtradb-cluster
       image: perconalab/percona-xtradb-cluster:5.7
       imagePullPolicy: Always
       ports:
         - containerPort: 3306
         - containerPort: 4567
         - containerPort: 4568
       env:
         - name: MYSQL_ROOT_PASSWORD
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: mysql-root-password
         - name: DISCOVERY_SERVICE
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: discovery-service
         - name: CLUSTER_NAME
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: cluster-name
         - name: XTRABACKUP_PASSWORD
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: xtrabackup-password
       volumeMounts:
         - name: mysql-persistent-storage
           mountPath: /var/lib/mysql
     volumes:
       - name: mysql-persistent-storage
         emptyDir: {}
---
apiVersion: v1
kind: ReplicationController
metadata:
 name: proxysql-rc
spec:
 replicas: 1 # tells deployment to run N pods matching the template
 selector:
   front: proxysql
 template: # create pods using pod definition in this template
   metadata:
     name: proxysql
     labels:
       front: proxysql
   spec:
     containers:
     - name: proxysql
       image: amnk/proxysql:1.2.2
       imagePullPolicy: Always
       ports:
         - containerPort: 3306
         - containerPort: 6032
       env:
         - name: MYSQL_ROOT_PASSWORD
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: mysql-root-password
         - name: DISCOVERY_SERVICE
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: discovery-service
         - name: CLUSTER_NAME
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: cluster-name
         - name: MYSQL_PROXY_USER
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: mysql-proxy-user
         - name: MYSQL_PROXY_PASSWORD
           valueFrom:
             configMapKeyRef:
               name: percona-config
               key: mysql-proxy-password
---
apiVersion: v1
kind: Service
metadata:
 name: pxc-service
 labels:
   app: pxc-app
spec:
 ports:
 # the port that this service should serve on
 - port: 3306
   targetPort: 3306
   name: "mysql"
 - port: 6032
   targetPort: 6032
   name: "proxyadm"
 # label keys and values that must match in order to receive traffic for this service
 selector:
   front: proxysql