If your internet connections aren't very fast and stable, or perhaps dialup or similar you can do a poor-mans replication. I do this and after lots of starts and stops on my scripts that get the data to the slave server it's finally working very good. When you turn on bin-log in my.cnf it just starts keeping a log of all inserts, deletes and updates so the slave can connect to it and recreate all those statements in sequence and therefore keep a perfectly replicated copy of the database. I just have the master produce the binary log and use "mysqlbinlog" after a "mysqladmin flush-logs" to extract the ascii contents (all the inserts, deletes and updates) from the log and ship them off to another server and just pipe them through the standard mysql client. It's a bit tricky but very possible. I use uucp over a TCP (internet) connection to move the files. Old school but very tried true and tested...
If you have good solid and fast internet connections for both you shouldn't have a problem doing regular replication though. Good luck! -----Original Message----- From: Priya Manivannan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 12:19 PM To: [EMAIL PROTECTED] Subject: Database Replication Over the internet Can MySQL database be replicated over the internet ? If so, Please give me a pointer on that Thanks and regards Manivannan __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
