Fusion-io claims to double MySQL capacity

Fusion-io announced NVM Compression, a flash-aware interface that the company claims can double the database capacity of ioMemory flash when using MySQL.

Fusion-io claims to have addressed both MySQL storage capacity and performance issues with the release of a new product, NVM Compression, a flash-aware interface. The goal is to make the best use of flash-based memory and flash-based storage devices.

What Fusion-io has to say about NVM Compression

Here's what the company has to say about its product

Fusion-io (NYSE: FIO) today announced NVM Compression, a flash-aware interface that can double the useable capacity of ioMemory flash while eliminating the performance impact associated with disk-era compression algorithms commonly used with flash SSDs. When integrated with the Atomic Writes interface, NVM Compression also delivers 4x more flash endurance by streamlining commands to optimize MySQL databases for persistent flash memory architectures.

With traditional disk storage, data compression significantly hinders database performance. Testing conducted by MariaDB MySQL database developer SkySQL showed that using the NVM Compression interface with the Fusion- io nonvolatile memory file system (NVMFS) doubled the useable capacity of the ioMemory server flash available to the database without affecting performance. As NVM Compression reduces undesirable write amplification, testing of longer workloads demonstrated that the MySQL database featuring NVM Compression became even faster than the traditional uncompressed database.

The NVM Compression and Atomic Writes interfaces are now in early access testing in MariaDB 10, Percona 5.6 and Oracle MySQL 5.7.4 DMR (for Atomic Writes) and a labs release for NVM Compression. Fusion ioMemory platforms for MySQL database acceleration are available from leading server vendors including HP, Cisco, Dell, IBM, and Supermicro.

Snapshot analysis

MySQL in all of its various forms has been a mainstay of Web-based applications for quite some time. One of the challenges application developers have faced is the increasing amount of information companies have wanted to store, and the performance today's applications require. They've turned to the use of flash-based memory caches and flash-based storage devices as a way to address both the growth and performance issues they face.

The challenge Fusion-io's NVM Compression is designed to address is the fact that flash memory used as a memory cache and flash memory used as a storage device have been architected differently. One is designed to address the requirements for low latency and the other has been designed to address the needs of high throughput. Fusion-io's NVM Compression is designed to make the best use of both types of storage.

While the claims are interesting, potential customers are advised to try out this technology using their own applications to determine what they'll see in real life.