Название: Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case
Автор: Lukas Vileikis
Издательство: Apress
Год: 2024
Страниц: 382
Язык: английский
Формат: pdf (true), epub
Размер: 22.8 MB
Your MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security―and that’s only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or security by uncovering what causes databases to break in the first place. At its core, this book provides you with the knowledge necessary for you to break your database instances so you can better optimize it for performance and secure it from data breaches. In other words, you’ll discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this book will help you keep it working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best MySQL configurations, among other essential skills. For database administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL.