Quote:
Originally Posted by XXP
It might be possible to mitigate the difference issue by pulling the copy at the beginning of low-peak and then running the index on a separate, dedicated and MySQL optimized machine. (The regular back-ups are probably run at the off-peak times already.)
|
It is the fact that we have several dedicated MySQL servers powering the sites and that changes need to be replicated across all of them before the servers can be brought back online. It has been tested and our developers know the techniques.
If it were as trivial as people seem to think it is, we would have made the change already.