> Good Morning, > > First, apologies for my English. > > We are starting to use Bucardo with the intention of replacing the > replication tool we currently use: BDR 1.0.3, developed by 2ndQuadrant to be > used with PostgreSQL 9.4 (the BDR-patched version of it). > > However, our implementation will be gradual, having to coexist for a while > with both tools (BUCARDO and BDR) until we can work only with BUCARDO. > > Did you have experience using Bucardo on a database with BDR installed on it? > > Any important question that we should take into account or problems that have > been detected? > > Thank you very much!!
Hi Mauricio, From my understanding, BDR utilizes replication slots and logical decoding to handle their replication; this would not prevent the trigger-based handing for Bucardo from working as well. I would expect there could be some oddities if you were targeting the same databases in terms of potential conflicts in replay if the same rows were changed by different replication tools; I can’t speak for the internals of BDR, so not sure how their conflict detection works, but I do know they have some form of that. If you were using completely new targets for the Bucardo cluster, I would expect no issues, but I haven’t tried this explicitly before so there could be some wrinkles that might be discovered. Best, David -- David Christensen End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
