Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Perl/mySQL question

by marius (Hermit)
on Feb 20, 2001 at 02:14 UTC ( #59500=note: print w/ replies, xml ) Need Help??


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
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

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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://59500]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (12)
As of 2014-09-17 19:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (96 votes), past polls