mysql-operator icon indicating copy to clipboard operation
mysql-operator copied to clipboard

Backups to a local storage

Open linqingping opened this issue 5 years ago • 7 comments

how to use "http" backup? @

linqingping avatar Mar 21 '19 07:03 linqingping

There is not such as an HTTP backup. Backups are made using Percona Xtrabackup and published on remote storage, like Google Storage, AWS S3 or Azure Blob.

To do a backup check out the operator documentation here.

Hope this helps, please let me know if you have more questions, also, we can talk further on slack.

AMecea avatar Mar 21 '19 08:03 AMecea

I want to published on local storage?how to do?

linqingping avatar Mar 21 '19 09:03 linqingping

Oh, ok, You can specify an HTTP remote for rclone, see documentation but it's read-only, you can use it to initialize a cluster, for example. But you can't publish backups over HTTP. Check out rclone documentation and maybe between supported remotes is something that works with your local storage. For example, using rclone with FTP will work but needs additional changes of how the rclone config is done, see this file.

AMecea avatar Mar 21 '19 09:03 AMecea

This is a new feature so that backups can be made on a PVC or on host path volume.

Contributions are welcome!

AMecea avatar Mar 25 '19 12:03 AMecea

I believe much simpler to do backups to local storage via Minio it is only one command to setup it in kubernetes.

    helm install \
        --name minio-service \
        --set accessKey=some-access-key \
        --set secretKey=some-secret-key \
        --set service.type=ClusterIP \
        --set persistence.size=2G

Minio is S3 compatible

delgod avatar Apr 10 '19 10:04 delgod

Delgod, I am interested in backing up to Minio and wondered if could you provide me with a sample yaml file that I could use that would specify Minio as the destination ?

Keithsc avatar Jun 24 '19 14:06 Keithsc

@Keithsc, please follow the documentation - https://www.presslabs.com/code/mysqloperator/backups/#setup-a-backup-on-s3 S3_ENDPOINT should be URL to minio service

delgod avatar Jun 25 '19 10:06 delgod