MySQL Forge

Resources for the MySQL Community

MySQLConf2008Notes

2008 MySQL Conference and Expo Notes

[edit] Photo sets

• Flickr set tagged mysqluc08
• Julian Cash photos
• Facebook MySQL 2008 Conference Group - requires login
• On Picasa
  • Zack Urlocker's photos
  • Ben Wolfe's photos including a swag photo
  • Xavier N's photos

[edit] Videos

• Index of Technocation's videos
• All videos are linked to their corresponding presentations below

[edit] Slides

• Slides as on O'Reilly's site
• Some slides are linked to their corresponding presentations below; as of 5/1/2008 volunteers are needed to link all the presentations to their slides, so this page is comprehensive

[edit] Notes from Monday (April 14 2008) - Tutorial Day

[edit] MySQL Workbench.

The Ultimate Guide to DBA Productivity: Writing Plugins and Scripts by Vladimir Kolesnikov (MySQL)

no info yet

[edit] Advanced Stored Procedures

Mariella Di Giacomo (The Hive)

no info yet

[edit] MySQL Cluster Tutorial

by Stewart Smith

• Notes from MySQL Cluster written by Venu Anuganti

[edit] MySQL Proxy: The Complete Tutorial

by Giuseppe Maxia (MySQL) and Jan Kneschke (MySQL) tutorial files, including slide stack

[edit] All Bases Covered: A Hands-on Introduction to High-availability MySQL and DRBD

by Florian Haas (LINBIT Information Technologies GmbH), Philipp Reisner (LINBIT Information Technologies GmbH)

• Blog post by Chris Barber

[edit] Building Scalable & High Performance Datamarts with MySQL

Tangirala Sarma (DW/BI Architect)

no info yet

[edit] MySQL Replication Tutorial

by Lars Thalmann and Mats Kindahl

• Replication Tutorial wiki page
• play video directly in browser - video and audio start automatically on this link
• download entire WMV, 347.60 Mb
  • or download separately
  • Part 1 WMV, 175.27 Mb
  • Part 2 WMV, 182.42 Mb

• Replication Tutorial Notes (Part 1) written by Eric Bergen
• Replication Tutorial Notes (Part 2) written by Eric Bergen

[edit] Writing MySQL UDFs

by Roland Bouman (MySQL)

no info yet

[edit] Memcached and MySQL

Everything You Need To Know by Brian Aker (MySQL) and Alan Kasindorf (Six Apart)

• slides in PDF
• play video directly online - video and audio start automatically
• Entire Video 223.33 Mb wmv file

(or download separately)

• • Part 1 Video 112.09 Mb wmv file
  • Part 2 Video 111.31 Mb wmv file

• Blog posts/notes
  • Memcached and MySQL Tutorial written by Colin Charles
  • Memcached and MySQL written by Chris Barber

[edit] SQL Antipatterns

by Bill Karwin (Karwin Software Solutions)

slides in PDF

[edit] Real World Web: Performance & Scalability, MySQL Edition

by Ask Bjørn Hansen (Develooper and YellowBot)

Weblog post with slides Slides in PDF

[edit] Meta

[edit] 2008 Conference main page

[edit] Notes from Tuesday (April 15 2008)

[edit] Keynotes

[edit] State of MySQL

Mårten Mickos (MySQL)

• Keynote Video
  • direct browser play -- video and audio start automatically
  • download the 193.15 Mb WMV file
• Awards Presentation Video
  • direct browser play -- video and audio start automatically
  • download the 33.06 Mb WMV file

• Keynote with Marten Mickos at MySQL Conference 2008 written by Colin Charles
• Allowing MySQL DBAs to spend more time drinking written by Dups
• Keynote by Marten Mickos@UC written by Keith Murphy
• Off to a flying start written by Ronald Bradford

• Rich Green says “Don’t Panic”! written by Colin Charles

