SOLVED Is there a way to exclude a table from BDR ?

bcmike

Active Member
Jun 7, 2018
281
45
28
50
I've managed to set up a small BDR cluster. My challenge is that machine A is in datacenter A behind a firewall, and machine B is in DC B behind a firewall. Unfortunately the Public NAT IP needs to be set in each one of the SIP profiles and obviously they are unique to each DC.

It would be helpful if I could skip the v_sip_profile_settings table during replication and simply populate it manually. I've tried Google but I've found nothing that addresses this specifically.
 

DigitalDaz

Administrator
Staff member
Sep 29, 2016
2,702
474
83
Obviously, you create the local_vars.xml on each individual server, you can extend that to as many local vars as you wish.
 

bcmike

Active Member
Jun 7, 2018
281
45
28
50
Thank you so much! Exactly what I was looking for, I'll give it a try on my test server ASAP.