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
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 |