| 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: | |
| Category: | MySQL Operator | Severity: | S3 (Non-critical) |
| Version: | OS: | Any | |
| Assigned to: | CPU Architecture: | Any | |
[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.

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