Google Answers Logo
View Question
 
Q: Database Clustering ( No Answer,   1 Comment )
Question  
Subject: Database Clustering
Category: Computers
Asked by: j_m_b-ga
List Price: $20.00
Posted: 29 Nov 2004 23:41 PST
Expires: 02 Dec 2004 01:42 PST
Question ID: 435927
This question is sort of 3-fold:

(1)What are the problems/issues that database clustering seeks to address?

(2)What is database clustering and what are the current approaches,
solutions, and products (in other words, how are the problems being
addressed and who is addressing what problems - I know a couple of the
main products that are being used for DB clustering are MS SQL server
and Linux-based mySQL server)?

(3)Finally, what improvements could be or need to be made in database
clustering (maybe what improvements are being suggested)?

Comments: This last question is especially important.  If you have to,
spend less time explaining the first 2 (more of (but not exclusively)
-pointing- me to information rather than explaining it yourself).  Also,
looking at some of the previous questions you answered, I know you
guys are generally pretty quick (*real* quick sometimes!), but I just
wanted to make sure you could get a response by, say, later this
afternoon or evening - later tonight (9 or 10 or 11ish) at the very
latest (today being Tuesday, November 30).  Thanks, guys!
Answer  
There is no answer at this time.

Comments  
Subject: Re: Database Clustering
From: scubajim-ga on 30 Nov 2004 10:02 PST
 
There are 2 main reasons:
1. scalability
2. Reliability (failover)

You could look at Oracle's RAC (real application Cluster's or their
Grid concepts)  www.oracle.com or otn.oracle.com (technical side). 
From a high level they use a shared disk approuch (each machine in the
cluster can see the same disk) and a high speed interconnect to manage
the cache between machines.

Some vendors (eg MS Sql Server, IBM DB2) use a shared nothing
approuch.  Here the data is actually split up onto different machines
and then the different machines can get you the informaion you want. 
Of course, if you add another machine into the mix you have to
redistribute the data.

Each approuch has its advantages and disadvantages and each vendor
will tell you theirs is best.  But they should have plenty of white
papers describing their clustering solutions and it is enlightenening
to at least read them.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy