MySQL Forums
Forum List  »  Newbie

Keeping 2 databases in Synch
Posted by: Brendon Gleeson
Date: March 25, 2005 12:33PM

I need to synch my intranet DB with my service providers DB. Thankfully, both are MySQL DB's, however I doubt they offer MySQL's native master/slave synch'ing. I was thinking about just using cron and shell scripts (mysqldump -> ftp to remote -> cron job on remote executes sql script) however this probably would only work for INSERT statements. Is their a way of recording all the queries, or at least all the UPDATE/INSERT/DELETE statements for a specified period? I really don't want the sync'ing to be interactive - It must just happen in the background..

Options: ReplyQuote


Subject
Written By
Posted
Keeping 2 databases in Synch
March 25, 2005 12:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.