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 |
|
trans
Starting Member
3 Posts |
 Posted - 2011-05-19 : 10:33:40
|
| We have a .NET application running with SQL Server and need high availability without a huge budget. They can run on the same server. We do have access to Win2008 Enterprise and were considering clustering.Question is: will clustering the whole server (application and DB) provide us with fail over on both the app and db? Or will we need to cluster the application to a 2nd system and mirror the db to a 2nd system, requiring 4 total systems? thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-20 : 02:11:31
|
| that is not a good practice both application and database server on the same server,yes as Tkizer mentioned about cluster aware,if application does nt support cluster then you can create an script with the help of PING command likeSAMPLEIF ping not then start application servicethis will be schedule on both Server on every 5 mins or as you want or policyIf you will go for this solution then you will have a problem of same IP if you are accessing the application with IP otherwise DNS issueyou can check NLB(Network Load Balancing) solution for this,this will create a single IP from these 2 different IP,user will access the NLB IP with out any intruption but you have to create this script of PING for the application Services onlySecond Sample isYou will create the cluster for SQL Server,if one node fail then second node will be start automatically .then you can schedule an script ofSAMPLEIF SQL Server service is running then Start application servicesAccording to my knowledge IIS service is not cluster awareRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|
trans
Starting Member
3 Posts |
Posted - 2011-05-20 : 07:01:49
|
quote:
Originally posted by tkizer
Does the application support clusters? You can cluster multiple components on one cluster, however the components must be cluster aware.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Yes, the application supports clustering. We need auto failover for application and DB. Is it standard practice to use the same server for both, or split the DB from the app, creating 4 servers to achieve this? Thanks. |
|
|
|
trans
Starting Member
3 Posts |
Posted - 2011-05-20 : 07:02:53
|
| Would using a cluster for the DB be better than a mirror to achieve HA / failover? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
High Availability - SQL and application