Fusion-io recently announced that it would would be collaborating with Oracle on the development of flash-aware interfaces for MySQL. The new interfaces include NVM Compression and Atomic Writes. It is said that both flash-aware interfaces work together to enable MySQL to deliver 4x more flash endurance by “streamlining commands to help optimise databases for persistent flash memory architectures.”
Here’s what the company said about its new 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.
