|
Recent
Articles |
What Employers Seek In Oracle Candidates
There are hundreds, if not thousands, of high tech computer jobs open for those with Oracle expertise. The highly reputable and popular Oracle products are used by firms in every part of the globe. As a result, experts...
Important Issues Regarding Database Tools
The sql server primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Sql server express and Sybase. SQL Server is commonly used by...
DevWeek: Day 2 Recap
Niels Berglund's "ADO.Net v.Next and the Entity Framework" was the first lecture of the day, I decided to skip Dino Espistos lecture after I read his slides and decided to go for something that I had not even...
Record Locking In SQL Server
Pessimistic and Optimistic Concurrency. In a multi-user environment, there are two models for updating data in a database: optimistic concurrency and pessimistic concurrency. Pessimistic concurrency involves locking...
Installing Fusebox
A quick editorial note. I mentioned last week that I would be playing with Fusebox and trying to learn the basics. In case anyone comes in via Google I wanted to be clear that these are my experiences as I learn. So please...
|
|
|
 |
|
04.25.07
Google Selects MySQL Goodies For Open Source
By
David A. Utter
Some of Google applications use the MySQL database, and internal performance enhancements made by Google engineers have been publicly released.
Database professionals who prefer to work with MySQL may be interested in how Googlers use the open source database.
Mark Callaghan, a Google software engineer, wrote on the Google Code Blog how some of their requirements push the boundaries of MySQL.
To compensate for their needs for high availability, manageability, and other areas of the database, they have had to code some changes.
"We would love for the some of these changes to be merged with the official MySQL release," Callaghan wrote. "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."
He listed the following changes available as patches to MySQL version 4. They anticipate version 5 support as coming soon:
• 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
Though Callaghan refers to a GPL license, the MySQL tools Google has released are listed under the Apache 2.0 License.
As the Apache Foundation has noted, its license is not compatible with the GPL due to the inclusion of certain patent termination cases that the GPL does not have.
About the Author:
David Utter is a staff writer for WebProNews covering technology and business.
|
