Posted by: Colin Smith
Cluster, MS SQL, MSSQL Administration, Replication
I have a customer who would like to have a couple things. They would like to have, above all, HA. Secondly they would like to be able to configure the application to write to one database and read from another. They want to do this to boost performance as they feel that IO may be an issue. I suggested to them that we do and Active – Active Cluster and in one instance we will have the full writeable database, and in the other instance we will have a copy of the database that is maintained by using transactional replication. This should give them exactly what they are looking for. I am excited that the customer also likes this solution and would like to get going on it ASAP. We do have some things to consider here before we can start. One big thing is that they do not really want any downtime, SHOCKER, while setting this up but the live database is currently sitting on one of the servers that will need to be a part of the cluster. I am hoping that we can move the database temporarily, do all the re-architecturing that is needed and then move the database back to the cluster. Once I get that done then I will be able to set up the replication.
I will post more about this project and how I get it done as I actually get to do it.