Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2007-10-26 : 01:37:45
|
| Hi All,I am deciding on high-availibitly for my database server box. My website can get large number of user hits for 4 days in every quater of year. We are also planning to launch some schemes which will help keep are business and servers busy :).I am planning to have 2 node cluster. With configurationWindows Server 2003 Standard Edition 64 bitSQL Server 2005 Standard Edition 64 bit4 GB RAM8 x 300 GB Ultra 320 SCSI Hard DrivesHardware RAID 0+1Redundant ControllersFiber AttachedMy Question are.1) What type of clustering I should go for? (Active/active vs Active/Clustering) and why?2) Will active/active means load balancing as there will be 2 servers as active and both of them can share the load?3) What are the advantages and disadvantages of clustering type you recommend in question 1.4) We are also planning to configure transactional replication on these servers as per disaster recovery plan. Will it an overhead to the servers if they are in different geographical locations? (My network bandwidth is 100 mbps connection)Please help. Thanks in advance.regardsSDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 11:32:44
|
| 1. Depends on how many instances you will have, how many licenses you purchased, and can a single node support the instances.2. Clustering does not give you load balancing. 3. You seem to be confused about clustering, so we need to get your understanding correct before we answer this.4. Clustering is recommended across a LAN not a WAN. If you do clustering across a WAN, then you'll need to purchase some very, very expensive hardware to do the SAN mirroring. We're talking in the 7 figures.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:24:53
|
| >> 4) We are also planning to configure transactional replication on these servers as per disaster recovery plan. Will it an overhead to the servers if they are in different geographical locations? (My network bandwidth is 100 mbps connection)Depend son transaction rate on source server, heavier traffic means longer latency. |
|
|
|
|
|
|
Cluster Queries