Обсуждение: question on cross-data center replication
Hi –
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?
Thanks,
Blake
On Wed, Oct 12, 2011 at 11:24 PM, Dournaee, Blake <blake.dournaee@intel.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
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@2ndQuadrant.com] Sent: Wednesday, October 12, 2011 3:54 PM To: Dournaee, Blake Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] question on cross-data center replication On Wed, Oct 12, 2011 at 11:24 PM, Dournaee, Blake <blake.dournaee@intel.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