Re: PostgreSQL clustering VS MySQL clustering

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Hervé Piedvache <herve@elma.fr>
Cc: pgsql-performance@postgresql.org
Date: 2005-01-20T14:24:05Z
Lists: pgsql-performance
> Is there any solution with PostgreSQL matching these needs ... ?

You want: http://www.slony.info/

> Do we have to backport our development to MySQL for this kind of problem ?
> Is there any other solution than a Cluster for our problem ?

Well, Slony does replication which is basically what you want :)

Only master->slave though, so you will need to have all inserts go via 
the master server, but selects can come off any server.

Chris