64,19 €
Versandkostenfrei per Post / DHL
Aktuell nicht verfügbar
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
Who This Book Is For
Database administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL
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
Who This Book Is For
Database administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL
Outside of BreachDirectory, Lukas produces content situated around database management systems. He has written articles for Severalnines, Redgate, DbVisualizer, Arctype (now part of ClickHouse), dbWatch, and other companies, as well as managed writers in some of those companies (DbVisualizer, Arctype.) Some of his content has been also replicated by MySQL, MariaDB, and Percona. He also runs a YouTube channel under the moniker "Database Dive," where he distills complex database topics into relatable explanations in video format. Lukas also talks and runs workshops at conferences like Percona LIVE, MariaDB Server Fest and MariaDB Unconferences, DevTalks Romania in Bucharest, Big Data Conference Europe and Build Stuff in Vilnius, he has taken part in "Dirty AI" and other software events in Spain, as well as spoken remotely at events like Nerdearla, Conf42, Software Architecture Conference, and others.
Lukas also runs his own blog at [...] and can be reached by email at [...]
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.
| Erscheinungsjahr: | 2024 |
|---|---|
| Genre: | Importe, Informatik |
| Rubrik: | Naturwissenschaften & Technik |
| Medium: | Taschenbuch |
| Inhalt: |
xxi
380 S. 100 s/w Illustr. 380 p. 100 illus. |
| ISBN-13: | 9798868809798 |
| Sprache: | Englisch |
| Einband: | Kartoniert / Broschiert |
| Autor: | Vileikis, Lukas |
| Auflage: | First Edition |
| Hersteller: |
Apress
Apress L.P. |
| Verantwortliche Person für die EU: | APress in Springer Science + Business Media, Heidelberger Platz 3, D-14197 Berlin, juergen.hartmann@springer.com |
| Maße: | 254 x 178 x 22 mm |
| Von/Mit: | Lukas Vileikis |
| Erscheinungsdatum: | 03.12.2024 |
| Gewicht: | 0,757 kg |