Various tools for managing, maintaining, and improving the performance of MySQL databases, originally written by Google.
Tag: mysql
MySQL Camp Google Notes
The most fascinating bits I took out of it is how they take a partitioning/sharding strategy similar (but notably different in some ways) to WordPress.com and that they use DNS to manage all load balancing, high availability, datacenter failover, etc. DNS is a pretty powerful building block.
some interesting tricks
Great Database in the Sky
He characterized Google as giving unstructured people access to unstructured data whereas MySQL gives structured people access to structured data, meaning that MySQL is targeted towards developers who understand how to structure data “properly”. A strange polarization in my view, but I guess he’s trying to put clear blue water between the Google approach and the traditional database approach. At Talis, we don’t see this distinction at all and our core platform technology, Bigfoot, unifies structured and unstructured data.He went on to describe his vision of a skype for database access, combining my data, your data and public data into the next generation OLAP, running a trillion transactions per day. An example could be weather data and he asked what if you could run a SQL statement across all the data sources in the world, something like SELECT CurrentWindDirection, CurrentWindSpeed FROM AllTheWorldsWeatherStations, MyOwnWeatherStation, MyFriendsWeatherStation.
mysql to promote the data web, seems a bit unaware of semweb tech though, but one can hope
Real database
We finally decided to go with a commercial database over the objections of a number of engineers, including myself. To ease the transition it was decided to convert AdWords over to the new system first, and to do the main ads system later. It was a project on a par with the internationalzation effort in terms of the tedious work required to comb over nearly all of the AdWords code and change all of the database queries. (Databases are supposed to all be compatible with one another, but in reality they pretty much aren’t.)
To make a long story short, it was an unmitigated disaster.
adwords runs on mysql (for the next time someone brings up the old “not for enterprise use”)
Mysql spatial indexes
SELECT name, AsText(loc) FROM map_test WHERE
Contains(GeomFromText(‘POLYGON((0 0, 0 1, 1 1, 2 0, 0 0))’), loc) = 1;
(via jeremy zawodny)
KAYWA are you listening? i’d imagine this to be quite useful with some location metadata..
Gregor J. Rothfuss 