Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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


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!


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?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (1)
As of 2023-01-29 05:23 GMT
Find Nodes?
    Voting Booth?

    No recent polls found