Название: Learning MySQL: Get a Handle on Your Data, Second Edition (Final)
Автор: Vinicius M. Grippa, Sergey Kuzmichev
Издательство: O’Reilly Media, Inc.
Год: 2021
Страниц: 632
Язык: английский
Формат: pdf (true), epub
Размер: 15.5 MB, 10.6 MB

Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster and recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS. Authors Vinicius Grippa and Sergey Kuzmichev from Percona show developers and DBAs methods for minimizing costs and maximizing availability and performance. You'll learn how to perform basic and advanced querying, monitoring and troubleshooting, database management and security, backup and recovery, and tuning for improved efficiency.

This edition includes new chapters on high availability, load balancing, and using MySQL in the cloud. Learning MySQL will help you: Deploy MySQL databases on bare metal, on virtual machines, and in the cloud Design database infrastructures Code highly efficient queries Monitor and troubleshoot MySQL databases Execute efficient backup and restore operations Optimize database costs in the cloud Understand database concepts, especially those pertaining to MySQL.

Who This Book Is For:
This book is primarily for people using MySQL for the first time or learning it as a second database. If you are entering the database arena for the first time, the first chapters will introduce you to the database design concepts and show you how to deploy MySQL into different operating systems and in the cloud. For those coming from another ecosystem, like Postgres, Oracle, or SQL Server, the book covers backup, high availability, and disaster recovery strategies. We hope all readers will also find this book to be a good companion for learning or reviewing fundamentals, from the architecture to advice for the production environment.

How This Book Is Organized:
We introduce many topics, from the basic installation process, database design, backups, and recovery to CPU performance analysis and bug investigation. We’ve divided the book into four main parts:

• Starting with MySQL
• Using MySQL
• MySQL in Production
• Miscellaneous Topics