background preloader

Mysql

Facebook Twitter

Php

Smugmug. Measurement. Mtop - MySQL Monitoring Tool. Google Megastore. What follows is a guest posting from Phil Bernstein on the Google Megastore presentation by Jonas Karlsson, Philip Zeyliger at SIGMOD 2008: Megastore is a transactional indexed record manager built by Google on top of BigTable. It is rumored to be the store behind Google AppEngine but this was not confirmed (or denied) at the talk. [JRH: I certainly recognize many similarities between the Google IO talk on the AppEngine store (see Under the Covers of the App Engine Datastore in Rough notes from Selected Sessions at Google IO Day 1) and Phil’s notes below]. · A transaction is allowed to read and write data in an entity group. · The term “entity group” refers to a set of records, possibly in different BigTable instances. Therefore, different entities in an entity group might not be collocated on the same machine.

The entities in an entity group share a common prefix of their primary key. . · A per-entity-group transaction log is used. . · Optimistic concurrency control is used. Scale Performance. Mysql-tools - Project Hosting on Google Code. Slides from "MySQL and Search at Craigslist" (by Jerem. Last week I delivered a talk titled "MySQL and Search at Craigslist" as part of the 2009 MySQL Conference and Expo. I talked about some of the good and bad of our MySQL work and also talked a lot about our recent Sphinx deployment. The slides are embedded below and here, thanks to SlideShare. (Anyone know why Google Docs doesn't yet handle OpenOffice presentations?) I gave a copy to O'Reilly but don't yet see them on the conference site. The usual disclaimers apply: I said a lot that's not well reflected in the slides, and I'm sure they're less informative without the audio or video that may or may not have been captured.

Either way, hopefully they're useful to folks who saw the talk and even a few of those who did not. I also delivered a condensed version of this talk at the Percona Performance Conference and those slides are available too. Thanks to everyone who provided useful feedback and discussion before and after the talks. Posted by jzawodn at April 28, 2009 08:11 AM.