On Tue, Oct 11, 2005 at 11:38:22AM -0500, Scott Marlowe wrote:
Don't get me wrong, if replication is one of the things you need, then
consider it, but if you're putting bad data into your database, what
good is replicating it gonna do ya?
But if real, ORAC-style clustering is what you need,
Andrew,
I disagree, I wouldn't want to contend with all the complexities
and kludge of Oracle thank you very much. If there was a way to get
PostgreSQL to do better than the current clustering methods, then why not, it
would be a
big win for us.
PostgreSQL *is* an enterprise
On Thu, Oct 13, 2005 at 10:06:51AM -0600, Aly S.P Dharshi wrote:
Andrew,
I disagree, I wouldn't want to contend with all the complexities
and kludge of Oracle thank you very much. If there was a way to get
PostgreSQL to do better than the current clustering methods, then why not, it
All,Forgive me if this has been answered before, but I've searched the archives and the net extensively and have come up mostly empty so far.I'm working at convincing my firm to implement a postgresql database cluster.
Specifically, we'd like to get a few machines running to be more available and
Hello Travis,
I don't know if there are a Oracle RAC style cluster system for
PGSQL but this software that can do something similar,
http://pgcluster.projects.postgresql.org/feature.html may help.
You can always use Slony for replication services.
Cheers,
Aly.
On
On Mon, 2005-10-10 at 15:16, Travis Brady wrote:
All,
Forgive me if this has been answered before, but I've searched the
archives and the net extensively and have come up mostly empty so far.
I'm working at convincing my firm to implement a postgresql database
cluster.
Specifically,
Don't forget that MySQL replication also has a habit of silently
failing on you and in my experience needs continuous monitoring to
make sure it actually keeps reasonably up to date (e.g. not days of
data behind on the slaves.)
That was a while ago though, maybe they fixed it?
British
Note that pgcluster is statement-based, which has some drawbacks. AFAIK
MySQL's 'clustering' is as well.
Many people use Slony to replicate to many slaves and use pgpool to hit
them. But remember if you do that you need to make sure any statement
that changes data hits your master and not the
