MySQL 5.6 tackles NoSQL competitors

The new MySQL features a speedy memcached interface and dynamic table updating

With MySQL 5.6, released Tuesday, Oracle has updated the open-source database to make it more competitive with NoSQL data stores such as MariaDB or Cassandra.

"We're in constant dialogue with our customers and users, and they've shown interest in the NoSQL technologies," said Tomas Ulin, Oracle vice president of MySQL engineering. Oracle hopes MySQL can offer NoSQL speeds and scalability while still being a fully relational database.

"We can combine the best worlds. You don't have to split your data sets or have two databases," Ulin said.

During development of this latest release, which lasted about two years, Oracle accelerated work on a number of enhancements that should make MySQL more competitive with NoSQL data stores, which have grown in popularity over the past few years.

MySQL now offers a way to more quickly access data, by way of the Memcached API (application programming interface). MySQL doesn't actually use Memcached but harnesses its API -- familiar to many system administrators -- as an interface to fetch data directly from the database, without going through the database engine. The approach can deliver data up to nine times more quickly, for data that does not need to be parsed by SQL.

Another new feature that should give MySQL a bit more parity with NoSQL is the ability to execute DDL (Data Definition Language) operations without taking offline the database tables being changed. Administrators can alter a schema, add or drop a column, or rename a column, all without taking the database offline. NoSQL products have been praised for these sorts of dynamic schema updates, which MySQL will now offer as well.

Other new features in MySQL 5.6 include the ability to optimize subqueries, or nested queries, which can otherwise take prohibitively long to execute. The diagnostics are more comprehensive, through an expanded EXPLAIN query. The database also offers an index for full text searches, so searches can be done within large fields of text without actually doing a full table scan, which takes longer.

For high availability, MySQL 5.6 has global transaction identifiers, which simplify the process of failing over to a backup database server. The MySQL Workbench now includes a set of Python code that monitors master-slave database sets and can automatically switch operations to the backup server should the primary database fail.

The software can now run across 48-core servers, up from 32 cores in MySQL 5.5. While not many are running the database across such large systems, Oracle anticipates they will be in years to come. "We need to be a little bit ahead of the curve when scaling out," Ulin said.

Ulin wouldn't say what changes are coming in MySQL 5.7, saying the development team is still in the early planning stages.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags applicationsdatabasessoftwareOracle

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

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Kurt Hegetschweiler

Brother PocketJet PJ-773 A4 Portable Thermal Printer

It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?