STORAGE SYSTEM SPECIALIST Fusion-IO has increased the potential capacity of its SSD storage subsystems in MySQL database environments by performing data compression on the fly.
Non volatile memory (NVM) data compression has always been a feature of MySQL, however it has always come at the price of significant performance degradation.
The Fusion-IO NVM interface has overcome this performance issue to increase potential SSD capacity, in some cases doubling it, while reducing I/O activity and significantly increasing SSD drive longevity.
NVM is fully compatible with the company's existing Atomic Writes interface, which is designed to write simultaneous in-out transactions as a single instruction. The two used in tandem can boost I/O speeds and reduce data I/O workloads by up to 80 percent, according Fusion-IO VP of Product Gary Orenstein.
Speaking to The INQUIRER ahead of Tuesday's announcment, Orenstein said, "We're breaking new ground, no doubt. And it's not just about MySQL - we are interested in increasing Flash awareness.
"Many applications are still based on the assumption by programmers that they will be writing and reading a physical disk. By showcasing the differences possible by working directly with Flash we hope to provide even more innovation in the future."
Fusion-IO is working with Percona, MariaDB and Oracle on the rollout and possibilities to pursue further work in the field.
"We believe it could be a much bigger trend," said Orenstein. "There's the possibility to optimise the whole stack."
SSD storage in data centre environments is becoming more mainstream as the Internet of Things takes off. Also on Tuesday, Sandisk announced four enterprise grade SATA SSD drives for data centre use. µ