Sun introduced the upcoming version of MySQL 5.1, which is expected to be generally available sometime this quarter, and offered up an early sample of the open source database with the availability of the near-final release candidate of the GPL software during the sixth annual MySQL Conference and Expo held April 14-17, 2008, in Santa Clara, Calif.

According to Sun Senior Vice President of Sun's Database Group and former MySQL CEO Marten Mickos, this soon-to-be released version performs "...up to 15 percent faster than previous versions in our own internal tests - making it a compelling solution for demanding Web-based enterprise applications."

A number of new enterprise enhancements will be included in MySQL 5.1:

• Table and Index Partitioning: Five forms of horizontal data partitioning will be supported: range, hash, key, list and composite (sub-partitioning) for faster query response times.

• Row-Based and Hybrid Replication: Row-based replication replicates the data changes (rather than the actual SQL statements) between a master server and its slave servers, and hybrid replication uses either statement-based or row-based replication depending on the individual SQL operations.

• Event Scheduler: Automatically schedule common recurring SQL-based tasks to execute on the database server. It provides greater support for database-specific tasks than is available through CRON in Linux or Unix or the Microsoft Windows task scheduler, Sun claims.

• New Upgrade Advisor in MySQL Enterprise Monitor: Provides automated rules that monitor and advise DBAs about specific bugs that can might impact their deployed versions of MySQL 5.1. When potential issues are detected, users are given recommendations how to upgrade their database servers to correct the problem. This feature will only be available to MySQL Enterprise subscribers.

For the final release of MySQL 5.1, users will have the following versions available:

• MySQL Community Server: Targeted to a technical, do-it-yourself audience, who does not require commercial support or premium add-on services. This version will be freely-available. - MySQL Enterprise Server: Targeted to corporate IT users, subscribers receive monthly rapid software updates and quarterly service packs with the latest fixes along with access to proactive monitoring tools and 24x7 production technical support.

• MySQL Embedded Server: This commercially-licensed version of the MySQL software allows ISVs and OEMs to embed or bundle a high-speed, small-footprint database with their own products, without the free-distribution requirements of the GPL license.

Supported platforms will include Red Hat Enterprise Linux, SuSE Enterprise Linux Server, Microsoft Windows, Solaris 10 Operating System, Macintosh OS X, Free BSD, HP-UX, IBM AIX, IBM i5/OS and other popular Linux distributions.

Access downloads and more information on MySQL 5.1. [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter