MySQL Forge

Resources for the MySQL Community

MySQLConf2009WednesdayNotes

Contents 1 Wednesday, April 22 1.1 8:30 am - 10:20 am 1.2 10:50 am - 11:35 pm 1.2.1 Camp: Chasing Bottlenecks 1.2.2 Mastering index 1.2.3 Build your own MySQL time machine 1.2.4 Trigger Happy - Getting around MySQL Limitations 1.2.5 Memcached meets Flash: New usage of the plugable engine interface 1.2.6 Beginner's Guide to Website Performance with MySQL and Memcached 1.2.7 The Future of MySQL 1.3 11:55 am - 12:35 pm 1.3.1 Camp: Running Two MySQL Instances Using One Installation 1.3.2 Shell Scripting for MySQL Administration: An Introduction 1.3.3 Using Q4M - a Message Queue Storage Engine for MySQL 1.3.4 libdrizzle: A new client library for Drizzle and MySQL 1.3.5 Cloud computing with MySQL and Kettle 1.3.6 How to create a scalable, high performance fulltext search solution with mysql 1.3.7 Monitoring 101 - Simple stuff to save your bacon 1.3.8 Data Warehousing and Business Intelligence, ISV/OEM, Performance Tuning and Benchmarks, Storage Engine Development and Optimization 1.4 2:00 pm - 2:45 pm 1.4.1 Camp: Practical Object-Oriented Models in SQL by Bill Karwin 1.4.2 SAN Performance on a Internal Disk Budget: The coming Solid State Disk revolution 1.4.3 Maria, the New Transactional Storage Engine for MySQL 1.4.4 Building a Twitter analysis tool using MySQL, PHP and NetBeans 1.4.5 Gearing up MySQL: Implementing MySQL synchronization for browser-based apps using an embedded database (powered by Google Gears) 1.4.6 Connect and Replicate Securely: How to Use MySQL with SSL 1.4.7 Practical MySQL Security 1.4.8 From Startup to Enterprise - a story of MySQL usage evolution 1.5 3:05 pm - 3:50 pm 1.5.1 Camp: Open Source for Newbies 1.5.2 Writing Efficient Java Applications for MySQL Cluster Using NDB/J 1.5.3 MySQL empowers mission critical financial system 1.5.4 Partitioning under the hood 1.5.5 MySQL Performance on EC2 1.5.6 Wide Open Spaces: Using MySQL as a Web Mapping Service Backend 1.5.7 New foreign keys in 6.1 1.5.8 Clickability: Scaling SaaS with MySQL and Memcached 1.6 4:25 pm - 5:10 pm 1.6.1 Camp: Top 10 MySQL Pet Peeves and How to Workaround Them 1.6.2 Perl Stored Procedures for MySQL 1.6.3 The ScaleDB Storage Engine: Enabling High Performance and Scalability using Materialized Views and a Shared-Disk clustering architecture 1.6.4 High Availability and Scalability Patches from Google 1.6.5 DTrace support in MySQL: guide to solving real-life performance problems. 1.6.6 Sharding using Spockproxy - a sharding only version of Mysql Proxy 1.6.7 Using MySQL with the Dojo Toolkit 1.6.8 InnoDB Internals: InnoDB File Formats and Source Code Structure 1.7 5:15 pm - 6:00 pm 1.7.1 Camp: DHT-based P2P storage engine for MySQL 1.7.2 Taking ActiveRecord to the next Level 1.7.3 How Sun and MySQL are Driving MySQL Performance and Scalability 1.7.4 mysqlnd - How the PHP/MySQL stack got better 1.7.5 Redundant Storage Cluster: For When It's Just Too Big 1.7.6 The future of replication 1.7.7 Testing the cluster with ANSTE 1.7.8 Inserts at Drive Speed: Designing a Custom Storage Engine for Write-Mostly Applications

[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)