Re: question on cross-data center replication

Hi Simon -

Thanks for your response, it is very helpful.

Can you help me understand the primary difference between log-based replication and semi-sync replication?

Blake Dournaee

-----Original Message-----
From: Simon Riggs [mailto:simon(at)2ndQuadrant(dot)com]
Sent: Wednesday, October 12, 2011 3:54 PM
To: Dournaee, Blake
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] question on cross-data center replication

On Wed, Oct 12, 2011 at 11:24 PM, Dournaee, Blake
<blake(dot)dournaee(at)intel(dot)com> wrote:

> I had a general newbie type question. I am looking for a database that
> supports replication across datacenters that may be widely distributed.
>
>
>
> I understand that Oracle has replication technology through "streams" and
> "data guard" and would like to understand a little more about the equivalent
> functionality in postgresql.
>
>
>
> Specifically:
>
> 1. Does this database support replication across instances of the database?
>
> 2. How does it work at a high level?
>
> 3. How does it compare to similar functionality in mySQL or Oracle?
>
> 4. How reliable is it?

PG9.1, latest release, supports replication equivalent to data guard
maximum protection mode, as well as other modes.

Multiple standbys are supported.

Replication uses log based replication, much better than MySQL
semi-sync replication.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services