Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Re: Re: Distributed DBM data storage

by lhoward (Vicar)
on Jul 06, 2001 at 16:17 UTC ( #94442=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Distributed DBM data storage
in thread Distributed DBM data storage

I can't speak for Oracle, but MySQL's replication strategy is very robust, but not without limitations.

With MySQL replication one DB serves as the master and others as children. Updates, inserts, and deletes should only be done on the Master (which pushes the changes down to the children), but selects can be done on any of the DBs. This works well because for many tasks because in many instances DB access is much more read-oriented than write-oriented.

You can even do something similar with the DBD::Multiplex. It allows you to have a single database handle (from your program's point of view) that connects to multiple DB's on the back end. It'll use any of the DB's when doing a select, but any updates/inserts/deletes will be performed on all teh DB's.

  • Comment on Re: Re: Re: Distributed DBM data storage

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (5)
As of 2019-08-22 04:31 GMT
Find Nodes?
    Voting Booth?

    No recent polls found