更新时间：2021-08-05 18:03:33
封面
版权页
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
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
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
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
Chapter 5. WAN Slave Architectures
Cascade slaves
Restricting replications
Designing slave in multiple continents
SSL replication
Compression options
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
Chapter 7. MariaDB Multimaster Slaves
Multimaster slave replication
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
Chapter 9. Spider – Sharding Your Data
Configuring Spider
Creating your first shard
Sharding replication
Performance tuning
Chapter 10. Monitoring
Single instance
Replication
Galera Cluster
Other monitoring solutions
Chapter 11. Backups
Using mysqldump
Using mysqlhotcopy
LVM
Xtrabackup
Galera backup
