Re: Perl/mySQL question

in reply to Perl/mySQL question

I don't know that Perl is the (best) way to do this, but it can be done in Perl I'm sure... Howevever..
If you are running MySQL 3.23.33 or higher, you may want to look at this site. This is arguably the better way to do database mirroring, and will likely be supported in the larger closed source database implementations. (You'll probably have to re-learn the replication aspect of Oracle/Informix/Sybase/etc.)

-marius

Comment on Re: Perl/mySQL question

Replies are listed 'Best First'.
Re: Re: Perl/mySQL question by $CBAS (Scribe) on Feb 20, 2001 at 02:49 UTC
Aah, that's the type of info I'm looking for, a big thanks to you! CBAS	[reply]
Re: Re: Perl/mySQL question by mp3car-2001 (Scribe) on Feb 21, 2001 at 02:04 UTC
Since the above mentioned link is the way that mysql provides for such a thing, I would recommend setting up one-way replication like this. However, if there is something magical about the database needing to be updated at a set interval, you could always use mysqldump on the secure host, then rebuild the web host from the dump without needing to close either host down.	[reply]

In Section Seekers of Perl Wisdom