The Artima Developer Community
Sponsored Link

Java Community News
MySQL Releases Maria, a New Open-Source Storage Engine

1 reply on 1 page. Most recent reply: Jan 29, 2008 11:57 AM by Morel Xavier

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 1 reply on 1 page
Frank Sommers

Posts: 2642
Nickname: fsommers
Registered: Jan, 2002

MySQL Releases Maria, a New Open-Source Storage Engine Posted: Jan 28, 2008 7:12 PM
Reply to this message Reply
Summary
MySQL creator Monty Widenius released a new transactional storage engine for the open-source database system. The new storage engine, code-named Maria, has many enterprise-class features for data safety and performance.
Advertisement

Ever since Oracle acquired InnoDB, the company behind its namesake transactional storage engine, MySQL users have been wondering what new transactional storage engine the makers of the open-source database server would provide as a replacement.

Today, MySQL creator Monty Widenius released the 1.0 version of Maria, which, in Widenius' words, is:

A crash-safe alternative to MyISAM. That is, on crash, Maria will, on mysqld restart, recover all tables to the state at the start of a statement or at the start of a previous LOCK TABLES.

The significance of MySQL's modular architecture, and the various storage engines that make use of that modularity, are explained by Mike Peters in MySQL Storage Engines. Noting that:

A well designed MySQL-powered application will use different storage engines for different tables...

Peters explains that:

One of the greatest things about MySQL, other than being free, widely supported and fast, is the flexibility of choosing different storage engines for different tables...

Out of the box, MySQL comes with 7 storage engines, including an "example" stub storage engine that allows you to implement your own storage library. Every storage engine is completely different, designed to address a unique application need. Not being locked down to a single storage engine (like Oracle), means you can optimize and choose the best tool for the job...

The most popular storage engine is the default MyISAM, written by Widenius, that has no transaction support, and trades some reliability for higher performance in read-mostly applications. InnoDB is a transactional engine that provides locking at the row-level, but is now being developed by Oracle. NDB is another storage engine, designed by Ericsson, that provides replicated and clustered operations, but limited database sizes. Additional engines include an in-memory engine for temporary tables, and an archive engine for storing data without indexes.

Maria fills the role of a highly reliable, transactional, open-source storage engine. Widenius points out that Maria provides:

  • ACID
  • Commit/Rollback
  • Concurrent selects (thanks to MVCC)
  • Row locking
  • Group commit

The goal of Maria, according to Widenius, is:

To create a new, ACID and multi-version concurrency Control (MVCC), transactional storage engine that can function as the default non-transactional and the default transactional storage engine for MySQL... To be a MyISAM replacement. This is possible as Maria can also be run in non-transactional mode, supports all row formats as MyISAM and supports or will support all major features of MyISAM... Maria to be standard part of MySQL 6.X

To what extent do you take advantage of database-level features in your applications? And to what degree are you willing to trade application portability for higher performance?


Morel Xavier

Posts: 73
Nickname: masklinn
Registered: Sep, 2005

Re: MySQL Releases Maria, a New Open-Source Storage Engine Posted: Jan 29, 2008 11:57 AM
Reply to this message Reply
> <p>Maria fills the role of a highly reliable,
> transactional, open-source storage engine. Widenius points
> out that Maria provides:</p>
>
>
> <blockquote>
> <ul>
> <li>ACID</li>
> <li>Commit/Rollback</li>
> <li>Concurrent selects (thanks to MVCC)</li>
> <li>Row locking</li>
> <li>Group commit</li>
> </ul>
>
> </blockquote>
>

No offense Frank, but you read it completely wrong. He points out that Maria does *not* provide these but that they're planned for version 2.0

In fact, the only thing he points to is that compared to MyISAM Maria provides automatic crash recovery. Period.

Flat View: This topic has 1 reply on 1 page
Topic: Bill Venners on the Rise of Scala Previous Topic   Next Topic Topic: The Busy Java Developer's Guide to Scala


Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2014 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us