Feeds

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

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

7 Elements of Radically Simple OS Migration

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. ®

Best practices for enterprise data

More from The Register

next story
Microsoft's Euro cloud darkens: US FEDS can dig into foreign servers
They're not emails, they're business records, says court
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
VMware builds product executables on 50 Mac Minis
And goes to the Genius Bar for support
Multipath TCP speeds up the internet so much that security breaks
Black Hat research says proposed protocol will bork network probes, flummox firewalls
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
Microsoft says 'weird things' can happen during Windows Server 2003 migrations
Fix coming for bug that makes Kerberos croak when you run two domain controllers
Cisco says network virtualisation won't pay off everywhere
Another sign of strain in the Borg/VMware relationship?
prev story

Whitepapers

7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
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.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
A new approach to endpoint data protection
What is the best way to ensure comprehensive visibility, management, and control of information on both company-owned and employee-owned devices?