Sun claims big leap with MySQL upgrade

April 14, 2008, 10:45 AM —  IDG News Service — 

MySQL developers should be
able to get their hands on a major update to the open-source database this week
when Sun Microsystems hosts its first MySQL conference since acquiring the company
earlier this year.

Sun will use the event in
Santa Clara, California, to release MySQL 5.1, an upgrade that adds several
new features to make the database more suitable for critical applications at
large enterprises.

"5.1, though it sounds like an incremental release, has got some pretty
major features," said Zack Urlocker, vice president for MySQL products
at Sun, in a
video posted to InfoWorld's Web site
this week. "Probably, we should
have called it 6.0, because there's so much stuff in there and we've been working
on it for a couple of years."

Among the advances in 5.1 are partitioning, events scheduling, row-based replication
and disk-based clustering. They are fairly standard features already offered
by rivals IBM, Oracle
and Microsoft,
but they should help MySQL compete in environments where performance and the
ability to scale are critical.

"One thing we're really most proud of is, frankly, we fixed a lot of outstanding
bugs in 5.0," Urlocker said. "So 5.1 has not only greater reliability,
but a performance increase of 20 percent. It will be more in some cases and
less in others, but there's a significant performance boost and scalability
enhancements."

MySQL had said it would release 5.1 in the first quarter, which ended March
31, and some developers have been getting impatient for the new release. "I'm
a little disappointed that Q1 is almost over and there's still no sign of MySQL
5.1," Andrew Poodle, who runs the MySQL user group in the U.K., said early
last month.

Other topics for discussion next week include which transactional engine MySQL
developers should focus on as they move forward. Most customers today use InnoDB,
but that software was acquired a few years ago by Oracle, and MySQL has been
developing an alternative, called Falcon, which is due for release with MySQL
6.0.

At the same time, Michael Widenius, one of the original developers of MySQL,
is developing a transactional engine called Maria, an early version of which
was released in January.

"The goal of the Maria development team is to make Maria to be the default
transactional engine for MySQL by MySQL AB. The Falcon team has the same goal
with Falcon engine. Let the best engine win :)" he wrote
in a blog post
before the Sun acquisition closed.

Developers will also be looking for an updated road map for MySQL, something
Sun has not given since it closed the US$1 billion acquisition in February.
And some will be looking for evidence that Sun won't interfere with MySQL's
open-source development model, something it has pledged not to do.

Sun does appear to be crafting the marketing message around Falcon, however.
The software will be "optimized for Web applications in a multi-core, multi-threaded
environment," Urlocker said in the video. Sun has been using similar language
in promoting its multi-core, multi-threaded server processors for running busy
Web sites.

Still, Poodle was positive about the acquisition. Sun is one of the few big
companies that have figured out how to offer free and paid products side by
side, and the deal should help MySQL break into the enterprise market, he said.
"I'm not saying MySQL is at a level where it can compete with the 'big
boys' in those markets, but it's getting there quickly," he said.

The MySQL
Conference & Expo
starts Monday. On Tuesday, Marten Mickos, the former
CEO of MySQL, and Sun CEO Jonathan Schwartz will give speeches about the future
of MySQL.

There is also a panel
with representatives from Flickr,
YouTube and Facebook
on the challenges of scaling MySQL to run busy Web sites. And a member of the
Swedish Pirate Party will talk about efforts
to fight copyrights
on software, which some see as a threat to open-source
development.

IDG News Service

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
Resources
White Paper

Symantec Backup Exec 12 and Backup Exec System Recovery 8 deliver industry leading Windows data protection and system recovery. Download this whitepaper to find out the top reasons to upgrade and how to get continuous data protection and complete system recovery.

Webcast

Data and system loss — from a hard drive failure, malicious attack, natural disaster, or simple human error — can happen anytime. Don’t leave your business vulnerable. Make sure you have a secure recovery strategy in place. Symantec's latest backup and system recovery technology can efficiently restore critical applications, individual emails and documents and even restore your entire system in minutes in the event of a loss.

White Paper

Businesses face a growing challenge to ensure that the IT environment is properly protected. Backup Exec 12 integrates with other applications in the Symantec family of products, to complement your current data protection strategy, keep your data securely backed up and make it recoverable when you need it most.

Free stuff

Crimeware: Understanding New Attacks and Defenses
By Markus Jakobsson, Zulfikar Ramzan
Published Apr 6, 2008 by Addison-Wesley Professional. Part of the Symantec Press series.
Enter now! | Official rules | Sample chapter

Securing VoIP Networks: Threats, Vulnerabilities, and Countermeasures
By Peter Thermos, Ari Takanen
Published Aug 1, 2007 by Addison-Wesley Professional.
Enter now! | Official rules | Sample chapter

Featured Sponsor

AISO founders envisioned a Web hosting company that was environmentally friendly. While the company employed energy-efficient innovations like solar panels, its infrastructure produced unacceptable power and cooling requirements. Find out how AISO leveraged AMD technology to overcome their challenge in this case study white paper.

In this whitepaper, Scalar explores the opportunity to change the landscape with respect to mission critical databases built around Oracle. Leveraging technologies such as Linux, high-end commodity processing power and Oracle RAC technology to architect, design, build and maintain database infrastructure that delivers maximum availability, reliability and performance at a fraction of traditional cost.

On a typical day, weather.com, the Web site for The Weather Channel in Atlanta, serves up between 15 million and 20 million page views. But in September 2004, when back-to-back hurricanes ransacked Florida, the peak traffic on one day more than tripled: over 70 million page views by more than 7 million unique visitors. Read the full success story now.

More Resources