Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

If you can run the servers in parallel, setup the old MySQL as a replication master, the new as a slave. Once the new server is running and sync'ed to the master, switch your DNS.

share|improve this answer
    
They're in different data centers, transferring to a different dedi host - would this still work? do you know of a better guide on this than dev.mysql.com/doc/refman/4.1/en/replication-howto.html ? –  inac Jun 12 '10 at 4:15
    
Yes this would work you will still need down time to make sure that there is no new data on the old server before you bring the new server to live or you could have duplicate content (ie primary keys). I did this and we managed to only have the site down for the prorogation time of dns –  Alistair Prestidge Jun 16 '10 at 16:41
    
dev.mysql.com/doc/refman/5.1/en/replication-howto.html is the latest for version 5.1.x –  Craig Jul 2 '10 at 16:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.