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 Good Gear Guide newsletter!

Error: Please check your email address.

Tags applicationsdatabasessoftwareOracle

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

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 News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?