Hacking MySQL : Breaking, Optimizing, and Securing MySQL for Your Use Case / by Lukas Vileikis.

Format:

Book

Author/Creator:

Vileikis, Lukas.

Series:

Professional and Applied Computing Series

Language:

English

Subjects (All):

Database management.

Database Management.

Local Subjects:

Database Management.

Physical Description:

1 online resource (382 pages)

Edition:

1st ed. 2024.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2024.

Summary:

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

Contents:

Part 1 The Basics of MySQL

Chapter 1: The World of MySQL

Chapter 2: Individual Storage Engines

Part 2 Breaking MySQL

Chapter 3: What Breaks MySQL?

Chapter 4: How You Broke Your Queries

Chapter 5: Understanding Query Components

Chapter 6: Understanding Your Server

Part 3 Optimizing MySQL

Chapter 7: Optimizing MySQL for Your Server

8: Optimizing Specific Storage Engines, Schemas, and Data Types

Chapter 9: Optimizing Queries

Chapter 10: Optimizing MySQL or Big Data

Chapter 11: Indexing MySQL

Chapter 12: Optimizing Partitions

Chapter 13: Optimizing Backups and Recovery

Chapter 14: Optimizing Replication

Chapter 15: Optimizing for Security

Part 4 Securing MySQL

Chapter 16: The World of Security in MySQL

Chapter 17: Securing Your Database Instance

Chapter 18

Security and Big Data

Chapter 19: Appendices: Things You Wish You Knew, but Don’t

19.1 Schrodinger’s Tables in MySQL

19.2 Having Fun with ibdata1

19.3 Having Fun with Indexes

19.4 Query that Breaks MySQL 5.7

19.5 Reliably Using MyISAM

19.6 Building APIs and Interacting with Big Data

1.7 Preparing for the Future

19.8 Summary.

Notes:

Includes index.

Description based on publisher supplied metadata and other sources.

ISBN:

9798868809804

OCLC:

1475038616