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/