MySQL 5.1 Coming In June, Adds Partitioning, ReplicationThe new release will be supplemented with MySQL Workbench, a database design tool built from the open source DBDesigner4 project.
The next release of the MySQL open source database is scheduled for release by the end of the second quarter and will include new partitioning, replication, and event scheduling features.
In addition, the new release will be supplemented with MySQL Workbench, a database design tool built from the open source DBDesigner4 project. Mike Zinner, lead of that project, appeared on stage at the MySQL 2008 Conference & Expo in Santa Clara, Calif. this week to unveil MySQL Workbench as a freely available download from the MySQL site, now branded by MySQL AB's new owner, Sun Microsystems. It's also a stand-alone commercial product available with technical support for $99 a year.
Zinner drew enthusiastic applause from the assembled MySQL database users and independent software vendors when he illustrated how many views of the database can be achieved with a single tool. The workbench portrays data modeling, physical database design, database creation, and change management through a single user environment.
The commercial, or standard, edition (as opposed to the free community edition) has extensions that add plug-ins to allow synchronization between the tool and live databases; built-in validation models, where data in use is validated in the required format; and reverse engineering capabilities. The commercial product also offers documentation for the various database design and modeling views.
Zack Urlocker, VP of products, said a main addition to the upcoming 5.1 release of the core database system is the ability to partition indexes and tables, allowing faster queries by reducing the amount of data that needs to be scanned. For example, a range partition might segment a sales table into the four quarters of the year, providing swifter retrieval from a particular quarter. The 5.1 release will support range, key, list, composite, and hash partitions, all different ways of subdividing data into more manageable segments.
The 5.1 release will also offer row-based replication, which captures and distributes the changes to a row of data without resorting to the SQL statements that produced them. The subsidiary databases can be updated more quickly through the row-update technique than by running on the SQL statements.
Hybrid replication can use traditional SQL statement updates to replicate an original to a secondary database; it can also tap the new row-based replication method, Urlocker explained.
The database's new event scheduler tool will help database administrators execute specific tasks at certain times. SQL-based tasks can be scheduled as needed, such as updates to certain tables or replication to auxiliary databases, he said.