-
Creating backup solution for database. Advice please.
How to create a backup system for my database? It has billions of records and consists of Tera bytes of data. I am looking for a solution that can setup along with the server. I also heard about https://www.storagepipe.com which offer online data backup and recovery services. But I think such services will cost thousands of dollars per month. Do anyone here have any experience on this. Please share your advice.
-
5 Replies
-
The most secure and the lowest cost is LTO tape backup/archive. LTO 6, the latest version, holds 2.5Tb per tape.
David Roth Weiss
Director/Editor/Colorist
David Weiss ProductionsDavid is a Creative COW contributing editor and a forum host of the Apple Final Cut Pro forum.
-
When you say database, do you mean an actual database like Filemaker, MySQL, or Oracle, or do you mean a collection of files that you manage? There are different approaches depending on what you’re actually working with.
Tim
—
Tim Jones
CTO – TOLIS Group, Inc.
https://www.tolisgroup.com
BRU … because it’s the RESTORE that matters! -
Tim,
One of the coolest things I ever learned about LTO, which I’m sure you know and appreciate, is that they are perfect for storing databases such as those generated by a DAM or MAM. So, not only do you archive the media to LTO, but the underlying metadata and the database in which in which it’s stored, all of which is good to go for 20 to 30 years (hopefully).
David Roth Weiss
Director/Editor/Colorist
David Weiss ProductionsDavid is a Creative COW contributing editor and a forum host of the Apple Final Cut Pro forum.
-
Very true, but sometimes there are Database “things” that need to be done to make sure that the data tables are handled properly – table transaction locking, user locking, journal log generation, etc.. This is especially true for multiuser databases where the table could be open and modified while being backed up. Most databases have SQL commands to enable backups, that’s why I asked for clarification.
The issue is that without taking care of these things before you backup the database, you could end up with an unstable environment on restore.
Tim
—
Tim Jones
CTO – TOLIS Group, Inc.
https://www.tolisgroup.com
BRU … because it’s the RESTORE that matters! -
Gotcha Tim! Frankly, though I’ve sold these solutions a zillion times, I was not implementing them myself.
David Roth Weiss
Director/Editor/Colorist
David Weiss ProductionsDavid is a Creative COW contributing editor and a forum host of the Apple Final Cut Pro forum.
Reply to this Discussion! Login or Sign Up