Morgan Tocker

Percona, Inc

Morgan is a MySQL Expert, with interests in Performance Tuning,
scalability and High Availability. He is a regular speaker on these
topics at MySQL (and PHP) conferences in the United States and Canada.

Before joining Percona, Morgan worked as a Technical Instructor for
MySQL (and then Sun Microsystems) in Canada where he taught courses on
High Availability, Performance Tuning and Database Administration. He
has also previously worked in the MySQL Support Team, and provided DRBD
support.

Morgan lives in Montreal, Canada. He's content in settling there after
moving from Australia in 2007.

I'm going to tell you what MySQL is bad at! View session page

English session

MySQL for many years has been everyone's default choice for data storage. It's easy to install, easy to use and scales well if you put just a little bit of effort into it.

Enter 2010, and there are a lot more options for data storage. We have fulltext systems like Sphinx available, and a whole wave of NOSQL databases. So in which cases shouldn't we be using MySQL?

Diagnosing and Fixing MySQL Database Problems View session page

English session

This talk is about what to do when you've identified your MySQL database is slow, but you don't know where to start.

I'll be showing you the approach I use - and how I've been able to put it to use on hundreds of customer machines.

Advanced MySQL DBA Training View training page

This tutorial is about running a High Performance MySQL Application in production. You will learn how to inherit an application, and then start running diagnostics to find out where your performance problems are, using the same approach I have as a database consultant. We then move onto tuning queries, tuning MySQL configuration and understanding how InnoDB works internally to start tuning it. This tutorial comes with prerequisites: You need to have some production experience with MySQL, and understand concepts such as "what is a storage engine".

Advanced MySQL Developer Training View training page

This tutorial teaches you how to build a High Performance, Scalable Application around MySQL. While it can be critical of stupid decisions some ORMs make, it does not relate to any specific programming language. You'll learn about MySQL concepts, what it's good (or bad at), and how to design your schema and queries to solve a large array of theoretical problems. The examples I use come from various web/social networking challenges, the lessons that come out of them have been designed to be as generic as possible.