Looking at sharding your environment? This is the real-world example of sharding our databases using Spockproxy, a sharding-only version of the MySQL Proxy. Layout, sharding, and loading data; problems and limitations of working within shards; and how to get around these problems. The problems and solution we've come across are largely applicable to every kind of sharded environment.

Beginners to MySQL often start monitoring their systems manually but quickly realize the need to automate. When the new MySQL DBA is also new to shell scripting, the task of automating becomes even more daunting. This presentation introduces the Bash shell, illustrates how it can communicate with MySQL and with the outside world, and gives practical examples of these scripts.

"MySQL internal QA" about which many of you may speculate and very have direct knowledge of, will be discussed in this presentation. QA takes care of your favorite database in the development and release cycle, from code review through bug management with massive amounts of testing in between. Come to find out what is being done internally before the server is shipped.

This proposal is to highlight the integration of Open HA Cluster and MySQL. I will cover the various aspects of high availability and business continuity. In addition to the current features, the roadmap of Open HA Cluster will be discussed. There is a large focus on the integration with MySQL replication and MySQL cluster.

Experienced SQL developers know how to solve a class of quite different problems efficiently with the help of an auxiliary sequence table: We'll learn from them with easy to understand hands-on examples -- and meet the SeqEngine, a pluggable storage engine for MySQL 5.1 that helps us to apply the expert's tricks even more efficiently.

The presentation will discuss the loading and indexing of spatial data, but will concentrate on the spatial functions available for further analysis in MySQL. Specific business cases will be used to illustrate these functions, such as the real-time monitoring of boats in offshore windfarm construction. A Java front-end will be used to support the claim that Java plus Mysql equals traditional GIS

The Spider Storage Engine creates table-links from local databases to remote databases. To supports XA transaction and table partitioning itself, the Spider also created for the database shardings. Spider Storage Engine is being offered to the public by GPL. http://spiderformysql.com

Although the popular Ruby on Rails framework is known for its ability to quickly build web applications, getting the most favorable performance out of the standard database, MySQL, takes a little bit of effort. This session will cover simple techniques and tricks for optimizing the interaction of the Rails ActiveRecord for MySql.

Testing a complex system like MySQL cluster is always difficult. In this session we'll show the ANSTE testing framework and how it can help a project like MySQL do exhaustive testing.

ScaleDB storage engine delivers high performance transaction processing capability with row level locking and multi-node concurrency control. It enhances performance through innovative indexing technology and delivers low cost computing with a Shared Disk architecture. When applications demand more computing power, additional servers are added to the cluster to scale the system capacity.

A story of scaling, in today's world - using modern technologies like ZFS, OpenStorage, MySQL, and more, running one of the world's most popular photo sharing sites - SmugMug.

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.