Fusion-io collaborates with MariaDB and Percona

“From each email we send to every song we listen to online, databases manage our ever-expanding information that must be processed and stored,” said Monty Widenius, creator of MariaDB. “The NVM Compression interface introduced by Fusion-io emphasises how flash architected as a memory for application acceleration goes far beyond the capabilities of SSDs. The results MariaDB saw in testing NVM Compression were astounding, and it’s very exciting to deliver new innovation in flash-aware database performance with Fusion-io.”

“Solutions like the flash-aware NVM Compression and Atomic Writes interfaces integrate powerful software-defined features that enhance the efficiency and effectiveness of modern IT architectures, making flash an even more essential addition to the data center,” said Eric Burgener, Research Director for IDC's Storage Practice. “While much of the rest of the industry is looking at flash as a replacement for disk, these flash aware interfaces emphasise how Fusion-io is architecting flash as a replacement for memory.”

With traditional disk storage, data compression significantly hinders database performance. Testing conducted by MariaDB 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 MariaDB database featuring NVM Compression became even faster than the traditional uncompressed database.

“Database compression provides the valuable ability to store more information in a limited storage capacity and reduces TCO of database management systems," said Peter Zaitsev, Percona CEO and Co-founder. "We recognise Fusion-io’s continued leadership in providing hardware level storage optimisation for databases and leverage that expertise when possible. We integrated both the flash-aware NVM Compression interface and Atomic Writes into Percona Server to ensure maximum capacity as well as maximum performance when used with Fusion-io flash memory products. We see this as enabling Percona Server users to enjoy lower total ownership costs and enhanced performance."

Unlike disk-era compression techniques, flash-optimised NVM Compression shares the vast majority of the application code with the traditional uncompressed database logic. By leveraging the underlying architecture of flash as a memory tier, NVM Compression significantly reduces the complexity of storage engines, which allows for improved scalability and higher efficiency.

In addition, the well-defined interface of NVM Compression allows developers to quickly introduce flash-aware compression to their applications using versatile workload-optimised compression algorithms. Once integrated into an application, NVM Compression enables developers to help enterprises scale their IT infrastructure to meet increasing data demands by effectively balancing storage efficiency with customer workload performance requirements.
“Flash-aware interfaces like NVM Compression and Atomic Writes underline the significant divide between flash as a memory and flash SSDs,” said Fusion-io Chief Technology Officer Pankaj Mehra. “The value of enterprise flash memory is maximised as a memory tier that enables unique optimisations for cloud computing, big data, in-memory databases and high volume transactions. Fusion-io is proud to collaborate with MariaDB and Percona to make these interfaces available to the businesses that use these databases every day.”

The NVM Compression and Atomic Writes interfaces are now in early access testing in MariaDB 10 and Percona 5.6. Fusion ioMemory platforms for MySQL database acceleration are available from leading server vendors including HP, Cisco, Dell, IBM, and Supermicro. The NVM Compression interface and other flash-aware interfaces led by Fusion-io are being showcased at the Percona Live conference April 1-4, 2014. For more information on flash-aware interfaces, visit Fusion-io in booth 200 at Percona Live 2014.