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
Vinicius M. Grippa is a Senior Support Engineer at Percona and has assisted customers (including Fortune 100 companies) in that capacity for the past three years. He also performs spot checks for other engineers at Percona, to assist in their development and to spread knowledge among his team. In addition to these responsibilities, Vinicius has written and reviewed articles for the Knowledge Base, and has served as a conference program chair for the Percona Live Conference & Expo 2019 and 2020, assisting with the development of each meeting's program and agenda. Prior to his tenure at Percona, Vinicius was a system analyst and DBA for nearly a decade.
Sergey Kuzmichev is a Support Engineer at Percona. He represents Percona in open source conferences and meetups all around the globe. He contributes to the community writing articles and blog posts about MySQL and open source databases. Prior to his time at Percona, Sergey was a DBA and DevOps Engineer for nearly a decade.