Bug #110829 MySQL Backup with Cronjob doesn`t work
Submitted: 27 Apr 2023 7:20 Modified: 4 May 2023 5:02
Reporter: Christopher Feldhues Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Operator Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[27 Apr 2023 7:20] Christopher Feldhues
Description:
Hey!
I try to produce a backup of my MySQL Cluster with the yaml-File in the Documentation. The problem is that neither a mysqlbackups.mysql.oracle.com nor a cronjob is executed, the cluster does nothing. The PV is created automatically. When I execute the backup manually, everything works (In my estimation).

How to repeat:
apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
  name: mysql-test-db-cluster
  namespace: mysql-test-db
spec:
  secretName: mysql-test-db-secret
  tlsUseSelfSigned: true
  instances: 2
  version: 8.0.32
  router:
    instances: 2
    version: 8.0.32
  datadirVolumeClaimTemplate:
    accessModes: 
      - ReadWriteOnce
    resources:
      requests:
        storage: 10Gi
  backupProfiles:       
  - name: backuprofile  # Embedded backup profile
    dumpInstance:         # MySQL Shell Dump
      storage:
        persistentVolumeClaim:
          claimName: mysql-test-backup-pvc # store to this pre-existing PVC
      backupSchedules:
        - name: mygreatschedule
          schedule: "0,15,30,45 * * * *" # Daily, at midnight
          backupProfileName:  backuprofile # reference the desired backupProfiles's name 
          enabled: true # backup schedules can be temporarily disabled
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mysql-test-backup-pvc
spec:
  storageClassName: default
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 10Gi
[27 Apr 2023 7:24] Christopher Feldhues
Version 8.0.32, sorry!
[27 Apr 2023 7:41] Christopher Feldhues
I found the mistake:

The "backupSchedules" should be under "InnoDBCluster.spec.backupSchedules". The documentation on https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-backups.html is wrong! Please fix it and write a better documentatation, e.g. for SSL and so on.
Thanks!
[4 May 2023 5:02] MySQL Verification Team
Thanks for finding this issue with documentation.