White Paper: MySQL Performance Testing: SupremeRAID™ versus Linux MD RAID
The results are in! Turns out, SupremeRAID™ RAID 6 delivers more transactions per second than Linux MD RAID 10, while delivering nearly 2x faster rebuild speeds AND supporting 2-3X the number of concurrent users. ⚡ Read the white paper here.
Executive Summary
SupremeRAID™ by Graid Technology offers a higher-performance alternative for NVMe SSD data protection of database workloads like MySQL, especially compared to Linux MD RAID. The benefits are significant, with SupremeRAID™ RAID 6 delivering more transactions per second than Linux MD RAID 10 during optimal (non-degraded) and recovery (degraded) states. Also, SupremeRAID™ RAID 6 delivers almost 2x faster rebuild speeds than Linux MD RAID 10. The performance benefits of SupremeRAID™ are even more compelling when comparing similar RAID levels (e.g., RAID 6 with SupremeRAID™ vs. MD RAID).
About this Test
In this test, we will deploy a MySQL 8 server on SupremeRAID™ SR-1010 RAID 6, Linux MD RAID 10, and Linux MD RAID 6. We will use sysbench, a popular database benchmark tool, to perform the OLTP Read/Write test and evaluate RAID performance.
Testing Background
Hardware Specifications
Server: Dell PowerEdge R750 x 1
Processor: Intel® Xeon® Gold 6338 CPU @ 2.00GHz x 2
Memory: Samsung M393A4G43BB4-CWE 32GB DDR4 3200Mhz x 16
InnoDB Buffer Pool (BP): 32GB (about 32% of data cached in the buffer pool)
Worker threads:
innodb_buffer_pool_instances=48
innodb_page_cleaners=48
innodb_read_io_threads=32
innodb_write_io_threads=16
innodb_purge_threads=16
Testing modes in optimal and rebuilding 1 SSD states:
SupremeRAID™ RAID 6 with 8 SSDs and 4k chunks
Linux MD RAID 6 with 8 SSDs and 4k chunks
Linux MD RAID 6 with 8 SSDs and 16k chunks
Linux MD RAID 10 with 8 SSDs and 4k chunks
Linux MD RAID 10 with 8 SSDs and 16k chunks
Testing Result
The results show that SR-1010 RAID 6 can provide almost twice the performance of Linux MD RAID SR-1010 RAID 6 performance is competitive with Linux MD RAID 10 while providing more usable capacity and better data security.
Transactions Per Second in Optimal State
In the lower concurrent users test cases (from 64 to 256), MD RAID 10 performed well because it is not a parity-based RAID. Still, as the number of concurrent users increases, the SQL service consumes CPU resources and competes with MD RAID. This resource contention significantly drops performance to levels lower than SupremeRAID™ RAID 6. Compared to MD RAID 6, SupremeRAID™ RAID 6 is faster in all cases and can deliver more than twice the performance with high concurrent users.
RAID Configuration*
64 Users
128 Users
256 Users
512 Users
1024 Users
SupremeRAID™ RAID 10
8476.39
14627.62
19889.56
22048.90
14729.23
SupremeRAID™ RAID 6
7669.51
13408.26
18813.23
18878.61
13807.17
Linux MD RAID 10
9838.45
10510.42
10556.98
10221.50
8269.07
Linux MD RAID 6
8305.70
9872.39
8826.24
8455.82
8046.76
* RAID with 4K chunks.
Transactions Per Second in Rebuilding State
RAID performance declines during rebuilds because of degraded reading and rebuilding task workloads running in the background. Testing showed performance declined up to 22% for SupremeRAID™ configured for RAID 10 and up to 87% for MD RAID configured for RAID 10. With RAID 6, performance declined up to 50% for SupremeRAID™ and up to 95% for MD RAID. However, with SupremeRAID™ configured for RAID 6 performance remained similar to 9x higher than MD RAID configured for RAID 10 for all test cases.
RAID Configuration*
64 Users
128 Users
256 Users
512 Users
1024 Users
SupremeRAID™ RAID 10
7009.97
11803.37
15445.57
16119.14
14875.35
SupremeRAID™ RAID 6
3793.36
8384.43
12623.33
12953.34
11616.73
Linux MD RAID 10
3308.86
2441.16
1851.95
1370.23
1253.52
Linux MD RAID 6
466.36
484.88
471.77
598.75
973.79
* RAID with 4K chunks.
Rebuilding Speed
During rebuilding, although MD RAID 10 is not affected by degraded reads, its performance still dropped due to the rebuilding traffic. As for SupremeRAID™ RAID 10, which benefits from the computing power of GPU, performance dropped less.
SupremeRAID™ RAID 6 simultaneously maintained 12,953 transactions per second and 700Mb/s rebuilding throughput (about 2.5TB per hour) at 512 users. However, MD RAID 6 at 512 users supported just 598 transactions per second and 340Mb/s rebuilding throughout.
The performance of MD RAID 6 severely declines because degraded reading and rebuilding tasks consume many CPU resources to calculate parity.
RAID Configuration*
Transaction/Sec in Optimal State
Transactions/Sec in Recovery State
SSD Rebuild Speed (MB/s)
SupremeRAID™ RAID 10
22048.90
16119.14
880
SupremeRAID™ RAID 6
18878.61
12953.34
700
Linux MD RAID 10
15994.38
10108.93
420
Linux MD RAID 6
8455.82
598.75
340
* RAID with 4K chunks.
Conclusion
Databases like MySQL benefit from access to the fastest-performing storage possible, so using multiple NVMe SSDs with RAID for data protection is standard. Selecting SupremeRAID™ enables using more effective and efficient RAID 6 for data protection, delivering typically higher performance than Linux MD RAID 10.
Other benefits include:
Data loss prevention during the simultaneous failure of two SSDs.
50% higher usable capacity with 8 SSDs (75% higher with 16 SSDs).
Up to 85% faster transactions per second in RAID optimal state
Up to 28% faster transactions per second in RAID recovery state
Up to 945% faster transactions per second in RAID rebuilding state
Up to 66% faster rebuild rates with a low impact on performance.
About Graid Technology Graid Technology, creator of SupremeRAID™ next-generation GPU-based RAID, is led by a team of experts in the storage industry and is headquartered in Silicon Valley, California with an R&D center in Taipei, Taiwan. Designed for performance-demanding workloads, SupremeRAID™ is the world’s fastest NVMe and NVMeoF RAID solution for PCIe Gen 3, 4, and 5 servers. A single SupremeRAID™ card delivers up to 19M IOPS and 110GB/s and supports up to 32 native NVMe drives, delivering superior NVMe/NVMeoF performance while increasing scalability, improving flexibility, and lowering TCO. For more information on Graid Technology, visit Graid Technology or connect with us on Twitter or LinkedIn.
Learn more about award-winning GPU-based NVMe RAID controller SupremeRAID™ by Graid Technology. We’re ushering in the future of high storage capacity and extreme performance for mission critical and performance-demanding workloads. Contact us today to chat with a sales representative in your region.