Channels ▼
RSS

Wozniak's Software Optimized Database Acceleration


The MariaDB open source database team and software optimized storage company Fusion-io have partnered on atomic writes capabilities. Atomic writes refers to an operation in which a processor can simultaneously write multiple independent storage sectors as a single transaction.

More Insights

White Papers

More >>

Reports

More >>

Webcasts

More >>

This new function claims to achieve performance and cost savings through a "flash-aware architecture", further differentiating MariaDB from more expensive proprietary databases.

NOTE: Steve Wozniack is chief scientist at Fusion-io.

Atomic writes prevent data losses from MariaDB (and related) databases in certain infrequent events, such as an unexpected power outage midway through a database transaction, without the need for mechanisms like the "double write buffer" that reduces speed and the life of flash media.

MariaDB team blogger Axel Schwenke explained that currently, in order to use atomic writes, it is necessary to use the DirectFS file system, which is a part of the Fusion IO SDK. "Wlad Vaintroub from Monty Program AB, in cooperation with FusionIO developers, implemented the necessary changes in InnoDB/XtraDB to use the new feature," writes Schwenke.

The MariaDB engineering team used Fusion-io's flash-aware APIs to optimize the InnoDB and XtraDB storage engines for atomic writes. The resulting scalable solution uses the underlying flash translation layer for atomicity of database updates.

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

Fusion-io's Nisha Talagala said that with a software-centric approach, her team can leverage the potential of flash to develop new features that accelerate databases and other applications in ways previously not possible.


Related Reading






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 


Video