Let’s be a bit techie today. Here go my findings on clustering failover and mirroring. Enjoy!!
If you have worked with SQL Server before, you should have heard of the terms mentioned in the topic today. Basically, clustering failover and mirroring both serves the purpose of reducing downtime of the SQL Server by automatically failover a database to a backup database. The difference is that clustering failover works at an instance level; while mirroring works at database level. And mirroring is something new in SQL Server 2005.
Clustering could protect you from hardware failures, but mirroring doesn’t only protect you from hardware failures, but also data failures. Besides, mirroring doesn’t require specially certified hardware, reacts much faster than clustering and requires less knowledge to set up.
In short, I think mirroring is a much better choice than failover clustering.
No comments:
Post a Comment