فهرست مطالب

• Copyright
• Table of Contents
• Foreword
• Preface
• Chapter 1: MySQL Architecture
• MySQL’s Logical Architecture
• Concurrency Control
• Transactions
• Multiversion Concurrency Control
• Replication
• Datafiles Structure
• The InnoDB Engine
• Summary
• Chapter 2: Monitoring in a Reliability Engineering World
• The Impact of Reliability Engineering on DBA Teams
• Defining Service Level Goals
• What to Measure
• Measuring Long-Term Performance
• Summary
• Chapter 3: Performance Schema
• Introduction to Performance Schema
• Configuration
• Using Performance Schema
• Summary
• Chapter 4: Operating System and Hardware Optimization
• What Limits MySQL’s Performance?
• How to Select CPUs for MySQL
• Balancing Memory and Disk Resources
• Solid-State Storage
• RAID Performance Optimization
• Network Configuration
• Choosing a Filesystem
• Summary
• Chapter 5: Optimizing Server Settings
• How MySQL’s Configuration Works
• What Not to Do
• Creating a MySQL Configuration File
• Configuring Memory Usage
• Configuring MySQL’s I/O Behavior
• Configuring MySQL Concurrency
• Safety Settings
• Advanced InnoDB Settings
• Summary
• Chapter 6: Schema Design and Management
• Choosing Optimal Data Types
• Schema Design Gotchas in MySQL
• Schema Management
• Summary
• Chapter 7: Indexing for High Performance
• Indexing Basics
• Indexing Strategies for High Performance
• Index and Table Maintenance
• Summary
• Chapter 8: Query Performance Optimization
• Why Are Queries Slow?
• Slow Query Basics: Optimize Data Access
• Ways to Restructure Queries
• Query Execution Basics
• Limitations of the MySQL Query Optimizer
• Optimizing Specific Types of Queries
• Summary
• Chapter 9: Replication
• Replication Overview
• Replication Under the Hood
• Replication Failover
• Replication Topologies
• Replication Administration and Maintenance
• Replication Problems and Solutions
• Summary
• Chapter 10: Backup and Recovery
• Why Backups?
• Defining Recovery Requirements
• Designing a MySQL Backup Solution
• Managing and Backing Up Binary Logs
• Backup and Recovery Tools
• Backing Up Data
• Recovering from a Backup
• Summary
• Chapter 11: Scaling MySQL
• What Is Scaling?
• Read- Versus Write-Bound Workloads
• Functional Sharding
• Scaling Reads with Read Pools
• Queuing
• Scaling Writes with Sharding
• Summary
• Chapter 12: MySQL in the Cloud
• Managed MySQL
• MySQL on Virtual Machines
• Summary
• Chapter 13: Compliance with MySQL
• What Is Compliance?
• Building for Compliance Controls
• Summary
• Appendix A: Upgrading MySQL
• Appendix B: MySQL on Kubernetes
• Index
• About the Authors
• Colophon