• MySQL Community Awards 2008 written by Kaj Arno
• Winners for 2008 at the MySQL Conference written by Colin Charles
• MySQL Awards at the MySQL Conference & Expo written by Ronald Bradford
• Baron writes about receiving the award
• Sheeri writes about receiving the award

[edit] Open Source: The Heart of the Network Economy

Jonathan Schwartz (Sun Microsystems)

• Keynote video
  • direct browser play -- video and audio start automatically
  • download the 147MB .wmv file

• Sun’s Agenda: Free and Freedom written by Dups
• A few words from Jonathan Schwartz written by Ronald Bradford
• The Network Has Become a Social Utility — Jonathan Schwartz written by Colin Charles
• Jonathan Schwartz's Keynote at the 2008 MySQL Conference written by Sheeri K. Cabral

[edit] A Head in the Cloud - The Power of Infrastructure as a Service

Werner Vogels (Amazon.com)

• Video
  • direct play in your browser -- video and audio start up automatically
  • Download the 249 Mb .wmv file

• Ahead in the cloud written by Colin Charles
• The next opening keynote - Everything fails, All the Time written by Ronald Bradford

[edit] 10:50am Sessions

[edit] Testing PHP/MySQL Applications with PHPUnit/DbUnit

Sebastian Bergmann (sebastian-bergmann.de)

• Video
  • download 229 Mb .wmv
  • direct play in browser -- video and audio start automatically

• Testing PHP/MySQL Applications with PHPUnit/DbUnit by Joe Stump

[edit] Performance Guide for MySQL Cluster

Mikael Ronstorm (MySQL)

• MySQL Conference Liveblogging: Performance Guide For MySQL Cluster (Tuesday 10:50AM) written by Artem Russakovskii

[edit] MySQL Online Backup: An In-depth Introduction

Chuck Bell (MySQL)

• Dr. Charles Bell — MySQL Online Backup: An Introduction @ UC written by Keith Murphy
• Notes from Online MySQL Backup in 6.0 written by Venu Anuganti

[edit] MySQL Workbench: The Ultimate Database Design Tool For Developers

Mike Zinner (MySQL)

• Sun Introduces MySQL Workbench -- official release statement
• Workbench 5.0 GA release announcement
• Duleepa Wijayawardhana (Dups)
• MySQL Workbench: The Ultimate Database Design Tool For Developers written by Mike Hillyer

[edit] New Subquery Optimizations in MySQL 6.0

Sergey Petrunia (MySQL)

• Slides: New subquery optimizations in MySQL 6.0 (new revision) written by Sergey Petrunia

[edit] Lessons Learned in Building a Highly Scalable MySQL Database

Mariella Di Giacomo (The Hive), Daniel Chote (The Hive), Geoff Harrison (The Hive)

• PPT slides

[edit] 11:55 am sessions

[edit] Full Text Search with MySQL 5.1: New Features & How To

Alexander Rubin (MySQL)

• MySQL Full Text Search by Alex Rubin written by Colin Charles

[edit] The Future of MySQL: What You Need to Know About What's Coming

Robin Schumacher (Sun/MySQL), Rob Young (Sun/MySQL)

• The Future of MySQL — Robin Schumacher and Rob Young@ UC written by Keith Murphy
• MySQL Conference Liveblogging: The Future Of MySQL (Tuesday 11:55AM) written by Artem Russakovskii

[edit] The Lost Art of the Self Join

Beat Vontobel (MeteoNews AG)

• The_Lost_Art_of_the_Self_Join.tar.gz (Slides and Examples/Source)

[edit] Practical MySQL for Web Applications

Domas Mituzas (MySQL)

• Video
  • play directly in browser -- audio and video start automatically
  • download 208 Mb .wmv file

[edit] 2 pm sessions

[edit] EXPLAIN Demystified

Baron Schwartz (Percona)

• PDF slides
• MySQL Conference Liveblogging: EXPLAIN Demystified (Tuesday 2:00PM) written by Artem Russakovskii
• EXPLAIN Demystified written by Colin Charles

