K
K
Konstantin Rudenkov2015-10-30 12:15:14
MySQL
Konstantin Rudenkov, 2015-10-30 12:15:14

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

1 answer(s)
S
shagguboy, 2015-10-30
@shagguboy

replication? XtraBacup?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question