Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

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.
0
OTNAdmin
Asked:
OTNAdmin
  • 4
  • 4
2 Solutions
 
irweazelwallisCommented:
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
 
irweazelwallisCommented:
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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
 
irweazelwallisCommented:
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
 
irweazelwallisCommented:
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
 
mozculluCommented:
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
 
OTNAdminAuthor Commented:
This is a create link and demo, thanks for sharing it. it has answered alot of my questions
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now