Sun Microsystems announced the availability of MySQL 5.1, a major new release of the open source database.
MySQL 5.1 features a number of new enterprise-class enhancements, including:
Table and Index Partitioning – MySQL 5.1 supports five forms of horizontal data partitioning: range, hash, key, list, and composite (sub-partitioning). By partitioning table and index data, faster query response times can be achieved as only the relevant partitions of data need to be scanned, instead of the entire table or index. Further, various storage and other maintenance operations are made much easier and accomplished more quickly via partitioning.
Row-Based and Hybrid Replication – Two new replication options are now available in MySQL 5.1. 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 – these achieve and maintain the most efficient and safest replication scheme for the application.
Event Scheduler – This new tool allows developers and DBAs 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(R) or the MicrosoftWindows task scheduler.
New MySQL Query Analyzer – Available to premium MySQL Enterprise subscribers, Sun’s new MySQL Query Analyzer tool can dramatically improve the speed and uptime of MySQL database applications by monitoring query performance to accurately pinpoint and correct problem SQL code. Thirty-day trial subscriptions for the MySQL Enterprise service, including the new MySQL Query Analyzer, are now available free-of-charge from http://www.mysql.com/trials.
MySQL 5.1 is available now for a wide variety of hardware and software platforms, including 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.