I have a question, I have two physical servers, in the first one I'll install two virtual machines in order to have two DB Servers and the other I'll use as DB Server support. The idea is to have three servers, this is the role for each one
VM1.- it will be used for sandbox, development and testing enevironments
VM2.- it will be used for staging and production environment
DBServerSupport it will be used when any of servers mentioned before breakdowns.
I want to implement the mirroring in High Availability mode in VMs, It means that VM1 will be the principal and DBServerSupport will be Mirror, the same situation for VM2 (I'll use other server as witness in both situations).
It is possible to have that environment?
Hi Uri Dimant
The idea is that both VM1 and VM1 play the principal role, and DBServerSupport plays the Mirror role, my doubt is if it is possible?, I mean to establish high availability in two different environments where the mirror is the same server for both
I believe you could configure it that way, but one really has to ask why you would? Meaning, hardware is cheap when compared to the human capital, VMs are SLOW and you retain a single point of failure (the VM host).
Consider this, your Support server would be alone if the VM host took a hit HENCE, in a high availability mode, your database(s) would be off line as the witness and mirror are no longer present (quorum; you always need two instances to see each other and you will not have that with a vm as principal (or mirror), the other vm as witness when the VM host goes off line).
I agree with you about the point of failure, but by the time, I would like to implement this environment because of current resources, and it will allow me to request for more resources in near future, it based on a document where it would includes all details that affect to High Availability environment such as the point of failure and the hardware features.