SQL Architecture
Hi all, I am new to the forums. I just setup denali in are laptop and I see it still uses MCS and Shared disks. This is not very helpful if you plan on using cloud computing. Denali's documentation says it that it introduced all this new HA features for disaster recovery. well if it relies on shared disks it is not very usful if your doing WAN based disaster recovery.
What I was hoping to find out is, does denali have the abillity to run in clustered mode and have two active nodes within this cluster? Can we have the SQL service run on two seperate nodes with the cluster at the same time?
I was also hoping to find out does denali support running in clustered mode accross a WAN? What we where hoping to achieve was have a SQL cluster with 2 active nodes, with one server at one datacenter and another server at another and have both SQL server running databases at the same time. exchange has the ability to do this. I was hoping denail did as well.
What I was hoping to find out is, does denali have the abillity to run in clustered mode and have two active nodes within this cluster? Can we have the SQL service run on two seperate nodes with the cluster at the same time?
I was also hoping to find out does denali support running in clustered mode accross a WAN? What we where hoping to achieve was have a SQL cluster with 2 active nodes, with one server at one datacenter and another server at another and have both SQL server running databases at the same time. exchange has the ability to do this. I was hoping denail did as well.
ASKER
Thanks for that, Does denali have the ability to run in active active mode?
fairly sure i have not had a chance to play with it fully yet to know if there any changes to how its activated.
ASKER
I just want to confirm, when running in active active meaning i can have two active servers with databases running on both servers? or would it be like the old version where we just split the SQL services accross the two servers?
it would be active\active in terms of splitting the DB's across the nodes you couldn't have a DB active on 2 nodes at once
ASKER
thanks for that, last question; do you have any recommandations or links for running SQL over a wan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is a create link and demo, thanks for sharing it. it has answered alot of my questions
its essential to have shared disks to have the cluster resource available to hold the settings