Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i need help on where to start and how to combine 2 physical servers to make it function as 1 server. what i'm trying to do here is that we need a 2x quad-core server to be set-up as our SQL server, however, the only available server in our place is a single core so we are planning to buy 2 servers and eventually combine them to function as one, will that be possible? if it does, what are the softwares that I need and how should i do it? sorry guys, this is very new to me, your help is very much appreciated. Thanks in advance.

share|improve this question
    
Is this a compute cluster (combine the power of 2) or a failover cluster (one carries on if the other breaks) ? Sounds like a compute, but just checking. –  Sirex Feb 7 '11 at 13:45
    
hey guys, thanks for replying in my query. @sirex - in my understanding with cluster, what we are trying to do is to combine the computing power of the 2 physical server. @chopper3 - we already have the 2 physical server in our office and what we are trying to do is to combine their computing power and function as our MSSQL Server. Thanks again in advance. –  user71165 Feb 17 '11 at 15:56
add comment

1 Answer

You don't mention which particular SQL engine you currently use or wish to use in the future but people generally cluster servers for only two reasons; to overcome performance limits of their existing hardware and to provide higher availability.

I suspect that you wish to cluster simply because you need higher performance, not for higher availability - if this is the case and you're using either MSSQL or Oracle then I would strongly suggest that due to the relatively cheap cost of modern hardware it will be cheaper and quicker to simply buy higher performance hardware than to buy the additional software and licences required to do this in a clustered environment. Of course these costs are unavoidable if you're trying to achieve higher availability.

If you're using another SQL engine you'd need to tell us what that is for us to help you to decide.

share|improve this answer
    
@dex, following your updated comment you really only have on choice which is to cluster your MSSQL servers - this is very common practice but costs money and doesn't not make both your machines act as one as such. –  Chopper3 Feb 17 '11 at 15:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.