Hello,
While looking for a master/master replication solution i found this
solution https://www.symmetricds.org/ but never tested it, if you do
i'm interested in a feedback.
I ended up using master/slave with automatic failover (with repmgr).
Cordialement,
Nicolas KAROLAK | SysAdmin
6-8, rue André Voguet - 94200 Ivry-sur-Seine
+33 1 77 56 77 96 | www.ubicast.eu | www.ubicast.tv
2018-05-10 15:37 GMT+02:00 JaeWon Lee <thejaewon@gmail.com>:
> Hi ^^
> I want to synchronize two master DB clusters. (Each generates its own DML
> statements)
> I'm using postgresql-10 server.
> I know BDR can synchronize two master DB clusters.
> But current BDR2 cannot synchronize postgresql-10 servers.
> As I know, upcoming BDR3 can synchronize postgresql-10 servers but I cannot
> afford to pay for it. ( $9,000 per server and I'm startup. )
> I'm considering two methods.
>
> (1) Retain postgresql-10 server and find some method to synchronize two
> master DB clusters.
> - I know logical replication cannot deal with my problem. ( it's one
> direction only )
> - Is there other method to use ?
>
> (2) Downgrade my DB server to 9.4 and use BDR1 for synchronizing.
> - As I know, I can use BDR1 for free now.
> - I'm using basic functions of postgresql-10 so I think downgrading itself
> may not cause big problem. But I'm worrying about unknown problem.
> - Are 9.4 and 10 different significantly?
> - Can I upgrade my 9.4 data to 10 later ? This is what I really worry
> about.
>
> Could you give me any idea ?
>
