MySQL Adds Scalability to Open Source Database

The same week Oracle announced plans to acquire Sun Microsystems for $7.4 billion, MySQL, one of Sun's own recent acquisitions, unveiled the next version of its popular open source database.

MySQL 5.4, which the company said will offer significant scalability improvements among several new features, was unveiled at this week's seventh annual MySQL Conference & Expo in Santa Clara, CA. The new version is set for release by year's end (with a preview version available for download here) and is designed to enable the database's storage engine, InnoDB, to scale up to 16-way x86 servers and 64-way CMT servers. Version 5.4 also comes with JOIN enhancements and new subquery optimizations. The result, the company said, is 90 percent better response times in certain situations.

"I know it was a long time in coming," said Karen Tegan Padir, newly installed vice president of Sun's MySQL and Software Infrastructure Group, in the conference's opening keynote address. "But it was worth the wait."

Padir said the long-anticipated MySQL upgrade "will transparently increase the performance and scalability of your applications to enable them to scale under more demanding user and data processing loads" without any modifications to existing applications. She added that MySQL 5.4 is better suited for scale-up deployments on SMP systems.

Padir reassured the standing-room-only crowd that MySQL, which was acquired just a year ago by Sun for $1 billion, would be safe in Oracle's hands. "I will continue to be a champion for open source no matter who the owner of MySQL is," she said. "MySQL's ubiquity absolutely transcends whoever is the steward of that technology." Padir cited some numbers to support that claim to ubiquity, saying that MySQL now has more than 12 million users of the database, more than 70,000 downloads per day and more than 1,000 partners in the MySQL ecosystem.

MySQL might even fare better at Oracle than it has at Sun, said Jonathan Eunice, principal IT advisor at Illuminata. "People who have been hoping that Sun would steer MySQL in the right direction were very disappointed," Eunice said.

As a database company, Oracle is actually better-suited to support MySQL, Eunice said, though he wonders how the company will deal with MySQL's evolution from lightweight database to enterprise database. "I doubt that Oracle will allow it to become an enterprise database," he said.

Under Sun's stewardship, MySQL had forked into several projects, including Drizzle, a fork of MySQL 6.0, and MariaDB, a fork of the database that uses the Maria transactional storage engine. MySQL creator Michael "Monty" Widenius is one of the creators of MariaDB.

Forking is the sign of a robust developer community, argued Kaj Arnö, vice president of community relations in Sun's MySQL group. Arnö has been with MySQL since 2001, making this his second acquisition.

"I have a phrase that I used to use last year: 'I cannot speak for Sun, because I am a MySQLer,'" he said during a post-keynote interview. "Now I have to do the same thing: I cannot speak for Oracle, but I will say that there are some things that an acquisition will not change. One is that MySQL has a huge user base. Another is that, though the founders and CEO are no longer with us, we have inside Sun some of the best MySQL experts. But most importantly, what has not changed is the license for MySQL. If you don't trust us, trust the GPL."

The GNU General Public License (GPL), the most commonly used open source license, employs the "copyleft" principle, which requires derivative works of GPL-licensed programs to be licensed under the GPL. The Linux operating system is a GPL-licensed product.

Forrester analyst Noel Yuhanna agreed that MySQL has languished at Sun. Speaking prior to the Oracle acquisition announcement, Yuhanna said Sun was not gaining traction with MySQL. "Even after a year, MySQL has still not made strong inroads into large enterprises and has not put any major pressure on Oracle, IBM or Microsoft," Yuhanna said. "It continues to focus on small to moderate-sized companies and apps like e-commerce and Web services which MySQL has done for years. There is no clear strategy on large-scale database deployment or a migration strategy from closed source databases to MySQL."

Yuhanna also lamented the departure from Sun of former MySQL executives Marten Mickos, David Axmark and Widenius. "Marten and Monty have definitely been the force behind MySQL's growth and adoption over the years and without them there is likely to be some setback at least for the short term," he said. "I believe Marten and Monty did not get their way at Sun -- the freedom and execution style that they had before the acquisition. This was clearly visible from the quality of MySQL, which declined -- as seen by Monty's blog -- and delays in minor releases and integration."

MySQL users had begun complaining last year to Forrester, Yuhanna said, about the lack of major product enhancement, especially around performance, scalability and security, which the 5.4 version largely addresses.

The list of new features and fixes in MySQL 5.4 also includes new query algorithms that use main memory to improve multi-way joins' execution times; stored procedures that improve error management via SIGNAL/RESIGNAL; better information schema and prepared statements; and expanded support for Sun's DTrace, Sun's dynamic tracing framework in the Solaris operating system.

The MySQL group also announced a new release of its high-availability database software, MySQL Cluster 7.0. This release also emphasizes performance and scalability enhancements, but also adds support for popular LDAP directories and simplified cluster backup and maintenance features. MySQL Cluster 7.0 is available now for download here.

Organizers of the MySQL Conference & Expo have traditionally presented awards during the opening keynote. This year, Padir added an ironic twist to that tradition by presenting Oracle Vice President Ken Jacobs, also known among Oracle's database administrators as "Dr. DBA," the "Acquirer of the Year" award. The joke drew laughter and applause from the crowd.

Meanwhile, at the annual RSA Conference under way this week in San Francisco, Sun announced plans to expand the interoperability between its identity management suite and the MySQL database. Sun ID technology will enable developers to create "more dynamic identity architectures" made up of directory services and relational databases. The result, the company said, is better performance and simplified management of large-scale applications.

Featured

  • Abstract AI circuit board pattern

    New Nonprofit to Work Toward Safer, Truthful AI

    Turing Award-winning AI researcher Yoshua Bengio has launched LawZero, a new nonprofit aimed at developing AI systems that prioritize safety and truthfulness over autonomy.

  • laptop displaying a glowing digital brain and data charts sits on a metal shelf in a well-lit server room with organized network cables and active servers

    Cisco Introduces AI-First Approach to IT Operations

    At its recent Cisco Live 2025 event, Cisco announced AgenticOps, a transformative approach to IT operations that integrates advanced AI capabilities to enhance efficiency and collaboration across network, security, and application domains.

  • young man in a denim jacket scans his phone at a card reader outside a modern glass building

    Colleges Roll Out Mobile Credential Technology

    Allegion US has announced a partnership with Florida Institute of Technology (FIT) and Denison College, in conjunction with Transact + CBORD, to install mobile credential technologies campuswide. Implementing Mobile Student ID into Apple Wallet and Google Wallet will allow students access to campus facilities, amenities, and residence halls using just their phones.

  • glowing blue AI sphere connected by fine light lines, positioned next to a red-orange shield with a checkmark

    Cloud Security Alliance Offers Playbook for Red Teaming Agentic AI Systems

    The Cloud Security Alliance has introduced a guide for red teaming Agentic AI systems, targeting the security and testing challenges posed by increasingly autonomous artificial intelligence.