MySQL Forge

Resources for the MySQL Community

MySQLConf2009Notes

Notes from the MySQL Conference and Expo 2009 and MySQL Camp 2009

including schedule, videos, presentations, and blog posts

Contents 1 Sunday, April 19 2 Monday, April 20 2.1 8:30 am - 12 noon 2.1.1 Camp: "Hackfest" 2.1.2 Build and Release Management for Database Engineers 2.1.3 Practical MySQL Plugin Development 2.1.4 MySQL Cluster Tutorial 2.1.5 Replication Tutorial 2.1.6 How to Avoid the Three Stooges of Data Warehousing - Practical Lessons for Open Source BI Implementations 2.1.7 MySQL DBA Certification Tutorial, Part 1 2.1.8 The Revised Memcached Tutorial 2.1.9 MySQL benchmarking and Monitoring tools 2.2 1:30 pm - 5:00 pm 2.2.1 Camp: "Ask a Guru" 2.2.2 Partitioning in MySQL 5.1 2.2.3 Introduction to Data Modeling with MySQL Workbench 2.2.4 Scale Up, Scale Out, and High Availability: Solutions and Combinations 2.2.5 MapReduce + SQL Using Open Source Software and Tools 2.2.6 MySQL DBA Certification Tutorial, Part 2 2.2.7 SQL Antipatterns Strike Back 2.2.8 Understanding How MySQL Works by Understanding Metadata 3 Blog posts 3.1 "MySQL Conference 2009 Daily summary: Monday" 4 Tuesday, April 21 4.1 8:30 am - 10:20 am 4.2 10:50 am - 11:35 pm 4.2.1 Camp: Learning from others' MySQL Performance Mistakes 4.2.2 Optimizing MySQL Performance with ZFS 4.2.3 New Replication Features 4.2.4 MySQL and Search at Craigslist 4.2.5 Using the Event Scheduler - The Friendly Behind-the-scenes Helper 4.2.6 Getting the most out of MySQL Enterprise Monitor 2.0 4.2.7 Connector/J Performance Gems 4.3 11:55 am - 12:35 pm 4.3.1 Camp: Intro to XtraDB, a Scalable InnoDB-based Storage Engine 4.3.2 Agile Environments and DBAs 4.3.3 Spatial SQL: who needs a traditional GIS 4.3.4 MySQL Embedded - Getting started with libmysqld 4.3.5 Automated data versioning with a storage engine middleware 4.3.6 MySQL Cluster on Windows 4.3.7 Starring Sakila: data warehousing explained, illustrated and subtitled 4.4 2:00 pm - 2:45 pm 4.4.1 Camp: Grand Tour of the Information Schema and its Applications 4.4.2 Rethinking MySQL, Enter Drizzle 4.4.3 Leveraging MySQL for Efficient Collaboration 4.4.4 If you love it, break it -- testing MySQL with the Random Query Generator 4.4.5 Distributed Innodb Caching with memcached 4.4.6 Falcon Storage Engine - Designed for Speed 4.4.7 How I used Query Analysis to Speed Up my Applications 4.5 3:05 pm - 3:50 pm 4.5.1 Camp: Setting up MySQL on Amazon Web Services (EC2,S3, EBS) 4.5.2 Creating quick and powerful web applications with MySQL, GlassFish, and NetBeans 4.5.3 The PBXT Storage Engine - Meeting Future Challenges 4.5.4 External Stored Procedures Framework for MySQL 4.5.5 Advanced query manipulation with MySQL Proxy 4.5.6 MySQL and the ORM: how far can you get without SQL? 4.5.7 Covering indexes : retrieving data without accessing it 4.6 4:25 pm - 5:10 pm 4.6.1 Camp: Setting up MySQL NBD (MySQL Cluster) Performance Tuning 4.6.2 Mining for insight within two billion visits 4.6.3 Introduction to using DTrace with MySQL 4.6.4 Solving common SQL problems with the SeqEngine 4.6.5 Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud 4.6.6 MySQL Proxy meets: Binlogs 4.6.7 Not so quiet on the C++ front 4.7 5:15 pm - 6:00 pm 4.7.1 Camp: InnoDB Database Recovery Techniques 4.7.2 MySQL Cluster 6.4 - New Features 4.7.3 Understanding and control of MySQL query optimizer: traditional and novel tools and techniques 4.7.4 Hadoop and MySQL: Friends with Benefits 4.7.5 Faster Data Reduction and Smoothing for Analysis & Archival in MySQL 4.7.6 Scaling a Widget Company 4.7.7 High Performance Ruby on Rails And MySQL 5 Wednesday, April 22 5.1 8:30 am - 10:20 am 5.2 10:50 am - 11:35 pm 5.2.1 Camp: Chasing Bottlenecks 5.2.2 Mastering index 5.2.3 Build your own MySQL time machine 5.2.4 Trigger Happy - Getting around MySQL Limitations 5.2.5 Memcached meets Flash: New usage of the plugable engine interface 5.2.6 Beginner's Guide to Website Performance with MySQL and Memcached 5.2.7 The Future of MySQL 5.3 11:55 am - 12:35 pm 5.3.1 Camp: Running Two MySQL Instances Using One Installation 5.3.2 Shell Scripting for MySQL Administration: An Introduction 5.3.3 Using Q4M - a Message Queue Storage Engine for MySQL 5.3.4 libdrizzle: A new client library for Drizzle and MySQL 5.3.5 Cloud computing with MySQL and Kettle 5.3.6 How to create a scalable, high performance fulltext search solution with mysql 5.3.7 Monitoring 101 - Simple stuff to save your bacon 5.3.8 Data Warehousing and Business Intelligence, ISV/OEM, Performance Tuning and Benchmarks, Storage Engine Development and Optimization 5.4 2:00 pm - 2:45 pm 5.4.1 Camp: Practical Object-Oriented Models in SQL by Bill Karwin 5.4.2 SAN Performance on a Internal Disk Budget: The coming Solid State Disk revolution 5.4.3 Maria, the New Transactional Storage Engine for MySQL 5.4.4 Building a Twitter analysis tool using MySQL, PHP and NetBeans 5.4.5 Gearing up MySQL: Implementing MySQL synchronization for browser-based apps using an embedded database (powered by Google Gears) 5.4.6 Connect and Replicate Securely: How to Use MySQL with SSL 5.4.7 Practical MySQL Security 5.4.8 From Startup to Enterprise - a story of MySQL usage evolution 5.5 3:05 pm - 3:50 pm 5.5.1 Camp: Open Source for Newbies 5.5.2 Writing Efficient Java Applications for MySQL Cluster Using NDB/J 5.5.3 MySQL empowers mission critical financial system 5.5.4 Partitioning under the hood 5.5.5 MySQL Performance on EC2 5.5.6 Wide Open Spaces: Using MySQL as a Web Mapping Service Backend 5.5.7 New foreign keys in 6.1 5.5.8 Clickability: Scaling SaaS with MySQL and Memcached 5.6 4:25 pm - 5:10 pm 5.6.1 Camp: Top 10 MySQL Pet Peeves and How to Workaround Them 5.6.2 Perl Stored Procedures for MySQL 5.6.3 The ScaleDB Storage Engine: Enabling High Performance and Scalability using Materialized Views and a Shared-Disk clustering architecture 5.6.4 High Availability and Scalability Patches from Google 5.6.5 DTrace support in MySQL: guide to solving real-life performance problems. 5.6.6 Sharding using Spockproxy - a sharding only version of Mysql Proxy 5.6.7 Using MySQL with the Dojo Toolkit 5.6.8 InnoDB Internals: InnoDB File Formats and Source Code Structure 5.7 5:15 pm - 6:00 pm 5.7.1 Camp: DHT-based P2P storage engine for MySQL 5.7.2 Taking ActiveRecord to the next Level 5.7.3 How Sun and MySQL are Driving MySQL Performance and Scalability 5.7.4 mysqlnd - How the PHP/MySQL stack got better 5.7.5 Redundant Storage Cluster: For When It's Just Too Big 5.7.6 The future of replication 5.7.7 Testing the cluster with ANSTE 5.7.8 Inserts at Drive Speed: Designing a Custom Storage Engine for Write-Mostly Applications 6 Thursday, April 23 6.1 8:30 am - 10:20 am 6.2 10:50 am - 11:35 am 6.2.1 Camp: 8 Rules for Designing More Secure Applications 6.2.2 SQL is dead 6.2.3 Deep-inspecting MySQL with DTrace 6.2.4 Map/Reduce and Queues for MySQL using Gearman 6.2.5 MySQL Support Internals 6.2.6 Dormando's Proxy for MySQL 6.2.7 Replication Tricks & Tips 6.2.8 Solutions for High Availability and Disaster Recovery with MySQL 6.2.9 Advanced Master-Slave Replication With Tungsten Failover 6.3 11:55 am - 12:35 pm 6.3.1 Camp: Test Drive MySQL 6.1 6.3.2 Memory Management in MySQL and Drizzle 6.3.3 Memcached Functions For MySQL: Seemless Caching in MySQL 6.3.4 Improving performance by running MySQL multiple times 6.3.5 Divide and be conquered 6.3.6 MySQL Server Backup, Restoration and Disaster Recovery Planning 6.3.7 MySQL HA using different solutions. Pros, cons and real world experiences 6.3.8 Securely and Seamlessly Deploy MySQL with your Application 6.4 2:00 pm - 2:45 pm 6.4.1 Camp: Predicting Performance with Queuing Models 6.4.2 MySQL Row Change Event Extraction and Publish 6.4.3 LDAP For MySQL Cluster - back-ndb 6.4.4 Unleash the Power of Your Data Using Open Source Business Intelligence 6.4.5 Software Quality and Testing in MySQL 6.4.6 MySQL Opaque Features 6.5 2:50 pm - 3:35 pm 6.5.1 Camp: Closing Keynote: The State of Open Source Databases 6.5.2 Advanced Memcached Use Cases 6.5.3 BLOB Streaming: Efficient reliable BLOB handling for all storage engines 6.5.4 SPIDER Storage Engine 6.5.5 Python and MySQL 6.5.6 Backup and Replication Integration Techniques 6.5.7 Database High Availability with a Punch: MySQL with DRBD for Dolphin Express 6.6 3:50 pm

