Launching MySQL databases in "The Cloud" can make a DBA's dreams come true. While it is relatively easy to set up special-purpose replicas or scale out on demand -- it is not as easy as it looks! RightScale, the leader in cloud computing management,has already launched thousands of MySQL clusters in the cloud and can help attendees understand the tradeoffs and tricks it takes to do it right.

Ever get frustrated because you can't enforce foreign key constraints between partitioned tables? Perhaps you'd like the ability to spread innodb partitions across multiple file systems / directories? During this session, we'll be looking at creative ways to use Triggers to get around a few of those annoying limitations, and what kind of impact they might have on your application in production.

This is a query optimization troubleshooting roadmap, presented by one of the MySQL optimizer developers. First, we'll give an overview of available query execution strategies and how they are (or aren't) shown in the EXPLAIN output. Second, we'll show how one can find out what the optimizer got wrong. Third, we'll discuss what means one can use to make the optimizer pick the right query plan.

You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA.

Based on a real-world case study from a comprehensive market intelligence product - developed for Boats.com/YachtWorld.com by Breadboard BI, Inc - this 45 minute presentation describes a multi-source, enterprise data warehouse developed on a 100% open source stack - MySQL 5.1 (with partitioning), Pentaho Business Intelligence Suite, Linux OS.

SQLstream's SQL engine performs continuous ETL to offload aggregation and data cleaning from MySQL database systems. Simultaneously, SQLstream enhances MySQL with true real-time queries and analytics. The result is that MySQL executes historical queries much faster while remaining continuously updated and accurate to the last second.

The Dojo toolkit is a popular AJAX-based platform for building interactive web applications. This session will provide information on how to build some basic applications using a combination of Dojo and MySQL. The applications will be built from base principles to fully working system,showing both the interactive and database components.

There has been a lack of substantive data about the state of open source in the business intelligence and data warehousing market. In this session noted industry analyst Mark Madsen will present the results of his recent market research on adoption profiles and characteristics for open source BI/DW.

Q4M (http://q4m.31tools.com) is a high-performance message queue that works as a pluggable storage engine of MySQL, used by Mixi (Japan's largest SNS provider) and Cybozu Labs (for running Pathtraq, one of the nation's largest web access stats service), etc. The presentation will cover from the design principles of Q4M, to how it is used to modularize, stabilize, and extend the web services.

One of MySQL 5.1 main features is the event scheduler, a portable way of executing SQL commands at given times or at scheduled intervals. Using the event scheduler you can organize your work regardless of the operating system you work with. This session presents the basics of the event scheduler, common tasks, tips and tricks.

Long the domain of ArcSDE, Oracle, and other proprietary database back ends, MySQL can compete as a reliable open-source database solution in the rapidly expanding world of Web Mapping Services (WMS). This presentation will demonstrate the utility and flexibility of MySQL's geo-spatial features and how these can be combined with other technologies to publish data into open WMS standards.

MySQL Cluster is unique among the selection of MySQL storage engines in that's not exclusively dependent on a MySQL server. The result is that a cluster can be accessed just as any other MySQL database or directly with the native NDB API. This session will cover application development with MySQL Cluster and Java using NDB/J.

Do you use replication? Would you like to improve your data protection and recovery capabilities? If you do, chances are you would also like to improve your ability to recover from failures faster. In this session, we will show you how you can use backup to enhance your replication capabilities.

There is a lot of buzz about Memcached and MySQL 5.1 and what it can do for your website. But how exactly do you go about setting it all up and write your code to make use of memcached? In this session, Adam Donnison will take you step by step through implementing memcached using real world examples in PHP from the MySQL.com website infrastructure.

Do you like to tinker? Would you like to see how MySQL? If you’d like to get your hands dirty (or watch others work their developer magic), stop by this session and learn how to take a simple desktop system running MySQL into a fully functional time based backup system that you can connect to any server and get up to the minute recovery capability.

In this session we will build a PHP+MySQL application in NetBeans that uses the Twitter API to find and graph a "meme" in Twitter.

Feeling the pressures of data warehousing? Costs growing non-linearly? Are data growth, ad-hoc queries and near real-time data availability requirements threatening to take your DW system past the event horizon? Let us show you how to create a scalable, open source, low cost data warehouse with MySQL & the Calpont storage engine.

This presentation explores what cloud computing means beyond being a buzz-word and touches upon the various scenarios where MySQL and Pentaho Data Integration (Kettle) can be deployed on a large number of hosts to process data in parallel.

Connector/J has a wealth of under-promoted performance features. Come to this session to learn about bulk data loading, load balancing, batch rewriting and the "reckless but really fast" options that C/J has.

Indexes are known to speed up retrievals, but do you know that sometimes looking at the indexes is sufficient to get the data you need ? This session will help you understand the principles of covering indexes, their benefits and the situations where you should avoid them.