Follow Us on Twitter
Facebook Page
LinkedIn Group
Sign up for the Bulletin
MySQL 2010 Video on YouTube
MySQLConf RSS Feed
MySQLConf Schedule
Speaker Slides & Videos
MySQLConf Attendee DirectoryMySQL Conference & Expo 2011 Schedule: Full Listing
Below are the confirmed and scheduled talks at MySQLConf 2011 (schedule subject to change).
Customize Your Own Schedule
Create your own MySQLConf schedule using the personal scheduler function. Mark the tutorials, sessions, keynotes, and events you want to attend by clicking on the calendar icon ![[calendar icon]](/images/personal-schedule-icon.png){kind=icon}
next to each listing. Then click on "personal schedule" below and get your own customized schedule generated.
Monday, 04/11/2011
9:00am
Sergei Golubchik (MariaDB),
Andrew Hutchings (Hewlett-Packard)
Average rating:
(1.75, 4 ratings)
MySQL Plugins - first introduced in 5.1 - are server extensions that can be loaded into the running MySQL on the fly, without restart. This tutorial will teach what tasks can be solved with plugins, what a plugin consists of, and how to write a plugin that helps with your specific problem. Basic C/C++ and MySQL knowledge is expected, but no deep familiarity with either is required.
Read more.
Max Mether (SkySQL Ab)
Average rating:
(2.00, 1 rating)
Learn everything there is to know about being a MySQL DBA in 1 day. this full day tutorial will teach you all the most important topics of being a MySQL DBA. At the same time it will prepare you for the MySQL DBA certification. Topics included in the tutorial are: Storage Engines, Backups, Server Architecture, Resource Usage, Optimisation, Security, Replication, Monitoring & Troubleshooting etc.
Read more.
Josh Berkus (PostgreSQL Experts, Inc.)
Average rating:
(4.00, 3 ratings)
Want to really scale PostgreSQL using the new binary replication? Learn how to set up hot standby, streaming replication, failover, non-persistant databases and cloning to scale PostgreSQL 9 for reads.
Read more.
Yoshinori Matsunobu (DeNA)
Average rating:
(4.60, 15 ratings)
Choosing right Hardware components, configuring them properly, and optimizing Linux settings are very important for MySQL and other database server deployments. But they are frequently overlooked. Learning best practices will certainly improve performance and stability. Do you want to learn these best practices? This three-hour tutorial is for you.
Read more.
Giuseppe Maxia (Continuent)
Average rating:
(4.80, 5 ratings)
MySQL replication is the backbone of web scalability principles.
This tutorial tells you how to go beyond the basics, to using MySQL replication more productively, by combining existing techniques and adopting new ones.
After covering the basics, we will explore failover techniques, several performance boosting tricks, and emerging technologies that you can adopt in house and in the cloud.
Read more.
Brian Aker (HP),
Alan Kasindorf (Six Apart)
Average rating:
(4.00, 1 rating)
Back by popular demand we have the Memcached tutorial. Come learn about what is new and exciting in the world of Memcached.
Read more.
Peter Zaitsev (Percona Inc)
Average rating:
(4.50, 4 ratings)
This is updated and revised version of tutorial done at MySQL Conference
2010
Read more.
Average rating:
(5.00, 1 rating)
This Cluster Tutorial guides DBAs and other mere mortals into the world of MySQL Cluster. At the end of the session you will have started your own cluster on your laptop and be able to administer and manage it as needed. You will also be able to create and install new clusters at ease. More advanced topics such as performance tuning and common pitfalls and best practices will also be showcased.
Read more.
12:30pm
Monday, 04/11/2011
Location: Pool Area & Santa Clara Ballroom
Lunch
(1h)
1:30pm
Average rating:
(4.50, 8 ratings)
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Read more.
Sebastian Bergmann (thePHP.cc)
Average rating:
(3.50, 2 ratings)
LAMP applications are used more and more to perform enterprise-critical tasks. Given by the creator of PHPUnit, this tutorial shows the audience how to efficiently test LAMP applications with PHPUnit and its DbUnit extension.
Read more.
Peter Zaitsev (Percona Inc)
Average rating:
(4.00, 7 ratings)
This talk is about Innodb and XtraDB architecture with focus on architecture aspects important for performance optimization. We will also look into tuning Innodb settings as well as designing database schema and application to take advantage of architecture.
Read more.
Robert Hodges (Continuent.com),
Edward Archibald (Continuent)
Average rating:
(3.00, 1 rating)
MySQL replication deprivation is a common condition that occurs when you encounter problems built-in MySQL replication cannot solve. Do you need automatic master promotion, ability to replicate to PostgreSQL or Oracle, multi-master/multi-source replication, parallel slave apply, or built-in consistency checking?
Read more.
Tuesday, 04/12/2011
9:00am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Tomas Ulin (Oracle),
Duleepa Wijayawardhana (Empire Avenue)
Average rating:
(4.00, 17 ratings)
Join Tomas Ulin, Oracle’s Vice President of MySQL Engineering, as he summarizes MySQL’s first year under Oracle’s stewardship, discusses the current and ongoing engagement with the MySQL user community and offers insights into future roadmaps and commitment to MySQL products.
Read more.
9:40am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Ed Boyajian (EnterpriseDB),
Bruce Momjian (EnterpriseDB)
Average rating:
(3.20, 10 ratings)
In the State of the Elephant keynote, Ed Boyajian, CEO of EnterpriseDB, and Bruce Momjian, Co-Founder of The Global PostgreSQL Development Group, will present an overview of the PostgreSQL Community.
Read more.
10:00am
Location: Ballroom EFGH
David Axmark (Me, MySelf and I),
Michael Widenius (Monty Program Ab)
Average rating:
(3.83, 6 ratings)
Join us for the annual MySQL Awards, as we recognize excellence in Community Contributor, MySQL Application, and Corporate Contributor categories.
Read more.
10:50am
Jeremy Zawodny (craigslist.org)
Average rating:
(3.22, 9 ratings)
This talk will discuss the ongoing evolution of data storage at Craigslist, starting from a homogeneous one-size fits all "MySQL everywhere" approach and moving toward a heterogeneous environment that considers our real data and performance needs and the plethora of tools available today (including Redis, MongoDB, MySQL, and Sphinx).
Read more.
Lars Thalmann (Oracle),
Alex Roedling (Oracle)
Average rating:
(4.60, 5 ratings)
The developers behind MySQL Replication describe the new features. After a quick review of what MySQL 5.5 brings, focus turns to the features that are coming after MySQL 5.5.
Read more.
Architecture and Technology,
Cloud Computing,
Data Warehousing and Business Intelligence
Location: Ballroom C
Location: Ballroom C
Sarah Sproehnle (Cloudera, Inc.)
Average rating:
(4.00, 3 ratings)
Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reporting and injestion of large amounts of raw or unstructured data.
Read more.
John Smiley (Amazon.com)
Average rating:
(2.14, 7 ratings)
Amazon engineers share experiences managing a large fleet of MySQL databases.
Read more.
Peter Zaitsev (Percona Inc)
Average rating:
(3.60, 5 ratings)
MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks.
Read more.
Anders Karlsson (Recorded Future)
Average rating:
(3.50, 2 ratings)
Does it really work well to have large amount of data on Amazon EC2? Yes it does, but it does require some careful thinking and testing. EC2 is not like your standard Linux box when in terms of cabability of sustaining a high load and large amounts of data. But it can sure be done, but in a different way. This talk is about what Recorded Future has experienced when working with EC2.
Read more.
11:55am
Jay Janssen (Percona, Inc.)
Average rating:
(3.57, 7 ratings)
In the midst of many attempts to "solve" the RDBMS high availability problems, the vast majority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architecture, it's advantages and disadvantages, as well what we see as needed for future HA advances. It's old-school, it's crude, but somehow it solves most HA problems.
Read more.
Architecture and Technology,
MySQL Cluster and High Availability,
Replication and Scale-Out
Location: Ballroom B
Location: Ballroom B
Giuseppe Maxia (Continuent)
Average rating:
(3.33, 3 ratings)
Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience.
Read more.
Zardosht Kasheff (Tokutek)
Average rating:
(4.50, 4 ratings)
We present some simple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data.
Read more.
Josh Berkus (PostgreSQL Experts, Inc.)
Average rating:
(4.00, 1 rating)
Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are you considering moving to an expensive proprietary database system do deal with your huge database? PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range.
Read more.
Ryan Thiessen (Facebook)
Average rating:
(4.67, 9 ratings)
Getting sharding right is crucial for achieving high scale with MySQL on commodity hardware like we do at Facebook. We will overview sharding best practices, and show some examples of both successful and unsuccessful methods at sharding MySQL.
Read more.
Andrew Hutchings (Hewlett-Packard)
Average rating:
(3.00, 2 ratings)
Drizzle was originally forked from MySQL in 2008 and has since gone through many changes. It is now very different from its MySQL cousin, so this talk is aimed to help anyone new to Drizzle get to grips with it from both a DBA and an application developer point of view.
Read more.
Sergey Petrunya (Monty Program Ab),
Igor Babaev (Monty Program)
Average rating:
(4.50, 2 ratings)
MariaDB has a lot of improvements to the core optimiser that powers both MySQL & MariaDB. These optimiser features all have flags which you can enable (they are disabled by default). Igor and Sergey both work on all these optimiser features on a daily basis, and will be able to go deep in-depth to explain them and why they are beneficial to end-users in general.
Read more.
2:00pm
Ori Herrnstadt (Akiban)
Average rating:
(4.00, 3 ratings)
Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting.
Read more.
Devananda Van Der Veen (Percona),
Justin Swanhart (Percona)
Average rating:
(4.14, 7 ratings)
When replication fails, it can be difficult to fix. This talk will show you how to diagnose the failure and, when possible, safely resume replication.
Read more.
Danil Zburivsky (The Pythian Group)
Average rating:
(4.20, 5 ratings)
Production schema changes are painful but unavoidable. This session will tell you how to
minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables.
Session will focus on pros and cons of each approach and describe most common use cases.
Read more.
Stewart Smith (Percona)
Average rating:
(5.00, 2 ratings)
HailDB is a project that maintains InnoDB as a shared library (forked from embedded_innodb). It provides an API direct to InnoDB without any pesky SQL in front of it. This session is an introduction to HailDB, followed by an introduction to programming it.
Read more.
Ragi Burhum (Burhum LLC - GIS Consulting)
Average rating:
(4.00, 2 ratings)
PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. It includes support for spatial indexes, and functions for analysis and processing of GIS objects.
Read more.
Colin Charles (Monty Program Ab)
MariaDB - Community Developed. Feature Enhanced. Backward Compatible. A branch of the popular MySQL database, the project began in 2009 around a storage engine, but quickly evolved to being another database project, with two major releases in 2010. This session will introduce the project, and will help any DBA or developer get to grips with MariaDB.
Read more.
Robin Schumacher (EnterpriseDB),
Bruce Momjian (EnterpriseDB)
Average rating:
(1.00, 1 rating)
PostgreSQL has much to offer today’s developers who has been charged with creating applications for Web, embedded, data warehousing, OLTP, geo-spatial, and other environments. Developers will find many flexible options at their disposal with PostgreSQL no matter what language or IDE they choose to use.
Read more.
John Busch (Schooner Information Technology)
Average rating:
(2.25, 4 ratings)
We present innovative technology developed to achieve industry-leading availability coupled with industry-leading performance for MySQL/InnoDB. Downtime is reduced by over 90% with tightly integrated, fully synchronous replication. Highly-optimized thread, lock, DRAM, and flash algorithms maximize performance.We present the technology, demonstrate management simplicity, and show benchmark results.
Read more.
3:05pm
Peter Zaitsev (Percona Inc)
Average rating:
(2.86, 7 ratings)
It takes a lot to deliver consistent high performance for your MySQL powered system. In this presentation we'll look at defining Performance Goals, understanding Architecture Scalability and performing Capacity Planing.
Read more.
Architecture and Technology,
Replication and Scale-Out,
Security and Database Administration
Location: Ballroom B
Location: Ballroom B
Yoshinori Matsunobu (DeNA)
Average rating:
(3.57, 7 ratings)
In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier.
Read more.
Gerardo Narvaja (OpenMarket Inc.)
Traditionally replication has been monitored using the information in SHOW SLAVE STATUS, however it doesn't always represent the full picture. This presentation will outline how combining different methodologies it is possible to obtain a more accurate picture about replication health.
Read more.
Architecture and Technology,
Security and Database Administration,
Storage Engine Development and Optimization
Location: Ballroom D
Location: Ballroom D
Vadim Tkachenko (Percona Inc)
Average rating:
(3.00, 3 ratings)
Percona Server is most known for its performance and slow-log diagnostics, but it has many other useful features. In this talk I will describe them.
Read more.
Bruce Momjian (EnterpriseDB)
Average rating:
(2.50, 2 ratings)
This talk explores the ways attackers with no authorized database access
can steal Postgres passwords, see database queries and results, and even
intercept database sessions and return false data. Postgres supports
features to eliminate all of these threats, but administrators must
understand the attack vulnerabilities to protect against them.
Read more.
Mark Atwood (HP Cloud Services)
Average rating:
(5.00, 1 rating)
Eucalpytus is a GPL open-source private cloud computing infrastructure platform that is compatible with Amazon Web Services. It has an undeserved reputation as being hard to provision, install, and operate. We hope to help dispel this reputation by walking through and talking through installation and operation of a small Eucalyptus cloud.
Read more.
Stewart Smith (Percona)
Average rating:
(4.00, 2 ratings)
Those who cannot remember the past are condemned to repeat it. This is part survey, part critique of the various Atomicity, Consistency, Isolation and Durability models available from various modern databases and data stores used in modern Web and Cloud environments. We'll not just look at the single machine solution but how these systems work in a distributed environment.
Read more.
Itamar Haber (Xeround)
mysql> EXPLAIN SELECT * FROM CLOUDSQLDB
WHERE Availability=’always’
AND Scale=’auto’
AND COUNT (CloudProviders)>1;
Come see a live demonstration of a highly-available and scalable cloud database – with self-healing, auto-scaling and pay-per-use – all with a click of a button.
Read more.
4:25pm
Walt Jones (SEOmoz)
Moving rarely accessed data out of your main database can have a big impact on speed and cost. This session covers techniques to analyze the granularity of your data and implement an archival strategy that allows you to recall archived data on demand.
Read more.
Mikey Dickerson (Google)
Average rating:
(2.86, 7 ratings)
Google engineers talk about the long fight against the specter of data drift. Starting from historical FUD about data drift, Google SREs will discuss design and implementation of a solution to detect data drift on any slave without downtime, and lessons learned from deployment and running in a world with detection.
Read more.
Steve Francis (LogicMonitor)
Average rating:
(4.00, 6 ratings)
This talk will cover some of the less common linux tuning options, and how they can benefit MySQL performance, and benchmark results showing real impacts (or lack thereof) of tuning.
Read more.
Chris Conlon (yaSSL)
Average rating:
(3.75, 4 ratings)
Security is becoming more important than ever, and as such, it should be a high concern for MySQL users. In this session we will cover important MySQL security practices, with a focus on configuring and using SSL with MySQL. Although sometimes overlooked, data in transit is vulnerable and should be secured. The use of SSL/TLS provides us with a tool to help protect peace of mind and data security.
Read more.
Tom Hanlon (Cloudera)
Average rating:
(4.00, 2 ratings)
HBase is an open source column store built on top of Hadoop.
In this 45 minute session you will get a brief introduction into the design of HBase, and the underlying framework along with some usage examples.
Read more.
Eric Day (craigslist)
Average rating:
(2.00, 2 ratings)
The OpenStack project was launched last summer by Rackspace, NASA, and a number of other cloud technology leaders in an effort to build a fully-open cloud computing platform. It is a collection of scalable, secure, standards-based projects currently consisting of OpenStack Compute and OpenStack Object Storage. This session will introduce the projects, principles behind it, and how to get started.
Read more.
5:15pm
David Stokes (Oracle)
Average rating:
(2.50, 2 ratings)
Need quick ad-hoc reports with sharp graphics from you MySQL instances? There are several open source reporting tools from Penatho, Actuate, Jaspersoft and others that can make a DBAs lies much easier. This session covers the more popular reporting tools and reommendations for for their use in your environment.
Read more.
Vadim Tkachenko (Percona Inc)
Average rating:
(4.00, 5 ratings)
Are you considering how to use SSD disks with MySQL? Should you even use them? Will they make your database faster? They are still expensive, so how can you get the most out of them? This is the talk for you
Read more.
Darren Cassar (MySQLPreacher)
Average rating:
(3.00, 2 ratings)
Security is often considered a waste of time given its tedious, painful and underestimated. This is where securich comes to the rescue helping you control users, privileges and enforce good passwords. User cloning, renaming, password complexity and much much more.
Read more.
Architecture and Technology,
Business and Case Studies,
LAMP,
PHP and MySQL,
Web 2.0, Ajax, and Emerging Technologies
Location: Ballroom D
Location: Ballroom D
Roland Bouman (XCDSQL Solutions / Strukton Rail)
MQL-to-SQL is open source software that lets you query a RDBMS over HTTP using MQL (Metaweb Query Language). MQL is the native query language of www.freebase.com. There are good reasons to want MQL also as RDBMS query language, instead of SQL. This talk explains what MQL is, how it compares to SQL, why MQL is great for AJAX apps, and how MQL-to-SQL allows you to query RDBMSes like MySQL & Postgres
Read more.
Robert Haas (EnterpriseDB)
Average rating:
(5.00, 2 ratings)
PostgreSQL is highly customizable, but which settings are most important and what values are most appropriate for a typical installation? This talk will explain the basics of how to configure PostgreSQL for reliability and good performance.
Read more.
Roger Bodamer (10gen)
Average rating:
(3.33, 6 ratings)
MongoDB -- from "humongous" -- is an open source, non-relational, document-oriented database.
Read more.
6:00pm
Location: Exhibit Hall A
Average rating:
(4.40, 5 ratings)
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
Read more.
7:00pm
Location: Ballroom A
Moderated by: Henrik Ingo
CSince 2008 Johan Andersson has been publishing tools to help people
test and deploy into production MySQL Cluster. Severalnines.com
configurator, sandbox and cmon have been of help to thousands of MySQL
Cluster users already. Come see what the new version, Severalnines
ClusterControl has to offer.
Read more.
Location: Ballroom B
Moderated by: Selena Deckelmann
Many PostgreSQL developers and community members will be at the conference this year. Come to hear about the latest in 9.1 development, talk directly to developers and users of PostgreSQL.
Read more.
Location: Ballroom C
Moderated by: Baron Schwartz
Transactional databases almost always use checkpointing, and checkpointing is really, really hard to do well. From Postgres to InnoDB to PBXT, the dreaded "checkpoint spike" has caused or continues to cause server stalls. Come learn how different databases do checkpoints and how to tune yours properly.
Read more.
Location: Ballroom D
Moderated by: Rich Kelm
Sphinx Search 2.0: this BOF will speak to the new features in the forthcoming 2.0 release of Sphinx along with an overview of our Roadmap. Also we would like to hear from the community and see where you would like us to take Sphinx in the future.
Read more.
Location: Ballroom E
Moderated by: Peter Zaitsev
Average rating:
(5.00, 1 rating)
Xtrabackup is an Open Source Hot Backup program for Innodb and XtraDB storage engine which works with MySQL, MariaDB, Drizzle and Percona Server. This session is to share your experiences using this project as well as discuss what features you would like to see in the future versions.
Read more.
Location: See BoF Schedule for Locations
Average rating:
(5.00, 2 ratings)
Birds of a Feather (BoF) sessions provide face to face exposure to those interested in the same projects and concepts. BoFs are happening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednesday from 6:00p - 11:00p.
Read more.
Location: Lobby Bar
Join fellow MySQL Conference & Expo participants at this fun and exciting event. Come together, meet each other face to face, and discuss things in real time over a drink at the bar at this year's MySQL CE Meetup.
Read more.
Wednesday, 04/13/2011
9:00am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Michael Widenius (Monty Program Ab)
Average rating:
(4.25, 12 ratings)
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. MariaDB is now 2 years old, and has made 2 releases in 2010. He’ll also present an overview of the future of this community developed branch of the MySQL database.
Read more.
9:30am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Mårten Mickos (Eucalyptus Systems)
Average rating:
(3.00, 9 ratings)
Elasticity is a key characteristic of public, private and hybrid clouds. Virtual machines can be spun up and spun down at a moment's notice. But how do databases behave in clouds?
Read more.
10:00am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Brian Aker (HP)
Average rating:
(4.67, 12 ratings)
What’s the forecast for Drizzle, a database optimized for Cloud and Net applications? Brian provides an overview of the Drizzle project’s current state as well as what’s ahead.
Read more.
Join participating sponsors and other companies as they present open positions from their respective companies. Wednesday, April 13th, 10:00am – 2:00pm.
Read more.
10:50am
Dan Rogart (Zynga),
mohan krishnan (Zynga)
Average rating:
(3.33, 3 ratings)
We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands.
Read more.
Brian Aker (HP)
Average rating:
(5.00, 2 ratings)
Many people view topics like Map/Reduce and queue systems as advanced
concepts that require in-depth knowledge and time consuming software setup.
Gearman is changing all that by making this barrier to entry as low as
possible with an open source, distributed job queuing system.
Read more.
Harrison Fisk (Facebook),
Domas Mituzas (Facebook)
Average rating:
(3.80, 15 ratings)
Running MySQL at a scale of Facebook leads to many unique problems. We will
discuss some of the performance problems seen in production systems and the tools and
techniques involved in solutions.
Read more.
Paul McCullagh (PrimeBase Technologies GmbH)
Average rating:
(3.00, 1 rating)
Learn about the latest developments in and around the PBXT Storage Engine. Emphasis will be placed on technical aspects, discussing how things work, and giving practical examples. I will also present the latest performance results for PBXT which reveal a particular sweet spot when running a new benchmark called the “Provider Benchmark”.
Read more.
Ivan Zoratti (SkySQL)
Average rating:
(3.00, 2 ratings)
MySQL ubiquity is expanding from the online world to many other areas. Data Warehousing is one of the hottest and fast growing sectors for MySQL, due to its reduced TCO and ease of use.
In this session we will present what's new in the DW market around MySQL and how MySQL Server can be used to achieve success in Data Warehousing, Business Intelligence, OLAP and Reporting Projects.
Read more.
Bernhard Ocklin (Oracle Svenska AB),
Rob Young (Oracle/MySQL )
Average rating:
(3.00, 1 rating)
This session will introduce you to new MySQL Cluster features, its performance in benchmarks, and shows how major mobile phone and web companies build highly available real time solutions based on MySQL Cluster. Sometimes even with SQL.
Read more.
Grant McAlister (Amazon.com)
Whether running with commodity servers on premise or in the cloud, there are many failure scenarios to protect your database against. In this session we will walk through the different types of replication possible with both self-managed MySQL deployments and managed Amazon Relational Database Service cloud deployments, understanding how they can help improve your availability and durability.
Read more.
11:55am
Michael Glaesemann (myYearbook.com)
Average rating:
(3.50, 2 ratings)
Founded by two high school students in 2005, myYearbook.com has grown to become one of the top 5 social networks and one of the top 25 most trafficked web sites in the United States. In this session, we'll review the growing pains, unique architectural decisions, and methodologies employed to support the consistent growth and demand of a social network.
Read more.
Fernando Ipar (Percona),
Ryan Lowe (Percona)
Average rating:
(2.67, 3 ratings)
Achieving PCI compliance can be a difficult and expensive process. This session will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy them.
Read more.
Baron Schwartz (VividCortex Inc)
Average rating:
(3.88, 8 ratings)
This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status.
Read more.
Jeff Davis (Aster Data)
Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications.
Read more.
Selena Deckelmann (PostgreSQL)
Average rating:
(4.00, 1 rating)
Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.
Read more.
Eliot Horowitz (10gen)
Average rating:
(3.43, 7 ratings)
While MySQL and MongoDB often fight over the same deployment, there are many cases where MySQL and MongoDB should be used in conjunction.
They each excel at different things, so its important to understand when to use one or the other, and how to make them work well together.
Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB
Read more.
Edward Archibald (Continuent)
Learn how to build scalable Database-as-a-Service with Tungsten, including: What is Tungsten & how it works, Configure Tungsten to create your own DBaaS, Implement fast, automatic database provisioning, Recover from failures through storage subsystem integration, Zero downtime maintenance & upgrades, Scale performance with SQL routing & load balancing, Replicate across sites.
Read more.
Kaj Arnö (SkySQL Ab)
Average rating:
(3.00, 1 rating)
Kaj Arnö, executive vice president of products for SkySQL will lead a panel of strategic partners including Calpont, Linbit, ScaleDB, Webyog and Zimory in a discussion of the SkySQL Reference Architecture for deploying data infrastructure solutions for the MySQL® database.
Wednesday, April 13, 11:55 a.m.
Ballroom H
Read more.
2:00pm
Architecture and Technology,
Business and Case Studies,
Memcached,
NoSQL,
Ruby and MySQL,
Storage Engine Development and Optimization
Location: Ballroom A
Location: Ballroom A
Corey Donohoe (GitHub)
Average rating:
(3.67, 3 ratings)
GitHub's history with MySQL and what we've built off of it.
Read more.
Ronald Bradford (EffectiveMySQL)
Average rating:
(4.00, 5 ratings)
Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations.
Read more.
Shlomi Noach (openark.org)
Average rating:
(4.50, 2 ratings)
openark-kit is a tool set of scripts which fills in some gaps in daily MySQL maintenance work. Some scripts make for automation of routine work; others introduce new functionality to the MySQL server. This session introduces concepts and usage of the openark-kit.
Read more.
Hartmut Holzgraefe (...???...)
Average rating:
(4.00, 1 rating)
OpenStreetMap raw data for any non-trivial area
comes as a massive amount of XML data.
Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options though, especially when it comes to producing on demand map data for web applications with acceptable performance.
Read more.
Architecture and Technology,
Business and Case Studies,
Security and Database Administration
Location: Ballroom E
Location: Ballroom E
Robert Hodges (Continuent.com)
Average rating:
(4.33, 3 ratings)
Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works.
Read more.
Architecture and Technology,
NoSQL,
Storage Engine Development and Optimization
Location: Ballroom F
Location: Ballroom F
J Chris Anderson (Couchbase)
Average rating:
(4.60, 5 ratings)
Apache CouchDB implements a reliable storage engine, webserver, and HTTP application server environment, in under 20k lines of Erlang and JavaScript source code (with an additional X lines of test code.)
I'll show 3 related examples that strike at the core of CouchDB's simplicity: The storage engine, the incremental map reduce views, and replication.
Read more.
Eran Levin (Xeround)
If you thought running a database in the cloud was easy, think again. Databases in a cloud environment are inherently different from traditional installations in a datacenter or even in your trusted hosted environment. Today I'll explain the four key considerations we believe every system architect should take into account when designing their database for the cloud.
Read more.
Michael Widenius (Monty Program Ab),
Kristian Nielsen (MariaDB / Monty Program AB)
Group commit is a very important optimisation for ACID storage engines in high transaction-per-second OLTP that is implemented for the binlog in MariaDB. Usage, benchmarks, and technical details of the implementation are presented, as well as the underlying extension to the storage engine API that enables better provisioning of replication slaves from non-blocking backup, and other enhancements
Read more.
3:05pm
Architecture and Technology,
Performance Tuning and Benchmarking,
Replication and Scale-Out
Location: Ballroom A
Location: Ballroom A
Tao Cheng (AOL)
Average rating:
(3.00, 3 ratings)
AOL deployed its large scale Real Time News (RTN) system in 2007. This system receives news updates from over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabytes of data. However, news are delivered to end users in close to real time fashion. This presentation shares how it is done and the lessons learned.
Read more.
Ronald Bradford (EffectiveMySQL)
Average rating:
(3.60, 5 ratings)
Too much for just one session, in Part 2 we continue with learning the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time.
Read more.
Jens Bollmann (SkySQL AB)
Average rating:
(2.00, 1 rating)
Small web apps running on shared hosting or single/dual server environments can take advantage of many optimizations without requiring additional hardware or drastic application redesign. This session is aimed at developers and covers the "low hanging fruit" type optimizations that just about everyone has to learn the hard way!
Read more.
Architecture and Technology,
GIS,
Performance Tuning and Benchmarking,
PostgreSQL
Location: Ballroom D
Location: Ballroom D
Andy Parsons (Obikosh.com)
As CTO of Outside.in, and in my new stealth company, I've seen my share of challenging scenarios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars!
Read more.
Architecture and Technology,
Cloud Computing,
Data Warehousing and Business Intelligence,
Replication and Scale-Out
Location: Ballroom E
Location: Ballroom E
Venu Anuganti (Venu Anuganti Blog)
Average rating:
(1.00, 1 rating)
This is a DBA or Data Architect perspective session which covers designing MySQL as data warehouse solution to handle tera bytes of data which compromises OLTP, ETL, OLAP and reporting
Read more.
Architecture and Technology,
MySQL Cluster and High Availability,
Replication and Scale-Out
Location: Ballroom F
Location: Ballroom F
Matt Freels (Twitter)
Average rating:
(1.67, 3 ratings)
At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate.
Read more.
Location: Ballroom G
Michael Widenius (Monty Program Ab),
Oleksandr Byelkin (Monty Program)
Average rating:
(2.33, 3 ratings)
New feature of Maria DB which makes schema-less part of table possible will be described for database users with some details of its implementation on the server.
Read more.
Tim Lossen (wooga - world of gaming)
Average rating:
(2.50, 2 ratings)
As an in-memory database, Redis offers an order-of-magnitude
reduction in query roundtrip latency, but also introduces new
challenges. This case study recounts how we successfully scaled
up two Facebook games with Redis, and what we learned on the way.
Read more.
4:25pm
David Shrewsbury (Rackspace)
Average rating:
(4.00, 1 rating)
Drizzle has thrown out the MySQL replication system and has started from scratch in implementing its own replication architecture. In this session, we'll take a look at the basics of the new architecture, what tools are available, and discuss possible future functionality. An example setup will also be presented.
Read more.
Max Mether (SkySQL Ab)
Average rating:
(4.00, 2 ratings)
Describe cluster feateres, node types, internal processes etc.
Read more.
Clint Byrum (Canonical)
Average rating:
(5.00, 1 rating)
Ubuntu has always been focused on leadership as a development platform for Free Software. Drizzle has always been focused on being flexible and integration friendly. The Ubuntu Server Team has teamed up with the Drizzle Development team to get Drizzle working on Ubuntu, and show developers how easy it is to port their apps to use Drizzle. As of Ubuntu 11.04, Drizzle will be included in Ubuntu.
Read more.
Ian Gulliver (Google),
Eric Rollins (Google)
Average rating:
(3.80, 5 ratings)
Google engineers have built a system that detects MySQL master failure, chooses a new master, promotes it and hooks up slaves with under a minute downtime. This is deployed in an environment where there's zero tolerance for transaction loss of any sort. The original designer and a sysadmin who worked on the deployment will talk about design, implementation and practical lessons learned.
Read more.
Kevin Knapp (Facebook)
Average rating:
(3.80, 5 ratings)
A real-world example of how re-sharding and table partitioning cut load data times in Facebook's analytics infrastructure from greater than 24 hours to less than 5 minutes.
Read more.
Yekesa Kosuru (Nokia),
Peter Zaitsev (Percona Inc)
Average rating:
(3.00, 1 rating)
The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discussions that focus on availability and scalability highlight ACID issues but not really SQL.
The key-value systems can be built many ways and relational databases as a back end is a serious contender.
Read more.
Vadim Tkachenko (Percona Inc)
Average rating:
(4.00, 1 rating)
This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy.
Read more.
Selena Deckelmann (PostgreSQL)
Average rating:
(4.00, 1 rating)
Taking lessons from the PostgreSQL community, and recent experience with the growing communities around the forks of MySQL, this talk will lead business owners, project managers and developers through best practices for connecting to and being successful working with open source database developers.
Read more.
5:15pm
Architecture and Technology,
Cloud Computing,
Memcached,
Replication and Scale-Out
Location: Ballroom A
Location: Ballroom A
Matt Ingenthron (Couchbase, Inc.)
Average rating:
(4.00, 1 rating)
With contemporary web applications, data is never isolated to one store. Memcached has long been a partner to MySQL; now Membase, a persistent, replicated, clustered memcached-protocol-compatible datastore is used alongside MySQL for simple, fast key-value access. This session will dispel the idea of needing to choose between SQL or NoSQL, showing how you can be both rich and fast.
Read more.
Patrick Galbraith (Blue Gecko)
Average rating:
(2.00, 3 ratings)
Perl has been around for a while now. Even with buzz around other interpreted languages, Perl is still prevalently used in many applications- anything from simple database utilities, database administrative tools or web applications, it is useful to know how to program with Perl along with a relational database. This session is refresher course for lovers and non-lovers of Perl alike.
Read more.
Jakub Vrana (Self-employed)
Average rating:
(3.00, 2 ratings)
phpMyAdmin is a well-known PHP application for managing MySQL database. What's wrong with it? It is big, slow and it misses support for many advanced features like stored procedures or triggers.
Its free alternative Adminer provides user-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
Read more.
Greg Smith (2ndQuadrant US)
Average rating:
(5.00, 6 ratings)
While databases are increasingly being distributed across multiple nodes, the performance of every node still matters--especially if you're considering virtualized or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performance, and using sysbench to benchmark both MySQL and PostgreSQL are all topics covered here.
Read more.
Gwen Shapira (Pythian)
Average rating:
(4.00, 4 ratings)
Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database.
Read more.
Yoshinori Matsunobu (DeNA),
Kazuho Oku (DeNA)
Average rating:
(4.33, 3 ratings)
Most of high scale web applications use memcached + MySQL or NoSQL. It is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently developed HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our production. We'd like to share our experiences.
Read more.
John David Duncan (Oracle Corp.),
Edwin DeSouza (Oracle)
The next major release of Memcached, memcached 1.6, will support loadable storage engines to manage cached data. The NDB Engine for Memcached allows MySQL Cluster and Memcached to be used together in a wide variety of ways, and can be individually configured for particular memcached key prefixes. The presentation will include an overview, how-tos, and benchmarks.
Read more.
Architecture and Technology,
Business and Case Studies,
LAMP,
MySQL Cluster and High Availability,
Replication and Scale-Out
Location: Ballroom H
Location: Ballroom H
Mat Keep (MySQL),
Bernhard Ocklin (Oracle Svenska AB)
Discover how MySQL Cluster can be used to store session data for the new generation of web applications that demand persistence, massive scalability and high levels of availability. We'll cover what today's applications need from a session store; why MySQL Cluster is so suited to meeting those needs and how to implement them. To make this more real we'll present some real life case studies.
Read more.
6:00pm
Location: Ballroom A
Moderated by: Henrik Ingo
Xtrabackup Manager is a new tool for scheduling your MySQL backups. It
uses Xtrabackup from Percona as the backup tool - in the future we
will support also other tools like mysqldump. This is a new project,
rough around the edges and incomplete user interface, but it can
already take a backup. If you are interested in working on the code
with us, even better!
Read more.
Location: Ballroom B
Moderated by: Gary Orenstein
Share, explore, and discover the performance potential of MySQL and flash memory!
Read more.
Location: Ballroom C
Moderated by: Paddy Sreenivasan
Discussion of MySQL backup and recovery methods and practices in various organizations.
Read more.
Location: Ballroom D
Moderated by: Erin O'Neill and Mike Tougeron
Average rating:
(5.00, 1 rating)
Mike Tougeron and Erin O'Neill co-wrangle the San Francisco MySQL Meetup taking it from an average of 10 attendees to 65. They'll lay out the 4 main keys to making their meetup a success.
Read more.
Location: Ballroom E
Moderated by: Mat Keep
Join Lars Thalmann, Development Director of MySQL Replication and Mat Keep, MySQL product manager for a discussion of the replication enhancements delivered as part of the MySQL 5.6.2 Development Milestone Release
This will be an interactive session with the opportunity to discuss your own replication requirements, providing feedback and input directly to the engineering team
Read more.
Location: See BoF Schedule for Locations
Average rating:
(4.00, 1 rating)
Birds of a Feather (BoF) sessions provide face to face exposure to those interested in the same projects and concepts. BoFs are happening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednesday from 6:00p - 11:00p.
Read more.
7:00pm
Location: Ballroom A
Moderated by: Johan Andersson
Severalnines ClusterControl tools have already proven to bring ease of
use to configuring and running MySQL Cluster. Now the same experience
is available for MySQL Replication deployments: Master-master setup
and as many scale-out slaves as you want, it's all there with a few
clicks.
Read more.
Location: Ballroom B
Moderated by: Jakub Vrána
NotORM for databases is like SimpleXML for XML. It is so fast that it often performs better than native queries.
Read more.
Location: Ballroom EFGH
Brian Aker (HP)
Average rating:
(3.50, 2 ratings)
If you had five minutes on stage what would you say? What if you only got 20 slides and they rotated automatically after 15 seconds? Would you pitch a project? Launch a web site? Teach a hack? We’ll find out this year at Ignite MySQLconf.
Ignite MySQLconf will happen on Wednesday, April 13 at 7:00pm.
The call for Ignite MySQLconf talk proposals now closed.
Read more.
8:30pm
Location: See BoF Schedule for Locations
Birds of a Feather (BoF) sessions provide face to face exposure to those interested in the same projects and concepts. BoFs are happening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednesday from 6:00p - 11:00p.
Read more.
Location: Techmart Santa Clara Dining Room
Average rating:
(4.33, 3 ratings)
Join the MySQL Team at Techmart Santa Clara (next door to the Convention Center) on April 13, 2011, as we celebrate the health and growth of the MySQL community.
Read more.
Thursday, 04/14/2011
9:00am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Baron Schwartz (VividCortex Inc)
Average rating:
(5.00, 13 ratings)
The last few years have brought technological and market shifts that have disrupted open-source databases. These include cloud computing, solid-state storage, non-SQL databases, and MySQL's acquisition. In this keynote presentation, Baron Schwartz will discuss the new reality
that faces open-source database users and developers.
Read more.
9:30am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Mike Olson (Cloudera)
Average rating:
(3.83, 12 ratings)
The meteoric growth of MySQL through the 1990s and 2000s were marked by some big in the enterprise database market -- a willingness to adopt open source software for critical business applications, and the emergence of a new class of database-backed web applications that needed a simpler, cheaper and more flexible storage model than the established vendors provided.
Read more.
10:00am
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Average rating:
(4.55, 11 ratings)
If you missed Ignite MySQLconf on Wednesday evening, come check out the Best of Ignite - several fun, high-energy “speed presentations” given by people like you.
Read more.
10:50am
Andrew Hutchings (Hewlett-Packard)
Average rating:
(4.00, 2 ratings)
A guide to migrating your database and application from MySQL to Drizzle at every layer, from schemas to connections and application modifications.
Read more.
Padraig O'Sullivan (Akiban Technologies Inc.)
Average rating:
(3.00, 2 ratings)
In this presentation, we will cover how to easily deploy MySQL and
Drizzle databases on Amazon and the Rackspace cloud using chef. In
particular, Drizzle is a database designed specifically for the cloud
and we will discuss how its modular architecture benefits deployment.
Read more.
Inaam Rana (Oracle),
John Russell (Oracle Corporation)
Average rating:
(3.50, 8 ratings)
InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works.
Read more.
Antony Curtis (Blizzard Entertainment)
Antony shows the OQGRAPH engine in MariaDB 5.2, allowing you to deal with graphs (networks) for social networking, hierarchies and other complex structures, all in plain clean SQL.
Read more.
Sarah Novotny (Meteor Entertainment)
Average rating:
(5.00, 1 rating)
MySQL's replication system has been a core feature often touted for scaling (sort of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicating to one another) as a reference for the many uses and misuses of replication.
Read more.
Seppo Jaakola (Codership),
Alexey Yurchenko (Codership)
Average rating:
(3.67, 3 ratings)
Galera provides synchronous multi-master replication for MySQL/InnoDB. In a sense, it works like MySQL/Cluster but on top of InnoDB storage engine. Is this too good to be true?
Read more.
Barry Leslie (PrimeBase Technologies),
Volker Oboda (PrimeBase Technologies GmbH)
Average rating:
(4.00, 1 rating)
MySQL and Drizzle were never designed to handle BLOBs efficiently, storing
BLOBs in the database results in huge memory requirements and bloated
backups and replication logs. The PrimeBase BLOB management system (PBMS) is
a daemon that is loaded by the database server and provides an efficient way
of handling BLOBs that doesn’t have these problems.
Read more.
Timour Katchaounov (Monty Program Ab)
Average rating:
(4.50, 2 ratings)
MySQL supports subqueries since version 4.1 released 8 years ago. Due
to their simplistic implementation and resulting poor performance,
subqueries have been considered as practically unusable by many users.
Read more.
11:55am
Cory Zue (Dimagi)
Average rating:
(5.00, 1 rating)
People talk about NoSQL in the context of distributed cloud-based web applications, but what if your application needs to be deployed throughout rural Africa, with limited computer resources, intermittent power, and above all, extremely unreliable internet? This talk discusses the features of CouchDB that make it uniquely suited for developing world health applications.
Read more.
Marius Moscovici (Metric Insights Inc.),
Steffan Mejia (Linden Lab)
This presentation provides architectural guidance, design patterns, and specific suggestions for deploying and administering Data Warehouses using Mysql. It is based on lessons learned building and operating a Multi-Terabyte Mysql 5 Data warehouse over a period of 5 years.
Read more.
Baron Schwartz (VividCortex Inc)
Average rating:
(4.14, 7 ratings)
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
Read more.
Ivan Zoratti (SkySQL)
Average rating:
(4.00, 1 rating)
MySQL Cluster (NDB) is one of the most interesting storage engines. Oracle promotes NDB as the perfect solution for high volume transactions in high availability. On the other hand, many famous users are reluctant in migrating applications to NDB. This session will help in understanding in practical terms when it makes sense to use NDB and when it is better to stay with or use InnoDB.
Read more.
Konstantin Osipov (MySQL)
Average rating:
(4.00, 1 rating)
MySQL 5.5 features a new transactional lock manager, available to all storage engines. The new subsystem allowed to solve a number of old MySQL architecture problems, such as lack of transactional awareness of data definition language, as well as opened the door for a number of new performance and scalability improvements.
Read more.
Seppo Jaakola (Codership),
Alexey Yurchenko (Codership)
Average rating:
(3.00, 2 ratings)
Aside from traditional master-slave setup used mostly for HA and read scale-out, there is an established history of attempts at multi-master replication with MySQL. In this presentation we will look at what multi-master replication can do for us and compare different approaches of doing it.
Read more.
Patrick Galbraith (Blue Gecko)
Average rating:
(3.33, 3 ratings)
The Narada Search Application is a project that was an idea that was inspired while writing a book on how to take advantage of Sphinx, Gearman and MySQL that introduces a whole new way of thinking about web applications. Instead of a single monolithic web application, functionality is broken out into several Gearman workers to make for a much more scalable and dynamic application.
Read more.
Monty Taylor (HP)
Average rating:
(3.00, 1 rating)
Now that you've decided to use Drizzle for everything, you're going to want to tune it to get the best out of your system. Some of the things you know from MySQL apply, some don't. Let's look at some real numbers and real graphs and see what Drizzle is doing.
Read more.
2:00pm
Daniel Peek (Facebook)
Average rating:
(4.20, 5 ratings)
MySQL replication has been a critical part of scaling Facebook's storage infrastructure. However, it brings with it the fear of divergent replicas. This session discusses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.
Read more.
Hartmut Holzgraefe (...???...)
Writing a complete plugin requires quite a bit of infrastructure work to get all the feature registration and build system aspects right. A code generator can take care of such tasks, allowing you to focus on the actual functionality you want to add without having to figure out all plugin API details up front. This can cut the time to create a simple plugin down from hours to minutes.
Read more.
Architecture and Technology,
Cloud Computing,
Data Warehousing and Business Intelligence,
MySQL Cluster and High Availability,
Performance Tuning and Benchmarking,
Replication and Scale-Out,
Storage Engine Development and Optimization
Location: Ballroom C
Location: Ballroom C
Moshe Shadmon (ScaleDB)
ScaleDB is a pluggable storage engine for MySQL. It turns MySQL into an enterprise-class, highly-available, clustered database that scales dynamically in a public and private cloud.
Read more.
Monty Taylor (HP)
Average rating:
(4.00, 3 ratings)
Drizzle has a rich plugin system, which means that Drizzle has a rather large set of available plugins which do things. Some of those plugins implement functionality that people have been asking for in the MySQL ecosystem for quite some time - such as LDAP or PAM based authentication, extremely flexible logging and direct use of Memcached. Come see how to actually do these things and more.
Read more.
Michael McLaughlin (BYU - Idaho)
Average rating:
(3.00, 1 rating)
Presents an in-depth view of how to combine and integrate MySQL subroutines with the security model. Shows how stored programs best support AJAX enabled web applications. Demonstrates how the MySQL security layers can support transaction control in stored functions and procedures. Provides examples on how to encapsulate key logic from web developers.
Read more.
Peter Zaitsev (Percona Inc),
Adam Rice (Sphinx Search)
Average rating:
(4.00, 3 ratings)
Sphinx Search Engine is a well known tool for dealing with full text search problems on the large scale, but did you know you can use Sphinx for other tasks, which your traditional database may not be well suited for. This presentation will look into practical cases of using Sphinx beyond full text search and provide performance comparison to using MySQL for the same task.
Read more.
Architecture and Technology,
Performance Tuning and Benchmarking,
Storage Engine Development and Optimization
Location: Ballroom G
Location: Ballroom G
Tetsuro Ikeda (Sumisho Computer Sytems Corporation),
Kentoku SHIBA (WildGrowth),
Daijiro MORI (brazil),
Tasuku SUENAGA (Brazil, Inc.)
Average rating:
(5.00, 1 rating)
In this session, We introduce groonga Storage engine which enables for MySQL to handle fulltext search lightly. groonga is a library which have storages and indexes for fast fulltext searching. The backend of groonga Storage Engine is groonga library. With groonga Storage Engine, you can use datas in groonga as a usual MySQL tables.
Read more.
Stewart Smith (Percona)
Average rating:
(3.33, 3 ratings)
Drizzle has fixed many "gotcha" type things. Often we find ourselves saying "fixed in Drizzle". This is a whirlwind tour of what that is.
Read more.
2:50pm
Location: Ballroom A
Ivan Zoratti (SkySQL)
The webyog monitor, how to use it, what it's good at etc.
Read more.
Average rating:
(4.33, 3 ratings)
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service.
Read more.
Patrick Crews (HP Cloud Services)
Kewpie is a random testing tool for database systems. Based on research by Microsoft's SQL Server team, it utilizes feedback from the system under test to help drive query generation. This design provides a greater degree of control and accuracy than purely random systems.
This talk will discuss the motivations behind the system as well as providing several applications for testing.
Read more.
Architecture and Technology,
Data Warehousing and Business Intelligence,
PHP and MySQL,
Replication and Scale-Out
Location: Ballroom D
Location: Ballroom D
Justin Swanhart (Percona),
Ryan Lowe (Percona)
Average rating:
(4.67, 3 ratings)
This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation.
I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads.
Read more.
Cloud Computing,
Drizzle,
Java,
Replication and Scale-Out,
Storage Engine Development and Optimization,
Web 2.0, Ajax, and Emerging Technologies
Location: Ballroom E
Location: Ballroom E
Sunny Gleason (Ning)
Average rating:
(4.00, 2 ratings)
This presentation introduces the St8 server, an open-source, REST-enabled storage service built using Jersey, Jetty, Guice, and most importantly, HailDB (formerly Embedded InnoDB). We describe interfacing HailDB with Java using JNA, and review benchmarks showing just how fast the service can be (including SSD as well as single-disk and RAID0 benchmarks).
Read more.
Mark Konetchy (Facebook)
Average rating:
(3.67, 3 ratings)
This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes
Read more.
Peter Zaitsev (Percona Inc)
Average rating:
(4.33, 3 ratings)
Learn best practices in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices
Read more.
Darpan Dinker (Schooner Information Technology, Inc.),
Brian O’Krafka (Schooner Information Technology)
Most MySQL deployments use some form of replication. Whether the reason is availability, scalability, backup, disaster recovery or archiving, understanding the performance characterization and trade-offs is critical to design and planning.
If you have always wondered when and why to choose async/semi-sync/sync MySQL replication, DRBD or other interoperable technologies, this session is for you.
Read more.
3:50pm
Location: Ballroom EFGH
Please note:
This and all other keynotes will be live streamed and recorded.
Jeremy Cole (Twitter)
Average rating:
(4.00, 6 ratings)
Keynote by Jeremy Cole, DBA Team Lead and MySQL Architect, Twitter.
Read more.
4:35pm
Location: Ballroom Foyer
Average rating:
(5.00, 3 ratings)
Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Take the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments.
Read more.
Diamond Sponsor
Gold Sponsors
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com
Media Partners Opportunities
For media partnerships, contact mediapartners@ oreilly.com
Press & Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
O'Reilly MySQL Conference Bulletin
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
Contact Us
View a complete list of O'Reilly MySQL Conference Contacts
©2011, O'Reilly Media, Inc.
(800) 889-8969 or (707) 827-7019
Monday-Friday 7:30am-5pm PT
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.
conf-webmaster@oreilly.com