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.
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
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.
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.
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:
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.