Обсуждение: Sync replication waits for only 1 slave
Hello
Having a master and 2 slaves in synchronous replication mode in 9.1
The master seems to wait for only one slave to respond before considering the transaction to be complete. I have done the setting for master to wait for all the slaves to finish:
synchronous_standby_names = '*'
I even tried replacing * with both the slave application_names.
Still master just waits for a single slave. Am I doing something incorrect or is it a limitation ?
Thanks.
AJ
On Tue, Jun 7, 2011 at 10:33 PM, A J <s5aly@yahoo.com> wrote: > Having a master and 2 slaves in synchronous replication mode in 9.1 > The master seems to wait for only one slave to respond before considering > the transaction to be complete. I have done the setting for master to wait > for all the slaves to finish: > synchronous_standby_names = '*' > I even tried replacing * with both the slave application_names. > Still master just waits for a single slave. Am I doing something incorrect > or is it a limitation ? No, its a design decision to improve availability and performance. You can list the second standby also, so it can take over in the event of failure. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services