Fusion-io Atomic Writes APIs Now in Use by Leading MySQL Databases

Flash memory storage supplier Fusion-io has announced a new milestone in the development and acceleration of flash-aware applications. Leading MySQL Databases Now Feature Atomic Writes.

The Fusion-io Atomic Writes API, contributed for standardization to the T10 SCSI Storage Interfaces Technical Committee is now in use in mainstream MySQL databasesMariaDB 5.5.31 and Percona Server 5.5.31 as well as the upcoming Percona Server 5.6.

Fusion-io“A flash-aware application optimizes the placement, movement, and especially the processing of data with awareness of NAND flash in the memory hierarchy, and offers configuration options for leveraging the properties of flash memory to improve performance, manageability, and return on investment,” said Pankaj Mehra, Fusion-io Chief Technology Officer. “With flash-aware applications, developers can eliminate redundant layers in the software stack, deliver more consistent low latency, more application throughput, and increased NAND flash durability, all with less application-level code. Complementing our ongoing standards work, we are pleased to make NVMKV and the Linux Demand Paging Extension available to the open source community.”

The latest releases of MySQL databases MariaDB and Percona Server deliver the option for flash-aware operation. These two popular MySQL distributions are the first enterprise applications to ship using Atomic Writes, streamlining the software stack by replacing the need to write twice to maintain atomicity, or database ACID compliance.

MariaDB products

“Increasingly our customers expect MariaDB products to not just compete with, but to exceed what they can get from rival database technologies,” said Monty Widenius, MariaDB creator. “The highly innovative solutions we have worked on with the Fusion-io Atomic Writes API are a great example of how both companies are bringing the best thinking to the best database in the world.”

By enabling a processor to simultaneously write multiple independent storage sectors as a single storage transaction, Atomic Writes streamlines data writes to improve performance and extend the life of flash memory. In I/O intensive workloads, Atomic Writes provides performance throughput increases up to 50%, as well as a 4x reduction in latency spikes, compared to running the databases on the same flash memory platform without Atomic Writes. Fusion-io is also extending the general purpose Linux I/O layer to allow these mainstream file systems to make the benefits of Atomic Writes accessible to a wider variety of applications.

Fusion-io’s flash memory platform and software defined storage solutions accelerate virtualization, databases, cloud computing, big data and performance applications. From e-commerce retailers to the world’s social media leaders and Fortune Global 500 companies, Fusion-io customers are improving the performance and efficiency of their data centers