The latest second generation of Dell Acceleration Appliance for Databases (DAAD 2.0) storage node comprises of a Dell PowerEdge R730 server, four Fusion Atomic SX300 series ioMemory PCIe flash adapters, and an updated DAAD ION Accelerator software. DAAD 2.0 storage node will be available in two different capacity flavors—12.8 TB using four 3.2 TB ioMemory PCIe flash adapters and 25.6 TB using four 6.4 TB ioMemory PCIe flash adapters. Both the capacities of DAAD 2.0 will support three different fabrics—Fibre Channel, iSCSI, and Infiniband/SRP.

This whitepaper provides an overview and the configuration details of the Fibre Channel-based DAAD 2.0 reference architecture. This whitepaper is an update to the reference architecture that was done as part of the previous study with DAAD 1.0 that can be found here. It also provides the performance results, analysis, and the improved results of both the capacity flavors of DAAD 2.0 over DAAD 1.0.

The solution described here is a high-availability-enabled, two-node, DAAD storage that uses the Fibre Channel storage protocol. DAAD 2.0 was able to deliver the following performance with the described reference architecture in this whitepaper:

  1. With Iometer synthetic benchmarking, DAAD 2.0 scaled up to nearly two million IOPS for the 4K Random Read workload, which is nearly double the IOPS performance when compared to DAAD 1.0 while keeping the latency under 3 ms.
  2. With CalibrateIO benchmarking tool, DAAD 2.0 scaled up to 12 GB per second (GBps) read throughput for the 1 MB sequential read workload, which is about 1.5 times the performance of DAAD 1.0.
  3. With CalibrateIO benchmarking tool, DAAD 2.0 scaled up to nearly 6 GBps write throughput for the 1 MB sequential write workload, which is about 1.4 times the performance of DAAD 1.0.
  4. Throughput (GBps) scaled linearly with up to four database nodes stressing a pair of highly available DAAD 2.0 storage nodes.
  5.  Using HammerDB benchmarking tool, DAAD 2.0 scaled over a million New Orders per Minute (NOPM) for TPC-C-like workload with an Average Response Time (ART) of about 10 ms.
  6. About 15–20% improvement in NOPM performance over DAAD 1.0