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)
[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)
- 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)
[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)
[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)
[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
[edit] 3:05 pm sessions
[edit] Investigating Innodb Scalability Limits
Peter Zaitsev (MySQL Performance Blog), Vadim Tkachenko (MySQLPerformanceBlog)
[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)
[edit] Meta
[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
[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)
[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