SQL架构 [英] SQL Architecture

问题描述

大家好，我是论坛新手。我只是在笔记本电脑中设置denali，我发现它仍然使用MCS和共享磁盘。如果您计划使用云计算，这不是很有用。 Denali的文档称它为
灾难恢复引入了所有这些新的HA功能。如果它依赖于共享磁盘，那么基于WAN的灾难恢复是不是很有用。

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.

我希望找到的是，denali是否具有在群集模式下运行的能力并在此群集中有两个活动节点？我们可以同时在两个单独的节点上运行SQL服务吗？

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?

我还希望找到在群集模式下运行的denali支持？我们希望实现的是具有2个活动节点的SQL集群，一个服务器位于一个数据中心，另一个服务器位于另一个服务器上，并且同时运行数据库的SQL服务器
。交换有能力做到这一点。我希望denail也这样做。

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.

推荐答案

新的基于AlwaysOn可用性组的解决方案不依赖于共享磁盘。您必须在Windows Server故障转移群集中拥有节点（例如独立的SQL Server），但数据移动是使用网络而不是通过共享的
磁盘进行的。

The new AlwaysOn Availability Groups based solution does not rely on the shared disk. You have to have your nodes (e.g. stand-alone SQL Servers) in Windows Server Failover Clustering but the data movement happens using the network and not via the shared disk.

那里是主副本和副副本之间的区别。主副本是读写的，而辅助副本可以从中读取，并且可以执行一些备份操作，例如，日志备份。

There is a distinction between the primary replica and the secondary replica(s). The primary replica is read-write while the secondary replica can be read from and it is possible to perform some backup operations e.g. the log backups.

可以在这里找到AlwaysOn的一个很好的概述，它在很多情况下都很有帮助：

http://msdn.microsoft.com/en-us/library/ff877884(v=SQL。 110）.aspx 。

A good overview of AlwaysOn which should be helpful in many cases can be found here: http://msdn.microsoft.com/en-us/library/ff877884(v=SQL.110).aspx .

这篇关于SQL架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！