Percona Live DC 2012 Conference Schedule

Percona Live is an intensive one-day MySQL summit presented by Percona, the experts in MySQL. The event takes place January 11th, 2012 in Washington DC. Speakers include Percona consultants and invited guests. All sessions are 100% technical.


Time
8:00AMRegistration
Room 144 AB
9:00AMOpening Keynote: Discover the Power of MySQL Opening Keynote: Discover the Power of MySQL»
[slides]
9:30AMOpening Keynote: What's Your Real Tolerance? Successfully scaling an application requires that you understand the businesses tolerances for data availability, performance, and cost before trying to tackle the challenges of backup, load balancing, and high availability. All too often, development teams are asked to build highly available systems, without justification or an understanding of the business needs for the data. These challenges are presented to Dyn's DNS and Email Delivery engineering teams on a daily basis, and by asking these questions ahead of development, we're able to successfully managed multiple terabyte-scale MySQL database instances across our global distributed datacenter footprint -- with strict durability and consistency requirements. This talk explains how Dyn sets tolerances for downtime, the recovery point objectives, and recovery time objectives for these mission-critical MySQL servers, and how examining these factors early in the design process help our teams to deliver value to our business and to our customers every day.»
[slides]
9:50AMBreak
Room 143 ARoom 143 BRoom 143 C
10:00AMInnoDB Architecture and Internals Learn the internals and architecture of InnoDB, MySQL's most important storage engine, including how it implements MVCC and guarantees ACID properties. This session will give you the foundation you need to make the most of using InnoDB.»
[slides]
Backup and Recovery Solutions for MySQL Learn about the most popular techniques for backing up MySQL, including logical data dumps, filesystem snapshots, and nonblocking backups with Percona XtraBackup or MySQL Enterprise Backup. Learn which options are best for your environment, and most importantly, how to ensure your recovery requirements are met.»
Introduction to MySQL Replication This session is a practical introduction to MySQL's most popular feature: its built-in replication capability, which is used in practically every MySQL-based application. You'll learn how replication works, some common problems that can break it and how to avoid those, and best practices for configuring replication to be dependable and robust. Also included: failover solutions, read-write splitting, and dealing with replication lag.»
[slides]
10:55AM
11:00AMPerformance of Stored Routines in MySQL Stored Routines (procedures and functions) are new in MySQL 5.0. Stored routines in other RDBMS systems have been blamed for poor performance, in addition to being hard to manage and maintain. This talk will focus on stored routines in MySQL 5.0 and share some performance data and best practices for using stored routines smartly and effectively. Come learn why, how, when, and where to best use stored routines, and when to avoid them.»
Achieving High Availability with MySQL What is high availability, and how do you make MySQL highly available? Learn about the available technologies and techniques to avoid downtime and loss or corruption of data, including MySQL replication, SANs, DRBD, MySQL Cluster, and Galera replication.»
Monitoring and Trending with MySQL Learn best practices for MySQL monitoring and historical metrics collection. We'll discuss what you should monitor in MySQL. A common mistake is to monitor too many things, thus causing false alarms and leading your team to ignore real problems. At the same time, many users don't capture enough metrics to help them diagnose problems or understand their capacity planning needs. Balancing these two needs, and understanding the difference between fault detection and historical metrics, is important for building a reliable infrastructure.»
[slides]
12:00 PMLunch
1:00PMWhat Causes Downtime in MySQL, and How Can You Prevent It? Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising, and will be detailed in this talk.»
MySQL Query Optimization Learn how to write queries that take advantage of MySQL's strengths, while avoiding its weaknesses. This session will cover the MySQL query optimization and execution process, common problems with performance in MySQL that can be solved by changing the SQL, and taking advantage of indexing and other optimizations.»
[slides]
Optimizing MySQL Configuration MySQL's configuration file is often the focus of too much attention, and too much tweaking of variables that make no difference -- or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You'll learn a practical approach to generate a sensible configuration file that sets what's needed and omits what isn't. The result will be a more stable and performant server that's resistant to many common problems.»
[slides]
1:55PM
2:00 PMMySQL Security, Privileges, and User Management This session is a deep-dive into MySQL's authentication and authorization mechanisms, overall security, data protection, PCI compliance, and more.»
[slides]
Managing MySQL with Percona Toolkit Percona Toolkit is an indispensable set of opensource command-line tools for managing and administering MySQL servers. This session will introduce the toolkit and the available tools, then demonstrate how to use some of the tools to manage replication, analyze queries, perform common DBA tasks, analyze disk I/O usage, and more.»
MySQL Cluster and NDB Cluster What is MySQL Cluster? What is it good for, and what is not a good fit for it? This session teaches the architecture of MySQL Cluster (MySQL, the NDB Cluster storage engine, and the NDB database), how it can achieve very high transactional throughput with synchronous replication and fault tolerance, what its weak points are, and what's new in current or upcoming versions of MySQL Cluster.»
[slides]
3:00 PMBreak
3:15 PMChoosing Storage Systems for MySQL In this session you'll learn about the three primary storage technologies commonly used for MySQL: RAID arrays of conventional disks, solid-state (flash) drives, and enterprise SAN/NAS storage. You'll learn the distinctive strengths and weaknesses of each for particular access paths such as random and sequential I/O or writes versus reads, and what types of workloads in MySQL demand high performance for those operations. As a result you'll be able to choose the appropriate type of storage for your server's workload.»
[slides]

EXPLAIN Demystified If you don't understand MySQL's EXPLAIN output, this session is for you. EXPLAIN output is confusing, but if you understand how it's created, it'll make sense to you. You'll leave this session with the knowledge necessary to understand the most complex query plans, including those with filesorts, subqueries, and UNIONs. You'll see the internals of MySQL from a new angle. That knowledge will prepare you to reason about query execution plans the same way the MySQL server does. As a result, you'll be able to write queries that get the best performance from MySQL's query optimizer and executioner.»
4:10PM
4:15 PMChoosing Hardware for MySQL In this session you'll learn how to choose hardware that helps MySQL execute queries the most quickly, while providing the best price-to-performance ratio. This includes choosing and configuring CPUs, RAM, network, and storage systems. We'll also discuss what performance you can expect from various Amazon EC2 instance sizes, including EBS volumes and Amazon's RDS service for MySQL.»
[slides]
High Availability with Percona-PRM Percona engineers have built a Pacemaker and replication-based system that detects MySQL master failure, chooses a new master, promotes it, and re-attaches slaves in a safe and swift manner. This system, Percona Replication Manager (Percona-PRM), is painless to implement and straightforward to administer. This talk will cover the setup and administration of Percona-PRM as well as providing attendees with sufficient knowledge of it's inner workings to allow them successful deployment in their production environments.»
[slides]
MySQL Performance and Scalability Optimization This session is a general overview of best practices for building high-performance, scalable applications with MySQL. Learn about scale-out versus scale-up, including the practical limitations and costs of both; how to implement sharding; and technologies that can help you build a more scalable, high-performance MySQL infrastructure.»
[slides]
5:10PM
Room 144 AB
5:15 PMMySQL in the Cloud and Virtualized How well does MySQL work in the cloud? What's different about running MySQL in the cloud versus on-premise or dedicated hardware? Does MySQL work well in a virtualized environment? What are the costs, benefits, and pitfalls? Join this panel of experts as they share their real experiences building applications in and out of the cloud, with and without virtualization.»
[slides]
6:30 PM

* Talks are subject to change


Sponsored By

Percona thanks our sponsors, who make this event possible:

RubyNation Webyog VMware OmniTI CustomInk Dyn
]]> ]]>