Innovation happens everywhere; MySQL drives innovation within support to serve customers better. Considered one of the best, we'll show off how MySQL Support works around the clock, around the globe. This talk could be useful for startups trying to build services for their customers and community. We'll show the tools we are using and how support engineers communicate internally with each other.

mysqlnd, also known as MySQL native driver for PHP, is the new way of connecting from PHP to MySQL. It's a superior substitute to libmysql. mysqlnd is "native" to PHP, in means that it uses the infrastructure provided by PHP. In this session I will show why mysqlnd is better than libmysql, in the PHP world - performance, better resources utilization, quicker bug-fixing cycle and others.

An overview how to make MySQL host system more secure, MySQL itself hardened, access control impossible to penetrate and use all possible security features MySQL provides. Additionally, it will cover some of security design flaws, that can be best resolved by hacking MySQL itself.

Recently faced with the problem of an ordinary table growing too large to back up or maintain, we designed a MySQL-Proxy-based storage cluster which seamlessly integrates with the rest of the database and offers redundancy, cluster-member failure protection, load balancing, and information lifecycle management (data age-out) capabilities.

See the replication developers give you a fast-paced session of some of the more interesting, useful, and odd ticks available for the intermediate to advanced replication user.

How do you set up replication? What can you do with replication? If these are the kinds of questions you ask yourself, then you need to go to this replication tutorial. You will hear the replication developers explain the architecture and concepts behind replication, and learn how to configure and use replication for managing backups, handle high-availability, and performing scale-out.

Discussion on solid state disk and how it will change the high performance industry. View pretty graphs and benchmarks that will dazzle your eyes, with numbers sure to get the purest database performance geek excited. DBT2, sysbench, Orion, and other benchmarks will help highlight the advantages and disadvantages of this new and exciting technology.

There are many different ways of scaling up and scaling out using MySQL. You can take advantage of replication, DRBD, memcached, MySQL Proxy and many other solutions. This tutorial will take you through all of these solutions and their combinations to increase your database throughput.

MySQL security best practices often assume restricted access to the physical server and restrictive file system privileges. However, OEM's and ISV's who bundle and distribute their application with MySQL have no control over where the application is installed. This session will provide silent installation instructions, common deployment strategies and recommendations for securing your data.

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.