Replicate with a cluster name, not a server name
Category
Quick technical tip. You can use a connection document to point at a cluster name. This will allow a server to connect to either server in a cluster for replication or routing. In the destination server name, enter the cluster name.
Quick technical tip. You can use a connection document to point at a cluster name. This will allow a server to connect to either server in a cluster for replication or routing. In the destination server name, enter the cluster name.
Comments
So it's a good idea when naming servers in a cluster to make sure that, if you want replication load to go to a particular server (assuming nornmal availability), that you name that one first in the collating sequence.
Posted by mick moignard At 11:03:21 On 18/12/2008 | - Website - |
Posted by Dennis van Remortel At 11:05:44 On 18/12/2008 | - Website - |
Also, when you set up a server outside the cluster, or a client, to replicate with the cluster by cluster name, you should also schedule replication with one named server from inside the cluster as well on a much less frequent schedule (once a day for example). The cluster cache (which is where the cluster name, members servers and contact info is stored) needs to be refreshed occasionally by conatcting a member server of the cluster, and if you haven't connected to a member server of the cluster in a long enough time, the client/server will not know how to contact the cluster by cluster name. Normal replication with the cluster by name will refresh the cluster cache as well, but adding the extra replication schedule will create a "self healing" solution should long communiation breaks occur, etc and is a matter of good practice.
Posted by Jeremy Hodge At 11:40:34 On 18/12/2008 | - Website - |
Posted by There is an issue with that At 12:35:38 On 18/12/2008 | - Website - |