Presentations: Architecture and Technology

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