Just wanted to let you know that using traditional SQL failover clusters and SQL FCI, or any MSCS / Microsoft failover cluster is available in tech preview as of NOS 4.1.5. This is because we have introduced SCSI 3 Persistent Reservations to the iSCSI stack. To implement a cluster you need to use the MS iSCSI Initator and the Nutanix Volume Groups contract and iSCSI target for in-Guest iSCSI access. This will become a full GA feature in an upcoming release of NOS. Please experiment with it and let us know your thoughts.
Already have an account? Login
Login to the community
Login with your account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
TempDBLUN : SQLVG
SysDBLUN : SQLVG
UserDBLUN : SQLVG
TempDBLUN : TempDBVG
SysDBLUN : SysDBVG
UserDBLUN : UserDBVG
Is there currently a process to grow a LUN with a VG?
(and) should I assume this is not a thin provisioned drive, therefore making growing the LUN even more important.
Currently on 22.214.171.124 and not seeing any information on resizing.
With 126.96.36.199 the sweet spot is 4 LUNs/vDisks per VG/Target. This is a performance sweet spot and not a limitation. You can configure more than that, but LUN's become CPU bound in the CVM with random IO and that will impact performance. 20K IOPS (8KB single IO pattern) or more is acheivable from a single LUN/Target, higher can be achieved with multiple LUN's/Target. Depending on the platform being used of course.
For a SQL DB in 188.8.131.52 you should be able to use a single Target/VG if you just need 4 drives. That would be the easiest configuration. Every LUN/vDisk is thin provisioned. We don't consume storage resources until the point that the application goes to write data.
At this stage I don't think we have a way to extend an existing vDisk/LUN connected to a target. So the process to expand the size would be to add another vDisk to the target and then use in guest tools to extend the volume. I'll check into this more and reply to this thread.
Compression, Dedupe, and EC-X are all supported. As far as ADFS/NDFS is concerned the LUN is just a vDisk on our system just like any other VMDK would be.
Do we expect this feature to come in the next or a near-future release? Specifically for Hyper-V customers.
This is already available and on the support portal and on the Nutanix bible. We have supported Windows Failover Clusters since AOS 4.1.5 and 4.5. There is also a best practice guide for Block Services availble on our web site. So it could be time to re-evaluate it.
Unless I'm mistaken, we are not able to resize disks that belong to a Volume Group without taking the Failover Cluster offline - that's what is preventing us from using NTX Block Services in our fialover clusters.
Am I mistaken and we can resize these disks while they're being used?
Just saw your second reply. Thank you. We are very much looking forward to that hot-expand as we're currently able to do this with our Luns that reside on our NetApp and Equilogic SANs.