Buy Percona SupportEmergency? Get 24/7 Help Now!

Percona eBooks

Percona eBooks are collections of the most helpful and insightful posts from the Percona Performance Blog by our technology experts from the Percona Support, Consulting, and Managed Services teams. They cover topics such as DBA best practices related to database performance and troubleshooting, as well MySQL, NoSQL, cloud and polyglot deployments. All Percona eBooks are available for free download.



  Mar 31, 2016   Alexander Rubin, Peter Zaitsev

Download section two of our newest eBook, “Practical MySQL Performance Optimization,” by Percona CEO Peter Zaitsev and Principal Consultant Alexander Rubin. The content in this eBook will enable you to troubleshoot and optimize your own database...

  Nov 17, 2015   Alexander Rubin, Peter Zaitsev

A hands-on, business-case-driven guide to understanding MySQL query parameter tuning and database performance optimization. With the increasing importance of applications and networks in both business and personal interconnections, performance has...

  Dec 17, 2014   Aurimas Mikalauskas, Stephane Combaudon, Alexander Rubin

The Percona eBook "MySQL Performance Tuning" (vol. 1) walks DBAs through the top 10 MySQL settings to tune after installation of your server. Subsequent chapters introduce techniques for advanced MySQL query tuning, share Linux performance tuning tips...

  Nov 14, 2014   Tushar Katarki, Jervin Real, Vadim Tkachenko, Peter Zaitsev

In this Percona eBook, the first in a series on MySQL backups, Jervin Real elaborates on encrypted and incremental MySQL backups with Percona XtraBackup; Tushar Katarki details backup and restore of MySQL to OpenStack Swift; Vadim Tkachenko offers...

  Nov 4, 2014   Jervin Real

In this Percona eBook, the first in a series on MySQL High Availability, senior MySQL consultant Jervin Real introduces mysqlnd_ms with a simple HA solution using asynchronous MySQL replication. He then demonstrates how to leverage an all-primary...

  Oct 21, 2014   Dimitri Vanoverbeke, Stephane Combaudon, Tushar Katarki, Tim Sharp, Terry Erisman

OpenStack, the fastest-growing open cloud platform, is a highly scalable operating system for public and private clouds and is winning the support of service providers and organizations of all sizes. Trove is the "Database as a Service" (DBaaS) for...

  Oct 9, 2014   David Busby, Ernest Souhrada, Peter Zaitsev

MySQL security is more important today than ever. In this Percona eBook, we'll examine MySQL 5.6 security vs ease of use, why it's important to review your current database security measures - along with real-world best practices and advice.

  Sep 22, 2014   Aurimas Mikalauskas, Stephane Combaudon, Muhammad Irfan

MySQL's built-in replication is the foundation for building large, high-performance applications on top of MySQL using the "scale-out" architecture. MySQL replication enables DBAs to configure one or more server as replicas of another server - keeping...

  Jul 14, 2014   Fernando Ipar, Martin Arrieta

MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. This Percona eBook examines using it to manage MySQL server farms and also looks at High Availability with MySQL Fabric....

  Jun 5, 2014   Alexander Rubin, Vadim Tkachenko

MySQL Performance Schema is a tool for monitoring database execution with minimal impact on server performance. In the Percona eBook, "MySQL Performance Schema," the authors address MySQL 5.6 Performance Schema in multi-tenant environments;...

  May 7, 2014   Vadim Tkachenko

MySQL has useful extension to the GROUP BY operation: function GROUP_CONCAT:

GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group.

When is GROUP_CONCAT useful? Usually while...

  Apr 25, 2014   Roel Van de Paar

For Roel Van de Paar, finding bugs in MySQL is not only fun, it’s also something he's been doing the last four years of his professional life.

Whether you want to become the next Shane Bester (who is generally considered the most skilled MySQL...

  Mar 26, 2014   Ernest Souhrada

In "InnoDB Full-text Search in MySQL 5.6," senior consultant Ernie Souhrada opens with a quick overview of Full-text Search (FTS) in InnoDB and some observations that he's made while getting it configured. In Chapter 2, he compares query results...

  Mar 20, 2014   Stephane Combaudon, Vadim Tkachenko

InnoDB is the default transactional storage engine for MySQL and the most important and broadly useful engine overall. It was designed for processing many short-lived transactions that usually complete rather than...

  Mar 11, 2014   Bill Karwin, Peter Zaitsev, Peter Boros

The Percona eBook, "MySQL Logs," is comprised of 4 chapters. The first, by Percona Senior Knowledge Manager Bill Karwin, focuses on Percona Toolkit's pt-query-digest, a tool indispensable for identifying your top...

  Mar 10, 2014   Nickolay Ihalainen, Muhammad Irfan, Fernando Laudares Camargos, Michael Benshoof

In this eBook we'll begin with a review of InnoDB performance optimization basics and continue with the revelation of one common pitfall you'll want to avoid when working with InnoDB file formats. Next we'll show you how to move the InnoDB log...

  Feb 24, 2014   Roel Van de Paar, Nilnandan Joshi

This Percona eBook features MySQL server memory usage. The first chapter offers popular troubleshooting tips from Percona support engineer Nilnandan Joshi based on his many customer interactions. Chapters Two and Three, by Alexey Stroganov, focus on...

  Jan 27, 2014   Jervin Real, Jay Janssen

In this issue Percona XtraDB Cluster 5.6 users will learn how to find a good IST donor, using keepalived with reader and writer VIPs, and also get introduced to new wsrep_provider_options.

  Jan 24, 2014   Jay Janssen, Jervin Real, Peter Zaitsev

This issue offers a peak at some of the useful MySQL 5.6 features that you get for free in Percona XtraDB Cluster, explains how to migrate to Percona XtraDB Cluster and then walks users through setting up a simple cluster. We'll also examine Galera...