[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Backup of databases on OpenShift



Title: Re: Backup of databases on OpenShift
Hi Jens.

on Donnerstag, 08. Juni 2017 at 16:46 was written:


Hi,

We recently set up an OpenShift Enterprise cloud and we're wondering what the best practices are for backing up databases running in an OpenShift cloud. I will focus on PostgreSQL here, but the same goes for MongoDB, MariaDB...

- Should we rely on backups of the persistent volumes (we're using NFS)? This would mean assuming the on-disk state is always recoverable. Which it *should* be, but it does feel like a hack...
- Should we have an admin-level oc script that filters out all running database containers and does some 'oc exec pg_dump ... > backup.sql' magic on them?
- Should we provide some simple templates to our users that contain nothing but a cron script that calls pg_dump?
...

Please share your solutions?

I like this one.

oc rsh <POD> mysqldump/pg_dump/... > backup_file

Some user use Filesytem back, as you have mentioned

I have seen somewhere out a concept with a sidecar container but I can't find it now

What I have seen in the past is not the backup the problem, the restore is the difficult part.
I have once needed to restore a db (postgresql) and it was not that easy and not automatically!



Kind Regards,


Jens


--
Best Regards
Aleksandar Lazic - ME2Digital e. U.
https://me2digital.online/

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]