Answer the question
In order to leave comments, you need to log in
How to organize the recovery of N databases on one mysql server in a reasonable time?
Colleagues, good day to all.
I'm trying to figure out how to solve the problem, but I don't have enough experience with the muscle to filter information from search engines.
Given:
1. Database backup (file), in expanded form, weighing ~ 30Gb.
(Now there are a lot of instances in virtual machines where this backup is restored by simple copying, this scheme has ceased to suit very much) DB.
Actually the question itself: how can this be done in a reasonable time?
If you go the way of SQL footcloths, then either I don’t know something, or the time is not acceptable.
If you go through file recovery (this is a hidden topic for me :), then it’s not clear how to slip it, and how to reduce the number of service restarts (read as: during business hours, since about a third of recovery requests will occur during business hours. ), so how many people will work there.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question