Databases and backups - size and recovery
by Andy Flagg, Publication Date: Tuesday, November 24, 2020
View Count: 145, Keywords: SQL, Backups, Databases, Recovery, Hashtags: #SQL #Backups #Databases #Recovery
Yesterday I was working on a 102GB SQL database and backup and restore of it was rather... interesting. It took 2 hours to recover the database and restore it to production usage. One does have to hold their breath sometimes and just wait.
What is the fastest solution to database recovery and continuation of business?
Is the size of the database proportional to the time to recovery? yes, and no. why is that? so 1GB database takes 1 minute, 10GB takes 10 minutes, 100GB takes 45 minutes, 1TB takes 2 hours. Why is that? Drives, RAM, caching, indexing, ETL magic? That is the question of the day.
Use different database technologies such that the data is spread across a cluster in JSON format with transaction logs such that accuracy is nearly 100% perfect and always duplicated and verified.
more to come...
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2021 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.