Join this episode for more Stories from the EUC Road as Sean Donahue (Nutanix) and Al Solorzano (E360) tackle this all too familiar question. But does it have to an \u201cOR\u201d statement? Can you have an \u201cAND\u201d statement instead? Tune in to learn more about performance in EUC, happy employees and how you might sleep better at night in the age of Malware and Ransomware.<\/p><\/oembed>

Resources<\/p>

nutanix上的SQL簇

j
徽章 +3
有人在NUTANIX / HYPERV实现上运行传统的SQL簇吗？
该主题已关闭以供评论

21个答复

Tomvangramberen
徽章 +5
你好



假设您的意思是故障转移群集配置，那么我相信这是（当前）不支持，因为这需要共享所有节点的数据。



我相信Nutanix不支持CSV或共享VHD（X）文件。



我们最终使用了nutanix完全支持的SQL Server Opplayon配置。不足的一面是它需要企业许可证和更多存储空间。



希望这可以帮助！

\n

\nAssuming you mean a Failover Cluster configuration, then I believe this is (currently) not supported as this requires sharing the data accross all nodes.

\n

\nI believe Nutanix does not support a CSV nor sharing a vhd(x) file.

\n

\nWe ended up using a SQL Server AlwaysOn configuration which is fully supported by Nutanix. Down side is that it requires an Enterprise license and more storage.

\n

\nHope this helps!","quoteUsername":"tomvangramberen","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
VCDXNZ001
秩
UserLevel 3
徽章 +19
嗨，汤姆，你是正确的。我们尚未支持SCSI 3个固定保留，这是共享磁盘在故障转移群集中正常工作所必需的。这在将来的某个时候可能会发生变化。
问
徽章 +3

不支持SCSI3持久性保留的哪一部分？仅当使用共享VMDK时，还是在VMware示例中，SCSI适配器设置为实体总线共享模式？我问的原因是，我在下一版本的Windows Server中看到了一个非常好的将来的用例，其中包括存储副本。

这仍然需要SCSI3持久性预订与Windows故障转移群集管理器中的基础VMDK对话，但是随着复制在SMB3中以smb3的形式在vmdk级别上“共享”磁盘实际上“共享”。预订仅用于将锁在操作系统级别的目标副本上。我在这里的博客中写了这一点http://www.cloudypolitics.com/virtualize-windows-storage-replica-cluster-on-vsphere/

希望使用此功能，我们可以使用SQL Server标准版在Nutanix上创建Windows簇。

What part of SCSI3 persistant reservations are not supported? Is it only if shared VMDK's are used, or if, in a VMware example a SCSI adapter is set to physical bus sharing mode? Reason I am asking is I see a really good future use case with Storage Replica in the next version of Windows Server.<\/p>

This still requires SCSI3 persistant reservations to talk to the underlying VMDK in Windows Failover Cluster manager, but the disks arent actually \"shared\" at the VMDK level as replication happens in-guest over SMB3 to the other cluster node. Reservations are only used to control locks to the destination replica at the OS level. I wrote about this in my blog here http:\/\/www.cloudypolitics.com\/virtualize-windows-storage-replica-cluster-on-vsphere\/<\/a><\/p>

Hopefully with this feature we can create windows clusters on Nutanix using SQL Server Standard edition.<\/p>","quoteUsername":"quinney_david","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

VCDXNZ001
秩
UserLevel 3
徽章 +19

nutanix SCSI堆栈中尚未实施SCSI3 PR。因此，任何需要SCSI3 PR的东西，包括通过RDM进行故障转移聚类，都将被阻止工作。但是，在故障转移聚类的情况下，有一个解决方案将使用第三方工具在Nutanix上使用。如果需要用于SQL Server和其他应用程序的故障转移群集，则可以使用SIO DatakeEper和其他类似工具来启用传统的故障转移群集。

这些第三方工具得到了各自的供应商的支持。当SCSI3 PR以及与SIO和其他类似技术供应商的任何验证 /联合论文有关时，我将更新此主题。

SCSI3 PR isn't implemented in the Nutanix SCSI stack as yet. So anything that requires SCSI3 PR, including Pass Through RDM's for Failover Clustering, will be prevented from working. However in the case of failover clustering there is a solution that will work on Nutanix using third party tools. If failover clustering for SQL Server and other applications is required then SIOS DataKeeper and other similar tools can be used to enable the traditional failover clusters.<\/p>

