]]>
Call us: 1-888-316-9775 • Contact Us
MySQL and InnoDB are trademarks of Oracle Corp.
Proudly running Percona Server
Copyright © 2006-2013 Percona Inc.
Copyright, Trademark, and Privacy Policy • Sitemap
]]>
Percona Live DC 2012 Sessions
Percona Live features leading experts in MySQL discussing real-world usage scenarios and application architectures.
Opening Keynote: Discover the Power of MySQL [slides]
Opening Keynote: Discover the Power of MySQL
Tracks: Developer, DBA, Manager
Opening Keynote: What's Your Real Tolerance? [slides]
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]
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
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]
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
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
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]
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?
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]
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]
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]
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
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]
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]
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
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]
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]
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]
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]
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