[edit] Best Practices for Database Administrators

Sheeri Kritzer Cabral (The Pythian Group)

• Video -- Direct play in browser -- video and audio start automatically
• PDF slides

• Best Practices for Database Administrators slides and links written by Sheeri Cabral
• Sheeri K. Cabral — Best Practices for Database Administrators @ UC written by Keith Murphy

[edit] InnoDB: Status, Architecture, and New Features

Heikki Tuuri (Innobase / Oracle Corp.), Ken Jacobs (Oracle / Innobase)

• Notes from InnoDB status, architecture and new features written by Venu Anuganti
• MySQL Users Conference written by George Trujillo, Jr.

[edit] Securing MySQL for a Security Audit

Brian Miezejewski (MySQL)

• Video
  • play directly in browser -- audio and video begin automatically
  • download 289 Mb .wmv

• PDF slides

[edit] 3:05 pm sessions

[edit] Investigating Innodb Scalability Limits

Peter Zaitsev (MySQL Performance Blog), Vadim Tkachenko (MySQLPerformanceBlog)

• PDF slides

[edit] 4:25 pm sessions

[edit] Disaster is Inevitable—Are You Prepared?

Farhan Mashraqi (Fotolog)

• MySQL Conference Liveblogging: Disaster Is Inevitable - Are You Prepared? written by Artem Russakovskii

[edit] 5:15 pm sessions

[edit] Services Oriented Architecture with PHP and MySQL

Joe Stump (Digg)

• Slides
  • view directly in your browser
  • zip of Keynote presentation (MAC)

• Notes by Colin Charles

[edit] Meta

2008 Conference main page

[edit] Notes from Wednesday (April 16 2008)

[edit] Keynotes

[edit] Copyright Regime vs. Civil Liberties

Rick Falkvinge (Swedish Pirate Party)

• Video
  • play directly in browser -- audio and video start automatically
  • download 280 Mb .wmv file
• slides in ODF and PPT format

[edit] Scaling MySQL - Up or Out?

Kaj Arnö (MySQL), John Allspaw (Flickr (Yahoo!)), Jeff Rothschild (Facebook.com), Farhan Mashraqi (Fotolog.com), Monty Taylor (MySQL), Domas Mituzas (Wikipedia), Paul Tuckfield (YouTube)

• Video
  • play directly in browser -- audio and video start automatically
  • download 310 Mb .wmv file
• MySQL - Sun - Flickr - Fotolog - Wikipedia - Facebook - YouTube Comparison - MySQL Conference Day 2 Keynote written by Artem Russakovskii
• Scaling MySQL - - Up or Out? Panel @ UC written by Keith Murphy
• Notes from Scaling MySQL - Up or Out written by Venu Anuganti
• Scaling Wisdom -- 20-second summaries as captured by Ronald Bradford

[edit] Faster, Greener, Cheaper: Why Every MySQL Database Server Will One Day Have a SQL Chip

Raj Cherabuddi (Kickfire)

• Video
  • play directly in browser -- audio and video start automatically
  • download 137 Mb .wmv file

Blog posts about Kickfire at the conference

• MySQL Conference Presentation at the Kickfire Booth written by Artem Russakovskii
• Kickfire: Relational Algebra in a Chip written by Baron Schwartz
• SQL Chip Gives MySQL Data Warehouse Boost written by Brian Prince of eweek.com

[edit] 10:50am Sessions

[edit] MySQL Sandbox: Easily Using Multiple Database Servers in Isolation

Giuseppe Maxia (MySQL)

• Slides from MySQL Sandbox talk (UC 2008) written by Giuseppe Maxia
• MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia written by Sheeri Cabral
• Giuseppe Maxia — MySQL Sandbox @ UC written by Keith Murphy

[edit] Portable Scale-out Benchmarks for MySQL

Robert Hodges (Continuent.com)

