MySQL AB has laid out its software road map through 2009, including some code contributed by Google and security improvements that are due in MySQL 7.0.

Earlier this year Google signed a Contributor License Agreement, which provides the legal framework under which MySQL can include code from another company in its database, MySQL co-founder and Vice President David Axmark said Tuesday.

Google is secretive about the distributed architecture underlying its services, but it's known to be one of MySQL's biggest users, running hundreds or even thousands of its databases worldwide.

The search company has done a lot of work customizing MySQL to meet its special needs, which include better database replication and tools to monitor a high volume of database instances, Axmark said in an interview at MySQL's user conference in Paris.

MySQL will include some of those capabilities in future versions of its database, probably in point upgrades to MySQL 6.0, which is scheduled for general availability in late 2008, Axmark said.

Google benefits because the add-ons become part of the official MySQL product and are included in big fixes and future upgrades. MySQL could benefit from some of Google's custom software, though it requires considerable work by the database vendor.

"It takes time to analyze what's relevant for everyone, what's doable, and how can we work it into a new version," said Kaj Arno, MySQL vice president for community relations. "There's huge potential, but there's also lots of work."

Google develops the add-ons only for the operating system it uses, Linux, so MySQL will need to port, test and document the additions for the 15 or so OSes it supports.

The features in MySQL 6.0 are fairly set, Axmark said, so the Google code won't appear before Version 6.1, due in early 2009. Some Google code is in the source code for MySQL 4.1, he said, but not in a supported MySQL product.

The companies are in close contact, Axmark said. The Google engineer in charge of its MySQL deployments spent several days at MySQL's internal developer meeting in Heidelberg, Germany, last month. Google has also released source code for some MySQL tools it developed.

At its developer event in Paris, MySQL laid out an unusually long roadmap stretching to MySQL 7.0, which will be generally available in late 2009 and focus on security improvements for enterprise users.

"Many of you have told us you want better security in the database, and we have listened," Robin Schumacher, MySQL director of product management, told developers.

Many of the features are standard in more mature databases from IBM and Oracle, Schumacher acknowledged in an interview. MySQL positions itself as a low-cost alternative to those products, with less sophisticated features that are sufficient for most users, most of the time.

Schumacher said Version 7.0 will support role- and group-based security, which allows administrators to set privileges for groups of users centrally instead of individually. It will also have "transparent data encryption" built into the database, so developers don't have to include it at the application level.

MySQL hopes the security features will win it financial, government and retail customers, some of whom add the capabilities themselves. "If we get the door slammed in our face in an account, this is one of the reasons it happens," Schumacher said.

In the nearer term, MySQL 5.1 is scheduled for general availability in the first quarter next year. Advances include table and index partitioning, which should boost data-warehousing performance, and the option of row-based replication, which lets companies create more exact back-up replicas.

The IDG News Service is a Network World affiliate.

Whitepapers

• 6 Simple Steps to Disaster Recovery Planning
• Boost Productivity While Cutting Costs with Next-generation Collaboration
• Deploying Virtualized NetWare on Linux Whitepaper
• Driving Business Success Through Workgroup Choice and Flexibility
• Toward More Flexible, Next-Generation Collaboration Solutions
• Collaboration Tools and Organizational Success Whitepaper

View more SOFTWARE whitepapers

Webcasts

• Managing the End User Experience-A Real World Example of Success
• Lowering the Cost of Email Archives
• Google Webcast: Why archive email? Top challenges and best practices
• Webcast: What's your domain's reputation?
• Webcast: Improve your network with unified Gigabit gear

View more SOFTWARE webcasts

Special Reports

• Executive Guide: Virtualization Reality Check
• WAN Optimization: The Ultimate No Brainer
• Keeping Spam at Bay
• Application Performance Management Executive Guide
• Executive Guide: Building a Service Oriented Architecture
• IT Buyers Guide To: Collaboration

View more SOFTWARE special reports