Speaker Presentation Files:
MySQL Conference & Expo 2008

Tyler Carlton (LimeWire), Cory Sessions (Nexation, Inc.)
Presentation: 0 to 60 in 3_1 Presentation [PPT]
We did it! Hear how we went from a third party database system to a 60G MySQL Cluster hosting large external web services and intensive internal data applications flawlessly, in three months.
Antony Curtis (MySQL), Eric Herman (MySQL)
A lightning tour of the design, implementation, and use of MySQL External Language Stored Procedures framework, with examples using C, Java, XML-RPC, and more.
Robin Schumacher (Sun/MySQL), Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc. )
A panel discussion hosted by Robin Schumacher that presents topics to a variety of data warehousing experts about issues concerning their industry.
Mariella Di Giacomo (The Hive)
MySQL 5.0 and higher versions support stored routines that are based on the SQL:2003 standard. The introduction of stored programs in MySLQ 5 has been a significant milestone of the MySQL language. This tutorial will offer a brief overview of the stored program language and focus on how to improve and tune stored programs.
Paul McCullagh (PrimeBase Technologies GmbH)
This session explains how the BLOB Streaming engine solves the problems involved in storing pictures, films, MP3 files, and other binary and text objects (BLOBs) in the database.
Phil Hildebrand (thePlatform)
Take advantage of MySQL partitioning to allow your database applications to scale in both size and performance. A practical look at applying partitioning to OLTP database systems.
Michael Widenius (Monty Program Ab)
A deep tour into the design of Maria, a new MVCC storage engine for MySQL from the original authors of MySQL that is designed to support transactions and automatic recovery.
Kian-Tat Lim (Stanford Linear Accelerator Center)
The Large Synoptic Survey Telescope will produce a 20 petabyte database. To support this huge database, we are investigating a new generic scalable architecture with MySQL as a core component. Learn how it can be used by others to manage extremely large databases.
Kai Voigt (Sun Microsystems)
Do you backup your data periodically? If not, this is your session. Learn about the possible options for backing up your data and how to get it back if you've lost something.
Igor Babaev (MySQL)
Batched Key Access is an advanced technique that is able to speed up the execution of queries with multitable joins to the factor of 5 and more.
Tom Hanlon (Cloudera)
Benchmarking and Profiling are extrememly important and a large array of tools exist for the job. Join Tom Hanlon for a tour of the current landscape. Demos of each tool wil be shown.
Tom Hanlon (Cloudera)
Join us for a presentation of the wonderful world of benchmarks and monitoring tools. Here you will learn what is available, how each tool works, and a demonstration using each tool against a running database from a veteran MySQL expert.
Mark Matthews (Oracle)
Learn how to use Connector/J's extension points to solve interesting problems and add functionality without changing the core code of the driver.
Sheeri K. Cabral (Mozilla Foundation)
Novice and experienced DBAs alike will learn, share, and discuss best practices that will help them be successful.
Ritu Kamboj (Sun Microsystems, Inc), Luojia Chen (Sun Microsystems, Inc.)
This session explains how MySQL can take advantage of advanced technologies in the Solaris OS, thereby expanding the MySQL user base into new and larger enterprises.
Tangirala Sarma (DW/BI Architect)
Data Warehousing and Business Intelligence is gaining mission critical status in managing today's enterprise. It is critical that these datamarts are built on good foundation. This tutorial focuses on design principles and techniques to build a solid foundation for datamarts using MySQL.
Robert Hodges (Continuent.com)
Replicated databases are complex to manage, don't provide seamless availability, and require application changes to provide scaling benefits. We show how Continuent's new Tungsten architecture rides new technology trends to create data services with high availability and performance using commodity hardware and off-the-shelf MySQL databases. Tungsten: it's coming to open source!
Rick Falkvinge (Swedish Pirate Party)
Presentation: external link
Rick Falkvinge, founder of the Swedish Pirate Party, talks about the rise and success of pirates and why pirates are necessary in today's politics. He'll also outline the next steps in the pirates' strategy to change global copyright laws.
Kirstan Vandersluis (XAware, Inc.)
Have you been ripping your hair out trying to mix and mash multiple data sources, all of different formats, into something that actually makes sense? There's something to be said for getting all your ducks in a row, and in this session, we'll show you how to regain your sanity when it comes to a distributed, heterogeneous data environment.
Julian Hyde (SQLstream)
This session will describe the benefits and approach to building OnLine Analytical Processing (OLAP) applications using MySQL Enterprise and Pentaho's Mondrian OLAP Project.
Joseph Hill (Novell), Joe Audette (Source Tree Solutions, LLC)
This session provides an introduction to application development with Mono and MySQL; the current state of Mono, including its support for databases through ADO.NET and LINQ; and explores how one open source ASP.NET application provides support for Mono and MySQL.
Sheeri K. Cabral (Mozilla Foundation)
For many companies, getting hacked is a matter of when, not if. This session shows how to find database vulnerabilities by Google hacking, providing methods minimizing the impact of being hacked.
Derek Gottfrid (The New York Times)
This talk will present a basic introduction to the DBAccessLayer or DBSlayer, a lightweight web-friendly mechanism for connection pooling and proxying against MySQL.
Mark Leith (MySQL)
MySQL 5.1 includes new functionality that allows you to create your own INFORMATION_SCHEMA tables with the new plugin interface. Learn how to implement these along with some real-world examples.
Ben Rockwood (Joyent Inc)
Presentation: DTrace and MySQL Presentation [PDF]
Noted Solaris and DTrace expert Ben Rockwood will show how to evaluate and introspect MySQL's behavior, and gain information that isn't normally attainable by developers and system administrators.
Baron Schwartz (VividCortex Inc)
Presentation: EXPLAIN Demystified Presentation [PDF]
EXPLAIN is one of MySQL's most-used and least-understood features, and it's not documented fully. This session helps EXPLAIN make sense by showing how it really maps to a query execution plan.
Morgan Tocker (Oracle), Carl Mercier (Defensio)
This talk tests Amazon EC2's (Elastic Compute Cloud) suitability for MySQL scale-out applications, including benchmarks and war-stories from active deployments.
Kevin Lewis (Sun Microsystems), Ann Harrison (MySQL)
Falcon is MySQL’s new transactional storage engine, currently in beta. Falcon, however, is not InnoDB and was not designed as a drop in replacement. The talk will discuss the architectural and philosophical differences between Falcon and InnoDB, and the problems that may be encountered when switching between InnoDB and Falcon.
Jim Starkey (MySQL), Ann Harrison (MySQL)
This talk is intended for users contemplating using Falcon for new applications. Starkey and Harrison will discuss the differences between Falcon and other storage engines, the types of applications for which Falcon is a good fit, and ways to exploit Falcon's strengths at the design stage.
Sean Kelly (Stumbleupon.com)
In this discussion we'll focus on the architecture, approaches, and challenges of cheaply loading the daily and historical stock market data into MySQL necessary for financial data applications.
Alexander Rubin (MySQL)
This presentation covers new Full Text Search features in MySQL 5.1. We also show some common tasks and solutions with Full Text Search in MySQL as well as benchmark results.
Michael Widenius (Monty Program Ab), Jay Pipes (Rackspace Cloud)
MySQL Fellow, Monty Widenius, will talk about the architectural and design challenges currently facing the MySQL server developers, including a bit of history behind why the architecture of MySQL looks the way it does. He will then talk about the future architecture of the MySQL server and the plans he and others have to solve the design issues of the present day.
Alexander Rubin (MySQL)
Geo distance / proximity search is a very common task in social networking (and other Web 2.0) applications. Example: "For the given user, find all users that live near by." Learn how to perform geo distance searches with MySQL.
Roland Bouman (XCDSQL Solutions / Strukton Rail)
The information schema is an underestimated feature: it has many applications but many people are unaware of them. This talk will introduce its components and demonstrate its applications.
Patrick Galbraith (Blue Gecko), Michael Kowalchik (Grazr Corporation)
Grazr is a new platform for aggregating, consolidating, and sharing information. We would like to share lessons we've learned with others considering using MySQL as the foundation for their product.
Eli White (Zend Technologies)
A crash course on what to do AFTER your web site has been hacked via SQL injection, XSS, CSRF, etc. How to track down the problem and fix it. Talk will focus on PHP/MySQL.
Patrick Bolduan (MTV Networks Japan KK), Yoshinori Matsunobu (DeNA)
This session will cover issues including High Availability database architecture using MySQL/DRDB/Heartbeat, modular application design, scale planning, and day-to-day operations of an HA MySQL implementation.
Britt Crawford (Cafepress.com), Justin McCarthy (CafePress.com)
Some data, such as user-created content, grows so large so fast it simply can't be stored in one database. This session will present HiveDB, an open source system for horizontally partitioning MySQL.
Lance Walter (Pentaho Corporation)
Learn how to obtain expert insight and learn best practices to help you achieve operational business intelligence throughout your organization from data warehousing to business intelligence functionality and performance.
Mike Hillyer (Message Systems)
At some point in every software project involving a database it becomes necessary for the developers who created (or inherited) the project to step back and take a look at their database. Mike Hillyer will guide the audience through the principles of database normalization and review some common normalization scenarios encountered by many application developers.
Mike Frost (DataDirect)
In this presentation, Mike Frost, product manager for DataDirect Technologies, will introduce a strategy for separating application logic from MySQL database access logic. The presentation will describe the benefits of a loosely coupled approach for all application and data access logic.
Paul McCullagh (PrimeBase Technologies GmbH)
This session takes a tour of the internals of the PBXT storage engine, revealing some unique solutions to the problems of transactional isolation, consistency, and durability.
Peter Zaitsev (Percona Inc), Vadim Tkachenko (MySQLPerformanceBlog.com)
You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed.
Eric Ries (Kleiner Perkins Caufield & Byers), Chris Hondl (IMVU)
In the course of six months IMVU’s user base quadrupled in size. This session will focus on the techniques used to incrementally add scalability without making large changes to the application layer or disrupt ongoing feature development by the rest of the team.
Mariella Di Giacomo (The Hive), Daniel Chote (The Hive), Geoff Harrison (The Hive)
Learn about a horizontal scalable architecture for accessing exponentially growing datasets, and performance results obtained on several filesystems, MySQL storage engines, and partitioning.
Brian Aker (MySQL), Alan Kasindorf (Six Apart)
Presentation: external link
Large MySQL deployments and Memcached go hand and hand. This tutorial details how to get started, the ins and outs of deploying Memcached as a key caching layer in your applications, and how to keep scaling.
Naoto Yokoyama (NIFTY Corporation), Kenji Hirohama (Sumisho Computer Systems Corp.), Lisa Phillips (Six Apart), Garth Webb (Six Apart)
NIFTY Corporation will discuss their experiences with MySQL and how they changed the configuration in TypePad to meet the Japanese market's requirement, such as more availability, more cell phone support, and so on.
Jeff Freund (Clickability)
Master-Master replication provides high availability and serviceability for the applications. Publishing web sites is a read-intensive operation, and the combination of Master-Slave replication with an application layer that intelligently splits database read and write operations allows for rapid scale out. Hear how Clickability solves issues for both environments.
Andy Bang (MySQL)
Automatically detect your replication environments and display their configurations. Monitor the health and performance of those systems.
Robin Schumacher (Sun/MySQL), Miriam Tuerk (Infobright Inc), Victoria Eastwood (InfoBright Inc. )
As organizations struggle to cope with increasing amounts of data, MySQL users are looking for ways to scale their data warehouse system. Come learn about new engine technology with proven scalability to 30TB, designed to support complex, ad hoc queries.
David Wartell (R1Soft )
Online backup and restore of mission critical MySQL servers has never been easy. Sure it’s not so bad if you have a small data set and you can afford to take your server offline for a backup. Seriously, how many MySQL deployments fit those requirements? This session helps you make sense of the myriad of MySQL backup options out there.
Learn how Paggo utilized a Replicated Cluster to guarantee the necessary High Availability and contingency for financial transactions.
Damien Seguy (Nexen Services)
A wealth of tips and tricks to solve real world SQL problems with SQL wizardy and MySQL magic. All you need is your commandline, and a lot of curiosity.
Chris Kasten (eBay)
This presentation discusses how MySQL was leveraged to provide a large scale personalization technology platform solution for a site like ebay.com, which processes over 2 billion URL requests per day.
Chuck Bell (Oracle)
This session presents the new Online Backup capability. Existing backup options and details of how they compare with the new features will be presented.
Giuseppe Maxia (Continuent), Jan Kneschke (MySQL)
MySQL Proxy is a tool that can enhance existing MySQL server features and create new ones. This tutorial explains how to create new syntax, filter queries, and how to deal with multiple servers.
Lars Thalmann (Oracle), Mats Kindahl (MySQL)
In this tutorial, the developers behind MySQL Replication start by explaining the architecture and major replication concepts and then walk you through a configuration to show what you can do with it.
Giuseppe Maxia (Continuent)
MySQL Sandbox is a tool to install a side server or a replication system in "seconds," in complete isolation, without need to remember complex sequence of commands.
Daniel Stangel (HP Open Source Middleware Stacks (OSMS)), Bruce Huang (HP Open Source Middleware Stacks (OSMS))
More information coming soon
Vladimir Kolesnikov (Primebase Technologies)
MySQL Workbench is a highly customizable tool to help you make your everyday job more efficient. This tutorial will show how to write configurable, flexible, cross-platform plugins (C++, Python, LUA).
Michael G. Zinner (Sun Microsystems)
A hands-on discussion of the MySQL Workbench tool showing the benefits for Ruby/Python/PHP, as well as .NET/Java developers. Efficient database schema design and maintenance has never been so easy.
Reggie Burnett (Oracle), David Sceppa (Microsoft Corporation)
LINQ is perhaps the most powerful new feature in the .NET Framework, allowing you to query in memory structures like tables in a database. Learn how to use the ADO.NET Entity Framework to construct LINQ queries or Entity SQL queries to interact with data in your MySQL database.
Sergey Petrunia (MySQL)
This talk describes new subquery optimizations in MySQL 6.0: what they are, how they are reflected in EXPLAIN output, and how they give orders-of-magnitude speedups for real-world queries.
Lars Thalmann (Oracle), Chuck Bell (Oracle)
In this session we discuss the new backup feature for MySQL 6.0, the new replication features coming up, and new contributions from the community in the replication arena. Don't miss it!
Charles Lee (Hyperic, Inc.)
This talk will focus on the significant changes Hyperic’s developers made to Hyperic HQ's underlying database code in order to add support for a MySQL backend, and provide tips for other developers.
Sergei Golubchik (MariaDB)
This talk will describe the MySQL Plugin API, its design principles, how it is used, and what plugin types are supported. It will cover both old and very new features, and discuss the future of the API.
Colin Charles (SkySQL Ab/MariaDB Foundation)
MySQL has created many resources online for opening up contributions from the community. From MySQL Forge, to the DevZone, to code reviews in public, MySQL is primed for more external contributions!
Mikael Ronstrom (MySQL)
Learn about all the tricks required to make MySQL Cluster high performance. This includes using real-time scheduling, batching in all its form, cluster interconnects, and locking threads to CPUs.
Lenz Grimmer (Sun Microsystems)
This session offers an introduction to the concept of utilizing LVM filesystem snapshots to perform consistent backups of MySQL databases without having to interrupt the normal server operations. While this technique isn't a "real" hot backup, it still provides a viable and free alternative to other backup methods like SQL dumps.
Robert Hodges (Continuent.com)
This talk presents new open source tools that allow users to set up and run database scale-out benchmarks easily. Hodges illustrates with benchmark results from your favorite MySQL configurations.
Ask Bjørn Hansen (Develooper)
Presentation: external link
Ask Bjoern Hansen will be covering the overall platform and architecture considerations involved in tuning applications from a holistic perspective. You'll be shown design scaleable architectures for dynamic, high-volume web sites. Topics covered include caching, scalable database design, replication, load-balancing, and architectural decisions derived from many years of experience.
Kevin Burton (Spinn3r), Jonathan Moore (Tailrank/spinn3r)
Most existing work in scaling MySQL has focused on high read throughput environments similar to web applications. Burton and Moore will present the backend architecture behind Spinn3r—their scalable web crawler.
Moshe Shadmon (ScaleDB)
ScaleDB is a transactional storage engine for MySQL. It is based on innovative indexing technology that provides high performance for large, disk based data sets. It provides for MySQL the functionality of Materialized Views and as it operates over the source data, it obviates the need to maintain a replica and synchronize between the source data and the replica.
Learn the places in MySQL that need to be secured and how to secure them for most commercial security audits.
Einar Rustad (Dolphin Interconnect Solutions )
The PCI express-based, MySQL optimized interconnect reduces latency and overhead and incorporates two levels of fault tolerance. The performance improvements allow customers to reduce their hardware investments and cost of operation and reduce time consuming performance tuning for developers. All fully transparent to the application.
Andrew Aksyonoff (Sphinx Technologies), Peter Zaitsev (Percona Inc)
Sphinx is an open source full-text search engine designed for indexing databases and integrated especially well with MySQL. We'll talk about its features, capabilities, and real-world applications.
Bill Karwin (Karwin Software Solutions)
Presentation: SQL Antipatterns Presentation [ZIP]
Bill Karwin has answered questions from SQL users for over ten years. Some techniques have emerged as widely used, but flawed, making them brittle, buggy solutions and create security or scalability risks in your projects. In this tutorial, Karwin describes SQL techniques that should be called antipatterns, illustrates their weaknesses, and offers better solutions.
Alexander Nozdrin (Oracle (MySQL division)), George Trujillo (MySQL )
This presentation will consist of two major blocks: explaining tricky features of stored routine behavior and providing examples of advanced use, such as using dynamic SQL in stored routines.
Sebastian Bergmann (thePHP.cc)
PHP/MySQL applications are used more and more to perform enterprise-critical tasks. The audience will learn how to efficiently test PHP/MySQL applications with PHPUnit and its DbUnit extension.
Robin Schumacher (Sun/MySQL), Rob Young (Oracle/MySQL )
What enhancements can you expect in the MySQL Server in the next few years? What new tools, services, and software is MySQL going to deliver this year and next to help you deploy and maintain MySQL applications? This session will let you in on all the plans MySQL has for the server, the Enterprise Monitor, the upcoming Load Balancer and Query Analyzer, management tools, and more.
Beat Vontobel (MeteoNews AG)
Presentation: external link
Why would you join a table to itself? It's an elegant solution to many problems beyond the text book example of an employee's table! And if you're brave, you might even solve a Sudoku with one SELECT.
Baron Schwartz (VividCortex Inc)
Understanding and tuning the query cache can be daunting. It's not really complicated; it only seems that way. Baron will explain it in ways you'll understand and remember.
Jacek Becla (Stanford Linear Accelerator Center)
Scientists are trying to understand dark matter, discover distant galaxies, hunt for the Higgs boson, detect asteroids, and take movies of molecules. Their science is fascinating but their analysis requirements may seem like science fiction. Few have experienced the reality of petascale analytics so far, but everybody, including you, will face it tomorrow. Are we ready?
Ronald Bradford (EffectiveMySQL)
Each database product has strengths and weaknesses. Having chosen MySQL as your database product, leverage the strengths of the product to maximize design and performance. Learn the things to avoid.
Dmitri Joukovski (Zmanda)
As MySQL powers the businesses, a good backup will go a long way to ensure you recover your data without impacting your business. In this session we review the top considerations for backing up MySQL.
Sigurd Magnusson (SilverStripe)
Presentation: external link
Preserving backward compatibility often prevents projects from benefitting from new MySQL features. Learn how to write elegant PHP code and SQL protected against the future as well as the past.
James Blair (UC Berkeley), Paul Fisher (UC Berkeley)
UC Berkeley's email system serves 70,000 users. Based on free software, a 22 node MySQL cluster ties the components together. See integration examples with Exim and the SQLAlchemy ORM for Python.
Seth Fitzsimmons (Yahoo! Inc.)
MySQL's Spatial Extensions and Ruby on Rails are a powerful combination for quickly and simply creating powerful spatially enabled applications.
Ian Fyfe (JasperSoft), Mary Flynn (Ten Pages)
This presentation and demonstration will highlight advances that are bringing the power of interactive Ajax web technology and powerful metadata to bring secure self-service business intelligence to business-users and OEM applications. Topics covered will include drag & drop report and dashboard design, JSR-168 portal support, and the new ad hoc query facility.
Tom Daly (Sun Microsystems, Inc.)
This technical session highlights three benchmark tools that MySQL users and web developers can use to compare, test, and tune MySQL performance: SPECjAppServer2004, EAStress, and FABAN.
Joshua Drake (Command Prompt, Inc.)
Designed to deliver pointed information on the flaws in the MySQL and PostgreSQL communities, what they can learn from each other and how they both can improve the open source database landscape.
Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.