SQL 2012 Peer to Peer Database Replication
Posted on 2014-08-26
I am helping a customer setup his SQL 2012 server with Peer to Peer replication and just for my own sake I was wondering how a website would connect to it. I know that nearly all websites that are configured thru .Net or something similar can connect to a SQL database using one of two ways... if the SQL database is local they can use Localhost in the name of the server field or they can use an IP address or computer name, but if a database is replicating via Peer to Peer how would the connection be made? Just something for my own peace of mind so that if they do ask me this, I can say how its supposed to work. They are already connecting to a database that is Mirrored to another location but the SQL database is on the same server as the website, so if the SQL database is down, so is the website and its an easy matter to use DNS Failover to reroute customers till the primary site is back online. This setup is different though in that the SQL database is on a different server than the website so if the SQL server goes down, the website might not go down and so now the website has to go to get its information from another SQL server.
Am I making much sense? Thanks for any help in this matter!!