Hacking MySQL Год издания: 2024 Автор: Vileikis L. Издательство: Apress ISBN: 979-8-8688-0980-4 Язык: Английский Формат: PDF/EPUB Качество: Издательский макет или текст (eBook) Интерактивное оглавление: Да Количество страниц: 382 Описание: 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. Most MySQL books focus exclusively on optimization, but this book argues that it’s just as important to pay attention to the ways databases break. Indeed, after reading this book, you will be able to safely break your database instances to expose and overcome the nuanced issues that affect performance, availability, and security. MySQL is one of the most widely used database management systems in the world. That’s not without a reason – MySQL is a friend to many tech companies including, but not limited to, Facebook, Twitter, Netflix, and Uber. The reason why so many companies elect to use MySQL as their primary database management system of choice is because of its robustness: MySQL supports multiple storage engines which makes MySQL flexible enough for an ever-changing world of data – those storage engines come with their features related to performance, availability, or security, features that can be exploited to get the most out of this database management system. What You Will Learn: - Know the basics of MySQL and the storage engines innoDB and MyISAM - Spot the ways you are harming your database’s performance, availability and security without even realizing it - Fix minor bugs and issues that have surprisingly serious impact - Optimize schema, data types, queries, indexes, and partitions to head off issues - Understand key MySQL security strategies
Примеры страниц (скриншоты)
Оглавление
About the Author xiii Acknowledgments xv Preface xvii Foreword xxi Part I: The Basics of MySQL 1 Chapter 1: The World of MySQL 3 Chapter 2: Individual Storage Engines 11 Part II: Breaking MySQL 39 Chapter 3: What Breaks MySQL? 41 Chapter 4: How You Broke Your Queries 61 Chapter 5: Understanding Query Components 97 Chapter 6: Understanding Your Server 115 Part III: Optimizing MySQL 131 Chapter 7: Optimizing Your Server for MySQL 133 Chapter 8: Optimizing Storage Engines, Schemas, and Data Types 155 Chapter 9: Optimizing Queries 169 Chapter 10: Optimizing MySQL for Big Data 195 Chapter 11: Indexing MySQL 209 Chapter 12: Optimizing Partitions 249 Chapter 13: Optimizing Backups and Recovery 269 Chapter 14: Optimizing Replication 291 Chapter 15: Optimizing for Security 303 Part IV: Securing MySQL 311 Chapter 16: The World of Security in MySQL 313 Chapter 17: Securing Your Database Instance 327 Chapter 18: Security and Big Data 341 Appendix: Things You Wish You Knew, but Don’t 355 Index 365
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
