Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case
暫譯: 破解 MySQL：為您的使用案例進行優化與安全加固
Vileikis, Lukas
相關主題
商品描述
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
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
商品描述(中文翻譯)
您的 MySQL 實例可能出現問題。許多開發人員面臨執行緩慢的查詢、與資料庫架構、複製或資料庫安全性相關的問題——這僅僅是開始。本書將針對您最迫切的 MySQL 資料庫問題提供解答，這些問題與性能、可用性或安全性有關，並揭示導致資料庫出現故障的根本原因。
本書的核心是提供您所需的知識，以便您能夠故意破壞您的資料庫實例，從而更好地優化其性能並保護其免受資料洩露。換句話說，您將發現那些會降低資料庫性能的各種行為，無論是小問題還是大問題，這樣您就可以修復並最終預防它們。MySQL 有時會根據自己的規則運作，而本書將幫助您保持其按照您的條件運行。同時，您將學會優化備份和恢復程序，確定何時以及索引哪些數據以實現最佳性能，並選擇最佳的 MySQL 配置，還有其他基本技能。
大多數 MySQL 書籍專注於優化，但本書認為，關注資料庫故障的方式同樣重要。事實上，閱讀完本書後，您將能夠安全地破壞您的資料庫實例，以揭示並克服影響性能、可用性和安全性的微妙問題。
您將學到的內容：
- 了解 MySQL 的基本概念及其儲存引擎 innoDB 和 MyISAM
- 發現您在不知不覺中損害資料庫性能、可用性和安全性的方式
- 修復那些看似微小但影響卻出奇嚴重的錯誤和問題
- 優化架構、數據類型、查詢、索引和分區，以防止問題發生
- 理解關鍵的 MySQL 安全策略
本書適合對象：
資料庫管理員、網頁開發人員、系統管理員和安全專業人員，具備中級的資料庫管理系統和 MySQL 應用程式開發知識。
作者簡介
Lukas Vileikis is an ethical hacker, a MySQL database administrator, and a frequent conference speaker. He has worked on MySQL since late 2013, and since 2014, has found and responsibly disclosed security flaws in some of the most visited websites in Lithuania and abroad. Lukas honed his database administration skills while building and administering one of the biggest data breach search engines in the world: BreachDirectory.com, which is used by cyber security companies, individuals, as well as prominent universities worldwide. The website allows people to check whether they're at risk of identity theft and then protect themselves on the web, and protects more and more people from all walks of life every single day. BreachDirectory has been running on MySQL ever since its inception and has been at the center of numerous awards, including at World Summit Awards 2020, where BreachDirectory was a national nominee nominated by the Lithuanian government to represent Lithuania against an international jury evaluating the best digital innovations in the world; and at Technorama 2021, a tech product-based event organized by Kaunas University of Technology (KTU), where BreachDirectory was nominated as the best product in the security space by Bentley Systems.
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 lukasvileikis.com and can be reached by email at lukas@lukasvileikis.com
作者簡介(中文翻譯)
Lukas Vileikis 是一位道德駭客、MySQL 資料庫管理員，並且是經常參加會議的演講者。他自 2013 年底以來一直在從事 MySQL 的工作，自 2014 年以來，他在立陶宛及國外的一些最受訪問的網站上發現並負責披露安全漏洞。Lukas 在建立和管理全球最大的資料外洩搜尋引擎之一 BreachDirectory.com 的過程中磨練了他的資料庫管理技能，該網站被網路安全公司、個人以及全球知名大學所使用。該網站允許人們檢查自己是否面臨身份盜竊的風險，並在網路上保護自己，每天都在保護來自各行各業的越來越多的人。BreachDirectory 自創立以來一直運行在 MySQL 上，並且獲得了多項獎項的中心，包括在 2020 年的世界峰會獎（World Summit Awards 2020），BreachDirectory 被立陶宛政府提名為國家提名，代表立陶宛參加國際評審團評估全球最佳數位創新；以及在 2021 年的 Technorama，這是一個由考那斯科技大學（Kaunas University of Technology, KTU）組織的技術產品活動，BreachDirectory 被 Bentley Systems 提名為安全領域的最佳產品。
在 BreachDirectory 之外，Lukas 創作有關資料庫管理系統的內容。他為 Severalnines、Redgate、DbVisualizer、Arctype（現為 ClickHouse 的一部分）、dbWatch 和其他公司撰寫文章，並在其中一些公司（DbVisualizer、Arctype）管理作家。他的一些內容也被 MySQL、MariaDB 和 Percona 轉載。他還經營一個名為「Database Dive」的 YouTube 頻道，將複雜的資料庫主題提煉成易於理解的視頻解釋。Lukas 也在 Percona LIVE、MariaDB Server Fest 和 MariaDB Unconferences、羅馬尼亞布加勒斯特的 DevTalks、歐洲大數據會議和維爾紐斯的 Build Stuff 等會議上進行演講和舉辦工作坊，他參加過西班牙的「Dirty AI」及其他軟體活動，並且在 Nerdearla、Conf42、Software Architecture Conference 等活動上進行過遠端演講。
Lukas 還經營自己的部落格，網址為 lukasvileikis.com，並可通過電子郵件聯繫他，郵箱地址為 lukas@lukasvileikis.com。
