MariaDB High Performance

Familiarize yourself with the MariaDB system and build high-performance applications

MariaDB High Performance

Progressing
Pierre MAVRO

Familiarize yourself with the MariaDB system and build high-performance applications
$26.99
$44.99
RRP $26.99
RRP $44.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781783981601
Paperback298 pages

About This Book

  • Build multiple slaves and load balance with HA-Proxy
  • Explore MariaDB 10 features like GTID replication or Sharding using Spider
  • This is a step-by-step tutorial guide to help you build high performance applications

Who This Book Is For

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.

Table of Contents

Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 5: WAN Slave Architectures
Cascade slaves
Restricting replications
Designing slave in multiple continents
SSL replication
Compression options
Summary
Chapter 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
Chapter 7: MariaDB Multimaster Slaves
Multimaster slave replication
Summary
Chapter 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
Chapter 9: Spider – Sharding Your Data
Configuring Spider
Creating your first shard
Sharding replication
Performance tuning
Summary
Chapter 10: Monitoring
Single instance
Replication
Galera Cluster
Other monitoring solutions
Summary
Chapter 11: Backups
Using mysqldump
Using mysqlhotcopy
LVM
Xtrabackup
Galera backup
Summary

What You Will Learn

  • Set up master/slave classical replications and make them scale easily, even over WAN
  • Create a dual master replication with load balancer and cluster software
  • Shard your data using the Spider engine
  • Grow your write infrastructure by setting up a Galera Cluster
  • Make your Galera Cluster and replication work together to build complex solutions
  • Optimize your engine and identify bottlenecks
  • Compare the Galera and MySQL Cluster
  • Graph your data and tools solution
  • Build a Galera disaster recovery solution

In Detail

Designing and maintaining a huge amount of data in production is not an easy task. Understanding how solutions work, what kind of differences exist between them, and how to get them working is necessary before designing a solution for production. MariaDB High Performance will help you avoid mistakes, bad designs, and wrong strategic choices.

This book will throw light on important and crucial subjects such as which hardware should be used in which situation and what the bottlenecks generally are. You will get acquainted with the latest addition to the MariaDB family, known as Spider, and you will get to know how data sharding is carried out across several MariaDB servers using Spider.

Authors

Table of Contents

Chapter 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
Chapter 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
Chapter 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
Chapter 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
Chapter 5: WAN Slave Architectures
Cascade slaves
Restricting replications
Designing slave in multiple continents
SSL replication
Compression options
Summary
Chapter 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
Chapter 7: MariaDB Multimaster Slaves
Multimaster slave replication
Summary
Chapter 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
Chapter 9: Spider – Sharding Your Data
Configuring Spider
Creating your first shard
Sharding replication
Performance tuning
Summary
Chapter 10: Monitoring
Single instance
Replication
Galera Cluster
Other monitoring solutions
Summary
Chapter 11: Backups
Using mysqldump
Using mysqlhotcopy
LVM
Xtrabackup
Galera backup
Summary

Book Details

ISBN 139781783981601
Paperback298 pages
Read More