Feeds

MySQL daddy Monty talks up Fusion-io's data-stuffed flash

Compressed tech's 'astounding' (on MariaDB, natch)

Boost IT visibility and business value

Fusion-io can cram more data into its ioMemory flash storage without cramping performance – at least that’s what it’s claiming about its NVM Compression technology.

We are told NVM Compression is “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.”

If it is “integrated with the Atomic Writes interface, NVM Compression also delivers 4x more flash endurance by streamlining commands to optimise MySQL databases for persistent flash memory architectures.”

The MariaDB Foundation announced the general availability of MariaDB 10 on 31 March and it is “many times faster than previous generations of MariaDB and especially legacy database MySQL thanks to new features including parallel replication and a further advanced group commit.”

An effective capacity doubling was achieved using NVM Compression with MariaDB and MySQL. Michael "Monty" Widenius, the creator of MySQL and MariaDB, was pleased: “The results MariaDB saw in testing NVM Compression were astounding, and it’s very exciting to deliver new innovation in flash-aware MySQL performance with Fusion-io.”

NVM Compression will also boost usable flash memory capacity by up to 50 per cent in MySQL databases from Oracle, Percona and SkySQL.

Fewer writes, faster execution

Fusion-io claims NVM Compression reduces undesirable write amplification and testing of longer workloads “demonstrated that the MySQL database featuring NVM Compression became even faster than the traditional uncompressed database.” Fewer writes means faster overall execution.

Happy bunny Peter Zaitsev, Percona’s CEO and co-founder, provided a quote for Fusion-io’s announcement: "We integrated both the flash-aware NVM Compression interface and Atomic Writes into Percona Server to ensure maximum capacity as well as maximum performance ... We see this as enabling Percona Server users to enjoy lower total ownership costs and enhanced performance."

The Fusion-io pitch is that it’s only because its flash is used as a memory tier that this non-performance limiting and even performance-boosting compression is possible: it can’t be done with SSDs.

Here’s Fusion-io’s CTO Pankaj Mehra on that topic: “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 wants developers to know that NVM Compression allows them “to quickly introduce flash-aware compression to their applications using versatile workload-optimised compression algorithms.”

Fusion-io needs to get app developers on board and using its PCIe flash rather than, for example, flash cards from LSI, Micron and others. Delivering APIs to make their software run faster on Fusion's flash should be an effective way of doing that.

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. The NVM Compression interface is being shown at the Percona Live MySQL conference, taking place now (1 to 4 April 2014). You can visit Fusion-io in booth 200 if you manage to get down to the Santa Clara venue. ®

The essential guide to IT transformation

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Oracle reveals 32-core, 10 BEEELLION-transistor SPARC M7
New chip scales to 1024 cores, 8192 threads 64 TB RAM, at speeds over 3.6GHz
US regulators OK sale of IBM's x86 server biz to Lenovo
Now all that remains is for gov't offices to ban the boxes
Flash could be CHEAPER than SAS DISK? Come off it, NetApp
Stats analysis reckons we'll hit that point in just three years
Object storage bods Exablox: RAID is dead, baby. RAID is dead
Bring your own disks to its object appliances
Nimble's latest mutants GORGE themselves on unlucky forerunners
Crossing Sandy Bridges without stopping for breath
prev story

Whitepapers

5 things you didn’t know about cloud backup
IT departments are embracing cloud backup, but there’s a lot you need to know before choosing a service provider. Learn all the critical things you need to know.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Build a business case: developing custom apps
Learn how to maximize the value of custom applications by accelerating and simplifying their development.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.