• Video
  • play directly in browser -- video and audio open automatically
  • download 259 Mb .wmv file
• PDF slides
• notes written by Artem

[edit] 11:55 am sessions

[edit] Falcon from the Beginning

Jim Starkey (MySQL), Ann Harrison (MySQL)

• Notes from Falcon from the beginning written by Venu Anuganti
• Jim Starkey and Ann Harrison — Falcon From the Beginning @ UC written by Keith Murphy

[edit] Applied Partitioning and Scaling Your Database System

Phil Hildebrand (thePlatform)

• Video
  • play directly in browser -- video and audio open automatically
  • download 188 Mb .wmv file
• PPT slides
• written by Artem

[edit] 2 pm sessions

[edit] Architecture of Maria: A New Storage Engine with a Transactional Design

Michael Widenius (MySQL)

• Video
  • download 293 Mb .wmv
  • play directly in browser -- video and audio start automatically
• PDF slides

• Liveblogging: Architecture of Maria By Monty Widenius written by Sheeri K. Cabral
• Q: What a MySQL fellow does? written by Ronald Bradford
• Notes from Architecture of Maria Engine written by Venu Anuganti

[edit] MySQL Performance Under a Microscope: The Tobias and Jay Show

Tobias Asplund (MySQL), Jay Pipes (MySQL)

• MySQL Conference Liveblogging: MySQL Performance Under A Microscope: The Tobias And Jay Show (Wednesday 2:00PM) written by Artem Russakovskii

[edit] 3:05 pm sessions

[edit] An Introduction to BLOB Streaming for MySQL Project

Paul McCullagh (PrimeBase Technologies GmbH)

• YouTube Video -- in 7 parts
• PDF slides
• MySQL Conference Liveblogging: Introduction To The BLOB Streaming Project written by Artem Russakovskii

[edit] The MySQL Query Cache

Baron Schwartz (Percona)

• Video
  • download 209 Mb .wmv
  • play directly in browser -- video and audio start automatically
• PDF slides

[edit] 4:25 pm sessions

[edit] Help, My Website has been Hacked! Now What?

Eli White (Digg.com)

• Help, my website has been hacked! Now What? written by Colin Charles

[edit] Falcon for InnoDB Users

Kevin Lewis (MySQL), Ann Harrison (MySQL)

• Video
  • download 202 Mb .wmv
  • play directly in browser -- video and audio start automatically
• PPT slides

[edit] 5:15 pm sessions

[edit] Extending MySQL

Brian Aker (MySQL)

• Liveblogging: Extending MySQL by Brian “Krow” Aker written by Sheeri Cabral

[edit] Benchmarking and Monitoring: Tools of the Trade (Part I and II)

Tom Hanlon (MySQL)

• MySQL Conference Liveblogging: Monitoring Tools (Wednesday 5:15PM) written by Artem Russakovskii
• Notes on Benchmarking tools written by Venu Anuganti
• MySQL Conference Liveblogging: Benchmarking Tools (Wednesday 4:25PM) written by Artem Russakovskii

[edit] Performing MySQL Backups Using LVM Snapshots

Lenz Grimmer (MySQL)

• Video
  • play directly in browser -- video and audio start automatically
  • download 206 Mb .wmv file
• view slides in browser

[edit] Meta

2008 Conference main page

[edit] Notes from Thursday (April 17 2008)

[edit] Keynotes

[edit] Who is the Dick on My Site?

Dick Hardt (Sxip Identity Corporation)

• Video
  • direct play -- video and audio starts automatically
  • download 286Mb .wmv file

• Liveblogging: Who is the Dick on My Site? written by Sheeri Cabral
• Identity and Facebook Challenges: Keynotes from Thursday written by Dups
• Who is the Dick on my site? written by Colin Charles

[edit] A Match Made in Heaven? The Social Graph and the Database

Jeff Rothschild (Facebook.com)

