15056332824/mysqldump repository overview

wget https://dl.min.io/client/mc/release/linux-amd64/mc

FROM ubuntu
WORKDIR /
RUN apt update && apt install mysql-client -y
ADD ./mc /
RUN /mc config host add s3 http://oss.chengdd.cn:9000 tmV0bG1RauymuH5j sHGvxaxzOrl3hJfhLkoN5AXZsiJlZ6RA --api s3v4
COPY entrypoint.sh /
ENTRYPOINT ["/entrypoint.sh"]

#!/bin/bash
TIME=`date +%Y%m%d%H%M%S`
mysqldump --column-statistics=0 -h ${HOST} -uroot -p${PASSWORD} --databases ${DATABASE} > /tmp/${DATABASE}_${TIME}.sql
/mc cp /tmp/${DATABASE}_${TIME}.sql s3/backups/mysql/${APPLICATION}/${HOST}/

apiVersion: batch/v1beta1
kind: CronJob
metadata:
  name: apolloportal
  namespace: devops
spec:
  jobTemplate:
    spec:
      template:
        spec:
          containers:
            - imagePullPolicy: IfNotPresent
              name: apolloportal
              image: 15056332824/mysqldump:8.0.32
              env:
                - name: HOST
                  value: 127.0.0.1
                - name: PASSWORD
                  value: mysql
                - name: DATABASE
                  value: ApolloPortalDB
                - name: APPLICATION
                  value: apollo
          restartPolicy: Never
  schedule: 00 23 * * *