Questions about Streams 3 way (2 plus1) replication.
I am trying to set up a specific streams configuration in a lab environment, but I was hoping for some feedback as to if it is possible and any experience anyone can share.
We have working, and are using bi-directional streams between two geographically distant nodes A and B. The two nodes are active-active in theory, but in practice only one is used at a time.
What we want to do is provide one-way replication to a third node C (replicated tables will be read-only on C.)
I have working one-way replication from A to C. Updates made on either A or B make it to C just fine. But…