Fusion-io Collaborates with Oracle to Double Usable Capacity for MySQL

New Flash-Aware NVM Compression Interface to Reduce Latency and Boost Usable Flash Memory Capacity by Up to 50% in the MySQL Database

SINGAPORE – April 7, 2014 – Fusion-io (NYSE: FIO) today announced collaboration with Oracle on the development of flash-aware interfaces for MySQL. These interfaces include NVM Compression, a flash-aware interface that can double the usable capacity of Fusion ioMemory flash while eliminating the performance impact associated with disk-era compression and Atomic Writes, an interface that enables more efficient database commits when running on flash memory. Together, these flash-aware interfaces allow MySQL to deliver up to 4x more flash endurance by streamlining commands to help optimize databases for persistent flash memory architectures.

Unlike disk-era compression techniques, flash-optimized 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-optimized 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 maximized as a memory tier that enables unique optimizations for cloud computing, big data, in-memory databases and high volume transactions. Fusion-io is pleased to collaborate with Oracle to make these interfaces available to the businesses that use MySQL database every day.”

“Oracle continues to lead MySQL innovation and is working with Fusion-io to deliver flash-aware application performance,” said Tomas Ulin, vice president of MySQL Engineering, Oracle. “The flash aware interfaces introduced by Fusion-io update disk-era commands with code streamlined for flash memory operations, significantly reducing latency and accelerating performance for modern web, cloud and embedded applications. Solutions like the flash-aware NVM Compression and Atomic Writes interfaces continue to push the boundaries of performance and efficiency for MySQL deployments around the world.”

The NVM Compression and Atomic Writes interfaces are now available in the MySQL 5.7.4 Development Milestone Release (for Atomic Writes) and as early access feature at labs.mysql.com for NVM Compression. Fusion ioMemory platforms for MySQL database acceleration are available from server vendors including HP, Cisco, Dell, IBM, and Supermicro.

Fusion-io Collaborates with MariaDB and Percona on New Flash Aware Interfaces to Increase Performance and Efficiency

Expanding the Architecture Advantages of Flash as Memory, New Flash-Aware NVM Compression Interface Reduces Latency and Boosts Usable Flash Memory Capacity by Up to 50% in Databases from Percona and SkySQL

SINGAPORE – April 3, 2014 – 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 databases for persistent flash memory architectures.

“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 emphasizes 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 emphasize 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 recognize Fusion-io’s continued leadership in providing hardware level storage optimization 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-optimized 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-optimized 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 maximized as a memory tier that enables unique optimizations 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.