Product

MySQL is an open-source relational database management system used in many high-profile websites globally.
REQUEST A POC
ScaleFlux MySQL Acelerated AB
MAR 06 / 2021 PDF
Percona: Testing the value of CSD 2000 for MySQL
MAR 06 / 2021 PDF
CSD 2000 Application Brief: MySQL (CN)
MAR 06 / 2021 PDF
CSD 2000 Application Brief: MySQL
MAR 06 / 2021 PDF

MySQL

 

50% SAVINGS ON FLASH COST

DATA PATH COMPRESSION & DECOMPRESSION

ScaleFlux’s implementation of data path compression and decompression in the CSD 2000 allows users to capture the cost/GB savings of data compression without sacrificing performance!

In the example shown here, we formatted a CSD 2000 with 4TB of physical NAND to 6.4TB of user capacity. Then, we ran TPC-H tests using a 4.8TB data set against both the CSD 2000 and a leading 6.4TB NVMe SSD (8TB physical NAND). On both Transactions per Second (TPS) and average latency, the two solutions were neck and neck. However, the CSD 2000 provides users 6.4TB at half the cost of the NVMe solution.

CSD 2000 delivers Penalty-Free Compression:

  • Half the cost to achieve 6.4TB of SSD storage
  • Throughput scales with each drive – no CPU bottleneck
  • Similar performance to leading NVMe SSDs
  • Unburdens the CPU from cumbersome data compression tasks

 

38% LOWER LATENCY

SYSBENCH READ-WRITE LATENCY SIGNIFICANTLY IMPROVED BY COMPUTATIONAL STORAGE

 In the example shown here, we formatted a CSD 2000 with 4TB of physical NAND to 3.2TB of user capacity. Then, we ran TPC-H tests using a 2.4TB data set against both the CSD 2000 and a leading 3.2TB NVMe SSD (4TB physical NAND). The CSD 2000 outperformed the NVMe SSD on both Transactions per Second (TPS) and 99% Latency - up to 50% higher TPS and 38% lower latency!