Percona Live DC 2012 Sessions

Sponsors
RubyNation Webyog VMware OmniTI CustomInk Dyn

Percona Live features leading experts in MySQL discussing real-world usage scenarios and application architectures.



Opening Keynote: Discover the Power of MySQL [slides]

9:00AM • Room 143 A • Peter Zaitsev (Percona)

Opening Keynote: Discover the Power of MySQL

Tracks: Developer, DBA, Manager


Opening Keynote: What's Your Real Tolerance? [slides]

9:30AM • Room 143 A • Tom Daly (Dyn Inc)

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.

Tracks: Developer, DBA, Manager


InnoDB Architecture and Internals [slides]

10:00AM • Room 143 A • Peter Zaitsev (Percona)

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.

Tracks: Developer, DBA

Level: Advanced


Backup and Recovery Solutions for MySQL

10:00AM • Room 143 B • Baron Schwartz (Percona)

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.

Tracks: DBA, Manager

Level: Intermediate


Introduction to MySQL Replication [slides]

10:00AM • Room 143 C • Kenny Gryp (Percona)

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.

Tracks: DBA, Manager

Level: Introductory


Performance of Stored Routines in MySQL

11:00AM • Room 143 A • Daniel Austin (Paypal, Inc.)

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.

Tracks: Developer

Level: Intermediate


Achieving High Availability with MySQL

11:00AM • Room 143 B • Baron Schwartz (Percona)

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.

Tracks: DBA, Manager

Level: Advanced


Monitoring and Trending with MySQL [slides]

11:00AM • Room 143 C • Mike DelNegro (AOL)

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.

Tracks: Manager, DBA

Level: Intermediate


What Causes Downtime in MySQL, and How Can You Prevent It?

1:00PM • Room 143 A • Baron Schwartz (Percona)

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.

Tracks: Manager, DBA

Level: Intermediate


MySQL Query Optimization [slides]

1:00PM • Room 143 B • Kenny Gryp (Percona)

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.

Tracks: Developer, DBA

Level: Intermediate


Optimizing MySQL Configuration [slides]

1:00PM • Room 143 C • Peter Zaitsev (Percona)

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.

Tracks: DBA

Level: Intermediate


MySQL Security, Privileges, and User Management [slides]

2:00 PM • Room 143 A • Kenny Gryp (Percona)

This session is a deep-dive into MySQL's authentication and authorization mechanisms, overall security, data protection, PCI compliance, and more.

Tracks: DBA

Level: Intermediate


Managing MySQL with Percona Toolkit

2:00 PM • Room 143 B • Baron Schwartz (Percona)

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.

Tracks: DBA, Developer

Level: Intermediate


MySQL Cluster and NDB Cluster [slides]

2:00 PM • Room 143 C • Yves Trudeau (Percona)

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.

Tracks: DBA, Manager

Level: Advanced


Choosing Storage Systems for MySQL [slides]

3:15 PM • Room 143 A • Peter Zaitsev (Percona)

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.

Tracks: DBA, Manager

Level: Intermediate


EXPLAIN Demystified

3:15 PM • Room 143 C • Baron Schwartz (Percona)

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.

Tracks: DBA, Developer

Level: Advanced


Choosing Hardware for MySQL [slides]

4:15 PM • Room 143 A • Kenny Gryp (Percona)

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.

Tracks: DBA, Manager

Level: Intermediate


High Availability with Percona-PRM [slides]

4:15 PM • Room 143 B • Yves Trudeau (Percona)

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.

Tracks: DBA

Level: Advanced


MySQL Performance and Scalability Optimization [slides]

4:15 PM • Room 143 C • Peter Zaitsev (Percona)

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.

Tracks: DBA, Developer

Level: Intermediate


MySQL in the Cloud and Virtualized [slides]

5:15 PM • Room 143 A • Baron Schwartz (Percona)Mark Uhrmacher (ideeli)Theo Schlossnagle (OmniTI)Michael West (VMware)Peter Zaitsev (Percona)

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.

Tracks: Developer, DBA, Manager

Level: Intermediate

]]> ]]>