[Bucardo-general] Bucardo with two way replication

[IT Technical Analyst FOD]

Hi Lucas,
if you read one of my previous emails I explained how you can do that.

I recall down here part of what I wrote, see specifically point 5b:

[…]

3.       Add your source db to bucardo (bucardo add db A, with tables etc)
bucardo add db db_A dbhost=myhost dbport=5432 dbname=mydbname dbuser=mydbuser dbpass=mydbpassword

4.       Add your target db to bucardo (bucardo add db B, with tables etc)
bucardo add db db_B dbhost=myhost_B dbport=5432 dbname=mydbname dbuser=mydbuser dbpass=mydbpassword

5.       Create a sync that has:

a.       database A as source, database B as target if you want a master to slave replication
bucardo add dbgroup grp_m2s_mydbname db_A:source db_B:target
bucardo add sync sync_mydbname_m2s dbs=grp_m2s_mydbname [‘tables=’]

b.       both databases as source if you want a master to master replication (you should choose a conflit resolution strategy,  I use “bucardo_latest”)
bucardo add dbgroup grp_m2m_mydbname db_A:source db_B:source
bucardo add sync sync_mydbname_m2m dbs=grp_m2m_mydbname conflict_strategy=bucardo_latest [‘tables=’]

More precisely I created a dbgroup with both databases, and then I add that dbgroup to the sync.
The “tables” parameter is optional, to specify a subset of tables to be replicated (comma separated).

6.       Start bucardo
[…]


Hope it can help,
regards.

Mattia

From: Bucardo-general <bucardo-general-bounces at bucardo.org> On Behalf Of Lucas Possamai
Sent: giovedì 27 maggio 2021 01:15
To: bucardo-general at bucardo.org
Subject: [Bucardo-general] Bucardo with two way replication

Hello all,

As you may have seen from my previous emails, I'm working on a migration from EC2 Instance PostgreSQL 9.2 to RDS PostgreSQL 12, and since I cannot have any downtime, I'm using Bucardo for that.

Previously, we were going to set up Bucardo, perform tests and we would move all customers at once to RDS. Now, the business decided that is risky and we wanna migrate a few customers over at a time. However, whatever these customers do in RDS, the data must be replicated back to the master 9.2.

Example:

source db (PG 9.2) --> Bucardo --> target db (PG 12)
target db (PG 12) --> Bucardo --> source db (PG 9.2)

So, it means that I'll need a two way replication set up.

I couldn't find anything online about this process. Does anybody have any suggestions or steps to follow, please?

Regards,
Lucas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20210527/4717f43c/attachment-0001.htm>