[edit] Sunday, April 19

12 noon - 12 midnight

Drop-in games day on the mezzanine. Meet fellow conference attendees, and play games or just watch! Games that will be provided include:

• Checkers
• Carcasonne: Hunters and Gatherers
• Pentago
• Blokus
• 1000 blank white cards
• plenty of decks of playing cards (at least 50 decks, and some plastic chips)
• Mille Bornes
• Blockhead
• Set Cubed
• Uno
• Wedgits technically, not a game, but a building toy. Tons of fun!
• Dolphin Puzzle by Educa Based on previous experience, a puzzle can be done in one sitting if there are many hands to help!

Please list other games you will provide here -- feel free to bring a game that's already on the list if you think 2 copies will be appreciated!

Games you would like to see at the conference (ie, someone please volunteer to bring these games!):

• Set
• Chess
• Backgammon

Please note that games involving a strong knowledge of culture or language may not be suitable for our heavily international crowd. For instance, word games like Scrabble or trivia games like Trivial Pursuit historically have not been a big hit in the crowd.

People will drop in and out all day, so finding new and old friends to have dinner with will not be an issue.

[edit] Monday, April 20

[edit] 8:30 am - 12 noon

(3h 30 min, 1 break)

[edit] Camp: "Hackfest"

Mark Callaghan. Pick a MySQL feature to add or extend (or a bug to fix) and Mark will walk you through the important basics and help one or more groups hack away!

