RE: Database Replication Over the internet
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]
Re: Database Replication Over the internet
On Thu, Jul 03, 2003 at 09:19:07AM -0700, Priya Manivannan wrote: > Can MySQL database be replicated over the internet ? > > If so, Please give me a pointer on that Yes. Type "replication" into the search box in the on-line manual. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 30 days, processed 941,376,405 queries (358/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]