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
