On 04/29/2015 10:53 AM, Alex Gregory wrote:
Hello-
I have been doing lots of reading and I really want to make sure that I get
this HA architecture I am working on correct. I figured the best way would be
to reach out to the community for advice.
I am installing Cisco Jabber and want to use Postgres for the back end. The
Postgres servers will be running on CentOS.
The requirement is to have two servers in HA using a database stored on shared
NetApp Filer storage in California. A third server will be in Ireland for DR
purposes. There only really needs to be one writeable server in California if
it keeps things simple. Automatic conflict resolution should be easier this
way causing lower overhead.
I was thinking that I could use Slony but then I read that it does not like WAN
replication. I have also read about streaming replication native to Postgres
but was not sure how that would work over the WAN. Bucardo seems better for
Data Warehousing or multimaster situations which this is not. That leaves
pgpool ii which seems like it would add an extra layer of complexity.
When it comes down to to there are so many choices I am not sure if I need one
or a combination of two. Any help you could provide could be greatly
appreciated.
This is a can of worms topic but:
You can use streaming replication (or log shipping) asynchronously which
will allow you to use it over WAN just fine.
Other than that, use the Linux HA suite. That is what it is there for.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
