2. Performance Analysis | MariaDB High Performance

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

MariaDB High Performance

By : Pierre Mavro

4.3 (13)

MariaDB High Performance

4.3 (13)

By: Pierre Mavro

Overview of this book

This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. You will be able to get a grasp quickly if you are comfortable with learning and building large infrastructures for MariaDB using Linux.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Performance Introduction

1. Performance Introduction

MariaDB history

Choosing the appropriate hardware

Architecture types and performances

BIOS power management optimization

Migrating from MySQL to MariaDB

Introduction to MariaDB engines

Summary

2. Performance Analysis

2. Performance Analysis

Slow queries

The explain command

Slow query logs

The show explain command

Profiling

Performance schema

User statistics

Sysbench

Percona Toolkits

Process list progression

mytop

innotop

mysqlsla

Summary

3. Performance Optimizations

3. Performance Optimizations

Resetting statistics

Global statistics

DNS connections

Maximum connections

The binlogs cache

Temporary tables

Open tables

The query cache

Optimizing storage engines

Index

mysqltuner

Summary

4. MariaDB Replication

4. MariaDB Replication

How replication works

GTID replication

Migrating from classical to GTID replication

Parallel replication

Load balancing read transactions

Use cases and troubleshooting

Summary

5. WAN Slave Architectures

5. WAN Slave Architectures

Cascade slaves

Restricting replications

Designing slave in multiple continents

SSL replication

Compression options

Summary

6. Building a Dual Master Replication

6. Building a Dual Master Replication

Dual master replication and risks

Installing and configuring a dual master

Automatic management

How to repair a dual master replication

Summary

7. MariaDB Multimaster Slaves

7. MariaDB Multimaster Slaves

Multimaster slave replication

Summary

8. Galera Cluster – Multimaster Replication

8. Galera Cluster – Multimaster Replication

How Galera Cluster works

Galera Cluster limitations

The basics of installation and configuration

Usages and understandings

Designing redundant architectures

Tests and issues

Summary

9. Spider – Sharding Your Data

9. Spider – Sharding Your Data

Configuring Spider

Creating your first shard

Sharding replication

Performance tuning

Summary

10. Monitoring

10. Monitoring

Single instance

Replication

Galera Cluster

Other monitoring solutions

Summary

11. Backups

11. Backups

Using mysqldump

Using mysqlhotcopy

LVM

Xtrabackup

Galera backup

Summary

Index

Index

Percona Toolkits

Percona Toolkits is a suite of tools for MySQL and MariaDB. They are very useful in many situations and well documented (the main website is http://www.percona.com/software/percona-toolkit). To install them, you can add the repository:

> aptitude install python-software-properties
> apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
> add-apt-repository 'deb http://repo.percona.com/apt wheezy main'

Then, configure APT-Pining to avoid the Percona repository overriding MariaDB's repository and conflict some packages. So, create this file at /etc/apt/preferences.d/00percona.pref and add the following content to it:

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 100

You're now ready for the installation of the package:

> aptitude update
> aptitude install percona-toolkit

That's it! Several binaries starting with pt- are now available on your system.

pt-query-digest

The pt-query-digest tool will help you analyze the MariaDB slow queries...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

MariaDB High Performance

Search

Your notes and bookmarks