I am lost using the MySQL Operator and InnoDBCluster CRD to configure a backup for the database. The backup is been loaded into the operator but data is never sent to the s3 bucket (in my case cloudflare R2).
I am confused what the configuration should be. From here there should be a secret
https://dev.mysql.com/doc/relnotes/mysql-operator/en/news-8-0-31-2.0.7.html
Here it referece to a config
https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-properties.html#mysql-operator-spec-innodbclusterspecbackupprofilesindexdumpinstancestorages3
where no example for can be found.
manifest
apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
name: mysql-db
namespace: mysql-operator
spec:
secretName: mysql-db-secrets
tlsUseSelfSigned: true
instances: 2
router:
instances: 1
backupProfiles:
- name: mysql-db-s3-backup-profile
dumpInstance:
dumpOptions:
excludeSchemas: ["information_schema", "mysql", "performance_schema", "sys"]
storage:
s3:
bucketName: mysql-db-backup
config: mysql-db-backup-secrets
prefix: mysql
endpoint: https://REDACTED.eu.r2.cloudflarestorage.com/mysql-db-backup
backupSchedules:
- name: mysql-db-daily-s3-backup
schedule: "5 13 * * *" # Daily at 2 AM
backupProfileName: mysql-db-s3-backup-profile
deleteBackupData: false
enabled: true
secret:
apiVersion: v1
kind: Secret
metadata:
name: mysql-db-backup-secrets
namespace: mysql-operator
type: Opaque
stringData:
awsAccessKeyId: REDACTED
awsSecretAccessKey: REDACTED
Did someone alread managed to connect backup to s3?
Thank you