Hi list,
I'm currently in the middle of planning a server migration and am trying to figure out how I am going to keep the databases in sync. The problem lies in DNS. When I make the DNS change to switch our site from one host to another, it's not automatic. For a period of a few days, customers will be hitting the site on both boxes, depending on if their ISP has updated their DNS as of yet. So my problem is that box 1 will still be taking orders (and inserting them into it's local MySQL database), at the same time box 2 will be taking different orders (and inserting them into box 2's local MySQL db). I've thought about just configuring box 1 to use the db on box 2, but testing has proven this to be a problem (timeouts from time to time). Is there a way I can keep these two db's in sync all the while having them accept data which isn't put into both, while the DNS filters down? TIA.
-- John C. Nichel KegWorks.com 716.856.9675 [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
