| Author |
 Topic  |
|
|
aradhyakiranbm
Starting Member
India
3 Posts |
 Posted - 07/19/2010 : 02:15:45
|
Dear members ,
I 'm trying to configure a fail over clustering for a client ,whose requirement states that :
Clustering should replicate data for two nodes without storage or a quorum .
what i have experimented:
I was trying to configure windows server 2003 enterprise edition and then tried to configure sql server over it . i have made one as active directory and domain controller , added the other as its member .
i was not possible to proceed without an external storage drive even after selecting majority set property (i.e., local storage disk)
my doubt :[/b]
is it possible without clustering the server 2003 with only sql server 2005 ?
how can i replicated data with in two nodes in case of failover ?
I need a help or any supporting document to resolve this clustering
thanks
kiran aradhya
Bangalore.
Kiran Aradhya
Application engineer
Kiran Aradhya
Application engineer |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 07/19/2010 : 03:57:46
|
What you're describing there is not failover clustering. Failover clustering requires shared storage and a quorum drive.
Might be worth getting some more details from the client, what they really want, what the point of this is (scale-out or HA), what their requirements are.
--
Gail Shaw
SQL Server MVP |
 |
|
|
aradhyakiranbm
Starting Member
India
3 Posts |
Posted - 07/19/2010 : 09:58:00
|
Hello Gail Shaw ,
Thank you for this clarification ,
My client needs :
Installation and Configuration of Operating systems
Installation of SQL Server
Configuration of Load Balancing
Installation and Configuration Application Clusters
Configuration / Replication of SQL Cluster
Testing Load Balancing , Testing SQL Cluster/Database Sync ,testing application Clustering
can you please suggest me how to go about it ,
or can please provide me any supporting document and links
or feel free to mail me at kiran.aradhya@technextsystems.com
warm regards
kiran
Kiran Aradhya
Application engineer |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 07/19/2010 : 10:58:53
|
SQL doesn't have any built-in load balancing.
There's not enough info there to help. Most of those should be easy enough to do. You need to sit down and get detailed requirements for the replication/load balancing to see what they want and how you might be able to implement it.
--
Gail Shaw
SQL Server MVP |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 08/17/2010 : 07:46:56
|
they don't want shared storage because they cannot afford a SAN and still want clustering? google iSCSI
otherwise I think they want replication, logshipping or mirroring
--------------------
keeping it simple... |
|
|
| |
Topic |
|
failover clustering
