Good book for active-active clustering

Question

Good book for active-active clustering

Jon.Morisi

SSChampion

Points: 12846
More actions
February 1, 2010 at 4:25 pm

#220155

Anyone know a good book for HA specifically active-active clustering?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

David Baffaleuf SSCrazy Points: 2159 More actions · Answer 1

Ooops

Looks like the term 'active-active' has been banished from MS vocabulary. The preferred terms are now single instance clusters and multi-instances clusters. This is because a clustered SQL Server Cluster is not really an active-active cluster, as one database file cannot be accessed in read/write by more than one instance at a time. You cannot load balance the users among many clustered SQL Server instances.

I assume you refer to multi-instance clustering, maybe the most exhaustive documentation is the white paper by MS, you can find it here:

http://www.google.fr/url?sa=t&source=web&ct=res&cd=1&ved=0CA4QFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F6%2F9%2FD%2F69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6%2FSQLServer2008FailoverCluster.docx&rct=j&q=SQL+Server+2008+cluster+white+paper&ei=IftnS5LAGYWq4Qbkq-nUCA&usg=AFQjCNGI1hQIgs4JkiNAfD6zVvVl1-8UuA&sig2=Hmi3YH5L2KuD0fM_wJjtZQ

HTH

David BAFFALEUF

David B.

Jon.Morisi SSChampion Points: 12846 More actions · Answer 2

Thanks David,

The mulit-instance / single-instance terminology does make more sense.

I'm considering these two books

Microsoft SQL Server High Availability (Paperback)

http://www.amazon.com/Microsoft-SQL-Server-High-Availability/dp/0672326256/ref=sr_1_11?ie=UTF8&s=books&qid=1265066982&sr=8-11

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring (Paperback)

http://www.amazon.com/Microsoft-Availability-Clustering-Database-Mirroring/dp/0071498133/ref=sr_1_4?ie=UTF8&s=books&qid=1265066281&sr=8-4

Jon.Morisi SSChampion Points: 12846 More actions · Answer 3

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring (Paperback)
http://www.amazon.com/Microsoft-Availability-Clustering-Database-Mirroring/dp/0071498133/ref=sr_1_4?ie=UTF8&s=books&qid=1265066281&sr=8-4

This book is worthless, complete waste of paper.

It's nothing but the msdn doc's rephrased. There's nothing in there about multi-instance (active-active) clustering.

David Baffaleuf SSCrazy Points: 2159 More actions · Answer 4

Hey ,

Good to know

Most of the best books on SQL Server do not explore the MSCS part. The only one I have dealing with it is Ken Henderson's SQL2005 Practical Troubleshooting. Cindy Gross wrote a short chapter on SQL Clustered instances, about 15 pages, but it is troubleshooting-oriented, not really architecture-oriented. So maybe not what you seek exactly.

http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/ref=sr_1_1?ie=UTF8&s=books&qid=1265878024&sr=8-1

David B.

Jon.Morisi SSChampion Points: 12846 More actions · Answer 5

The Sams books rock!

Microsoft SQL Server 2008 Management and Administration has more useful multi-instance failover cluster info on one page then the Mc Graw Hil book

I really like my

Microsoft SQL Server 2005 Unleashed book too