Re: On "multi-master"

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: ajs(at)crankycanuck(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: On "multi-master"
Date: 2005-10-14 14:54:19
Message-ID: 20051014.235419.07645701.ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> But because there's no enforcement of "every transaction should go
> through pgpool", it's not enough for the managers who are ultimately
> responsible for deciding on system design. In the hypothetical case,
> we're aiming at multimaster systems that are there for reliability,
> not performance. Decreasing the reliance on fault-tolerant hardware
> by increasing the potential for human error does not solve that
> problem.

Enforcement? There would be plenty of ways to achieve that. For
example, you could set pg_hba.conf so that on ly the host where pgpool
is running on could connect to the host where postmaster is running
on.

> We have been (my colleague Brad is the one who's been working on
> this). But for something to qualify for real production-grade use,
> it needs to be rock solid stable in heavy use for a considerable
> period of time. We're not there yet, is all I'm suggesting. (This
> principle is why it's also a good thing that Red Hat Enterprise isn't
> always completely up to date with the community sources.)

Right. It's your freedom that you do not use pgpool until you think
it's solid enough.
--
SRA OSS, Inc. Japan
Tatsuo Ishii

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-14 15:06:11 Re: Postgres logs to syslog LOCAL0
Previous Message Tom Lane 2005-10-14 14:39:54 Re: PostgreSQL Gotchas