Asia's Source for Enterprise Network Knowledge

Sunday, May 28th, 2017

Storage

Mangstor, Mellanox collaborate to deliver MySQL database acceleration over low latency storage

Mangstor NX-Series

Mangstor Inc., a developer of non-volatile memory storage solutions, and Mellanox Technologies, Ltd., a supplier of interconnect solutions for datacenter servers and storage systems, jointly announced extensions to the Mangstor NX-Series storage array portfolio that deliver clustered database workloads using a Mellanox 100Gb/s Remote Direct Memory Access (RDMA) network.

Mangstor’s NX-Series storage array platform is available in configurations of 10.8TB and 21.6TB of usable capacity, and supports industry standard Ethernet connectivity with network speeds up to 100Gb/s using Mellanox’s end-to-end RDMA over Ethernet (RoCE) solution featuring ConnectX-4 Network Interface Cards (NICs), Spectrum switch, and LinkX cables.

The result is an NVMe over Fabric (NVMf) storage solution that provides high bandwidth, low latency flash storage connectivity using minimal server compute resources.

StorageReview labs benchmarked the scalable NX6325 Storage Array in a 32-node virtualized Percona MySQL cluster that distributed the dataset, tempDB file, and log files across 330GB volumes. Testing was performed across a range of nodes, from 4 to 32. Outstanding transactional performance, with low latency, was seen across the range of testing. The NX-Series array delivered a total aggregate performance of more than 38,000 transactions per second (TPS) in the 32-node test.

These results represented over 2.5x faster performance than the next closest shared storage array tested by StorageReview. The latency not only performed extremely well under load, but maintained consistent overall MySQL transactional latency of 14.3ms for a 4 Virtual Machine (VM) node cluster to 26.6ms for a 32 VM node cluster. Though the load ramped up by 8x when going from 4-node to 32- node testing, the latency did not even double. 

“Reducing time to results of MySQL database applications is key to increasing business efficiency for many companies. Low latency data response times from storage enables more OLTP transactions per second without increasing user response times,” said Paul Prince, CTO for Mangstor. “We’re particularly pleased with these results as it shows the ability to bring the fantastic performance of Mangstor NVMf storage to an environment using a cluster of Virtual Machines. This now means that companies choosing to operate MySQL in a virtualized environment can benefit from NVMf storage performance.”

“Using RoCE to transfer data from application servers to storage servers in high-speed and low latency scale-out architectures, bypasses the lower level SCSI transport layer, which eliminates bottlenecks and maximizes overall datacenter efficiencies,” said Motti Beck, senior director enterprise market development at Mellanox. “This joint NVMf storage solution allows customers to fully leverage their existing datacenter infrastructure and operational practices over 10/25/40/50/100 GbE networks.”

The solution features Mangstor’s TITAN NVMf storage software enabling IT managers to dynamically provision shared flash storage via a REST-based API and GUI tools so that large clusters of NVMf storage can be managed efficiently to meet the needs of scalable database cluster environments.