Frank DENIS random thoughts.

Google releases patches that enhance the manageability and reliability of MySQL

New in Google Code : a set of patches for MySQL

  • SemiSyncReplication - block commit on a master until at least one slave acknowledges receipt of all replication events.
  • MirroredBinlogs - maintain a copy of the master’s binlog on a slave
  • TransactionalReplication - make InnoDB and slave replication state consistent during crash recovery
  • UserTableMonitoring - monitor and report database activity per account and table
  • InnodbAsyncIo - support multiple background IO threads for InnoDB
  • FastMasterPromotion - promote a slave to a master without restart

Unfortunately these patches are only for MySQL 4, but support for version 5 is coming shortly.

They are released under the GPL.