Peng Yu Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Oct 17, 2011; 23:35
Peng Yu
Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Hi,
There are some webpages on synchronizing two mysql server, some of them are old and some of them are for situations that are not exactly same as mine. So I ask how to syncrhonize two mysql servers again and hope to get the best solution to my particular requirement.
Suppose I have two servers (one on mac and one on ubuntu), at any time I only change one server but not both servers. After I have done changes on A, I want to propagate the changes to B. After I have done changes on B, I want to propagate the changes to A.
I think that probably it is OK to synchronize these two servers at the database file level using something like unison. However, this will be slow when the database file gets bigger. But I'm wondering what is the best way to synchronize mysql databases in the scenario that I just mentioned.
-- Regards, Peng
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Oct 18
Johan De Meersman Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Oct 18, 2011; 08:02
Johan De Meersman
Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Oct 18
Andrew Moore Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Oct 18, 2011; 11:47
Andrew Moore
Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!