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 recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS.\n\nAuthors 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.\n\nGet started with MySQL and learn how to use it in production\nDeploy MySQL databases on bare metal, on virtual machines, and in the cloud\nDesign database infrastructures\nCode highly efficient queries\nMonitor and troubleshoot MySQL databases\nExecute efficient backup and restore operations\nOptimize database costs in the cloud\nUnderstand database concepts, especially those pertaining to MySQL