Postgres Cluster - How Many Nodes?

From: Lee Nguyen <leemobile(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Cluster - How Many Nodes?
Date: 2013-12-11 14:01:35
Message-ID: CAHghi5Cj_E+AbZMhdTmKEZMEkH6ptP46KtdGgowHGrfojpTdAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to setup a postgres replicated cluster for the first time, and
I'm not sure of the hardware setup we need.

What we would like is to have synchronously replicated postgresql instances
running in one data center which also asynchronously replicates to a remote
data center (in case of a disaster in the main data center).

I'm wondering what is typical for the number of nodes per set of replicated
nodes? If we only go with 2 per each data center, then if one node fails
we are no longer replicating, so it seems like 3 is the minimum.

How about 4 nodes per data center? That way when we want to upgrade, we
can take 2 nodes offline to perform an upgrade, while leaving the other 2
nodes replicating, and then switch them off.

Is 4 overkill? What is the best practice?

Thanks!

Lee Nguyen

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-12-11 14:12:51 Re: Convert table to view 9.1
Previous Message Michael Paquier 2013-12-11 13:57:17 Re: build from source with MSVC