Date: November 2, 2018
Strip Together Multiple Disk In A Simple Storage Space
You are building a SANless SQL Server cluster with SIOS DataKeeper. Or maybe you’re configuring Always On Availability Groups for SQL Server. How about trying to strip together multiple disk in a Simple Storage Space (RAID 0) for performance? This is very commonly done in the cloud where each instance typically is backed by hardware resiliency, so RAID 0 is not really all that risky.
For instance, I had a recent customer in AWS that wanted to max out his IOPS to 80,000 – the maximum IOPS currently available to a single instance. Now keep in mind, only the largest EBS optimized instance sizes supports 80,000 IOPS. So make sure you know what maximum IOPS your particular instance size supports.
In this case we had ac5.18xlarge instance which does support 80,000 IOPS. However, any individual EBS Provisioned IOPS volume only supports up to 32,000 IOPS. The only way to achieve 80,000 IOPS when writing to any single volume is to strip three of these volumes together in a Simple Storage Space.
Herein lies the rub. If you try to do Strip Together Multiple Disk In A Simple Storage Space in an existing cluster, things are going to go haywire pretty fast. Fellow MVP Joey D’Antoni recently blogged about the issue. It appears to still be an issue in the Windows Server 2019 preview.
Just as Joey suggests, I always advise my customers to build out the nodes and any Storage Spaces before they start the clustering process. This makes the process to Strip Together Multiple Disk In A Simple Storage Space go much smoother. It also allows the customer to have some time to benchmark the server’s performance before they add any replication. And also to ensure everything is working as expected.
Keen to know more quick tips like how to Strip Together Multiple Disk In A Simple Storage Space, check out our other posts about clustering
Reproduced with permission from Clusteringformeremortals.com