Google Offers Updates to MySQL

Google this week offered up changes to the open source MySQL database, which are designed to improve the free software's ability to perform under heavy load. The improvements were released under a GPL license and may be freely implemented by the MySQL community, the company said.

Although MySQL has gained traction on the Web as a free alternative to Oracle and Microsoft SQL Server, the database still has its drawbacks with regards to high availability and manageability. Google uses MySQL in some of its non-search products, and says it would love for its changes to be included in the official MySQL release. More details from the Google Code blog.

Though you may think of us as simply a company with a big search index, Google uses MySQL, the open source relational database, in some of the applications that we build that are not search related.

We think MySQL is a fantastic data storage solution, and as our projects push the requirements for the database in certain areas, we've made changes to enhance MySQL itself, mainly in the areas of high availability and manageability.

We would love for the some of these changes to be merged with the official MySQL release, but until then we felt strongly that anyone should have access to them, thus we have released the changes with a GPL license for the MySQL community to use and review.

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.

Source: BetaNews

Contact Us | Authors | Subject Index | RSS Feeds

Copyright ©2007 Setup32.com