Hi, I have had a short time to play around with SymmetricDS and it is pretty easy to setup. There are two ways of doing it, (1) two node setup: master-slave (2) three node setup: centralized master sending and receiving updates to/from two child nodes as the little diagram shows in the "Demo" section of the tutorials. I've had to basically follow the manuals to configure both the setups and is very easy to start cracking with. It is trigger based just like Slony is, however, I could not test SymmetricDS with massive amounts of data as I 've tested Slony. Slony is robust but a little cumbersome to implement but if you know what you doing with Slony and follow the manuals, it really creates wonders. I have seen situations where Slony deamons were killed and restarted and it picked up from where it had left without breaking down completely. Best Regards, Nawaz Ahmed Software Development Engineer Fujitsu Australia Software Technology Pty Ltd 14 Rodborough Road, Frenchs Forest NSW 2086, Australia T +61 2 9452 9027 Nawaz@xxxxxxxxxxxxxxxxxxx fastware.com.au -----Original Message----- From: Nicolas Karolak [mailto:nicolas.karolak@xxxxxxxxxx] Sent: Friday, 11 May 2018 5:04 PM To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: Re: Can I synchronize two master DB clusters except BDR ? 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 ? > Disclaimer The information in this e-mail is confidential and may contain content that is subject to copyright and/or is commercial-in-confidence and is intended only for the use of the above named addressee. If you are not the intended recipient, you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you have received this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by reply e-mail to the sender and delete the document and all copies thereof. Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email communication, it is the receiver’s responsibility to scan all communication and any files attached for computer viruses and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may result directly or indirectly from this communication or any files attached. If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe@xxxxxxxxxxxxxxxxxxx