[edit] Build and Release Management for Database Engineers

Gregory Haase (Bill Me Later, Inc.)

[edit] Practical MySQL Plugin Development

Roland Bouman (XCDSQL Solutions / Strukton Rail), Sergei Golubchik (MySQL)

[edit] MySQL Cluster Tutorial

Stewart Smith (Sun Microsystems)

[edit] Replication Tutorial

Mats Kindahl (MySQL), Lars Thalmann (MySQL)

[edit] How to Avoid the Three Stooges of Data Warehousing - Practical Lessons for Open Source BI Implementations

David Lutz (Infobright)

[edit] MySQL DBA Certification Tutorial, Part 1

Kai Voigt (Sun Microsystems)

[edit] The Revised Memcached Tutorial

Alan Kasindorf (Six Apart), Brian Aker (Sun Microsystems)

[edit] MySQL benchmarking and Monitoring tools

Tom Hanlon (MySQL)

[edit] 1:30 pm - 5:00 pm

(3h 30 min, 1 break)

[edit] Camp: "Ask a Guru"

Drop-in sessions. Come with your questions, and leading MySQL experts will provide help free of charge. Or just come to listen.

[edit] Partitioning in MySQL 5.1

Giuseppe Maxia (Sun Microsystems Inc), Sarah Sproehnle (MySQL)

