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@xxxxxxxxx>: > 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 ? >
