Multi-master replication

Started by Dmitry Mordovinover 10 years ago6 messagesgeneral
Jump to latest
#1Dmitry Mordovin
d.mordovin@dwide.com

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or
need install BDR module?).

I wants to play with multi-master, asynchronous replication on two
servers PostgreSQL 9.5 beta 2.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

BR, Dmitry

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Merlin Moncure
mmoncure@gmail.com
In reply to: Dmitry Mordovin (#1)
Re: Multi-master replication

On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need
install BDR module?).

Huh -- that may be so. But if it is, it contradicts the BDR
documentation: http://bdr-project.org/docs/stable/install-requirements.html

Maybe Andres might know the answer?

I wants to play with multi-master, asynchronous replication on two servers
PostgreSQL 9.5 beta 2.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

Have you looked here?
https://wiki.postgresql.org/wiki/BDR_Quick_Start

merlin

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Dmitry Mordovin
d.mordovin@dwide.com
In reply to: Merlin Moncure (#2)
Re: Multi-master replication

Thank you Merlin,

I see this doc too. But I confused, in 9.5 BDR placed to native code and
becomes built in feature.

So, need I install external BDR or try to config built in version ?

Or I didn't understood clearly.

BR, Dmitry

On 12/14/2015 08:38 PM, Merlin Moncure wrote:

On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need
install BDR module?).

Huh -- that may be so. But if it is, it contradicts the BDR
documentation: http://bdr-project.org/docs/stable/install-requirements.html

Maybe Andres might know the answer?

I wants to play with multi-master, asynchronous replication on two servers
PostgreSQL 9.5 beta 2.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

Have you looked here?
https://wiki.postgresql.org/wiki/BDR_Quick_Start

merlin

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Mario Soto Cordones
marioa.soto.cordones@gmail.com
In reply to: Dmitry Mordovin (#3)
Re: Multi-master replication

Hi,

I have understood that at 9.5 BDR is not implemented yet , but you have to download and install it from 2ndQuadrant , ie , a modified version of postgresql

Mario Soto

-----Mensaje original-----
De: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] En nombre de Dmitry Mordovin
Enviado el: lunes, 14 de diciembre de 2015 13:45
Para: Merlin Moncure <mmoncure@gmail.com>; Andres Freund <andres@2ndquadrant.com>
CC: PostgreSQL General <pgsql-general@postgresql.org>
Asunto: Re: [GENERAL] Multi-master replication

Thank you Merlin,

I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature.

So, need I install external BDR or try to config built in version ?

Or I didn't understood clearly.

BR, Dmitry

On 12/14/2015 08:38 PM, Merlin Moncure wrote:

On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin <d.mordovin@dwide.com> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or
need install BDR module?).

Huh -- that may be so. But if it is, it contradicts the BDR
documentation:
http://bdr-project.org/docs/stable/install-requirements.html

Maybe Andres might know the answer?

I wants to play with multi-master, asynchronous replication on two
servers PostgreSQL 9.5 beta 2.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

Have you looked here?
https://wiki.postgresql.org/wiki/BDR_Quick_Start

merlin

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5Simon Riggs
simon@2ndQuadrant.com
In reply to: Dmitry Mordovin (#1)
Re: Multi-master replication

On 14 December 2015 at 15:55, Dmitry Mordovin <d.mordovin@dwide.com> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need
install BDR module?).

PostgreSQL 9.5 does not yet have the full code required for Bi-Directional
replication. How did you hear that? Was that word of mouth, or is that
written down anywhere so we can correct it?

I wants to play with multi-master, asynchronous replication on two servers
PostgreSQL 9.5 beta 2.

BDR does exist as production quality software.
http://bdr-project.org/docs/stable/index.html
BDR 0.93 is compatible with PostgreSQL 9.4.
Binary versions are available.

Later versions of BDR will be compatible with later versions of PostgreSQL,
until the features are fully merged. The full project has taken 4 years so
far and we expect it to take another 2 years at least.

I'll write a blog about this because there is clearly some confusion around
this.

In official docs very small information about how to configure servers.

Could anyone direct me in right way?

If anyone would like to contribute better documentation, they are very
welcome to do so.

--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/&gt;
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

#6Dmitry Mordovin
d.mordovin@dwide.com
In reply to: Simon Riggs (#5)
Re: Multi-master replication

Just word of month,

Thank you Simon for detailed explanation current status of BDR and
PostgreSQL.

BR, Dmitry

Show quoted text

On 12/14/2015 09:31 PM, Simon Riggs wrote:

On 14 December 2015 at 15:55, Dmitry Mordovin <d.mordovin@dwide.com
<mailto:d.mordovin@dwide.com>> wrote:

Hello All!

As I heard, PostgreSQL 9.5 has built in Bi-Direction replication
(or need install BDR module?).

PostgreSQL 9.5 does not yet have the full code required for
Bi-Directional replication. How did you hear that? Was that word of
mouth, or is that written down anywhere so we can correct it?

I wants to play with multi-master, asynchronous replication on two
servers PostgreSQL 9.5 beta 2.

BDR does exist as production quality software.
http://bdr-project.org/docs/stable/index.html
BDR 0.93 is compatible with PostgreSQL 9.4.
Binary versions are available.

Later versions of BDR will be compatible with later versions of
PostgreSQL, until the features are fully merged. The full project has
taken 4 years so far and we expect it to take another 2 years at least.

I'll write a blog about this because there is clearly some confusion
around this.

In official docs very small information about how to configure
servers.

Could anyone direct me in right way?

If anyone would like to contribute better documentation, they are very
welcome to do so.

--
Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/&gt;
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services