MariaDB High Performance

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

MariaDB High Performance

Pierre MAVRO

1 customer reviews
Familiarize yourself with the MariaDB system and build high-performance applications
Mapt Subscription
FREE
$29.99/m after trial
eBook
$18.90
RRP $26.99
Save 29%
Print + eBook
$44.99
RRP $44.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$18.90
$44.99
$29.99 p/m after trial
RRP $26.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


MariaDB High Performance Book Cover
MariaDB High Performance
$ 26.99
$ 18.90
Rust High Performance Book Cover
Rust High Performance
$ 35.99
$ 25.20
Buy 2 for $35.00
Save $27.98
Add to Cart

Book Details

ISBN 139781783981601
Paperback298 pages

Book Description

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.

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

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
From 1 reviews

Read More Reviews

Recommended for You

MariaDB Essentials Book Cover
MariaDB Essentials
$ 23.99
$ 16.80
Getting Started with MariaDB - Second Edition Book Cover
Getting Started with MariaDB - Second Edition
$ 19.99
$ 14.00
NGINX High Performance Book Cover
NGINX High Performance
$ 31.99
$ 22.40
Learning Ansible 2 - Second Edition Book Cover
Learning Ansible 2 - Second Edition
$ 35.99
$ 25.20
Web Development with Django Cookbook - Second Edition Book Cover
Web Development with Django Cookbook - Second Edition
$ 39.99
$ 28.00
Building a Web Application with PHP and MariaDB: A Reference Guide Book Cover
Building a Web Application with PHP and MariaDB: A Reference Guide
$ 21.99
$ 15.40