Currently, I have 2 servers that are replicating specific db’s on a schedule. I want those to servers to be synchronized all the time, so I want to cluster those 2 servers (I’m assuming that is what I have to do). If I create a cluster of those two servers, what do I do with the connection document that specifies the replication schedule? Also, are there any issues with replicating a clustered server with a server that is not in the cluster?
Subject: Normal replication in and with clusters.
Yes, you can certainly cluster your servers for near-realtime replication of (enabled) databases. You will want to keep your existing connection docs (with the existing scheduled replications) as a backup to the cluster replication as there are some rare conditions that can cause cluster replication to be incomplete. You might however, reduce the frequency of the existing scheduled replications.
Other servers can continue to replicate with either or both of the clustered servers. One nice feature of the cluster however is the ability to specify the Cluster name instead of an individual server name in connection docs from other servers so as to provide failover for the scheduled replication.