pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: cho <tobutaz@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Cluster/Replication
Date: Mon, 22 Oct 2007 08:34:24 +0000 (UTC)
Message-ID: <pan.2007.10.22.08.34.20@gmail.com> (raw)
References: <D7B69B79-A6B1-443B-AAB7-C53CA60BD874@eaglepress.com>

Le Fri, 19 Oct 2007 12:43:40 -0400, Sean Brown a écrit :

> We are setting up a new database system that is going to act as our
> central database. We are planning to have a Master/Slave setup,
> originally with one slave but there is a strong possibility of adding a
> second slave at our second site. We could run Mulit-Master, it just
> wasn't the original plan. (The original plan was MySQL log shipping). We
> do not want the possibility of loosing data in the event of loosing the
> master node so synchronous replication is preferable. We are using
> BLOBS, so the replication has to be able to handle that. The slave we
> want to have useable but it would be used for reporting only under
> normal usage.

Have a look at pgpool-I or pgpool-II in replication mode.
Pgpool proxies SQL requests, so that requests on one server are replayed 
on the other. pgpool-I is limited to two nodes, whereas pgpool-II is not. 
Latency is important for write performance. You can do failover, you just 
need to detect by yourself when one node is dead.

There is also PITR recovery, but as it batches the transaction logs you 
may lose a bit of data (up to a configured data size / duration).





view thread (7+ messages)  latest in thread

Message-ID: <pan.2007.10.22.08.34.20@gmail.com>
Permalink:  ../pan.2007.10.22.08.34.20@gmail.com/
Also on:    postgresql.org/message-id/pan.2007.10.22.08.34.20@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tobutaz@gmail.com
  Subject: Re: Cluster/Replication
  In-Reply-To: <pan.2007.10.22.08.34.20@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox