From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Michael Paquier *EXTERN*" <michael(dot)paquier(at)gmail(dot)com>, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> |
Cc: | Torsten Förtsch *EXTERN* <torsten(dot)foertsch(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PG replication across DataCenters |
Date: | 2013-11-22 14:46:00 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B17C5EEB7@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
Michael Paquier wrote:
> On Fri, Nov 22, 2013 at 10:03 PM, Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com> wrote:
>> I am not sure i understand the difference between async and sync replication
>> and on what scenarios i should use async or sync replication. Does it mean
>> if it is within same DC then sync replication is the best and if it is
>> across DC replication async is better than sync. Please help me understand.
> In the case of synchronous replication, master node waits for the
> confirmation that a given transaction has committed on slave side
> before committing itself. This wait period can cause some delay, hence
> it is preferable to use sync replication with nodes that far from each
> other.
I am sure that you wanted to say
"with nodes *not* that far from each other".
Basically, you have to choose between these options:
- Slow down processing, but don't lose a transaction on failover
(this would be synchronous, nodes close to each other)
- Replicate over longer distances, but possibly lose some
transactions on failover (that would be asynchronous).
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-11-23 08:09:04 | Re: PG replication across DataCenters |
Previous Message | Michael Paquier | 2013-11-22 13:38:36 | Re: PG replication across DataCenters |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-11-22 14:54:57 | Re: Browsing postgres database using the Eclipse QuantumDB plugin |
Previous Message | Dorian Hoxha | 2013-11-22 14:41:26 | Multiple aggs,sums in 1 query |