MySQL Conference & Expo 2009 Schedule: Full Listing

Customize Your Own Schedule

Create your own schedule using the personal scheduler function. Mark the tutorials, sessions, keynotes, and events you want to attend by clicking on the calendar icon next to each listing. Then click on "personal schedule" below and get your own customized schedule generated.

Is your database development out of control? Are you using source control but still feel apprehensive about how your database changes are released into the wild? This tutorial will demonstrate how to logically structure and manage your database development and use the latest tools to code, test, and release database changes with ease and confidence.
Read more.

The MySQL plugin API is a generic extension point for the MySQL (>=5.1) server. It allows users to add new features like storage engines and information schema tables, and to extend existing features such as FULLTEXT search.
In this tutorial, you will learn how to write your own plugins from one of the designers of the plugin API. Basic C/C++ programming skills are recommended but not required.
Read more.

A hands-on MySQL Cluster tutorial. We'll be using the latest MySQL Cluster version and we'll be installing and using it on your laptop. All hands on, so you really learn (it's not just a long talk).
Read more.

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.
Read more.

This tutorial focuses on how to design and build a data warehouse, with emphasis on common pitfalls encountered by implementers and how to avoid them. We’ll spend some time discussing why Data Marts are different from transactional solutions and how to think differently when designing and implementing a Data Mart or Data Warehouse, along with real life examples using Open Source technologies.
Read more.

Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the first part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
Read more.

Setting realistic expectations and choosing appropriate architectures rely on having solid benchmarks. This tutorial will show you how to use the available tools.
In addition once you have built your application monitoring is key.
Join us while we give you a three hour tour of the tools available.
Tools such as mysqlslap, supersmack, jmeter, xenoss, enterprise monitor, nagios and more.
Read more.

The original memcached tutorial has done its rounds around the globe, and it's time for round two. Quickly get up to speed with integration and tuning examples, then dive into new topics and community tricks. See how the new binary protocol and storage engine interfaces can solve hard problems.
Read more.

Partitioning is a powerful feature in MySQL 5.1. Its use can boost
performance considerably, both in OLTP and data warehousing systems.
Its usage is not intuitive, though, and requires some care and experimentation.
Read more.

Regardless if you are a newbie to the MySQL database or you have been using MySQL for years already - this is your chance to learn professional database schema design from the MySQL experts. Get fluent on the basic modeling concepts, learn all about the performance tricks and become a pro in using MySQL Workbench, making database design and maintenance most efficient. Reserve your seat now!
Read more.

The database is the foundation of any innovative project, but you can't innovate if you're making the same mistakes of yesteryear.
Bill describes a selection of common SQL blunders, illustrates their weaknesses, and offers better solutions.
Read more.

Recently, there has been a lot of buzz around MapReduce, and the Apache Hadoop project. Even more recently, we have seen proprietary SQL database systems add support for MapReduce. This is great for data, but lacks advantages of open source. In this tutorial, we will provide both background knowledge and the practical experience necessary to combine these models to get more out of your data.
Read more.

Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the second part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference.
Read more.

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.
Read more.

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.
Read more.

Sponsored by Sun Microsystems, Inc., 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 first day of the conference.
Read more.

In the annual State of MySQL keynote, Karen Padir, Vice President for MySQL & Software Infrastructure at Sun Microsystems discusses the current and future role of MySQL in the modern online world. The presentation also covers the broader role MySQL plays at Sun, the role open source is playing for users and customers all over the planet, and what the visions for the future are.
Read more.

MySQL Camp 2009, a community organized event designed to share and improve the essential skills required to participate in collaborative, free and open online projects. It is the place for hacking code and exchanging technology within the larger event.
Read more.

It began as a question. Could a slice of silicon make MySQL the fastest database on the planet? Impossible, most thought. It would have to be magic. Well, call it magic or advanced technology, it's here. Join us and we'll show you how it's making customers' data warehousing limitations disappear!
Read more.

This session describes the joint Sun/MySQL performance & scalability project. We will look at the key performance issues, what has been achieved so far and share initial results. We will indicate some of what's on the roadmap for the immediate future. Wherever possible, best practices and recommendations for achieving optimal performance will be offered.
Read more.

Craigslist serves millions of classifieds to millions of users around the world on a daily basis and MySQL is our database of record for all this data. But how do you efficiently design a search system to handle this volume?
Read more.

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.
Read more.

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.
Read more.

Mamasource has a vibrant online community with 2 million members and hundreds of millions of rows of data. Explosive growth meant we were pushing the envelope on analytics. We required dramatic improvements in query performance, scalability and cost. Find out how Kickfire's appliance proved to be the magic we needed!
Read more.

In this joint presentation, Ian Fyfe, Senior Director of Product Management at Jaspersoft, and David Lutz, Director of Systems Engineering at Infobright, will discuss the evolution of the market and give real-world examples of end-to-end open source Business Intelligence solutions.
Read more.

Working in an Agile environment poses unique challenges for DBAs used to more traditional environments. This session, co-presented by Laine Campbell of Palomino DB, Inc. and Sheeri K. Cabral of The Pythian Group, will explain how to function more effectively as an Agile DBA, giving you tips and tricks to better survive in an Agile development environment.
Read more.

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
Read more.

MySQL deeply embedded version, libmysqld, is coming back in MySQL Version 5.1. This talk gives an overview of libmysqld, the advantages and the limitations, as well as example applications and sample code. The talk is centered around C applications, so knowledge of C is assumed to appreciate this talk fully.
Read more.

With the increase complexity of software architecture and database design the amount of data stored in databases systems grows rapidly. Additionally, data security and international regulatory laws require that data changes are audited and restorable to any point of time. The revision engine implements automated auditing of data transparently as a storage engine.
Read more.

With MySQL Cluster 6.4, we introduce support for the Microsoft Windows platform. This session covers: introduction to MySQL Cluster, getting started with Cluster on Windows and differences between Linux and Windows versions.
Read more.

Lately there's been a lot of talk about MySQL-based business intelligence and datawarehousing. But what does it all really mean? What's behind the BI/OLAP/ETL alphabet soup, and what in heavens name are star schemas, facts and dimensions? Using the Sakila sample database as material, this session will explain what data warehouses are, what problems they solve, and how they are designed and built.
Read more.

InnoDB has always had unique features to maximize performance and protect the integrity of your data. As hardware has evolved, InnoDB has been enhanced to take full advantage of modern multi-core, large memory platforms. Come learn about the special design features of InnoDB and the performance- and reliability-enhancing features recently introduced in the InnoDB Plugin.
Read more.

Ever wondered what would happen if we could rethink a decade worth of design changes? Drizzle is a fork of the MySQL server targeted at web development and cloud computing. We are looking at how to create database for modern multi-core, large memory databases that fit inside of an overall application framework.
Read more.

Enterprise email is broken. From managing metadata to the inefficiency of multiple message storage, IT administrators have long bemoaned the task of implementing a scalable, affordable, reliable messaging architecture. Zimbra and MySQL’s combined expertise has altered the way administrators control their email servers through the development of a more effective back end for messaging architecture.
Read more.

The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL.
Read more.

The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines.
Read more.

Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits.
Read more.

Supercharge your MySQL deployments with the world-class performance of Intel® Xeon® 5500 series processors. Hear Steven Chin, Director of Software Engineering, discuss Intel's role in OpenSource and the ongoing benefits to users that are a result of Intel performance teams working jointly with Sun and the MySQL performance engineers.
Read more.

Many of the characteristics that make MySQL so successful also apply to GlassFish and NetBeans. This talk will demonstrate how MySQL, GlassFish, and NetBeans can be used together to create quick and powerful web applications. It shares tips to boost web application development when using all of them together.
Read more.

What are the challenges facing storage engines today and tomorrow? Solid state storage, 64 cores and beyond and cloud computing environments are all areas in which a storage engine must prove itself now, to be equipped for the future.
This session will discuss the design of the PBXT transactional storage engine, and the ideas and solutions, planned and implemented to meet these challenges.
Read more.

Advanced uses of MySQL Proxy require a deeper understanding of queries running through Proxy than
tokenization can offer. Using a parser and supplementary infrastructure makes accurate query rewriting
possible to do sharding, better error messages or accomodating legacy applications.
We will look at how to implement these features and demonstrates how it can be used in other
applications, too.
Read more.

How good are ORMs like ActiveRecord, DataMapper, and Sequel? We'll examine the dominant Ruby ORMs and look at the SQL they generate, MySQL gotchas, and what a developer really needs to know about SQL in the age of ActiveRecord.
Read more.

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.
Read more.

Join James Dixon, founder and chief technology officer of Pentaho Corporation, as he explains how to bring business intelligence to your MySQL deployments with Pentaho BI Suite – the most comprehensive suite of BI capabilities in open source.
Read more.

Habbo, the world's leading virtual world for teens, has been running on MySQL ever since year 2000 and serves millions of users each month. It's global operation and continued product development depend on timely analysis of masses of data, a challenge we solved using Infobright's Brighthouse DWH engine. I'll tell you why and how we did that.
Read more.

This session will introduce DTrace, OpenSolaris's Dynamic Trace Facility, which can be used to give unprecedented access to the inner workings of MySQL. We will explore specific MySQL DTrace probes and the DTrace pid provider, which allows the gathering of information about any function within a process.
Read more.

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.
Read more.

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.
Read more.

Cloud is becoming computing and storage platform of choice for MySQL DBAs. In this session, we will discuss backing up on-premises MySQL databases to Storage Cloud (e.g. S3 or Sun Cloud), as well as backing up MySQL databases running in the cloud. We will demonstrate Zmanda's Cloud Backup Solutions.
Read more.

In blazing speed we will cover the most important features on MYSQL Cluster 7.0: online add node, multi-threading of the data node and a bunch of other features that pushes the limits of MySQL Cluster even further.
A demo will be made showing how to add a node.
Read more.

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.
Read more.

The combination of MySQL and Hadoop opens up new doors for innovation that weren't possible before. Hadoop allows for Massive Parallel Processing but falls short of offering the speed, features and advantages of a relational database such as MySQL. For data intensive startups with massive data processing requirements, a combination of Hadoop and MySQL may be the best solution.
Read more.

Any application with frequent polling and extensive archiving needs has run into the situation of ‘too much data’. Tables become huge and unsearchable, performance goes down, and over time the cost to store this data adds up. This session covers data smoothing techniques including SQL query side solutions that reduce resolution for data archival storage for more efficient application performance.
Read more.

Sharding is all the rage now a days, this presentation explains in detail how Rockyou.com implements Sharding to support over 100 million users across various global social networks. More then 3.4 Billion queries per day are done on this new architecture all using mySQL as a common backend.
Read more.

Database access in Ruby on Rails can be extremely slow, but it doesn't have to be: this talk will discuss ways you can get massive performance speedups by increasing your query efficiency and by minimizing ActiveRecord object creation. This can keep your application scalable and responsible even under large datasets and modest hardware.
Read more.

Attendees will learn the benefits and key features of a solid
dashboard solution. The presentation will also include a demonstration of how to build and configure dashboards and a discussion of the integration with MySQL.
Read more.

In this session, DBMoto’s architect, Marco Sandrini, will walk attendees through a technical review and customer implementation example of mirroring between MySQL and other major databases. DBMoto’s functionality includes support for remote replication, fast CSV loading, replication grouping, recovery, and visual error-checking.
Read more.

In this BoF we would like to have an open discussion with members of the MySQL Community about the subject of code contributions to MySQL. We'd like to talk about some of the recent changes and improvements we've put in place and generally ask for input and advice on how to further open up and accelerate the process of accepting code to the MySQL code base.
Read more.

One of Joyent's customer just hit 45,274,892,601 queries on MySQL running on the cloud with zero down time and no reboots. This as well as several other examples help to prove out that scaling is possible in the cloud. This session will explore how to make this happen with your applications with MySQL and without.
Read more.

Come, learn and exchange with engineers who implemented OpenDS for MySQL Cluster how to access efficiently to data stored and managed in MySQL Cluster Carrier Grade.
Also understand how by leveraging Sun Virtual Directory Proxy you can consolidate LDAP data access to MySQL Enterprise.
Share with others users and architects from the Sun/MySQL development team use cases and deployment scenario.
Read more.

Zmanda Recovery Manager for MySQL is a widely used open source tool to perform MySQL backup and recovery. Sun Open Storage is an excellent platform to be the target of MySQL backups as well as to run MySQL server on. BoF will discuss enhancements as well as what is planned for these two products together.
Read more.

Drizzle runs well in distributed clusters for web-scale and cloud-scale applications. It makes sense to use distributed computing for the analysis of the performance and query logs for the Drizzle servers.
Read more.

This BoF session brings the MySQL Proxy Community back together with the Enterprise Tools Engineering team to share what we have done, where we are, and where we are headed with the Proxy. It is also a great time to learn about new Proxy extensions and share your feedback on how Proxy can best fit your specific needs.
Read more.

Jaspersoft would like to host a BOF for it's community and users to update them on the following topics;
- Whats new in our v3.5 release
- Jaspersoft and MySQL Stored Procedures (making them work for you)
- Community feedback/dialog session
Read more.

Performance Is Everything. Percona's free technical conference brings together the leading minds in the application performance field. The focus is on full-stack application performance, not just databases.
Read more.

This lively panel discussion keynote will address the nature of the Cloud, with cloud technologists at Sun Microsystems, with industry analysts, experts and customers in the cloud area. This panel is moderated by Kaj Arnö, and attendees are encouraged to participate online via Twitter.
Read more.

Sheeri K. Cabral, a two-time winner of the MySQL Community Advocate
award, passes the baton to the next generation of MySQL Community
superheroes -- you! Though you cannot fly or have X-ray vision,
Sheeri will explain how you can make a difference in the MySQL
Community without writing a single line of code.
Read more.

With the volume of data exploding and the need for business insight more critical then ever, a new breed of open source solutions delivers the simple-but-sophisticated analytics an enterprise needs to make fact-based decisions and compete more effectively.
Read more.

Everybody knows that indexes can boost SELECT performance, but how do you verify that you are using index correctly?
In this session, I'll explain detailed mechanism of traditional MySQL B+Tree indexes, optimizer plans, and how to boost performance. Not only speeding up SELECT, but also speeding INSERT are covered.
Read more.

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.
Read more.

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.
Read more.

memcached is a key ingredient in any major Web 2.0 site to offload the database by handling the read-load. The introduction of Flash memory and SSD in commodity hardware, opens new possibilities for a hybrid cache with a better price/performance.
Read more.

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.
Read more.

This presentation provides a look into the future of the entire MySQL product line - the MySQL Server, MySQL Enterprise, and Management Tools with an update also being given on community and partner storage engines, high-availability solutions, data warehousing offerings, and much more.
Read more.

MySQL Enterprise Monitor provides a plethora of base Advisors, Graphs and Data Collections for DBAs and Developers. However, have you ever wanted to extend these to suit your environment more closely?
Read more.

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.
Read more.

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.
Read more.

What is libdrizzle? A complete client library rewrite for the Drizzle project. Why is this interesting for MySQL users? It supports the MySQL protocol and provides a non-blocking I/O interface. This session will demonstrate the power of connection pooling and how to run parallel queries to decrease overall processing time. PHP examples will be used, but other languages will be very similar.
Read more.

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.
Read more.

From this presentation you will know how to create a scalable full text search solution with MySQL, how to tune MySQL full text search for maximum performance, how to integrate MySQL with external search solutions and much more.
Read more.

Monitoring is not rocket science yet so many websites and organizations simply don't do the basics. Why?
It's not a complex problem, and having monitoring & metrics in place can both prevent disaster and give great insight to solving problems more easily.Prevent unnecessary extended down time and have perform tuning gathering timings with a detailed history at your fingertips in a few easy steps.
Read more.

Do you have a hard time getting an overview of where replication is moving? Are you wondering what is going on in the community and inside the replication team? If these questions are on your mind, then you have to visit this panel discussion with some of the foremost developers and consultants on replication technology and hear what they have to say about the future of replication.
Read more.

Network communication can be a significant bottleneck for several MySQL architectures and applications. Dolphin Express cost effectively reduces network latency and can dramatically improves applications performance. Dolphin showcases application examples with improved performance results based on Dolphin Express and the ease of installation and use to achieve these results.
Read more.

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.
Read more.

The talk will describe the goals and design of Maria, the new transactional storage engine for MySQL. It will cover the goals of Maria Storage Engine, overall design, on-disk data formats, Multi-Version Concurrency Control in Maria, BLOB handling, row locking and lock escalation, roadmap (current and future).
Read more.

Gears is a Google OSS project to extend common web browsers (FF, IE, Chrome), providing Ajax webdevs with features such as an embedded SQL database and support for long-running background processes.
This talk describes in detail how to create browser-based applications that use this local, embedded relational database, and how to synchronize this local database to a central MySQL server.
Read more.

This hands-on session will show you how to change your MySQL server to enable SSL. You will see the steps involved to create an SSL certificate and enable users to connect securely. With SSL you can allow a user to connect unsecurely, connect unsecurely or securely, and you can also require a user to only connect securely.
Read more.

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.
Read more.

A case study of the evolution of MySQL usage, as a company moved from a scrappy startup - with the goals of finding a cheap, quick, and simple database solution - to a mature enterprise - with high availability and horizontal scalability as key requirements.
Read more.

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.
Read more.

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.
Read more.

Have you ever had Innodb database corrupted or have deleted data
accidentally and want it back ? This session will go through various
approaches you can use to get most of your data back using MySQL build
in features as well as third party open source tool.
Read more.

Insights from the developers behind MySQL Partitioning.
How is partitioning implemented, how does it work in the server and with the storage engines? What solutions can it be a part of and what problems does it introduce?
We present a new partitioning type: Column list, range partitioning on any column type. And give the status of the current development.
Read more.

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.
Read more.

The goal of this session is to introduce users to new standard conforming and engine-neutral implementation of foreign keys, which is being developed for 6.1 version of server. The session will describe capabilities of this new implementation (including limitations for different engines), give a glance at its performance and provide comparison with current InnoDB-specific implementation.
Read more.

Building a SaaS platform requires application and infrastructure engineering that push beyond “enterprise scale” to “web scale”. MySQL and Memcached play a key role in scaling the Clickability platform. This presentation will tell the evolutionary story of the core technology components that have allowed the platform to scale from 0 to 400m pages per month, without changes to the architecture.
Read more.

Topics for this session will include: Choosing between MySQL and a host of other DB platforms,Plugging new MySQL instances into the Ticketmaster architecture, Challenges encounted when upgrading to MySQL 5.x, Transferring data between Oracle and MySQL, and MS SQL Server and MySQL, Monitoring and performance tuning MySQL Databases to meet event onsale traffic
Read more.

Perl stored procedures provide greater flexibility than the standard SQL stored procedures. For many users, they can provide performance and connectivity which is not available from the built in SQL implementation, where many users have to resort to writing UDFs.
Read more.

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.
Read more.

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.
Read more.

Are you being asked to integrate your application into an enterprise identity management architecture? Come and hear from Nick Wooler and Ludo Poitou as they provide an overview of Identity Management and ways to use MySQL.
Read more.

This session explores the capabilities of BIRT, and looks at how BIRT enables you to integrate world-class reporting into applications running on MySQL databases. We will discuss how developers can use a visual design environment to create reports based on a wide variety of data sources, including MySQL.
Read more.

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.
Read more.

ZFS offers many leading-edge features, including automatic protection against silent data corruption, immense capacity, and vastly simplified administration. But how well does it perform with MySQL? This session explores MySQL performance with ZFS compared to
alternative file system implementations. The performance implications of ZFS compression and other features are also examined.
Read more.

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.
Read more.

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.
Read more.

Writing a custom engine can seem intimidating and creating a generic engine can be. This presentation will show how to refine the requirements to a manageable subset. We will discuss the problem addressed, the approach chosen, storage engine design and API required to implement the design. We will talk about lessons learned implementing the storage engine to improve flexibility and performance.
Read more.

Sun Microsystems, Jaspersoft and Infobright are pleased to invite you to join us at our cocktail reception. Don’t worry, there won’t be a formal presentation; this is just a great chance to network with your colleagues, learn more and have fun!
Read more.

The BOF is to demonstrate the ease of use for MySQL and Sun Cluster. With a live demo of making MySQL high available with Sun Cluster, we will show that configuring MySQL in Sun Cluster is easy to complete. After the demo will have a discussion about topologies and use cases.
Read more.

A lot is happening about InnoDB at the MySQL Conference and Expo! Come to this open discussion session, where Heikki Tuuri, Calvin Sun and Ken Jacobs and others will engage with you about all the latest news about InnoDB products and technology. It's a great place to raise questions and get answers about this technology that is so critical to YOUR success!
Read more.

Members of the memcached community, and any other memcached users, are encouraged to come to learn about memcached, participate in discussions on new features and enhancements, discussion of memcached clients, how to integrate memcached into your application's deployment, etc.
Read more.

Chances are if you're using MySQL, you've probably heard of Postgres, but may not be too familiar with it. Similar to MySQL, it's open source and supported by Sun, but there are a lot of differences once you get below the surface. Come join us to find out about Postgres, discuss ways you can use Postgres & MySQL together, or to just have your say in one of open sources favorite religious debates
Read more.

The MySQL Enterprise Monitor and Query Analyzer proactively monitor all of your MySQL servers for problems and tuning opportunities that you typically can not find yourself. Join the MySQL Enterprise Tools team for a fun, interactive demo of the Monitor and "Quan" and to provide feedback on how the feature set can be improved or expanded to fit your specific needs.
Read more.

If you need to play with a side installation of MySQL, you can use an extra host, or you can use MySQL Sandbox, and install as many as you want in just a few seconds.
Come see the magic of an application that can save you time and resources. Single servers, circular, standard, and hierarchical replication, all is available at your fingertips with no effort!
Read more.

We report our experience in addressing challenges related to prototyping a Database encryption scheme as part of MySQL's native functions that access disk files;
We compare the performance of this implementation to that of Oracle's TDE - Database Encryption: we show that the encryption layer be implemented is superior both in terms of its performance and security.
Read more.

Performance Is Everything. Percona's free technical conference brings together the leading minds in the application performance field. The focus is on full-stack application performance, not just databases.
Read more.

MySQL Camp 2009, a community organized event designed to share and improve the essential skills required to participate in collaborative, free and open online projects. It is the place for hacking code and exchanging technology within the larger event.
Read more.

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.
Read more.

Every database conference has to have some sort of loon standing up telling everyone that the main thing everyone has that ties them all together is total crap. This time, I'd like that loon to be me! So bring rotten fruits to throw.
Read more.

DTrace is breakthrough tool for on-demand tracing and analysis of any software.
As MySQL internals are open, it is possible to extract incredibly valuable information about database work - without performance overhead or even need to restart a server.
This talk covers and merges knowledge and practice from both DTrace and MySQL worlds - and explains why D in DTrace means 'dynamic'.
Read more.

Come learn the fundamentals of how to leverage Gearman, the open-source, distributed job queuing system. Gearman can help in building scalable MySQL-backed applications or use through a user-defined function. Gearman’s generic design allows it to be used as a building block for a wide variety of applications, from farming out image processing to building your own Map/Reduce implementation.
Read more.

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.
Read more.

Dormando's Proxy for MySQL (DPM for short) is a community lead, BSD licensed, alternative to the official MySQL Proxy. It is not a fork, and has its own ideals. Learn what it can do, and find out how you can help!
Read more.

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.
Read more.

In this talk, we will present an introduction to the Tungsten Replicator, which provides open source, database-neutral replication. The Tungsten Replicator has unique capabilities that for solving problems that go well beyond the capabilities of existing open source replication such as built-in MySQL Replication.
Read more.

How does the database server use memory? Where? What are the scaling implications of how we allocate, use and free memory in the database server? Can we scale to many CPU cores effectively? Do alternate malloc libraries really help? Why? What does MySQL do? What does Drizzle do (and what have we changed?). These questions (and more) will be answered in this session.
Read more.

The memcached Functions for MySQL are User Defined Functions (UDFs) that give you the power to interact with both MySQL and memcached in one place, giving you the ability to have read-through or write-through caching using a number of tricks, all without having to have caching logic in the application. Learn from Patrick Galbraith how to take advantage of these great new UDFs!
Read more.

You can run MySQL on a standard server, but there can be benefits to running MySQL within a virtualized environment. You can take advantage of the isolation it provides, or the performance gains possible by running multiple MySQL instances on one large server. This session will show you the benefits and potential issues of running MySQL in a virtualized environment.
Read more.

There should be nothing more important to a database administrator than backups, restoration and disaster recovery planning. Unfortunately it is an often neglected area of database administration.
This session will cover the importance of these vital areas and practical information about the ways to perform backups and recovery with currently available technology.
Read more.

MySQL is a great DBMS with a vast feature set. It is lightweight and easy to use "out of the box". What it lacks is a good High-Availability (HA) solution though. There are different approaches to create a HA environment - Depending on software setup and application preferences. This talk will cover everything from pros and cons of different solutions to real world experiences.
Read more.

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.
Read more.

In a classic case of "eat your own dogfood", MySQL.com is
a key player in the beta testing of MySQL software, including Query
Analyzer. In this presentation MySQL.com web developer Adam Donnison
will take you through how he used Quan to improve database performance
on the MySQl.com website by orders of magnitude, and why Quan was needed.
Read more.

This talk introduces a system we built at Google, which extracts row change event streams from large replicated MySQL server clusters. We will cover various issues we encountered and solved, including change log generation, conversion, storage and replication. We will also discuss some existing and planned usage cases.
Read more.

In this session we present OpenLDAP/back-ndb which gives an LDAP interface to MySQL Cluster. The LDAP interface on Cluster offers some nice ways of scaling out, as well fantastic performance, and we discuss how this is done. Moreover, it is possible to simultaneously access the LDAP data using e.g SQL!
A short demo will be given.
Read more.

"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.
Read more.

In the daily work of MySQL Support Engineers, alongside genuine problems,
there are some that are plain mistakes. These mistakes can become forum
questions, or bug reports, or finally Support issues. Even the most
advanced users make terrible mistakes that become interesting support case
stories. This presentation is a collection of those.
Read more.

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.
Read more.

InnoDB is well-known and popular, but naturally there's room for improvement. There are many hard-coded constants – what happens if we turn them into command-line parameters? InnoDB is also incredibly complex, with a lot going on under the covers. What algorithms can we change to make InnoDB faster and more scalable, especially on modern hardware?
Read more.

memcached usage is growing like wild fire and most major Web 2.0 websites depend heavily on it. In this session, we will explore several advanced memcached and MySQL use cases. Come see how some of the top destinations online are using memcached to scale their applications, offload load from databases and decrease their application response time.
Read more.

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
Read more.

This talk will be a code level survey of ways to access MySQL from Python. I'll cover the major Python libraries and frameworks for database access, including the Python DB-API/MySQLdb module, SQLAlchemy/Elixir, SQLObject and Django's ORM facilities.
Read more.

Maatkit is a set of tools that helps MySQL users and administrators fill otherwise unmet needs. The toolkit is absolutely packed with functionality. This session will teach you how to get your daily work done faster, safer and smarter.
Read more.

Learn why MySQL was chosen as core database in mission critical system
for fund managers of financial firms. In this mission critical financial
system, in which database manages more than 1TB and handles over 200
concurrent transactions per second, all operations of front office team
are managed including positions, executions and capital management.
Read more.

Barack Obama's presidential campaign created an unprecedented online grassroots movement in which supporters generated thousands of events, made millions of phone calls, raised record amounts of money, and received over a billion emails.
Read more.