| Lists: | pgsql-general |
|---|
| From: | Vlad Mihalcea <mihalcea(dot)vlad(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PosgtresSQL master-slave synchronous replication to multiple slaves |
| Date: | 2014-05-31 08:30:08 |
| Message-ID: | CA+gWKMBBB3eyCxLHT_0OPawVh4VseeJDTZFeepALDjpOPQ9cPw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
PostgresSQL has support for master-slave replication, but the synchronous
streaming replication
<http://www.postgresql.org/docs/current/static/warm-standby.html#SYNCHRONOUS-REPLICATION>
only supports a single synchronous slaves. You can have multiple slaves,
but only one will be synchronously updated the others being eventually
consistent.
Synchronous replication offers the ability to confirm that all changes made
by a transaction have been transferred to one synchronous standby server.
This extends the standard level of durability offered by a transaction
commit. This level of protection is referred to as 2-safe replication in
computer science theory.
If you run a large enterprise system in a master-slave replication scheme
on top of PostgreSQL, what options do I have for enabling multiple
synchronous slaves? Has anyone been able to set-up such replication
configuration?
Original SQL question:
| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Vlad Mihalcea <mihalcea(dot)vlad(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PosgtresSQL master-slave synchronous replication to multiple slaves |
| Date: | 2014-05-31 15:58:42 |
| Message-ID: | CAB7nPqQeHMEuTpOP73bHmPKvXab8sY3=iR5+xr=foA5TDms9HQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Sat, May 31, 2014 at 5:30 PM, Vlad Mihalcea <mihalcea(dot)vlad(at)gmail(dot)com> wrote:
> If you run a large enterprise system in a master-slave replication scheme on
> top of PostgreSQL, what options do I have for enabling multiple synchronous
> slaves?
As of now, none. Only a single synchronous slave is possible. There
have been discussions about implementing N-synchronous slaves though.
--
Michael