Re: Using sql server clustering
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Sun, 24 Jun 2007 12:45:17 -0400
You can cluster any one or all of them if you are worried about any of them
going down. But the mainone (the one that you load data on) is probably the
most likely candidate. Clustering will give that one high availability. As
for the ones that are used to read from I personally wouldn't bother with
clustering them. I would add a 5th read server so that if one fails the
other 4 can still handle the load while you fix the one that is down. This
is much cheaper than clustering all 4 and a LOT easier to manage.
--
Andrew J. Kelly SQL MVP
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:O9lTYujtHHA.4440@xxxxxxxxxxxxxxxxxxxxxxx
WHell Andrew
I got more information about the system i should manage:
for the 6 applications that uses the same data
there is only one application that only load data from sources and there
are 5 applicaions that just showing the data.
So it seems that i need replication for that. and not merge but
transactioal replication but this is not for this forum.
my question is: it seems that in order to make the system better i should
add more server for incoming data wich is failover cluster.
About the servers to pull data, can i use sql server clustering in order
to make that if one of the 5 is fallen down anoter server use it?
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OR4ZBscsHHA.4572@xxxxxxxxxxxxxxxxxxxxxxx
Wow, you are really starting at the bottom:). I suggest you start here
to get an idea of what options are available to SQL Server in terms of
HA.
http://www.microsoft.com/sql/technologies/highavailability/default.mspx
--
Andrew J. Kelly SQL MVP
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:umBRnjbsHHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Thankes Andrew
If what you are saying is true i need it only for recovery.
Do you have offical a documentation from microsoft about it?
secondly' i've seen some documentation about sql server clustering witch
is being used by windows clustering (as far as i know). but on the
document i've seen something about create virtual server.
what is this thing?
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:O1MU$KbsHHA.4612@xxxxxxxxxxxxxxxxxxxxxxx
Clustering in SQL Server is a hardware failover technology only. There
is no load sharing of any kind and there are no performance benefits
from running SQL Server in a Windows cluster. The only thing a cluster
will get you close to is #3. But only 1 server at a time is active. You
best bet is to optimize your existing applications / database or to
scale up with the hardware. Another option may be to use replication
but it sounds like you will need Merge and that would not be my first
choice.
--
Andrew J. Kelly SQL MVP
"Roy Goldhammer" <roy@xxxxxxxxxxx> wrote in message
news:%23t7HmyasHHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
Hello there
I have huge sql server databese that works on single server right now.
To the database there are at least 6 applications that update the data
and use it.
as a result of that there are problems on performance.
I've heard that by using sql server clustering i can do 3 things that
will improve my performance:
1. setting 6 diffrent servers for each application and due to sql
server clustering(as i've been heard) the data is immidietly being
update on each other server
2. the clustering can assist the performance by getting to one
application data from more then one server
3. Recovery: this way if one server is down the other server fills its
action until the server is online again.
my question:
1. is all true that it can be achived on sql server clustering?
2. how can i start learing and using it?
3. what hardware i need to test it and to place at the client?
.
- Follow-Ups:
- Re: Using sql server clustering
- From: Roy Goldhammer
- Re: Using sql server clustering
- References:
- Using sql server clustering
- From: Roy Goldhammer
- Re: Using sql server clustering
- From: Andrew J. Kelly
- Re: Using sql server clustering
- From: Roy Goldhammer
- Re: Using sql server clustering
- From: Andrew J. Kelly
- Re: Using sql server clustering
- From: Roy Goldhammer
- Using sql server clustering
- Prev by Date: Re: Set up clustering on single node to add second later
- Next by Date: Re: Set up clustering on single node to add second later
- Previous by thread: Re: Using sql server clustering
- Next by thread: Re: Using sql server clustering
- Index(es):
Relevant Pages
|
