Here's the situation. I have two application servers, each running
their own mysql databases. If one goes down, the other takes over for
it. But when it comes back up, whatever user preferences were stored on
the other server during the downtime are lost. I need a way to
syncronize the databases. This needs only be a periodic process, say
once a day or so, running at command line with no environmental
dependencies. It is not the case that one app server is the main and
the other is the backup, they are both main servers, both maintaining
separate lists of info, even though the type of info they store is the
same (ie the load is just balanced between the two).So i need a way
to do a two-way sync, so that if a situation like this arises, the user
prefs are not totally from the server that went down lost. It isn't
especially important to mirror everything on both servers up to the
transaction. A loss of preferences over a day or two isn't that big a
deal. Just something to sync them once a day so the information on both
is relatively current in the context of say weeks rather than days.
Suggestions?
--
A. Dennison
Software Developer - Server Applications Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php