Keeping 2 databases in Synch
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..
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.