Presentations

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.
Werner Vogels (Amazon.com)
There are many challenges when building a reliable, flexible architecture that can manage unpredictable behaviors of today's internet business. This presentation will review some of the lessons learned from building one of the world's largest distributed systems; Amazon.com.
Jeff Rothschild (Facebook.com)
Social applications integrate information about many different facets of people’s lives. Join us as Jeff Rothschild from Facebook looks at the power of the social graph, how it can increase the utility and adoption of applications, and its implications on storage architectures.
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.
Jeremy McAnally (Arcturo)
It's very important to have a firm grasp of ActiveRecord if one plans on using it with Rails or Ruby; this talk will cover ActiveRecord from the top level abstractions to the nitty-gritty with SQL.
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.
Jeffrey McManus (Approver.com)
In this session we'll go beyond the basics to demonstrate the creation of data-driven applications using .NET and MySQL. We'll include discussion of ASP.NET Ajax with MySQL and LINQ in .NET 3.x.
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.
Florian Haas (LINBIT Information Technologies GmbH), Philipp Reisner (LINBIT Information Technologies GmbH)
Is high availability on your agenda? Then this tutorial is a must. It's high-availability clustering on Linux with MySQL and DRBD in a nutshell.
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.
Have a burning question about Pythian or MySQL? Whether you want to know what it's like to work at Pythian, what it's like to be a client of Pythian, or just have a MySQL question you have not gotten answered yet, The Pythian Group's Database Mastros are on hand to answer your questions. Or, just listen and sip some free booze. Yes, we said it. Free Booze.
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.
*Release your inner geek at this festive Web 2.0 code-athon!* * For newbies, get a hands-on look at the latest Ajax and Web 2.0 technologies. * For rock stars, compete for the title of Fastest Web 2.0 Developer in the West! This BoF mixes hands on tutorials for Ajax and Web 2.0 newbies with the action and excitement of a white knuckle coding competition.
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.
Mike Ho (Quasidea Development)
Beyond the basics of today's ORM-based approaches, this discusses object-oriented querying in PHP, allowing developers to execute complex MySQL queries without needing to write a single line of SQL.
Forum for discussing the evolution of Online Backup.
Reggie Burnett (Oracle)
This session will walk through everything from using BitKeeper to access the source trees, to the CMake build system, and using the free command line and GUI-based tools to build and debug MySQL.
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.
Your first MySQL Plugin or UDF extension is only 10 minutes away using this code generator. Focus on the actual functionality and let the generator take care of glue code and build infrastructure.
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.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
MySQL provides you with a choice of storage engines to power your data warehouse applications. Choosing the right storage engine can make all the difference. If your are experiencing performance shortfalls, then you need to attend this BOF session. Storage engines will be compared, and a revolutionary new storage engine technology, Fractal Trees, will be introduced.
Florian Haas (LINBIT Information Technologies GmbH), Philipp Reisner (LINBIT Information Technologies GmbH)
A high-level introduction to high-availability database clustering on Linux with MySQL Enterprise, Heartbeat, and DRBD.
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.
Nathan Letwory (Blender Foundation)
MySQL can bring a production environment the basis needed to create the tools for managing large datasets. Searches can be implemented in an efficient manor and the database lends itself for collaboration between multisites. dbBlender is a project to integrate MySQL in Blender to solve many of the problems with large datasets and multisite projects.
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.
Jess Balint (Sun Microsystems, Inc.)
Deadlocks, wait timeouts, and other transaction issues—how to develop transactional applications with InnoDB and what to expect from Falcon.
Arjen Lentz (Open Query)
A popular and lighthearted session in quiz format. Fun and educational, a broad range of "what not to do" is explored, taking examples from the scary real world.
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.
Frank Mashraqi (Opportunities)
What’s the worst disaster you expect to happen? What can you do to better prepare for the disaster? Join us in this heart-racing, real-life inspired presentation for answers to these questions and more.
Data-driven businesses that use data analysis to direct their decisions, are collecting data at ever-increasing rates. At the heart of these businesses is the database used to store and analyze that data. Tokutek's storage engine significantly accelerates both insertions and range queries. Our storage engine achieves high performance through the use of cache-oblivious algorithmics.
Drupal is an open source social publishing software that empowers individuals, teams, and communities to easily publish, manage and organize web content. Tens of thousands of organizations use Drupal to power community web portals, corporate web sites, social networking sites, personal web sites or blogs, and much more. MySQL skills are in high demand to help manage these growing sites.
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.
Chuck Bell (Oracle)
In this session you will learn how to create embedded MySQL applications through a tour of the MySQL embedded library C API.
Baron Schwartz (VividCortex)
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.
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
Brian Aker (MySQL)
MySQL has a wealth of extension points. Through plugins and UDFs you can extend the server to create custom environments.
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.
Take the opportunity to network one last time at this closing event. Say thank you and exchange contact information until next year.
Raj Cherabuddi (Kickfire)
The history of computing is full of algorithms such as graphics processing that are fine-tuned in general purpose CPUs over decades. Only when they are finally ported to dedicated hardware are tremendous improvements in speed, cost, and power realized. Raj Cherabuddi explains how a new SQL chip will revolutionize today’s database query processing.
General discussion on the Federated Storage Engine. Where development stands, what are the plans for the engine, how can the engine be improved. Also, anyone who wants to know how to use the new pluggable FederatedX storage engine.
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.
Brian Moon (dealnews.com)
The more popular a web site gets, the more power it takes to run it. Brian Moon will share the journey of their web site from one server, to the cluster they run today, including how they have used MySQL.
Stewart Smith (Percona), Monty Taylor (HP)
A discussion of the use of and internals of the NDB API (through C++ and Java) and execution in MySQL Cluster.
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.
Discuss Sphinx engine and full text search questions in general, share your usage experience, submit your ideas for new features, and have a nice full text evening with Sphinx project lead as your host.
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 (php[architect])
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.
Mark Callaghan (Facebook)
Mike Callaghan will describe enhancements to InnoDB that improve its scalability on servers with many disks and many CPU cores, results from benchmarks, and results from production systems.
MySQL can be made Highly Available in countless ways, which can make picking the right one tough. We'll compare and contrast many of the popular tools, including Replication, DRBD, Cluster, and more.
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.
IBM
More information soon
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.
Meet and greet fellow InnoDB users along with Innobase's Heikki Tuuri and Ken Jacobs for a lively and wide-ranging discussion about technology and directions for InnoDB, the most popular, proven and best-performing transactional storage engine for MySQL.
Heikki Tuuri (Innobase / Oracle Corp.), Ken Jacobs (Oracle / Innobase)
If you're new to MySQL, new to transactional applications, or wondering about how InnoDB compares to other emerging storage engines, this session is for you. Your business can depend on reliable, fast, and proven transactional capabilities.
Heikki Tuuri (Innobase / Oracle Corp.), Ken Jacobs (Oracle / Innobase)
Ken Jacobs and Heikki Tuuri will describe the InnoDB architecture in depth, and discuss the new powerful performance-enhancing capabilities in InnoDB.
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.
How to extend your LAMP stack for rapid web application development by using an integrated environment of various frameworks (Zend for PHP, YUI for Ajax), Smarty for templating, and other libraries.
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.
Sun Microsystems and JasperSoft invite all MySQL OEM customers and prospects to join us for a cocktail reception, Wednesday, April 16, 2008, from 5:30PM-7:30PM, in the Bayshore Ballroom at the Hyatt Regency Santa Clara.
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.
A meetup of MySQL meetup organisers and participants
Brian Aker (MySQL)
Not heard of Memcached? This means you haven't scaled your application yet, or that you are having problems. Lets consider some solutions.
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.
General discussion of Memcached Functions for MySQL, new user-defined functions (UDFs) utilizing Brian Aker's libmemcached client library that allow you to interact with a memcached server through MySQL
Memcached is awesome, come hack on it!
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.
Almost from it's inception PHP has enjoyed a symbiotic relationship with MySQL. Even though both projects continue grown in new and exciting directions, 70% of all PHP users still use MySQL for their data storage. Come talk about where the relationship has been, where it stands now and where things are going. Come celebrate the relationship of these two friends.
In this BoF Session, Zmanda will review best practices for backup and recovery of MySQL databases.
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.
New addition to the MySQL Conference & Expo for 2008, the MySQL open source career fair offers sponsors the opportunity to promote job openings to the hundreds of MySQL developer DBAs and system administrators attending the conference. The one-day fair will take place on the last day of the conference, Thursday, April 17, from 10:00 AM – 3:00 PM.
MySQL Cluster is a fault-tolerant, high performance, in memory clustered storage engine. Additionally, it provides a direct API that works underneath the SQL layer that can be used for clients with truly high performance needs.
In this BoF we will talk the design and status of a new backend for OpenLDAP, back-ndb, developed by Symas Corp that offers realtime LDAP performance, scalability and high availability.
Stewart Smith (Percona)
A hands-on MySQL Cluster 5.1 tutorial where you'll install and setup MySQL Cluster (on your laptop) and learn about what it is, what it can do, and basic administration skills.
Learn how Paggo utilized a Replicated Cluster to guarantee the necessary High Availability and contingency for financial transactions.
The MySQL Enterprise Monitor provides a consolidated view into the health, performance and availability of all your MySQL servers. Join the MySQL Enterprise Tools Engineering team for an early look at the new Query Analyzer feature and help shape how this new feature can be delivered to best fit your needs.
Brian Moon (dealnews.com)
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Learn how.
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.
This session will be an Engineering led discussion of the new MySQL Enterprise Load Balancing, Query Analysis and Connection Manager functionality. These new tools are designed to alleviate common pain points felt by those using replication to scale the performance of high-traffic, online applications and web sites.
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.
MySQL will host a partner meeting, in conjunction with our Conference, on Monday April 14, 2008 from 5:30pm to 7:30pm. As a current or prospective partner, this is a unique opportunity to learn about company goals, future directions, product roadmaps, partnership opportunities.
Tobias Asplund (Marin Software), Jay Pipes (Rackspace Cloud)
In this session we'll put features that do the same thing up against each other and see which performs better. We find the optimal way to do smaller things. Everything is backed up by benchmarks and discussion.
Jan Kneschke (MySQL), Jimmy Guerrero (Oracle-MySQL)
MySQL Proxy is a tool to route, rewrite, handle, and block queries on the MySQL Protocol level. Load Balancing, Query Replay, Online Query Rewrites, and more with a grain of scripting.
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.
The MySQL Conference Quiz Show pits teams of contestants against each other in a battle of geek wit, ingenuity, MySQL knowledge, and speed.
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.
Dan Stangel (HP Open Source Program Office), Bruce Huang (HP Open Source Middleware Stacks (OSMS))
More information coming soon
For everybody not attending the tutorial on Monday this is a chance to ask questions about the MySQL Workbench scripting capabilities.
A discussion of the MySQL Workbench road-map in general and the MySQL Workbench 5.1 release in particular.
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)
The power of MySQL Workbench will be shown by using it in several real world scenarios. These will cover migration, automation of schema transformation processes, and schema reporting.
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!
Make plans to join us at a new addition to the MySQL Conference & Expo for 2008: The Open Source Career Fair. The Fair offers sponsors the opportunity to promote job openings to the hundreds of MySQL developer DBAs, and system administrators attending the conference.
Jonathan Schwartz (Sun Microsystems)
Free software and open communities are the lifeblood of network innovation. Sun Microsystems CEO Jonathan Schwartz will highlight the rising open source tide and how Sun's recently announced acquisition of MySQL furthers free software as a platform for the web economy.
Frank Mashraqi (Opportunities)
In this presentation learn how MySQL, InnoDB, and Solaris helped Fotolog gain the top performance it desired as the world's largest photo blogging community through tuning and schema optimizations.
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.
Gregg Kitaeff (LogicWorks), John Rowell (OpSource, Inc.), Bruce T. Guptill (Saugatuck Technology), Uday Shanmugam (Relationals)
This panel will discuss the impact of Open Source Software on Software as a Service (SaaS)companies and their ability to effectively deliver on Service Level Agreements to their clients.
Join us for this 75 minute Seminar on how MySQL Enterprise can help you strengthen your position as a trusted adviser and drive revenue.
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!
PBXT a transactional storage engine from the open source company PrimeBase Technologies will be one of the new engines available in MySQL 5.1. Also available will be the Blob Streaming Storage Engine.
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.
In this BoF session, join Kickfire and some of our MySQL geek consultant friends to share your input on what the industry should address to get the best query performance in MySQL. The query fairy will buy the beer. There is magic after all.
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.
Domas Mituzas (Facebook)
Experience from international customer base and multilingual projects: character set conversion issues, performance impact, limitations, security concerns, and more.
Domas Mituzas (Facebook)
A walk through modern web application database development tips and tricks: MySQL-specific features, web-oriented schemas and queries, and storage engine behavior.
Chander Kant (Zmanda)
Protecting corporate data through effective backup and recovery is the most critical task for a database administrator. As MySQL moves into mission-critical transaction environments, the ability to perform online backups without causing any application downtime is a must. Similarly, the ability for MySQL DBAs to go back in time and restore data just before an error is equally important.
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.
Patrick Galbraith (Blue Gecko)
Replication is one of the most important features in MySQL. Having the ability to replicate data across data centers is invaluable. Learn how to set up replication, monitoring, and problem-solving.
Lars Thalmann (Oracle), Mats Kindahl (MySQL)
Tips and tricks to speed up deployment of your replicated database server environment. Come learn all the goodies from the creators of the MySQL replication system!
Dathan Pattishall (Rockyou)
Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. MySQL myISAM/INNODB, curl, Java are the only component used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
Kaj Arnö (SkySQL Ab), John Allspaw (Etsy), Jeff Rothschild (Facebook.com), Monty Taylor (HP), Domas Mituzas (Facebook), Paul Tuckfield (YouTube), Frank Mashraqi (Opportunities)
This lively panel discussion keynote will address the challenges large, modern web properties face in scaling MySQL. Panelists from Facebook, YouTube, and Flickr pair up with MySQL engineers in discussing the current and future problem domain and possible solutions.
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.
Ed Presz (Ticketmaster, Inc.)
With the help of MySQL 5, Ticketmaster event databases are meeting the growing global live entertainment demand. Learn how they are implementing databases for the Beijing Olympics, and the new features and limitations they encountered upgrading from MySQL 4 to 5.
Jeremy Cole (Twitter), Eric Bergen (Proven Scaling LLC)
In this session, Cole and Bergen will take a look at the hardware of recent past, today's hardware, and what hardware trends will become interesting during 2008 and beyond.
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.
Joe Stump (SimpleGeo)
Services Oriented Architecture offers a number of benefits over the standard paradigm including parallel asynchronous request, decoupling your code from your data, and abstracting scalability.
Raj Cherabuddi (Kickfire)
Learn about the revolutionary hardware and software behind the first high-performance database appliance for MySQL. Find out how Kickfire packs the power of 10s of CPUs into a single SQL chip and delivers record-breaking query performance for reporting and analysis in the industry’s smallest form factor appliance. Raj Cherabuddi will explain all and share the astounding benchmark data.
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.
Mårten Mickos (MySQL), Rich Green (Sun Microsystems, Inc)
In his annual State of MySQL keynote, Marten discusses the current and future role of MySQL in the modern online world. The presentation also covers the acquisition by Sun of MySQL, the role open source is playing for users and customers all over the planet, and what the visions for the future are.
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.
Put your MySQL problems before Arjen, PeterZ and a gang of other active MySQL Community members present at the MySQL Conference. See if they can work it out!
Have a drink, mingle with fellow conference participants, and enter our raffle to win great prizes, including a a Sony PS3! Sponsored by Sun Microsystems.
Joseph Chamdani (Kickfire)
Traditionally running complex queries on large database workloads requires expensive high-performance hardware. In this talk, Chamdani will present the key system techniques that remove the I/O bottlenecks to deliver order of magnitude(s) performance improvements on large query intensive applications.
Jeremy McAnally (Arcturo)
This talk will cover the basics of using MySQL with Ruby, providing an overview of the three most popular and pragmatic options: the mysql gem, DBI/DataObjects, and ActiveRecord.
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)
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.
Frank Mashraqi (Opportunities)
Lucene is a high performance, scalable, full-text search engine library that allows you to add search to any application. This presentation shows you how you can use Lucene within your environment.
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?
Marc Taillieu (Roadtrips)
TheTicketDepartment.com is an Online Ticket Brokerage that ties into approximately 800 brokers. Learn how they have tied MySQL 5.1 DB into a MySQL 3.23 DB App using replication and triggers.
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.
Following the planned sessions during the day, it's time for MySQL participants to take the floor. BoFs are informal conversations that you and other participants plan. Check the BoF board in the Grand Ballroom Foyer for schedule information.
MySQl has become the database of choice for web applications. In this session, SugarCRM Co-Founder and Chief Technology Office Jacob Taylor will discuss best practices for tuning MySQL to maximize performance and availability. Topics will technical tips and tricks he has learned for performing maintenance and updates to MySQL while minimizing performance degradation.
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.
One of the most powerful, yet underutilized MySQL features are User Defined Functions and Aggregates. Learn how to use them to dramatically improve the speed of your data warehouse processing.
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.
John Rowell (OpSource, Inc.)
Until this point, SaaS applications have been created in separate silos. However, now there are non-proprietary platform choices as part of the Web 2.0 architecture and other emerging technologies that enable mash-ups and composite applications. Learn how web operations have expanded to include application and business services that affect application development and integration.
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.
Following the planned sessions during the day, it's time for MySQL participants to take the floor. BoFs are informal conversations that you and other participants plan. Check the BoF board in the Grand Ballroom Foyer for schedule information.
Have you been yearning to deal with your menu structure or social network using plain SQL queries, joining on to your other data? What if... that can actually be done?
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.
Dick Hardt (Sxip Identity Corporation)
Much of the data in a database is about people. Identity 2.0 technologies will lower the friction for people to provide and easily move data about themselves online. This fast paced keynote will offer a background on Identity 2.0, discuss current roadblocks and future opportunities, and explore the potential impacts these will have on databases.
Roland Bouman (XCDSQL Solutions / Strukton Rail)
During this tutorial, attendees will get a detailed introduction into the MySQL UDF interface and will learn to write and deploy their own UDFs for both Windows and Linux platforms.
Ann Ruckstuhl (Zmanda, Inc.)
Zmanda Recovery Manager (ZRM) for MySQL is a comprehensive, certified, enterprise backup and recovery solution specifically designed for MySQL databases. With ZRM, MySQL database administrators (DBAs) can manage mission-critical, high-volume transaction processing environments with confidence.
Sorry, this tutorial has been canceled.
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.