I'm trying to save the time zone offset and was attempting to use the following format: YY:MM:DD HH:ii:SS ZMM:SS, but it's not working, and I can't find a way to do it. I didn't want to create a new column just for this. Is there a way? Am I using the wrong format?
Hi all,
Looking at options for backups of a production MariaDB server currently housing one large-ish database (135GB data dir), and another 6 smaller databases (1-6GB in size).
The time taken to backup the databases isn't a primary concern, although as always the faster the better. Currently the nightly cron task for backups takes around 3 hours, including compression of the files out put my mariadb-dump.
What does concern me is the time to restore should we have a disaster. I'm performing occasional restores to a staging server, and that large DB is taking somewhere in the vicinity of 6+ hours.
One of my criteria would be the ability to restore just a single one of those 7 databases to the production host, which appears to preclude or at least make more complex a few of the options I've been looking at (ie mariadb-backup). I also need the ability to restore a single one of those databases to a separate (staging/forensic) host once a month.
Can I have a few ideas as to the direction you'd recommend I look, here?
Thanks!