Best way to migrate servers without losing any data and with no downtime(?)

Posted by ina on Stack Overflow See other posts from Stack Overflow or by ina
Published on 2010-06-07T10:53:57Z Indexed on 2010/06/07 11:02 UTC
Read the original article Hit count: 193

Filed under:
|
|
|
|

This is a methodology question from a freelancer, with a corollary on MySQL.. Is there a way to migrate from an old dedicated server to a new one without losing any data in-between - and with no downtime? In the past, I've had to lose MySQL data between the time when the new server goes up (i.e., all files transferred, system up and ready), and when I take the old server down (data still transferred to old until new one takes over). There is also a short period where both are down for DNS, etc., to refresh.

Is there a way for MySQL/root to easily transfer all data that was updated/inserted between a certain time frame?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about server