BEGIN:VCALENDAR X-WR-CALNAME:O'Reilly MySQL Conference & Expo 2011 VERSION:2.0 PRODID:Expectnation CALSCALE:GREGORIAN BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110418T162235 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17381 UID:http://mysqlconf.com/--s2011-04-11-09:00--17381 SUMMARY:MySQL Replication Advanced Techniques DESCRIPTION:Presented by Giuseppe Maxia (Continuent). MySQL replication is the backbone of web scalability principles. This tutorial tells you h ow 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 bo osting tricks, and emerging technologies that you can adopt in house and in the cloud. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110412T062409 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17957 UID:http://mysqlconf.com/--s2011-04-11-09:00--17957 SUMMARY:The Memcached Tutorial DESCRIPTION:Presented by Brian Aker (HP), Alan Kasindorf (Six Apart). Ba ck by popular demand we have the Memcached tutorial. Come learn about wh at is new and exciting in the world of Memcached. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T123000 DTSTART;TZID=US/Pacific:20110411T090000 DTSTAMP:20110413T175334 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17636 UID:http://mysqlconf.com/--s2011-04-11-09:00--17636 SUMMARY:Scaling Applications with Caching, Sharding and Replication DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). This is updated an d revised version of tutorial done at MySQL Conference 2010 END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110422T214513 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17142 UID:http://mysqlconf.com/--s2011-04-11-13:30--17142 SUMMARY:Diagnosing and Fixing MySQL Performance Problems DESCRIPTION:Presented by Justin Swanhart (Percona), Ryan Lowe (Percona), Baron Schwartz (VividCortex Inc). This tutorial focuses on the diagnost ic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. T he emphasis is on practical usage under pressure, and less on performanc e theory. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110411T170000 DTSTART;TZID=US/Pacific:20110411T133000 DTSTAMP:20110412T022801 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/19268 UID:http://mysqlconf.com/--s2011-04-11-13:30--19268 SUMMARY:Learn how to cure MySQL replication deprivation with Tungsten! DESCRIPTION:Presented by Robert Hodges (Continuent.com), Edward Archibal d (Continuent). MySQL replication deprivation is a common condition that occurs when you encounter problems built-in MySQL replication cannot so lve. Do you need automatic master promotion, ability to replicate to Po stgreSQL or Oracle, multi-master/multi-source replication, parallel slav e apply, or built-in consistency checking? END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110418T192654 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17119 UID:http://mysqlconf.com/--s2011-04-12-10:50--17119 SUMMARY:Using MySQL 5.5 Performance Schema DESCRIPTION:Presented by Peter Zaitsev (Percona Inc). MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110422T215841 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17472 UID:http://mysqlconf.com/--s2011-04-12-10:50--17472 SUMMARY:Real-world Experiences Managing Large MySQL Fleet DESCRIPTION:Presented by John Smiley (Amazon.com). Amazon engineers shar e experiences managing a large fleet of MySQL databases. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T115000 DTSTART;TZID=US/Pacific:20110412T105000 DTSTAMP:20110416T151451 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17154 UID:http://mysqlconf.com/--s2011-04-12-10:50--17154 SUMMARY:Where does MySQL Fit In (at Craigslist)? DESCRIPTION:Presented by Jeremy Zawodny (craigslist.org). This talk will discuss the ongoing evolution of data storage at Craigslist, starting f rom a homogeneous one-size fits all "MySQL everywhere" approach and movi ng toward a heterogeneous environment that considers our real data and p erformance needs and the plethora of tools available today (including Re dis, MongoDB, MySQL, and Sphinx). END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110419T125055 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17169 UID:http://mysqlconf.com/--s2011-04-12-11:55--17169 SUMMARY:MySQL High Availability at Yahoo DESCRIPTION:Presented by Jay Janssen (Percona, Inc.). In the midst of ma ny attempts to "solve" the RDBMS high availability problems, the vast ma jority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architec ture, it's advantages and disadvantages, as well what we see as needed f or future HA advances. It's old-school, it's crude, but somehow it solv es most HA problems. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110416T151521 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17429 UID:http://mysqlconf.com/--s2011-04-12-11:55--17429 SUMMARY:The Secret Sauce of Sharding DESCRIPTION:Presented by Ryan Thiessen (Facebook). Getting sharding righ t is crucial for achieving high scale with MySQL on commodity hardware l ike we do at Facebook. We will overview sharding best practices, and sh ow some examples of both successful and unsuccessful methods at sharding MySQL. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T124000 DTSTART;TZID=US/Pacific:20110412T115500 DTSTAMP:20110415T143355 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17151 UID:http://mysqlconf.com/--s2011-04-12-11:55--17151 SUMMARY:A Beginner's Guide to Drizzle DESCRIPTION:Presented by Andrew Hutchings (Hewlett-Packard). Drizzle was originally forked from MySQL in 2008 and has since gone through many ch anges. 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T150000 DTSTART;TZID=US/Pacific:20110412T140000 DTSTAMP:20110419T125104 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17273 UID:http://mysqlconf.com/--s2011-04-12-14:00--17273 SUMMARY:Dealing with Schema Changes on Large Data Volumes DESCRIPTION:Presented by Danil Zburivsky (The Pythian Group). Production schema changes are painful but unavoidable. This session will tell you how to minimize (or totally eliminate) downtime during schema changes w ith master-master setup or by using "shadow" tables. Session will focus on pros and cons of each approach and describe most common use cases. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T192215 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17115 UID:http://mysqlconf.com/--s2011-04-12-15:05--17115 SUMMARY:Percona Server: Secret Features DESCRIPTION:Presented by Vadim Tkachenko (Percona Inc). Percona Server i s most known for its performance and slow-log diagnostics, but it has ma ny other useful features. In this talk I will describe them. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T203003 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17544 UID:http://mysqlconf.com/--s2011-04-12-15:05--17544 SUMMARY:Securing PostgreSQL From External Attack DESCRIPTION:Presented by Bruce Momjian (EnterpriseDB). This talk explore s the ways attackers with no authorized database access can steal Postgr es passwords, see database queries and results, and even intercept datab ase sessions and return false data. Postgres supports features to elimin ate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T155000 DTSTART;TZID=US/Pacific:20110412T150500 DTSTAMP:20110413T191908 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17584 UID:http://mysqlconf.com/--s2011-04-12-15:05--17584 SUMMARY:Advanced Replication Monitoring DESCRIPTION:Presented by Gerardo Narvaja (OpenMarket Inc.). Traditionall y replication has been monitored using the information in SHOW SLAVE STA TUS, however it doesn't always represent the full picture. This presenta tion will outline how combining different methodologies it is possible t o obtain a more accurate picture about replication health. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110415T055057 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17139 UID:http://mysqlconf.com/--s2011-04-12-16:25--17139 SUMMARY:Securing MySQL with a Focus on SSL DESCRIPTION:Presented by Chris Conlon (yaSSL). 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 sometim es 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T171000 DTSTART;TZID=US/Pacific:20110412T162500 DTSTAMP:20110413T203013 LOCATION:Ballroom E URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17652 UID:http://mysqlconf.com/--s2011-04-12-16:25--17652 SUMMARY:Introduction to HBase DESCRIPTION:Presented by Tom Hanlon (Cloudera). 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 f ramework along with some usage examples. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110412T180000 DTSTART;TZID=US/Pacific:20110412T171500 DTSTAMP:20110416T151434 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17372 UID:http://mysqlconf.com/--s2011-04-12-17:15--17372 SUMMARY:Securich DESCRIPTION:Presented by Darren Cassar (MySQLPreacher). Security is ofte n considered a waste of time given its tedious, painful and underestimat ed. This is where securich comes to the rescue helping you control users , privileges and enforce good passwords. User cloning, renaming, passwor d complexity and much much more. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T115000 DTSTART;TZID=US/Pacific:20110413T105000 DTSTAMP:20110415T143451 LOCATION:Ballroom A URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17183 UID:http://mysqlconf.com/--s2011-04-13-10:50--17183 SUMMARY:Scaling MySQL in the Cloud - A Success Story DESCRIPTION:Presented by Dan Rogart (Zynga), mohan krishnan (Zynga). We will examine the challenges faced by Zynga in running a large scale MySQ L plant in EC2. Serving our social games to millions of players around t he globe has required significant investment in automation and performan ce 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110419T123204 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17129 UID:http://mysqlconf.com/--s2011-04-13-11:55--17129 SUMMARY:The Aspersa System Administrator's Toolkit DESCRIPTION:Presented by Baron Schwartz (VividCortex Inc). This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatk it tools. It includes tools such as an I/O profiler, a bottleneck analy sis tool, and tools to quickly summarize a system's configuration and st atus. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110416T151621 LOCATION:Ballroom F URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17465 UID:http://mysqlconf.com/--s2011-04-13-11:55--17465 SUMMARY:MySQL and MongoDB joined at the hip DESCRIPTION:Presented by Eliot Horowitz (10gen). 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 differen t things, so its important to understand when to use one or the other, a nd how to make them work well together. Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T124000 DTSTART;TZID=US/Pacific:20110413T115500 DTSTAMP:20110414T235313 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17141 UID:http://mysqlconf.com/--s2011-04-13-11:55--17141 SUMMARY:Achieving PCI Compliance with MySQL DESCRIPTION:Presented by Fernando Ipar (Percona), Ryan Lowe (Percona). A chieving PCI compliance can be a difficult and expensive process. This s ession will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy th em. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110415T143524 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17155 UID:http://mysqlconf.com/--s2011-04-13-14:00--17155 SUMMARY:openark-kit: MySQL utilities for everyday use DESCRIPTION:Presented by Shlomi Noach (openark.org). openark-kit is a to ol set of scripts which fills in some gaps in daily MySQL maintenance wo rk. Some scripts make for automation of routine work; others introduce n ew functionality to the MySQL server. This session introduces concepts a nd usage of the openark-kit. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T150000 DTSTART;TZID=US/Pacific:20110413T140000 DTSTAMP:20110418T193421 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17098 UID:http://mysqlconf.com/--s2011-04-13-14:00--17098 SUMMARY:MySQL Best Practices for DBAs and Developers - Part 1 DESCRIPTION:Presented by Ronald Bradford (EffectiveMySQL). Learn the ri ght techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences be tween MySQL and other RDBMS products are essential to understand in orde r to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL securit y and schema optimizations. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T155000 DTSTART;TZID=US/Pacific:20110413T150500 DTSTAMP:20110418T193435 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17616 UID:http://mysqlconf.com/--s2011-04-13-15:05--17616 SUMMARY:MySQL Best Practices for DBAs and Developers - Part 2 DESCRIPTION:Presented by Ronald Bradford (EffectiveMySQL). Too much for just one session, in Part 2 we continue with learning the right techniq ues to maximize your investment in MySQL by knowing the best practices f or DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T171000 DTSTART;TZID=US/Pacific:20110413T162500 DTSTAMP:20110413T235405 LOCATION:Ballroom G URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17116 UID:http://mysqlconf.com/--s2011-04-13-16:25--17116 SUMMARY:Percona Server and XtraBackup: painless operations DESCRIPTION:Presented by Vadim Tkachenko (Percona Inc). This talk shows how to use Percona Server together with XtraBackup to make important ope rational tasks easy. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110413T180000 DTSTART;TZID=US/Pacific:20110413T171500 DTSTAMP:20110418T192824 LOCATION:Ballroom B URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17252 UID:http://mysqlconf.com/--s2011-04-13-17:15--17252 SUMMARY:Perl programming with MySQL and Drizzle DESCRIPTION:Presented by Patrick Galbraith (Blue Gecko). Perl has been a round for a while now. Even with buzz around other interpreted languages , Perl is still prevalently used in many applications- anything from sim ple database utilities, database administrative tools or web application s, 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. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110415T143623 LOCATION:Ballroom C URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17153 UID:http://mysqlconf.com/--s2011-04-14-11:55--17153 SUMMARY:Forecasting MySQL Performance and Scalability DESCRIPTION:Presented by Baron Schwartz (VividCortex Inc). This talk sho ws you how to gather the correct data for performance forecasting and ca pacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T124000 DTSTART;TZID=US/Pacific:20110414T115500 DTSTAMP:20110414T231405 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17498 UID:http://mysqlconf.com/--s2011-04-14-11:55--17498 SUMMARY:Performance Tuning for Drizzle DESCRIPTION:Presented by Monty Taylor (HP). Now that you've decided to u se Drizzle for everything, you're going to want to tune it to get the be st out of your system. Some of the things you know from MySQL apply, som e don't. Let's look at some real numbers and real graphs and see what Dr izzle is doing. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110414T215315 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17493 UID:http://mysqlconf.com/--s2011-04-14-14:00--17493 SUMMARY:Finally! How Drizzle Does the Things You've Always Wanted to Do DESCRIPTION:Presented by Monty Taylor (HP). Drizzle has a rich plugin sy stem, which means that Drizzle has a rather large set of available plugi ns which do things. Some of those plugins implement functionality that p eople 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 m ore. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T144500 DTSTART;TZID=US/Pacific:20110414T140000 DTSTAMP:20110419T123339 LOCATION:Ballroom H URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17441 UID:http://mysqlconf.com/--s2011-04-14-14:00--17441 SUMMARY:Fixed in Drizzle: No more "GOTCHA's" DESCRIPTION:Presented by Stewart Smith (Percona). Drizzle has fixed many "gotcha" type things. Often we find ourselves saying "fixed in Drizzle" . This is a whirlwind tour of what that is. END:VEVENT BEGIN:VEVENT DTEND;TZID=US/Pacific:20110414T153500 DTSTART;TZID=US/Pacific:20110414T145000 DTSTAMP:20110421T154738 LOCATION:Ballroom D URL:http://en.oreilly.com/mysql2011/public/schedule/detail/17146 UID:http://mysqlconf.com/--s2011-04-14-14:50--17146 SUMMARY:Summary Tables, Aggregate Tables and Materialized Views Using Fl exviews DESCRIPTION:Presented by Justin Swanhart (Percona), Ryan Lowe (Percona). This talk describes using summary tables to improve application perform ance. It focuses on Flexviews, an open source toolkit based on MySQL st ored procedures. Flexviews maintains summary tables and supports joins a nd aggregation. I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provid ed for both OLTP and OLAP workloads. END:VEVENT END:VCALENDAR