[development] Re: enterprise needs

[Darrel O'Pry]

On Mon, 2006-02-27 at 17:46 +0100, Dries Buytaert wrote:
> >> 6. Do MySQL replication
> >
> > At present you can only use mysql replication as a hot standby, drupal
> > does not support mysql replication at present because it does not
> > differentiate between read and write queries.
> 
> Can't you use master-master configurations?  Not sure if that will  
> work properly (never played with it); I guess masters can be out of  
> sync at times.

Master-Master replication in mysql is asking for trouble. You can try
it, but it won't be pretty.

Mysql 5's nbd clustering is promising, but is for in memory only
databases... Hopefully that technology will be built on. 

Maybe one of the postgre folks can chime in on postgresql's clustering
and replication technologies.

> 
> I understood what you wrote in your previous e-mail now; we should  
> separate read from write queries so we can support master-slave  
> configurations (and get most out of database replication).
> 
> --
> Dries Buytaert  ::  http://www.buytaert.net/
> 
>