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: 255
        
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