Oracle previews MySQL 5.6

The next version of MySQL will offer better replication and a sneak preview of NoSQL-like fast accessibility

Offering a glimpse of the new features some database administrators will be working with before too long, Oracle has posted a preview version of the next MySQL relational database management system.

The Development Milestone Release (DMR) for MySQL 5.6 comes with a number of new and still experimental features for the open source database system, including improved replication and the ability to bypass the SQL framework for faster data access.

As part of the open source LAMP stack -- which also includes Linux, Apache and Perl, Python and PHP -- MySQL is widely used in Web applications. Large, popular sites such as Twitter, Facebook and Flickr use MySQL.

With this pending version of MySQL 5.6, Oracle and outside developers have strengthened the way the software handles data replication, as well as potentially shortening the software's response times to complex queries.

In regards to replication, MySQL introduces Global Transactions Identifiers (GTIDs), which assure the system can track data as it is replicated across different servers. GTIDs will ease the process of automatically switching to a duplicate server should the original fail. Third-party software now offers this capability, but this will be the first time MySQL itself can do the job.

MySQL 5.6 offers a number of new features that should speed queries. It can now consolidate multiple queries or result sets into a single unit of work. It can assign the current date and time as the default for DATETIME columns, eliminating the need for the application to do that work itself. The software can also speed query time by determining the best order of execution for Filesort and ORDER BY queries.

Another new benefit for developers: MySQL can also deliver query results in the popular JSON (JavaScript Object Notation) format, useful for integrating data to Web applications.

In addition to these new features, which will be ready for production duty with the full release of MySQL 5.6, the software also includes some experimental features that may appear in future versions of the software, courtesy of Oracle's MySQL Labs. Developers can test them now to see how well they work.

Perhaps the most notable feature is an API (application programming interface) that allows applications to directly access data from the core InnoDB database engine, rather than going through the SQL-based interface. The API replicates the interface of the open source memcache caching technology used by Facebook and others for speedy access to large amounts of data.

Such an API may bring MySQL on par with the easy accessibility offered by NoSQL databases currently gaining favor in Web applications, said Tomas Ulin, Oracle vice president of MySQL engineering,in an interview last year.

Another experimental improvement aimed at making MySQL more suitable for NoSQL database duties is a new set of ADD operations that allow an application to write data to the database without blocking other operations from accessing the database index when adding their own data. Such a feature could be beneficial for the operations of rapidly evolving Web services, according to Oracle.

Oracle did not reveal when it expects to release the final version of MySQL 5.6 The last major upgrade, version 5.5, was released in December 2010.

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Father’s Day Gift Guide

Brand Post

PC World Evaluation Team Review - MSI GT75 TITAN

"I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it."

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?