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 DirectoryPersonal schedule for Darren Cassar
Download or subscribe to Darren Cassar's schedule.
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:
(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.
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.
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.
John Smiley (Amazon.com)
Average rating:
(2.14, 7 ratings)
Amazon engineers share experiences managing a large fleet of MySQL databases.
Read more.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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