Tutorials

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.

Advanced
Tutorials
3 hours tutorial

Vadim is main architect of Percona XtraBackup, In this tutorial he will cover every details of XtraBackup:
- Original idea behind product
- Internal design
- Comparison with other backup solutions for MySQL
- Work principles
- Purpose of files in package
- Basic usage
- Parallel backup
- Streaming backup -
More complex usage:
* Incremental backups
* Differential backups
* Partial backups
* Move InnoDB tables between servers
* Parallel compressed backups
* lock and lockless modes

Beginner
Database Administration
3 hours tutorial

In this tutorial we will walk though all the key steps on adding search capabilities to your application. We'll start from integrating Sphinx into your code and learn how to perform initial configuration and integration with MySQL. Then we'll cover creation of advanced Sphinx-based capabilities in your application like faceted search, auto completion, misspells correction, finding similar items and more.

Beginner
Tutorials
3 hours tutorial

This tutorial will utilize laptop-based VMs to guide attendees through the basics of setup and administration of XtraDB cluster. Covered topics will be:

  • Migration from standard mysql to xtradb cluster
  • Configuration differences between standard mysql and xtradb cluster
  • Monitoring cluster node states
  • Adding nodes to the cluster and various SST methods
  • Setting up load balancing for Xtradb cluster
  • Cluster maintenance
  • Examples of the types of locking different clients can expect to see in Xtradb cluster if writing to...
Intermediate
Replication and High Availability Strategies
3 hours tutorial

-

-
Tutorials
3 hours tutorial

-

-
-
3 hours tutorial

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.

-
Tutorials
3 hours tutorial

Percona Toolkit is the must-have toolkit for serious MySQL administrators, with well-tested tools for many purposes such as query analysis and replication management. This half-day tutorial will show examples (with occasional hands-on exercises) of when and how to use the most important tools:

  • pt-archiver
  • pt-kill
  • pt-stalk, pt-collect, and pt-sift
  • pt-summary and pt-mysql-summary
  • pt-table-checksum and pt-table-sync
  • pt-heartbeat
  • pt-index-usage
  • pt-query-digest
Intermediate
Database Administration
3 hours tutorial

It is essential to understand how your system performs at different workloads to measure the impacts of changes and growth and to understand how those impacts will manifest. Measuring the performance of current workloads is not trivial and the creation of a staging environment where different workloads need to be tested has it's own set of challenges.

Intermediate
Tutorials
3 hours tutorial


Sponsored By