GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com
MTNCOMP | List | Table

myBlog

myBlog Home

Blog


SQL

Databases and backups - size and recovery

by Mountain Computers Inc., Publication Date: Tuesday, November 24, 2020
View Count: 199, 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.