MySQL 5.1 Expected for Release Later This Quarter
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.
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: Will provide 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.