[edit] Introduction to Data Modeling with MySQL Workbench

Michael G. Zinner (MySQL), Max Mether (MySQL)

[edit] Scale Up, Scale Out, and High Availability: Solutions and Combinations

MC Brown (Sun Microsystems)

CPU load -- scaling up won't help if the DBs aren't loaded

RAM -- always add more

• cache rows
• cache indexes
• check key_reads
• check key_buffer_size
• key_reads / key_read_requests = miss rate
• is mySQL set to use all available memory?

Disks -- spread the load

• RAID

Partitioning -

• splitting the data across disks
• resolves disk contention

Multiple instances

• if you have lots of CPU, this may be the solution
• use virtualization (solaris containers?)

Scaling out

• Reducing read/write load
• More machines
• Spread the data
  • duplicate data
  • segregate/partition data

Replication

• Difficult to seed
• Synchronization
• Lag
• Statement and row-based
• Chaining replication -- saves network interface on master machine

Clustering

• Management node
• SQL node
• Data nodes
• Synchronous distributed writes
• Needs lots of network bandwidth
• Mostly for high-read, low-write
• Add more nodes for complicated queries
• Add data nodes for more storage
• NDB (wtf?) is the engine
• Limits on column types

Memcache

• IS THE SOLUTION TO ABSOLUTELY EVERYTHING
• ALL HAIL MEMCACHE

DRBD

• Device Level replication
• Replicates actual blocks of a disk, only information that has really changed
• Very efficient use of network
• Easy synchronization
• Mainly for High Availability

ZFS

• We were not interested

Sharding

• SHARDING IS EVEN MORE THE SOLUTION TO EVERYTHING
• SHARDING WILL HAVE YOUR BABIES

[edit] MapReduce + SQL Using Open Source Software and Tools

Christophe Bisciglia (Cloudera, Inc), Jeff Hammerbacher (Cloudera, Inc), Aaron Kimball (Cloudera, Inc), Tom White (Cloudera, Inc)

[edit] MySQL DBA Certification Tutorial, Part 2

Kai Voigt (Sun Microsystems)

[edit] SQL Antipatterns Strike Back

Bill Karwin (Karwin Software Solutions)

The database is the foundation of any innovative project, but you can’t innovate if you’re making the same mistakes of yesteryear.

Bill Karwin has supported SQL developers since 1994. Some blunders occur so frequently that we call them antipatterns: brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Bill describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.

SlideShare

[edit] Understanding How MySQL Works by Understanding Metadata

