| Author |
 Topic  |
|
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 23 October 2003 : 23:55:58
|
Currently the company I work for has one sql server that does all the work, and one that is being fed the backup of databases from the first every couple hours or so. If a problem occurs with the first, someone has to go there to change things over to the second untill the first is back online. I am trying to think of a good way to do load balancing with MSSQL 2000. I would like to create a cluster of server. Can you do this with MSSQL and Windows 2000 advanced server?
The data on the databases is pretty much constantly being updated (and my forum is on the server  ) so it needs to be instant replication whenever a change is made on one server. Can anyone suggest of what to do, or what the best way of setting this up is? I pretty much have access to use whatever software/hardware I want to as long as it works.
Thanks! |
Erick
Snowmobile Fanatics
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 24 October 2003 : 00:10:20
|
I usually do not deal with packaged features of a server operating system and not sure how much money your company will invest (if any) but I personally use Legato Standby Server for my SQL Server
http://portal2.legato.com/products/costandbyserver/ |
 |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 24 October 2003 : 06:16:26
|
In the bank I work at, we use MS Cluster service all the time, with both a SCSI array or with EMC. I helped create the document on creating a Standard build of a MS Cluster at work.
Windows 2000 Advanced Server has Clustering built in, but you do need to add it after building the server. When you fail the cluster over, it will have all the data there, and only takes a few seconds to fail accross, but you will not have your SQL data on the node you just failed from.
If you want I can get you a copy of the document and remove all reference to the bank and their security, but it will show you how to build a robust MS SQL cluster if you want. Just send me an email from my site via the online form.
|
Cheers,
David Greening |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 24 October 2003 : 10:47:39
|
| Ok, so probably the main thing I would need here is the shared disk array? What does this consist of anyways, this central array. Is it another server or what? |
Erick
Snowmobile Fanatics
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 24 October 2003 : 18:44:47
|
OK, we use 2 different types (models shown are an example) of arrays at the bank.
There is the SCSI Array - Cheap alternative
Then there is the Fibre Array which requires more, is faster than SCSI and can work out to be over 3 times the cost of SCSI.
I hope these point you in the right direction and give you a better understanding of what an array is..
|
Cheers,
David Greening |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 24 October 2003 : 18:56:59
|
| Thanks for the links. I will look into this. I have been reading that article on technet. Sounds interesting. It isn't that our SQL isn't working now, I mean it is...just that I would like things to be more reliable yet. We do have about 14,000 dial up, wireless, and dsl customer authenticating to it for e-mail and dial up authentication. I think soon we are planning on adding a couple thousand more customers from a location that was bought up. I'd like to keep downtime to the very least possible. |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 24 October 2003 18:59:25 |
|
|
| |
Topic |
|
Topic Locked
