Google is a big fan of the open source MySql relational database, it uses this for its applications. Google made some patches to the relational MySql database for better manageability and reliability, google has released these patches for the community, Mark Callaghan, Software Engineer at Google posted on the google code blog. These patches are released under GPL license (General Public License), these patches are currently available for version 4 of the MySql, but they will release patches for version 5 in the near future.

What have we added and enhanced?

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.

Patches can be found here

If you're new here, you may want to subscribe to my RSS feed or Email alerts. Thanks for visiting!