What this book covers

Chapter 1, Performance Introduction, describes common hardware solutions to help you choose the best solution for your needs; furthermore, it introduces system optimization and describes how to migrate from MySQL to MariaDB.

Chapter 2, Performance Analysis, introduces tools to find performance issues and shares basic best practices.

Chapter 3, Performance Optimizations, talks about how to find bottlenecks, how to tune caches, and also introduces some engines.

Chapter 4, MariaDB Replication, explains how to set up MariaDB replications, how to scale with HAProxy, and the benefits of replication.

Chapter 5, WAN Slave Architectures, helps us understand the problems that arise in WAN replications and how to work with them.

Chapter 6, Building a Dual Master Replication, describes what the benefits are of this kind of architecture and how to set it up using DRBD, Pacemaker, PRM, and so on.

Chapter 7, MariaDB Multimaster Slaves, introduces the benefits of using the replication features of MariaDB 10.

Chapter 8, Galera Cluster – Multimaster Replication, describes the benefits and the way to deploy a Galera Cluster.

Chapter 9, Spider – Sharding Your Data, explains how to achieve better performance in sharding your data.

Chapter 10, Monitoring, describes what kind of elements are important to monitor on a single instance, replication, or Galera Cluster.

Chapter 11, Backups, introduces several ways to create backups and helps you choose the best method for your needs.