Re: HDR over secondary network
Posted in 2005
Andreas Legner wrote:
> Hmmm ... if two networks are used, srvB and srvB-sync would resolve to different ip addresses,
> similar would be true for srvA and srvA-sync, wouldn't it?
>
Correct.
The machines are on two networks. as srvA and srvB they have IP
addresses such as X.X.25.X. as srvA-sync and srvB-sync, they have IP
addresses such as X.X.27.X
srvA is always connected to both networks.
the replication over the X.X.27.X network only works if srvB has no
connection to the X.X.25.X network.
In this case, I can set each machine to have an SQL hosts line such as:
srvA onsoctcp srvA-sync istarcarsto identify the other machine, then use
onmode -d primary srvBand
onmode -d secondary srvA
This works fine and replicates over the X.X.27.X network. (using
srvB-sync and srvA-sync does not work).
If srvB has connections to both networks, changing the references to
srvA-sync or srvB-sync in sqlhosts to just plain srvA or srvB allows
connections over the X.X.25.X network, but I cannot find a way to get
the connections over the X.X.27.X network.