VSL-Powered Software enables MySQL acceleration.October 13, 2011 -
When connecting VSL software to MySQL, Atomic Writes extension - operation in which processor can simultaneously write multiple independent storage sectors as single storage transaction - accelerates MySQL enterprise database and enables features powered by flexibility of flash architectures. In addition to eliminating need to utilize double write buffer, Atomic Writes reduces complexity and increases scalability due to use of less complex code paths within database.
Original Press release
Fusion-io
6350 South 3000 East 6th Floor
Salt Lake City, UT, 84121
USA
Fusion-io Unveils VSL-Powered Atomic Writes for MySQL Acceleration
Reference Architecture for Improving Performance in Enterprise Databases and Applications with New Flash-Powered Features to Support the MySQL Community
SAN FRANCISCO -- [Oracle OpenWorld] -- Fusion-io, Inc., (NYSE: FIO) pioneer of shared data decentralization, today announced a new extension to its VSL software subsystem for conducting Atomic Writes in the popular MySQL open source database. Referring to an operation in which a processor can simultaneously write multiple independent storage sectors as a single storage transaction, the Atomic Writes extension helps accelerate the popular MySQL enterprise database and enables new features powered by the flexibility of sophisticated flash architectures.
"Some vendors approach flash like just another disk, but this shortsighted approach leaves great potential unaddressed," said Nisha Talagala, Fusion-io Lead Architect. "With a software-centric approach, intelligent memory architectures can leverage the potential of flash to develop new features that accelerate databases and applications in ways previously not possible. By reducing the number of steps required to safely write data, the Atomic Writes software extension enables a substantial improvement in predictable performance and reduces the impact of database processing on the host CPU."
Atomic Writes allow flash-based memory to significantly outperform architectures that require applications to conduct additional operations to safeguard data during failures. Since Atomic Writes eliminate the need to utilize the double write buffer, performance speeds are drastically increased by not having to write data twice. This also reduces complexity and increases scalability as less complex code paths are used within the database. As the number of writes is cut in half by Atomic Writes, the software extension can also double hardware endurance. In addition, Atomic Writes ensure that operations are completed in their entirety, reducing the likelihood of data corruption and thereby increasing reliability.
The Atomic Writes extension connects Fusion's powerful VSL software architecture to MySQL to uniquely provide these enhanced features. The extension for MySQL is the first example of directly optimizing an application through the flexibility of VSL. With the new Atomic Writes extension, Fusion-io testing has observed 35 percent more transactions per second and a 2.5x improvement in performance predictability compared to conducting the same MySQL tests without the Atomic Writes feature.
To activate the Atomic Writes feature, database architects apply the extension to the InnoDB transactional storage engine for MySQL, which then creates a new InnoDB source image. The Atomic Writes extension selects operations that require Atomic Writes and then executes the operations accordingly. The Atomic Writes extension will be available to select customers for testing in Q4 2011. Fusion-io will collaborate with the MySQL community to assist with making the new Atomic Writes features accessible for widespread use as quickly as possible.
Visit Fusion-io booth #421 at Oracle OpenWorld in San Francisco October 3 - 6, 2011 for more information and demonstrations of the new Atomic Writes extension.
To learn more about Fusion-io, go to http://www.fusionio.com. Follow Fusion-io on Twitter at http://www.twitter.com/fusionio and on Facebook at http://www.facebook.com/fusionio.
About Fusion-io
Fusion-io has pioneered a next generation storage memory platform for shared data decentralization that significantly improves the processing capabilities within a datacenter by relocating process-critical, or "active", data from centralized storage to the server where it is being processed, a methodology referred to as data decentralization. Fusion's integrated hardware and software solutions leverage non-volatile memory to significantly increase datacenter efficiency and offers enterprise grade performance, reliability, availability and manageability. Fusion's data decentralization platform can transform legacy architectures into next generation datacenters and allows enterprises to consolidate or significantly reduce complex and expensive high performance storage, high performance networking and memory-rich servers. Fusion's platform enables enterprises to increase the utilization, performance and efficiency of their datacenter resources and extract greater value from their information assets.
|
|
|
|
|
|
|
| 
