 | |
cluster design
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: cluster design -
01-12-2004
, 10:35 AM
|
-----Original Message----- How will this be possible? Windows Advance Server does not allow me to install the cluster because it says no shared SCSI Bus found. Lets say I install this SCSI drive, how will I install the second node of the cluster? I do not want the second cluster to use the SCSI drive used by the first machine. Thanks Shailesh -----Original Message----- Yes. it is possible -----Original Message----- Hello Mike, I shall be using transactional replication which wont be time consuming at all. So I do not want the clustering service to handle replication. The two nodes will have their own hard drives and their own version of SQL Server running. The data on them will be nearly simlar because of the replication performed by SQL Server on machine 1. On a failure of machine 1, I simply want the clustering service to hand over the control to Machine 2. No replication of data is performed by this server. At all times the nodes in the cluster will be handling their own data (not the shared drive). Is there such a design possible? Thanks, Shailesh -----Original Message----- Microsoft's implementation of clustering uses a shared set of drives to store the data (SAN). What you want to do is network load balancing with only 1 node being active at a time. If you are worried about the shared external drives and their associated equipment failing, add another SAN with separate IO controllers. It is not recommended that you run a SAN on SCSI, but rather on Fiber Channel. A possibility is always buying a Unisys ES 7000 and clustering over the virtual machines. Replication always has a time lag, so what are your tolerances for data loss (1, 5 or 10 minutes) ? Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Epprecht Consulting (PTY) LTD Johannesburg, South Africa Mobile: +27-82-552-0268 IM: mike (AT) NOSPAMepprecht (DOT) net Specialist SQL Server Solutions and Consulting "Shailesh" <shailesh (AT) softhome (DOT) net> wrote in message news:001b01c3d617$b0a8cbf0$a601280a (AT) phx (DOT) gbl... I am trying to install a cluster of two computers. Both of them are going to be production machines which have similar applications installed on it. Both have SQL installed and are database servers. As data comes into one of them the SQL on this first machine replicates the data for every transaction to the 2nd machine. Thus both have similar data at almost all times. On failure I want the cluster service to make the 2nd computer as the new server where the data can be inserted automatically until the first server is brought to action again. The clustering architecture in windows wants the 2 machines to not have dat on them but on an external SCSI hard drive. But this sturcture fails to provide any service when the external hard drive itself fails. Our approach takes care of hard drive failure as well a machine failure. How do I go about doing the cluster service installation as the service, while installation, prompts that no seperate SCSI bus found (during the installation of the first node) Thanks in advance. Shailesh . . . . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.