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.
OTNAdminAsked:
Who is Participating?
 
Metehan OzculluSQL Service ManagerCommented:
I watched the denali High Availability demo on Last TechEd Europe and according to that, both nodes will be active active but one will be readonly. It will use a similar technology like mirroring on new cluster methodology. the second node will be active for readonly operations and It will not need shared disks.

The demo is here: http://channel9.msdn.com/Events/TechEd/Europe/2010/DAT303
0
 
ChrisCommented:
if you want to run a cluster you will need to have storage replication to put it in two places otherwise it would be an NLB

its essential to have shared disks to have the cluster resource available to hold the settings
0
 
OTNAdminAuthor Commented:
Thanks for that, Does denali have the ability to run in active active mode?
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
ChrisCommented:
fairly sure i have not had a chance to play with it fully yet to know if there any changes to how its activated.
0
 
OTNAdminAuthor Commented:
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?
0
 
ChrisCommented:
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
0
 
OTNAdminAuthor Commented:
thanks for that, last question; do you have any recommandations or links for running SQL over a wan
0
 
ChrisCommented:
if you want storage replication for clustering then that's some big bandwidth min 1GB with Latency of <10ms but thats using fibre to IP converters. you could pay for dark fibre links to do native fibre to fibre SAN fabric meshing but thats really big bucks

what do you want to achieve?
If you just want DR then you could just use TLOG shipping or something like that
0
 
OTNAdminAuthor Commented:
This is a create link and demo, thanks for sharing it. it has answered alot of my questions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.