From: | Samba <saasira(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Statistics about Streaming Replication deployments in production |
Date: | 2011-07-28 11:03:26 |
Message-ID: | CAKgWO9Keq64wDQ_2x2_058e_NzDmfoFWjKUJGkkFznq3qn+6ng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
We, at Avaya India, have been using postgres for a few years and are very
happy with the stability and performance of the system. We would want to
utilise the newly released streaming replication feature to build a
master-(multiple)slave based geographically redundant setup . We ship to our
customers a product that stores its transactional data in postgres, and the
size of the data would be accumulating to some where around a couple of
hundred gigabytes over a period of time. it will have heavy read load and
average write load.
One concern that is being coined by the our management team is regarding the
relative stability and 'industrial-strength' of streaming replication.
Considering that this feature is just one year old, doubts are expressed
about
- data integrity -- cancelled long running transactions on Primary must
not be applied on the standby
- reliability -- what if the network link is broken or one of the pair
got crashed when log-segments for a huge committed transaction are being
sent from master top standby?
- guaranteed recovery (on failover) -- at any moment, one should be able
to turn the standby into active and start using it (there should not be a
scenario where master crashed and the slave could not be turned active)
On account of these, we thought it would be reassuring to our management
team if we can cite a few existing production deployments and their success
stories.
I think one year is sufficient time for any product/feature to be thoroughly
tested for all its strengths and weaknesses; so would it be too much to ask
the vast postgres customer base about their experiences with streaming
replication, the good, the bad; and perhaps the best and the ugly too? It
would be great if customers can give their identity (employer info) but not
necessary though.
Thanks and Regards,
Samba
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2011-07-28 11:18:15 | eval function |
Previous Message | Maton, Brett | 2011-07-28 10:13:32 | Fresh Restore - relation contains more than "max_fsm_pages" |