Hi. Not only that you also sent it to the wrong person:) It was david that asked the question anyway i cc it to the list and him.
sometime i will experiment with that also but time is to short:) Regards /PM\ Ed Lazor wrote: > > doh... I should go to bed... I just reread what I wrote and it dawned on me > that I didn't really say anything you didn't already know... I do know > that replication is possible and it's built into MySQL... I don't remember > how I did it... but it wasn't that difficult... had to do with establishing > one server as a master and the other two as slaves to the master server and > there was a place where you could specify how often replication > occurs. Between replication, the main server records logs and uses the > logs to track what should be transferred to the clients... so only changed > data gets replicated, which is very cool. > > Hope that helps. > > -Ed > > At 09:53 AM 1/28/2002 +0100, you wrote: > >Hi. > > > >I would do a simple read file,search database,input record script in > >perl > >and transfer the files using scp (ofcourse i asume this is in > >linux/unix) > > > >put it all under cronjob and it should work fine. > > > >On the other hand i am sure others have better ideas:) > > > >/PM\ > > > >David Shields wrote: > > > > > > Hi, I was wondering if any of you clever people out there can help me. I > > > have a client with a problem I'm sure some of you have fixed in the > > past ... > > > > > > Client has 3 geographically separate sites, running same application (mine, > > > of course) and generating data on MySQL database. > > > Periodically (probably nightly), we want to push changes occurring on each > > > database into each of other 2 sites. Data volumes are low-ish (est max 5Meg > > > per database absolute worst case). Line cost is minimal (ADSL), and comms > > > issues I can work out just fine. > > > > > > This strikes me as a version of the multi-mysql-database replication > > > pattern, though sort of slow. Is replication setup acceptable, or are the > > > downtimes where databases are separate an issue, and is this using a > > > sledgehammer to crack a nut? > > > > > > The alternative that occurs to me (though it is a bit if a pain) is to > > > change my code slightly so each DB update query is written to a transaction > > > log at each site, and then manually apply each of these logs to the other 2 > > > databases. I can do this fine, but it seems a bit, well, crude. Plus the > > > overhead of protecting the logs, and of clearing them on successful > > completion. > > > > > > Am I missing something, or is there a better way ? Advice and > > > recommendations solicited and welcomed. > > > > > > David. > > > > > > (By the way, Mysql 3.23.38, app in php 4.0.5) > > > > > > Magic words: sql, database, query, abracadabra, butterscotch, nibble, > > > phong. (some of these are just *nice* words, you know ? ) > > > > > > --------------------------------------------------------------------- > > > 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 > > > >--------------------------------------------------------------------- > >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 --------------------------------------------------------------------- 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
