Googling Magazine: Google Releases Patch for Enhanced MySQL Manageability and Reliability : Mobile Edition

Published on 2007-04-25 06:46:08

From April 23rd to 26th is held the MySQL conference and Expo 2007 edition, one of the biggest MySQL events worldwide, and by April 23rd The Google Code blog announced new Google MySQL tools under GPL license, a collection of patches that enhance the manageability and reliability of MySQL. The patches are released to get tested and reviewed by the MySQL community before see them merged with official release of MySQL.

The high availability features include support for semi-synchronous replication, mirroring the binlog from a master to a slave, quickly promoting a slave to a master during failover, and keeping InnoDB and replication state on a slave consistent during crash recovery.

The manageability features include new SQL statements for monitoring resource usage by table and account. This includes the ability to count the number of rows fetched or changed per account or per table. It also includes the number of seconds of database time an account uses to execute SQL commands.

More details

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

Related Entries