Oracle girds MySQL for heavier Web usage

Oracle has issued a release candidate of the upcoming MySQL 5.6

Oracle is updating its widely used open source MySQL database, and a range of associated products, in order to meet the increasing demands of Web users.

In the past decade, "The Web has transitioned from just serving Web pages to actually providing critical services," said Tomas Ulin, Oracle vice president of MySQL engineering. "You expect your e-mail to always be available, for your Facebook account to always be available. Ten years ago, it was acceptable to hit reload on your browser. Now you expect your page to come up immediately."

For its first MySQL Connect conference, held over the weekend in San Francisco, Oracle has released a number of updates to its line of MySQL technologies. It has posted a release candidate (RC) for the next version of the database, MySQL 5.6, as well as a developer milestone of the next version of MySQL that runs across multiple servers, MySQL Cluster 7.3. It has also updated its MySQL Enterprise package for commercial clients. All these updates feature new technologies designed to boost database readiness.

The MySQL 5.6 RC offers a nearly complete version of MySQL 5.6, which will probably be released in its final state within the next few months. This version comes with a number of significant features. Through the use of the Memcached API (application programming interface), MySQL can now offer a speedy way to store and retrieve database entries, one that should rival the performance of NoSQL databases.

"We can get really good performant NoSQL access whilst having the strength and power of SQL. We think that is a unique offering," Ulin said.

Oracle also worked at making MySQL faster. The MySQL Optimizer has new techniques of selecting, sorting and returning results in a more efficient way. The underlying InnoDB storage engine has been refactored to handle concurrency better, which will make MySQL more suitable for heavily loaded OLTP (Online Transaction Processing) systems and read-only workloads. InnoDB also features full-text search, which should speed searches for words and phrases.

Another new feature that should please heavy users of MySQL is the new ability to execute DDL (Data Definition Language) operations without taking offline the database tables being changed. "If you want to alter your schema, add or drop a column to your schema, or rename a column, you typically had to bring down the database, alter it and bring it up," Ulin said. "With online DDL, you don't have to think about that. The table will be available through that period."

In addition to the MySQL 5.6 release candidate, Oracle also updated a number of related MySQL products.

The company has released the first Development Milestone Release (DMR) of MySQL Cluster 7.3, a version of the database for running a database across multiple servers. A DMR release has finalized a subset of features that will appear in the final release.

This DMR introduces native support for foreign keys. Long part of the SQL standard, foreign keys allow cross indexing of tables. Due to various architecture constraints in the clustered architecture, MySQL Cluster has not offered foreign keys, which left the work of tying together database tables to the application layer. Support for foreign keys should reduce the workload of the application developer, as well as provide a more foolproof method of securing database access to appropriate users.

"We know a lot of customers wouldn't consider a cluster without foreign keys," Ulin said. "It also adds a level of assurance when developing a program."

The software also includes a Node.js API for accessing the data directly, without transforming the query into SQL first. This method of JavaScript access joins the other existing NoSQL-like methods of accessing MySQL Cluster, including those based on Memcached, Java and HTTP.

MySQL Cluster 7.3 also features a new installer that can optimize workloads and automatically discover resources offered by the servers, such as the CPU architecture and the number of processor cores per machine.

Oracle has also updated its commercial version of the database, MySQL Enterprise Edition, with two new extensions. The software now provides the ability to provide reports for auditing and compliance. This extension offers policy-based monitoring and logging of all actions on a database. The second extension provides high availability (HA) safeguards, including automatic failover and replication.

The extension are available at no cost as part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition.

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

Join the Good Gear Guide newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection
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


PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

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.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?