These third party tools are supported by their respective vendors. I'll update this thread when there is more news on SCSI3 PR and also any validation \/ joint papers with SIOS and other vendors of similar technology.<\/p>","quoteUsername":"vcdxnz001","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

我
徽章 +2
VCDXNZ001写道：嗨，汤姆，你是正确的。我们尚未支持SCSI 3个固定保留，这是共享磁盘在故障转移群集中正常工作所必需的。这在将来的某个时候可能会发生变化。

嗨，您表示不支持SCSI 3持续保留，但是CSV是否支持？从SQL Server 2014开始，ElwaysOn故障转移群集Instances在Windows Server 2008 R2和Windows Server 2012中支持集群共享量（CSV）。//



谢谢，



伊恩
vcdxnz001 wrote:Hi Tom, You're correct. We don't yet support SCSI 3 Presistent Reservations, which are required for the shared disks to work properly with failover clustering. This is likely to change at some point in the future.

\n<\/blockquote>Hi, you indicated that SCSI 3 Persistent Reservations are not supported, but is CSV supported? Beginning in SQL Server 2014, AlwaysOn Failover Cluster Instances supports Clustered Shared Volumes (CSV) in both Windows Server 2008 R2 and Windows Server 2012. \/\/ \ufeff

\n

\nThanks,

\n

\nIan","quoteUsername":"Ian_Elsinga","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
VCDXNZ001
秩
UserLevel 3
徽章 +19
CSV又称群集共享量还需要SCSI 3持续保留。这可能与刚刚发布的4.1.5号合作使用，因为SCSI 3 PR现在是技术预览。但是我们尚未测试。



同样，SQL FCI又名MSCS又称故障转移群集现在正在技术预览中，使用了GUEST ISCSI，截至第4.1.5号。

\n

\nAlso SQL FCI aka MSCS aka Failover Cluster is now in tech preview with the use of in-guest iSCSI as of NOS 4.1.5.","quoteUsername":"vcdxnz001","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
j
徽章 +2
嗨



这已经进行了测试吗？杰森

\n

\nHas this been tested yet?Jason","quoteUsername":"jayglate","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
VCDXNZ001
秩
UserLevel 3
徽章 +19
嗨，杰森，



我们已经在各种不同条件下在世界各地的质量检查和性能实验室环境中进行了一段时间（跨测试的所有阶段）进行了内部测试。目前的性能可能不如功能为GA时那样出色。技术预览并不意味着未进行测试。但是，它应该在非生产环境中使用，直到我们将功能完全ga。它将在以后的版本中成为GA。

\n

\nWe have tested it internally in our QA and performance lab environments across the world under various different conditions for quite some time now (across all phases of testing). Performance may not be as good at the moment as it will be when the feature is GA. Tech Preview does not mean not tested. But it should be used in non-production environment until we fully GA the feature. It will become GA in a future release.","quoteUsername":"vcdxnz001","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
d
徽章 +2
嗨



是否支持使用nutanix复制到另一个nutanix群集同步复制一对Windows群集VM（VMware）？



是否支持群集对VM的局部Nutanix快照？



换句话说，有哪些选择用于保护任何群集对？希望远离SQL镜像/日志运输。

\n

\nIs it going to be supported to synchronously replicate a pair of Windows Cluster VMs (VMWare) using Nutanix replication to another Nutanix cluster?

\n

\nIs it even supported to have local Nutanix snapshotting of cluster pair of VMs?

\n

\nPut another way, what options are there for protecting\/DR of any cluster pair? Would prefer to keep away from SQL mirroring\/log shipping.","quoteUsername":"dazza","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
VCDXNZ001
秩
UserLevel 3
徽章 +19
嗨，达扎，



我还没有测试，我会发现。但是对于SQL Server，我们建议使用站点之间的FCI本地站点（群集）（群集）。这将是一致的应用程序，因为我们在存储级别上所做的任何事情都只能崩溃一致。

\n

\nI haven\u2019t tested it, I\u2019ll find out. But for SQL Server we would recommend FCI local site (clustering) with Availability Groups (replication) between sites. This will be application consistent, as anything we do at the storage level would only be crash consistent.","quoteUsername":"vcdxnz001","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
d
徽章 +2
谢谢你想知道。

因此，在这里使用AAG进行DR形成业务POV……..这与当前的SAN技术（如HP 3PAR群集扩展）相对应的问题。这为您提供了多站点同步的拉伸集群功能在SQL标准许可证模型下。涉及哈和博士。因此，当我们查看当前的SQL项目时，SAN看起来非常吸引人，因为它可以在我们的SQL项目之间有所不同，而SQL项目的价格为15万英镑，SQL许可证或60万英镑。如果Nutanix要求通过AAG实现相同的HA/DR能力，那么从SAN到Nutanix的任何搬迁的TCO都可以因需要企业而否定，因此，假设没有其他驾驶员可以企业企业。

