Learning MySQL: Get a Handle on Your Data

by Vinicius M Grippa, Sergey Kuzmichev

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. 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.

629 pages, Paperback

Published October 19, 2021

Reviews

[Mel Riffe · Rating 3 out of 5]

I picked up this book as a 'getting to know my toolset better' opportunity. I've been a professional software developer for nearly 31 years. I've written a lot of SQL, and accessed a number of different databases. I felt it was time to really dive into MySQL. Probably due to my goals, mostly to not be a DBA, I found this book equal parts too basic and too technical. And that is due to a lacking on my part, not the authors.

During my career I did not need to be a 'full stack' developer, with DevOps experience. I didn't learn about networking and systems administration, or OS configuration, and monitoring. Yes, I understood the concepts, but I never had to put them into practice. For me, that is where the book became too technical; I appreciate the background but I don't have any plans of acting on the new found knowledge.

Overall, and take this with a grain of salt, if you're new to MySQL, but you have some DBA experience, I feel you will find this a good introductory volume.