Sheeri K. Cabral (The Pythian Group), Patrick Galbraith (Lycos Inc.) PDF of slides

[edit] Blog posts

[edit] "MySQL Conference 2009 Daily summary: Monday"

- Shlomi Noach

[edit] Tuesday, April 21

[edit] 8:30 am - 10:20 am

(1h 50 min)

• Camp: Closed.
• Conference: TBD (Keynotes in Ballroom E)

[edit] 10:50 am - 11:35 pm

(45 min)

[edit] Camp: Learning from others' MySQL Performance Mistakes

Matt Yonkovit (Sun/MySQL, Waffle Grid, Big DBA Head)

PDF of slides Pythian blog post by Gerry Narvaja about what swappiness is.

[edit] Optimizing MySQL Performance with ZFS

Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)

[edit] New Replication Features

Lars Thalmann (MySQL), Mats Kindahl (MySQL)

[edit] MySQL and Search at Craigslist

Jeremy Zawodny (craigslist.org)

[edit] Using the Event Scheduler - The Friendly Behind-the-scenes Helper

Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems)

[edit] Getting the most out of MySQL Enterprise Monitor 2.0

Phil Hildebrand (thePlatform), Ryan Thiessen (Big Fish Games)

[edit] Connector/J Performance Gems

Mark Matthews (MySQL)

[edit] 11:55 am - 12:35 pm

(45 min)

[edit] Camp: Intro to XtraDB, a Scalable InnoDB-based Storage Engine

Vadim Tkachenko, Percona

[edit] Agile Environments and DBAs

Sheeri K. Cabral (The Pythian Group), Laine Campbell (PalominoDB)

[edit] Spatial SQL: who needs a traditional GIS

John Powell (eMapSite)

[edit] MySQL Embedded - Getting started with libmysqld

Anders Karlsson (MySQL )

[edit] Automated data versioning with a storage engine middleware

Peter Volk (DDEngine)

[edit] MySQL Cluster on Windows

Stewart Smith (Sun Microsystems)

[edit] Starring Sakila: data warehousing explained, illustrated and subtitled

Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

[edit] 2:00 pm - 2:45 pm

(45 min)

[edit] Camp: Grand Tour of the Information Schema and its Applications

Roland Bouman

[edit] Rethinking MySQL, Enter Drizzle

Brian Aker (Sun Microsystems)

[edit] Leveraging MySQL for Efficient Collaboration

Boris Burtin (Zimbra Inc.)

[edit] If you love it, break it -- testing MySQL with the Random Query Generator

Philip Stoev (Sun Microsystems)

[edit] Distributed Innodb Caching with memcached

Matthew Yonkovit (MySQL), Yves Trudeau (MySQL)

[edit] Falcon Storage Engine - Designed for Speed

Kevin Lewis (Sun Microsystems), Christopher Powers (MySQL, Inc.)

[edit] How I used Query Analysis to Speed Up my Applications

MC Brown (Sun Microsystems)

[edit] 3:05 pm - 3:50 pm

(45 min)

[edit] Camp: Setting up MySQL on Amazon Web Services (EC2,S3, EBS)

Ronald Bradford - Principal at 42SQL

[edit] Creating quick and powerful web applications with MySQL, GlassFish, and NetBeans

Arun Gupta (Sun Microsystems)

[edit] The PBXT Storage Engine - Meeting Future Challenges

Paul McCullagh (PrimeBase Technologies GmbH)

[edit] External Stored Procedures Framework for MySQL

Antony Curtis (Google Inc)

[edit] Advanced query manipulation with MySQL Proxy

Kay Roepke (Sun Microsystems)

[edit] MySQL and the ORM: how far can you get without SQL?

Jonathan Dahl (Tumblon)

[edit] Covering indexes : retrieving data without accessing it

Stephane Combaudon (SQLI)

[edit] 4:25 pm - 5:10 pm

(45 min)

