MSSQL故障转移群集（主动/被动）是否支持加密的碎片磁盘（RDM） [英] Is MSSQL failover Cluster (Active/Passive) will support to encrypted shred disks (RDM)

问题描述

大家好，

我们已经成功构建了主动 - 被动SQL故障转移群集（Node& ;磁盘占多数）
  ，先前的群集磁盘加密，  SQL故障转移群集服务在节点之间成功移动& SQl& MSDTC服务在节点上自动联机。

由于一些安全合规性，
  我们需要加密群集磁盘+操作系统磁盘（〜$ C& $ D，）（第三方供应商），但是加密后， <跨度>&NBSP;
SQL群集未按预期进行故障转移  和磁盘需要更多时间才能上线。初始化，然后它的领先SQL集群故障转移服务失败，一旦磁盘启动&上线，然后
  需要  手动联机提供SQl故障转移服务。

 

• MSSQl故障转移群集共享磁盘是否支持加密
• 如果对群集磁盘（RDM）进行加密
，则SQL故障转移群集服务需要更改哪些参数以自动使服务联机 ul>


 




提前谢谢









---




此致，Kiron

解决方案

你需要将PendingTimeout设置为适合故障转移时间的内容。

例如：





 cluster resource" MySQLServerClusterRolename" / prop PendingTimeout = 120000 




$
PowerShell



< pre class ="prettyprint"> Set-ClusterResource -Name MySQLServerClusterRolename | Set-ClusterParameter -Name PendingTimeout -Value 120000










Hi All,

We have built the active-passive SQL fail over cluster successfully (Node& Disk majority)  , prior cluster disk encryption,  the SQL failover cluster services moving successfully between the nodes & SQl & MSDTC services coming online automatically on nodes.

Due to some security compliance,  We need to do encrypt the cluster disks + OS disks (~ $C & $D,) ( third party vendor ), but post encryption,  the SQL cluster is not fail over as expected  and disks are taking more time to coming online & initializing , And then it’s leading SQL cluster fail over services failed , Once disks are initiated & coming online, then  need  to bring SQl failover services manually online.

 

• Is MSSQl failover cluster shared disks will support encryption or not
• What are parameters need to change in SQL failover cluster services to bring services online automatically if encrypted the cluster disks (RDM)

 

Thank you in advance




---

Regards, Kiron

解决方案

You need to set PendingTimeout to something appropriate to the failover time.
For example:



cluster resource "MySQLServerClusterRolename" /prop PendingTimeout=120000



PowerShell



Set-ClusterResource -Name MySQLServerClusterRolename | Set-ClusterParameter -Name PendingTimeout -Value 120000








这篇关于MSSQL故障转移群集（主动/被动）是否支持加密的碎片磁盘（RDM）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！