On Tue, Feb 14, 2012 at 8:09 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
On Tuesday, February 14, 2012 4:21:22 am Venkat Balaji wrote:It would seem you are really after streaming replication(which is asynchronous)
> Hello,
>
> Disaster Recovery testing for Synchronous replication setup -
>
> When the standby site is down, transactions at the production site started
> hanging (this is after the successful setup of synchronous replication).
>
> We changed synchronous_commit to 'local' to over-come this situation.
>
> - No transactions are hanging at the production site even when the standby
> is down
> - Standby is automatically getting synced when it is back up again.
>
> Can someone let us know if there are any "-ve" effects of putting
> synchronous_commit='local' ??
>
> I am assuming that this as good as putting "synchronous_commit=on" on an
> stand-alone system.
more than synchronous replication. I have not used synchronous replication
enough to be sure, but I think by setting synchronous_commit='local' you are
basically turning the system into a straight streaming(asynchronous) system
anyway.
Yeah. Its a kind of asynchronous. All i wanted is as follows -
1
--
>
> We need to get this setup live on production shortly.
>
> Thanks
> VB
Adrian Klaver
adrian.klaver@xxxxxxxxx