[edit] Camp: Setting up MySQL NBD (MySQL Cluster) Performance Tuning

Yves Trudeau (Sun/MySQL, Waffle Grid, Big DBA Head)

[edit] Mining for insight within two billion visits

Osma Ahvenlampi (Sulake)

[edit] Introduction to using DTrace with MySQL

Vince Carbone (Sun Microsystems, Inc), Mikael Ronstrom (MySQL)

[edit] Solving common SQL problems with the SeqEngine

Beat Vontobel (MeteoNews AG) SeqEngine Website

[edit] Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud

Thorsten von Eicken (RightScale, Inc)

[edit] MySQL Proxy meets: Binlogs

Jan Kneschke (MySQL)

[edit] Not so quiet on the C++ front

Andrey Hristov (SUN Microsystems)

[edit] 5:15 pm - 6:00 pm

(45 min)

[edit] Camp: InnoDB Database Recovery Techniques

Peter Zaitsev (Percona)

[edit] MySQL Cluster 6.4 - New Features

Johan Andersson (SUN MySQL)

[edit] Understanding and control of MySQL query optimizer: traditional and novel tools and techniques

Sergey Petrunia (MySQL)

[edit] Hadoop and MySQL: Friends with Benefits

Frank Mashraqi (NetEdge)

[edit] Faster Data Reduction and Smoothing for Analysis & Archival in MySQL

Michael McFadden (Sciencelogic.com)

[edit] Scaling a Widget Company

Dathan Pattishall (Rockyou)

[edit] High Performance Ruby on Rails And MySQL

David Berube (Berube Consulting)

[edit] Wednesday, April 22

[edit] 8:30 am - 10:20 am

(1h 50 min) TBD (Keynotes in Ballroom E)

[edit] 10:50 am - 11:35 pm

(45 min)

[edit] Camp: Chasing Bottlenecks

Morgan Tocker

[edit] Mastering index

Yoshinori Matsunobu (Sun Microsystems)

[edit] Build your own MySQL time machine

Chuck Bell (Sun Microsystems), Mats Kindahl (MySQL)

[edit] Trigger Happy - Getting around MySQL Limitations

Phil Hildebrand (thePlatform)

[edit] Memcached meets Flash: New usage of the plugable engine interface

Trond Norbye (Sun Microsystems)

[edit] Beginner's Guide to Website Performance with MySQL and Memcached

Adam Donnison (Sun Microsystems)

[edit] The Future of MySQL

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

[edit] 11:55 am - 12:35 pm

(45 min)

[edit] Camp: Running Two MySQL Instances Using One Installation

Christos Kalantzis

[edit] Shell Scripting for MySQL Administration: An Introduction

Bob Burgess (Radian6 Technologies)

[edit] Using Q4M - a Message Queue Storage Engine for MySQL

Kazuho Oku (Cybozu Labs, Inc.)

[edit] libdrizzle: A new client library for Drizzle and MySQL

Eric Day (Concentric)

[edit] Cloud computing with MySQL and Kettle

Matt Casters (Pentaho Corp.)

[edit] How to create a scalable, high performance fulltext search solution with mysql

Alexander Rubin (MySQL)

[edit] Monitoring 101 - Simple stuff to save your bacon

Ronald Bradford (42SQL)

[edit] Data Warehousing and Business Intelligence, ISV/OEM, Performance Tuning and Benchmarks, Storage Engine Development and Optimization

TBC

[edit] 2:00 pm - 2:45 pm

(45 min)

[edit] Camp: Practical Object-Oriented Models in SQL by Bill Karwin

[edit] SAN Performance on a Internal Disk Budget: The coming Solid State Disk revolution

Matthew Yonkovit (MySQL)

[edit] Maria, the New Transactional Storage Engine for MySQL

Michael Widenius (MySQL)

[edit] Building a Twitter analysis tool using MySQL, PHP and NetBeans

