[Bucardo-general] Bucardo with two way replication

[Lucas Possamai]

Hello Mattia,

True... saw your email where you mention that. I'm building a local cluster
to test that solution, so I might ask you questions in the next few days.

Thanks again for replying!

Lucas


On Thu, 27 May 2021 at 20:30, IT Technical Analyst FOD <
fo.ittechnicalanalyst at emergency.it> wrote:

> 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/20210528/479af16e/attachment.htm>