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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