Petr Pisl (Sun Microsystems, Inc.), David Van Couvering (Sun Microsystems, Inc.), Justin Bolter (Sun Microsystems, Inc.)

[edit] Gearing up MySQL: Implementing MySQL synchronization for browser-based apps using an embedded database (powered by Google Gears)

Roland Bouman (XCDSQL Solutions / Strukton Rail)

[edit] Connect and Replicate Securely: How to Use MySQL with SSL

Sheeri K. Cabral (The Pythian Group)

[edit] Practical MySQL Security

Domas Mituzas (Sun Microsystems)

[edit] From Startup to Enterprise - a story of MySQL usage evolution

Vidur Apparao (LiveOps, Inc.), Stephen O'Sullivan (LiveOps, Inc.)

[edit] 3:05 pm - 3:50 pm

(45 min)

[edit] Camp: Open Source for Newbies

Leslie Hawthorn (Google)

[edit] Writing Efficient Java Applications for MySQL Cluster Using NDB/J

Monty Taylor (Sun Microsystems - Drizzle), Jess Balint (Sun Microsystems, Inc.)

[edit] MySQL empowers mission critical financial system

Ryusuke Kajiyama (Sun Microsystems / MySQL)

[edit] Partitioning under the hood

Mattias Jonsson (Sun/MySQL), Mikael Ronstrom (MySQL)

[edit] MySQL Performance on EC2

Mark Callaghan (Google)

[edit] Wide Open Spaces: Using MySQL as a Web Mapping Service Backend

Don Beesing (Alion Science and Technology), Steve Judy (Alion Science and Technology)

[edit] New foreign keys in 6.1

Dmitry Lenev (Sun Microsystems/MySQL)

[edit] Clickability: Scaling SaaS with MySQL and Memcached

Jeff Freund (Clickability)

[edit] 4:25 pm - 5:10 pm

(45 min)

[edit] Camp: Top 10 MySQL Pet Peeves and How to Workaround Them

Jeremy Zawodny

Abstract forthcoming

[edit] Perl Stored Procedures for MySQL

Antony Curtis (Google Inc)

[edit] The ScaleDB Storage Engine: Enabling High Performance and Scalability using Materialized Views and a Shared-Disk clustering architecture

Moshe Shadmon (ScaleDB)

[edit] High Availability and Scalability Patches from Google

Ben Handy (Google), Justin Tolmer (Google)

[edit] DTrace support in MySQL: guide to solving real-life performance problems.

Alexey Kopytov (Sun Microsystems)

[edit] Sharding using Spockproxy - a sharding only version of Mysql Proxy

Frank Flynn (Spock Networks)

[edit] Using MySQL with the Dojo Toolkit

MC Brown (Sun Microsystems)

[edit] InnoDB Internals: InnoDB File Formats and Source Code Structure

Heikki Tuuri (Innobase / Oracle Corp.), Calvin Sun (Oracle)

[edit] 5:15 pm - 6:00 pm

(45 min)

[edit] Camp: DHT-based P2P storage engine for MySQL

Davi Arnaut (Sun)

[edit] Taking ActiveRecord to the next Level

Blythe Dunham (Spongecell)

[edit] How Sun and MySQL are Driving MySQL Performance and Scalability

Allan Packer (Sun Microsystems), Mikael Ronstrom (MySQL)

[edit] mysqlnd - How the PHP/MySQL stack got better

Andrey Hristov (SUN Microsystems)

[edit] Redundant Storage Cluster: For When It's Just Too Big

Bob Burgess (Radian6 Technologies)

[edit] The future of replication

Mats Kindahl (MySQL), Lars Thalmann (MySQL)

[edit] Testing the cluster with ANSTE

Jorge Bernal (Warp Networks), Victor Jimenez (Warp Networks)

[edit] Inserts at Drive Speed: Designing a Custom Storage Engine for Write-Mostly Applications

Ben Haley (NetQoS)

[edit] Thursday, April 23

[edit] 8:30 am - 10:20 am

