TCP/UDP connections for Shareplex:
1. Why does Shareplex need bi-directional ports?
2. When does Shareplex use UDP ports?
1. Bi-directional Ports:
Connection establishment
For replication data, the target accepts the connection request from the source. For sp_ctrl, the connection is accepted by either side. The target would not attempt to establish a connection unless it is also acting as a source in a bidirectional or multisource configuration.
For Data Equator, the server side (target) accepts the connection.
Dataflow
Replication content flows from the source to the target. A small amount of status/feedback flows from the target to the source.
A small amount of summary data flows between sp_cop processes on each node.
2. TCP and UDP
TCP is used for sp_ctrl connections to a source or target and for the replication data transport (export/import).
UDP is used for all interprocess messaging between sp_cop and the replication processes and for summary exchanges between all sp_cops involved in replication. (rmp module).