14 DAY TRIAL // Although it might sound a little weird, Google is using MySQL for some of the applications that are not based on the search technologies. As you might know, MySQL is a database management system that was designed by the Swedish company MySQL AB. According to a blog post published today, the company's employees are trying to improve the solution by their own needs and design several patches to increase the functionality of the program. Now, I bet you really want to test the tools used by Google and find out if you're able to design similar solutions. OK, maybe I'm overreacting but it's possible and some of the experienced developers might try this crazy idea. Now, the Mountain View-based firm improved two of the most important MySQL aspects: the high availability and the manageability of the databases.
"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," Mark Callaghan, Software Engineer, presented the new tools.
If you want to download the set of tools, you can take them from Google Code's page, a separate website that hosts numerous utilities able to help developers contribute to the company's products. The Google MySQL Tools are available on this link and can be freely downloaded by any user under an Apache License 2.0