Tutorials

  • Track: Developing Applications
    Beginner
    Andrew Aksyonoff

    Search is easy. Just how hard can a CREATE FULLTEXT INDEX can be, right? Except that won't scale. And it won't be easy to tweak either. And don't even get me started on relevance. (And no, relevance isn't something only Google can have, because they enslaved every scientist working on that.)

  • Track: Database Administration
    Intermediate
    René Cannaò

    General backup best practices:

    what to backup, why, and when;
    backup schedules and retention policies;
    documentation and test of recovery procedures;
    archiving
    Overview, analysis and comparison of various methods of backups:

    full backup vs incremental backup;
    binary backup vs logical backup;
    cold backup vs hot backup.
    Overview on differences between storage engines, and how that affects the choice of backup.

    Methods:

    file system snapshot ( LVM and XFS snapshot );
    backup from slave;
    EBS snapshot ( in the cloud ).
    Tools:

    mysqldump
    XtraBackup
    mydumper
    mylvmbackup

  • Track: Developing Applications
    Intermediate
    Jonathan Levin

    This tutorial is about the most effective techniques to scale MySQL and improve response times that are specifically targeted at developers.
    These strategies play to the strengths of developers as well as domain expertise and scope of authority. It will not include hardware or operating systems fine-tuning and anything else that may annoy your operations team. All strategies are “cloud-compatible”.

    Topics will include:
    * Choosing the very best indexes
    * Making your database more lean
    * Some MySQL settings hacks for touch situations
    * Writing better SQL (and how to avoid bottlenecks)

  • Track: Replication and High Availability Strategies
    Intermediate
    Florian Haas

    In this popular tutorial first presented at this year's MySQL Conference and Expo in Santa Clara, Florian explores the Pacemaker cluster stack, fully integrated with MySQL. He covers DRBD based and MySQL replication based cluster solutions, and combined configurations — all within one high availability framework.

  • Track: Replication and High Availability Strategies
    Intermediate
    Johan Andersson, Vinay Joosery

    MySQL Cluster offers rich SQL functionality of an RDBMS and many interesting NoSQL options co-existing in one environment at the same time. It provides full transactional support with a relational model, 99.999% availability, real-time access and a lot more.

    In this tutorial we will learn the following things:

    * MySQL Cluster architecture
    * MySQL Cluster basic administration
    * Loading data
    * NoSQL options for MySQL Cluster and when to use what
    - Memcached
    - Cluster/J
    - NDBAPI

  • Track: Replication and High Availability Strategies
    Intermediate
    Frederic Descamps

    This tutorial will cover the following topics:

    - Migration from standard MySQL Master-Slave Architecture to PXC
    - The process of using PXC to establish a real HA solution. Connectors will be the main focus but some load-balancers will be included.
    - SST, IST... What they are and the differences between the two. Ultimately, how to use them.
    - How to backup the cluster
    - How to monitor the cluster
    - 2 nodes servers- Why this isn't ideal but reasons and steps to setting it up anyway.
    - Galera Arbitrator: Defining what it is.
    - How to maintain the cluster

  • Track: Replication and High Availability Strategies
    Intermediate
    Neil Armitage, Giuseppe Maxia

    In this session we will explore the possibilities that Tungsten Replicator can provide to solve complex replication problems. Tungsten replicator (http://tungsten-replicator.org) is a high performance, open source, data replication engine for MySQL that is a drop in replacement for standard MySQL replication. We will cover

    • The Tungsten Replicator components.
    • Replacing standard MySQL replication with Tungsten Replicator and why it is a good idea.
    • Setting up Master-Master Replication and the pitfalls around this setup.
  • Track: Database Administration
    -
    Peter Zaitsev

    In this session you will learn about the additional features Percona Server offers compared to a stock MySQL Server. I will take a highly pragmatic approach exploring features, providing details on a variety of advantages in production and walk you though how and when to use these production advantages, as well as investigate potential implications and pitfalls. If you want to learn how to get the most out of your Percona Server installation, please attend this talk.

  • Advanced
    Tim Ellis

    When a component of your organization goes from medium to large in its size or volume, there are a series of performance problems that must be addressed. Sharding the cluster of MySQL databases is almost always the proper solution, but there are many different ways of sharding. This tutorial will go over some of them with actual working examples from high-volume shops in the past.

  • Track: Replication and High Availability Strategies
    Intermediate
    Johan Andersson, Vinay Joosery

    MySQL Cluster offers rich SQL functionality of an RDBMS and many interesting NoSQL options co-existing in one environment at the same time. It provides full transactional support with a relational model, 99.999% availability, real-time access and a lot more.

    In this tutorial we will learn the following things:

    * MySQL Cluster architecture
    * MySQL Cluster basic administration
    * Loading data
    * NoSQL options for MySQL Cluster and when to use what
    - Memcached
    - Cluster/J
    - NDBAPI