Oracle presents "much faster" MySQL beta
Oracle presented a beta of what it called a "much faster" MySQL at the O'Reilly MySQL Conference and insists it will be continuing to invest in the open source database. Oracle's Chief Corporate Architect, Edward Screven, presented the beta version of MySQL 5.5 which will now use InnoDB as its default storage engine, saying that the switch offers a 200% performance improvement and over ten times faster recovery times. He assured the audience that despite the switch to Oracle's InnoDB, Oracle will be maintaining the pluggable storage engine architecture and that the company would continue to ship the same code base in the community and enterprise editions.
Screven said Oracle's plan for MySQL was to keep it as a slim, easy-to-administer database and that it would be investing to make MySQL compete more effectively with Microsoft's SQL Server. He noted that more customers deploy MySQL on Windows than on any other platform. In an interview with eWeek before the presentation, Screven also confirmed that MySQL's Falcon storage engine was no longer being developed. "Falcon was Sun’s, or actually really MySQL AB’s…response to Oracle buying InnoDB" he said, "Now that we've brought the teams together, Falcon doesn't have a place in the world". Oracle's future plans include making it easier to migrate data between MySQL and Oracle databases and adding Oracle features such as Secure Backup, Enterprise Manager and Audit Vault to MySQL.
On the MySQL developers site, a new article details some of the other changes in MySQL 5.5. These include better metadata handling during transactions, improved performance and scaling on Windows, semi-synchronous replication and heartbeating and more partitioning options. The MySQL performance schema, a table of information on the low level performance of MySQL, has been introduced and already enhanced to include low level InnoDB statistics.
The beta of MySQL 5.5, currently development release version 5.5.4, is available to download from the MySQL developer site and is licensed under the GPL2. The current stable version of MySQL is version 5.1.45.