all groups > sql server clustering > january 2007 >
You're in the

sql server clustering

group:

Mirroring vs Clustering...


Mirroring vs Clustering... Hassan
1/27/2007 9:03:37 PM
sql server clustering:
I am breaking my head trying to figure what should we be using as a standard
for our HA/DR planning.

Can you help me figure out how to make the choice ? Cost is not a factor
here. Is Mirroing a better choice than Clustering ?

Help me make a wise choice for the organization...

RE: Mirroring vs Clustering... Linchi Shea
1/27/2007 9:41:00 PM
[quoted text, click to view]

If cost is not a factor, you may consider both because they protect
different aspects of your database systems (if there is a business
requirement). Clustering is mostly for protecting against system failure
(e.g. motherboard), and mirroring is mainly for storage hardware and certain
database corruption as well as site failure. Though you can use mirroring for
protecting against system failure, clustering gives you faster and safer
recovery with lower overhead. Any time your failover involves data, it's
always risky. Cluster failure doesn't involve data in the database.

We use both, though we use storage-level hardware remote mirroring instead
of database mirroring. However, this doesn't mean that database mirroring is
no good. If you have thousands of databases, you probably don't want to
maintain thousands of database mirroring setups.

Linchi

[quoted text, click to view]
Re: Mirroring vs Clustering... Hassan
1/28/2007 4:06:36 PM
Linchi,

Do you use EMC or HDS for your storage level mirroing ? And do you use
synchronous or asynchronous ? Do you use manaul failover for your remote
storage level mirroing as well ?


[quoted text, click to view]

Re: Mirroring vs Clustering... Linchi Shea
1/28/2007 6:41:00 PM
EMC plus synchronous replication for zero data loss and manual site failover
in most cases.

Linchi

[quoted text, click to view]
Re: Mirroring vs Clustering... Hassan
1/28/2007 9:43:09 PM
Any issues w/ synchronous ? Would love to do so, but we are concerned about
the latency .
I dont know if you saw my other thread on BCVs, but do you have to kinda
quiesce the source at times when the destination may get out of sync,etc ?
What happens when the destination either falls of the n/w or is slow ? Do
you apps timeout ?

[quoted text, click to view]

Re: Mirroring vs Clustering... Linchi Shea
1/29/2007 9:44:00 AM
[quoted text, click to view]

There is a latency, and the latency may be significant depending on how
sentitive your app is. But the latency is manageable in most cases.

[quoted text, click to view]

If there is a problem on the destination that may prevent synchronous
replication, in most cases you should obviously scrifice the replication to
protect the primary. But if you have to do this often, there is a bigger
problem with the capacity or architecture.

Linchi

[quoted text, click to view]
Re: Mirroring vs Clustering... Linchi Shea
1/29/2007 1:55:01 PM
Good point! One of the challenges--not insurmoutable--is that some companies
don't like to span VLAN across data centers.

Linchi

[quoted text, click to view]
Re: Mirroring vs Clustering... John Toner [MVP]
1/29/2007 4:09:39 PM
FYI, if you're using SRDF sync or async replication and MSCS, you might also
consider using SRDF/CE for MSCS to assist with the integration.

Regards,
John


[quoted text, click to view]

Re: Mirroring vs Clustering... Floyd
1/30/2007 7:52:09 AM
Linchi,

How can I reach you to talk about how to manage latency and how to make the
app not so sensitive ? Our apps here are very sensitive and would love to
absorb any suggestions you could provide.

[quoted text, click to view]

RE: Mirroring vs Clustering... Ken
2/3/2007 10:03:00 AM
I can not agree with you.
I think clustering is higher than mirroring.
You can use FC-SAN to achieve the safety of data, and the enterprise-level
FC-SAN provide much more kinds of protect.

FYI,
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx


[quoted text, click to view]
AddThis Social Bookmark Button