(1h 50 min) TBD (Keynotes in Ballroom E)

[edit] 10:50 am - 11:35 am

(45 min)

[edit] Camp: 8 Rules for Designing More Secure Applications

Augusto Bott and Nicklas Westerlund (The Pythian Group)

[edit] SQL is dead

Monty Taylor (Sun Microsystems - Drizzle)

[edit] Deep-inspecting MySQL with DTrace

Domas Mituzas (Sun Microsystems)

[edit] Map/Reduce and Queues for MySQL using Gearman

Eric Day (Concentric), Brian Aker (Sun Microsystems)

[edit] MySQL Support Internals

Geert Vanderkelen (Sun Microsystems)

[edit] Dormando's Proxy for MySQL

Alan Kasindorf (Six Apart)

[edit] Replication Tricks & Tips

Mats Kindahl (MySQL), Lars Thalmann (MySQL)

[edit] Solutions for High Availability and Disaster Recovery with MySQL

Detlef Ulherr (Sun Microsystems GmbH)

[edit] Advanced Master-Slave Replication With Tungsten Failover

Robert Hodges (Continuent.com)

[edit] 11:55 am - 12:35 pm

(45 min)

[edit] Camp: Test Drive MySQL 6.1

Peter Gulutzan and Konstantin Osipov (Sun Microsystems)

[edit] Memory Management in MySQL and Drizzle

Stewart Smith (Sun Microsystems)

[edit] Memcached Functions For MySQL: Seemless Caching in MySQL

Patrick Galbraith (Grazr Inc.)

[edit] Improving performance by running MySQL multiple times

MC Brown (Sun Microsystems)

[edit] Divide and be conquered

Brooks Johnson (Verdiem)

[edit] MySQL Server Backup, Restoration and Disaster Recovery Planning

Lenz Grimmer (Sun Microsystems/MySQL)

[edit] MySQL HA using different solutions. Pros, cons and real world experiences

Robert Krzykawski (bwin Games AB), Anders Karlsson (MySQL )

[edit] Securely and Seamlessly Deploy MySQL with your Application

Lee Stigile (MySQL), John David Duncan (MySQL AB)

[edit] 2:00 pm - 2:45 pm

(45 min)

[edit] Camp: Predicting Performance with Queuing Models

David Lutz (Sun Microsystems)

[edit] MySQL Row Change Event Extraction and Publish

Yuan Wei (Google Inc.)

[edit] LDAP For MySQL Cluster - back-ndb

Johan Andersson (SUN MySQL)

[edit] Unleash the Power of Your Data Using Open Source Business Intelligence

Christopher Lavigne (Breadboard BI, Inc.)

[edit] Software Quality and Testing in MySQL

Omer BarNir (MySQL), Trim Pershad (Sun Microsystems)

[edit] MySQL Opaque Features

Sveta Smirnova (Sun), Morgan Tocker (Sun Microsystems)

[edit] 2:50 pm - 3:35 pm

(45 min)

[edit] Camp: Closing Keynote: The State of Open Source Databases

Brian Aker (Sun)

[edit] Advanced Memcached Use Cases

Frank Mashraqi (NetEdge)

[edit] BLOB Streaming: Efficient reliable BLOB handling for all storage engines

Barry Leslie (PrimeBase Technologies)

[edit] SPIDER Storage Engine

Kentoku Shiba

[edit] Python and MySQL

Ted Leung (Sun Microsystems)

[edit] Backup and Replication Integration Techniques

Chuck Bell (Sun Microsystems), Lars Thalmann (MySQL), Mats Kindahl (MySQL)

[edit] Database High Availability with a Punch: MySQL with DRBD for Dolphin Express

Florian Haas (LINBIT Information Technologies GmbH), Joachim Worringen (Dolphin Interconnect Solutions)

[edit] 3:50 pm

(45 min) Camp: Closed

Closing Keynotes TBD

• MySQL 2009 Conference
• MySQL Conferences