MySQL 5.5.18 fixes replication issues

Oracle has released MySQL 5.5.18, the latest of the regular updates to the production version of the open source database. In this update, Oracle has marked a number of statements unsafe for statement-based replication. The statements in question all rely on the result of a select statement where the order cannot be relied upon. Oracle advises users of statement-based logging to consult the documentation for further guidance. Another replication problem, where the master could send damaged events to slaves if the disk holding the binary log on the master became full, has also been fixed.

Other changes include improvements to the libedit library bundled with MySQL, removal of unnecessary memory allocation and freeing when opening tables, fixes for crashes related to ARCHIVE and FEDERATED tables, and possible corruption with the OPTIMIZE TABLE command when using MyISAM. The developers have also made it possible to use RPM to replace any installed version of MySQL with another from the same release family, for example, when upgrading from the GPL version to the commercial version. Full details of the changes are available. MySQL 5.5.18 can be downloaded from the dev.mysql.com site.

(djwm)