\nSo here lies the problem with using AAGs for DR form a business PoV\u2026\u2026.. it\u2019s up against current SAN technologies like HP 3Par Cluster Extensions. This gives you multi-site synchronous stretched cluster capabilities under a SQL Standard license model<\/b>. That deals with HA and DR. So, when we look at our current SQL project the SAN looks very appealing because it could make the difference between our SQL project costing \u00a3150k in SQL licenses or \u00a3600k. If Nutanix requires an Enterprise SQL license to achieve the same HA\/DR capabilities via AAG, then the reduced TCO of any move from SAN to Nutanix could be negated by a need to go Enterprise, assuming of course there's no other driver to go Enterprise.","quoteUsername":"dazza","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
VCDXNZ001
秩
UserLevel 3
徽章 +19
拉伸集群的最大问题是集群本身的千里。除非您有两个，否则您不能保证生产的非破坏性操作，并且它们的实施和维护非常复杂。因此，无论您从前保存什么，您最终都会随着时间的推移而在增加的OPEX中付款。Nutanix提供的Metro可用性可以单击几下实施，并消除了传统的SAN基伸展群集的许多问题。但是，这目前与SQL群集不起作用，这需要从卷组中访问iSCSI。
VCDXNZ001
秩
UserLevel 3
徽章 +19
嗨



随着今天的v4.5 OS发布，我们现在支持Windows Failover群集，并使用MPIO访问guest ISCSI访问。这将有助于您的项目以及其他需要支持传统故障转移聚类的客户，而不是始终在可用性组上。

\n

\nWith the release of our v4.5 OS today we now support Windows Failover Cluster with in-guest iSCSI access with MPIO. This will help with your project and for other customers that need to support traditional failover clustering instead of or in addition to Always On Availability Groups.","quoteUsername":"vcdxnz001","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
d
徽章 +2
那是好消息。现在只是等待功能复制该群集
一种
徽章 +10
你好，



现在，Nutanix支持SCSI对吗？我是Windows的新手。您可以提供有关传统SQL震荡的一些链接吗？



RGD

里奇

\n

\nso now nutanix support scsi right?.i am new to windows .can you provide some links about the traditional sql clutering?

\n

\nrgds

\nritchie","quoteUsername":"alunkal","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
j
UserLevel 2
徽章 +8
我知道这是一个旧线程，但它在搜索中弹出，所以我想我会添加。您可以在Nutanix中运行故障转移SQL簇，没有任何问题。在过去的几个月中，我已经建造了它们，这是一个坚实的高性能，高可用的解决方案。每个驱动器都是作为两个节点都可以访问的卷组创建的。我有一台服务器2012运行SQL 2016 Standard现在，正在计划另一个运行服务器2016和SQL Enterprise今年（2019年）。
H

嗨，大卫，

nutanix SCSI堆栈中尚未实施SCSI3 PR。因此，任何需要SCSI3 PR的东西，包括通过RDM进行故障转移聚类，都将被阻止工作。但是，在故障转移聚类的情况下，有一个解决方案将使用第三方工具在Nutanix上使用。如果需要用于SQL Server和其他应用程序的故障转移群集，则可以使用SIO DatakeEper和其他类似工具来启用传统的故障转移群集。这些第三方工具得到了各自的供应商的支持。当SCSI3 PR以及与SIO和其他类似技术供应商的任何验证 /联合论文有关时，我将更新此主题。

亲切的问候，

迈克尔

你好 @vcdxnz001- 该线程更新的时间？。由于SCSI-3 PR支持添加了AOS 5.17。它如何影响WSFC配置并与Nutanix HCI上运行的每个市长管理程序（AHV，ESXI和HyperV）相关。感谢您的分享和评论。

这是一个很好的参考：https://next.nutanix.com/archive-44/shared-storage-for-windows-server-failover-clusters-on-nutanix-27364

雨果桑切斯
\t

Hi David,

