03 May FlashGrid on eight NVMe SSDs obliterates XtremIO and Violin in SLOB performance
After reading this white paper many people asked a logical question – how about write throughput? Well, to make the numbers meaningful we have to compare FlashGrid results with alternatives. But the publicly available performance specs for flash arrays are not very helpful in estimating write-intensive Oracle DB throughput (unlike the read-only CalibrateIO results that we can directly compare against the published specs). And buying a flash array just to run performance tests was not in our plans. That’s why we were so happy to find two sets of SLOB performance results on XtremIO and Violin.
Thank you, Principled Technologies and FlashDBA.com !
In case you are not familiar with it, SLOB is a popular tool in the Oracle DB community for benchmarking storage performance. It generates OLTP-like workload with most of the stress on storage.
Here is the summary of the results.
XtremIO Violin 6616 SLC FlashGrid (2 RAC nodes, 8 SSDs) Write n/a 320 MB/s 950 MB/s Read n/a 1520 MB/s 3900 MB/s Total n/a 1840 MB/s 4850 MB/s IOPS 118,000 229,000 545,000
SLOB 2.3 workload profile: db_block_size=8kb, UPDATE_PCT=25 (20 on XtremIO), REDO_STRESS=LITE
FlashGrid setup details:
- 2 x Dell R730xd, Dual Intel Xeon E5-2667 v3, 8 cores @3.2GHz, 48 GB DRAM
- Dual-port Mellanox ConnectX-3 at 40 Gb/s
- 2 x 4 Intel DC P3500 400GB SSD
- Oracle Linux 7.2
- Oracle Grid Infrastructure 220.127.116.11
- Oracle Database 18.104.22.168
- FlashGrid 16.3
Note that in the FlashGrid configuration we used just eight (four per node) Intel P3500 400GB NVMe SSDs. The total storage hardware cost was less than $7,000 even after adding dual-port InfiniBand adapters. We are planning to run a similar test with more SSDs and 100 Gb/s InfiniBand. In the meantime we wanted to share the results we already had. We welcome flash array vendors to publish their latest and greatest results (along with the price tag), so we can do more comparisons.
Do you have servers with NVMe SSDs? We can help you with configuring FlashGrid and running SLOB and we can publish your results. Email us at [email protected]