Friday, February 17, 2012

DB Load Balancing with mirroring ?

Hi guys, can I know whether 2 servers (load balancing) able to set up the mirroring on another server? From what I know, mirroring only can set 1 IP address for principal. I just want to double confirm on it. Thanks for any assistance here.

Best Regards,

Hans

Hi Hans,

Is your question whether you can 2 principal servers sharing the same mirror to host mirror databases.

If yes, then the answer is yes as long as the database names are different. Also, you will need to be aware that when you failover both principals on to one mirror server, the performance will not be the same.

Jag

No comments:

Post a Comment