\tSCSI3 PR isn't implemented in the Nutanix SCSI stack as yet. So anything that requires SCSI3 PR, including Pass Through RDM's for Failover Clustering, will be prevented from working. However in the case of failover clustering there is a solution that will work on Nutanix using third party tools. If failover clustering for SQL Server and other applications is required then SIOS DataKeeper and other similar tools can be used to enable the traditional failover clusters. These third party tools are supported by their respective vendors. I'll update this thread when there is more news on SCSI3 PR and also any validation \/ joint papers with SIOS and other vendors of similar technology.

\tKind regards,

\tMichael<\/p>\t<\/div><\/content-quote>

Hi @vcdxnz001<\/user-mention>\u00a0- Time for that update on the thread? \"🙂\" . Since SCSI-3 PR support was added with\u00a0 AOS 5.17. How it affect WSFC configurations and related\u00a0 on each mayor hypervisor (AHV, ESXi and HyperV)\u00a0 running on Nutanix HCI. Thanks for sharing and commenting.<\/p>

Here is a good reference:\u00a0https:\/\/next.nutanix.com\/archive-44\/shared-storage-for-windows-server-failover-clusters-on-nutanix-27364<\/a><\/p>","quoteUsername":"HugoS","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

m

嗨，雨果，

现在，SCSI 3 PR在本质上受支持，它可以在跨越机械程序范围内工作。对于AHV，如果将VDISK连接到多个VM并使用WSFC，则无需任何特殊配置就可以在本地工作。通常，您将使用VM之间的共享卷组进行集群存储。这也适用于使用SCSI围栏的RedHat和Linux簇。这是一个重大胜利，使设置故障转移簇非常简单。

对于ESXI和Hyper-V，您可能需要使用ISCSI连接到AOS上的卷。尽管我认为您可以通过Hyper-V中的SMB3传递SCSI 3 PR命令，因此它也可以与正常的共享VDISK一起使用。如果可能的话，建议使用5.20或更高版本的LTS发行版，以便获得最新功能。

这是一篇不错的文章 -http://longwhiteclouds.com/2020/11/09/simple-guest-os-clustering-without-complex-config/

Hi Hugo,\u00a0<\/p>

\u00a0<\/p>

Now SCSI 3 PR is natively supported it works across hypervisors. For AHV if you connect vDisks to multiple VM\u2019s and use WSFC it will natively work without any special configuration. Usually you would use a shared volume group between the VM\u2019s for the cluster storage. This also works with RedHat and Linux clusters that use SCSI fencing.\u00a0 This is a major win and makes setting up failover clusters very simple.<\/p>

For ESXi and Hyper-V you may need to use iSCSI connections to Volumes on AOS. Although I think you can pass the SCSI 3 PR command via SMB3 in Hyper-V, so it may also work natively with normal shared vDisks. Recommend using LTS release of 5.20 or above if possible so you get the latest features.\u00a0<\/p>

Here is a good article -\u00a0http:\/\/longwhiteclouds.com\/2020\/11\/09\/simple-guest-os-clustering-without-complex-config\/<\/a><\/p>","quoteUsername":"michael.webster-55854","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">

H

使用WS2019进行WSFC配置|ESXI 6.7 |AOS 5.20.0.1，一切顺利，直到我们添加第五盘为止。我们正在使用nutanix卷进行展示。然后找到这个评论https://docs.microsoft.com/en-us/troubleshoot/windows-server/high-availability/scsi-3-persistent-restrive-test-test-fail。一种配置的限制可能是原因？有建议吗？- 谢谢你！

雨果桑切斯
m

没有配置的限制。您是否正在使用与这些卷的ISCSI连接？我建议为此开启支持请求。

There is no configured limit. Are you using iSCSI connections to those volumes? I would suggest opening a support request for that.\u00a0<\/p>","quoteUsername":"michael.webster-55854","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
H

是的，使用ISCSI连接。已经与Nutanix支持一起工作了。

雨果桑切斯
Yes, using iSCSI connections. Already working with Nutanix Support.<\/p>","quoteUsername":"HugoS","translations":{"Common":{"like":"Like","unlike":"Unlike"},"Forum":{"Quote":"Quote","Share":"Share"}}}">
条款和条件
Learn more about our cookies.<\/a>","cookiepolicy.button":"Accept cookies","cookiepolicy.button.deny":"Deny all","cookiepolicy.link":"Cookie settings","cookiepolicy.modal.title":"Cookie settings","cookiepolicy.modal.content":"We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.<\/a>","cookiepolicy.modal.level1":"Basic
Functional","cookiepolicy.modal.level2":"Normal
Functional + analytics","cookiepolicy.modal.level3":"Complete
Functional + analytics + social media + embedded videos"}}}">
Baidu