• Video
  • play directly in web browser - audio and video start automatically
  • download 228 Mb .wmv file

• Notes from Social graph and the Database written by Venu Anuganti
• Liveblogging: A Match Made in Heaven? The Social Graph and the Database written by Sheeri Cabral

[edit] Radically Simple Backup & Recovery for Live MySQL

Chander Kant (Zmanda)

• Video
  • play directly in browser -- video and audio start automatically
  • download 192 Mb .wmv file
• slides written by the Zmanda team

[edit] 10:50am Sessions

[edit] Future Design Hurdles to Tackle in the MySQL Server

Michael Widenius (MySQL), Jay Pipes (MySQL)

• Monty Widenius — The Future of MySQL @ UC written by Keith Murphy
• Future design hurdles to tackle in MySQL Server written by Venu Anuganti

[edit] Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community

Farhan Mashraqi (Fotolog)

• Video
  • download 188 Mb .wmv
  • play directly in browser -- video and audio start automatically

[edit] Scaling out MySQL: Hardware Today and Tomorrow

Jeremy Cole & Eric Bergen (Proven Scaling LLC)

• PDF slides

[edit] 11:55 am sessions

[edit] MySQL Hidden Treasures

Damien Seguy (Nexen Services)

• MySQL Conference Liveblogging: MySQL Hidden Treasures (Thursday 11:55PM) written by Artem Russakovskii
• PDF slides

[edit] Database Security Using White-Hat Google Hacking

Sheeri Kritzer Cabral (The Pythian Group)

• Flash Video -- video and audio automatically start
• PDF slides
• Database Security Using White-Hat Google Hacking links and notes written by Sheeri K. Cabral

[edit] Helping InnoDB Scale on Servers with Many CPU Cores and Disks

Mark Callaghan (Google)

• Mark Callaghan (Google) on InnoDB written by Arjen Lentz
• Mark Callaghan — Scaling InnoDB/MySQL @ UC written by Keith Murphy
• Notes on InnoDB Scale on servers with many cores written by Venu Anuganti
• Notes from Google + InnoDB Scalability Talk written by Kevin Burton

[edit] External Language Stored Procedures

Antony Curtis (MySQL), Eric Herman (MySQL)

• Video
  • download 242 Mb .wmv
  • play directly in browser -- video and audio start automatically
• PDF slides

[edit] 2 pm sessions

[edit] 10,000 Tables Can’t Be Wrong: Designing a Highly Scalable MySQL Architecture for Write-intensive Applications

• Liveblogging: 10,000 Tables Can’t Be Wrong written by Sheeri Cabral

[edit] Scaling Heavy Concurrent Writes In Real Time

Dathan Pattishall (Flickr)

• Notes on scaling heavy concurrent writes in real time written by Venu Anuganti

[edit] Top 20 DB Design Tips Every Architect Needs to Know

Ronald Bradford (Primebase Technologies)

• Video
  • play directly in browser -- video and audio start automatically
  • download 186 Mb .wmv file
• slides written by Ronald Bradford

[edit] 2:50 pm sessions

[edit] Optimizing MySQL for High Volume Data Logging Applications

Charles Lee (Hyperic, Inc.)

• MySQL Conference Liveblogging: Optimizing MySQL For High Volume Data Logging Applications (Thursday 2:50PM) written by Artem Russakovskii

[edit] 4:25 pm sessions

[edit] 5:15 pm sessions

[edit] Addressing Challenges of Data Warehousing - a Panel Discussion

Moderator: Robin Schumacher (Sun/MySQL) Panelists: Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc.)

• Video
  • download 285 Mb .wmv
  • play directly in browser -- video and audio start automatically

[edit] Closing Keynote

[edit] The Science and Fiction of Petascale Analytics

Jacek Becla (Stanford Linear Accelerator Center)

• Video
  • download 288 Mb .wmv
  • play directly in browser -- video and audio start automatically
• PPT slides

[edit] Meta

2008 Conference main page