Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency
暫譯: 精通 MySQL 管理：高可用性、安全性、性能與效率

這本書是針對管理員的 MySQL 資料庫安裝和伺服器管理的一站式資源。內容涵蓋安裝、升級、監控、高可用性、災難恢復、安全性以及性能和故障排除。您將熟悉 MySQL 8.2，這是最新版本的高可擴展性和穩健的關聯式資料庫系統。

本書採用實作導向的方法，提供逐步指導，幫助您安裝、升級並建立穩健的高可用性和災難恢復能力，適用於 MySQL 資料庫。它還涵蓋了使用 InnoDB 和 NDB 集群的高可用性、MySQL 路由器和企業 MySQL 工具，以及穩健的安全設計和性能技術。在整個過程中，作者以他們在 Meta 和美國航空等公司進行大規模實作的經驗為例，強調概念，將這本實用指南與 MySQL 8.2 管理的現實世界相結合。

您將學到的內容：
- 了解 MySQL 架構及 MySQL 伺服器管理的最佳實踐
- 配置高可用性、複製、使用 InnoDB 和 NDB 引擎的災難恢復
- 使用 MySQL 工具和實用程式進行備份和還原，並配置資料庫以實現零資料損失
- 針對現實世界中的關鍵錯誤進行故障排除，並提供詳細解決方案

本書適合對象：
技術專業人士、資料庫管理員、開發人員和工程師，尋求優化 MySQL 資料庫以達到擴展性、安全性和性能。

Y V Ravi Kumar is an Extraordinary Ability (EB1-A) Einstein Visa recipient from the United States of America, an Oracle Certified Master, a co-author, a mentor, a technical blogger, a frequent speaker in international conferences, and a technical reviewer. He is TOGAF-certified, has published 100+ technical articles, and is an Oracle Open/cloud speaker (x4). He is an IEEE Senior Member with 26+ years of multinational leadership experience in the USA, Seychelles, and India in banking, financial services, and Insurance (BFSI) verticals.

Ravi Kumar has co-authored four books: Oracle Database Upgrade and Migration Methods, Oracle High Availability, Disaster Recovery, and Cloud Services, Oracle GoldenGate with MicroServices, and Oracle Global Data Services for Mission-Critical Systems. And he served as technical reviewer on five books: Oracle 19c AutoUpgrade Best Practices, Oracle Autonomous Database in Enterprise Architecture, End-to-End Observability with Grafana, Maximum Availability Architecture (MAA) with Oracle GoldenGate MicroServices in HUB Architecture, and The Cloud Computing Journey: Design and Deploy Resilient and Secure Multi-cloud Systems with Practical Guidance.

Ravi Kumar is an Oracle Certified Professional (OCP) in Oracle 8i, 9i, 10g, 11g, 12c, and 19c, and he is also an Oracle Certified Expert (OCE) in Oracle GoldenGate, RAC, Performance Tuning, Oracle Cloud Infrastructure, Terraform, and Oracle Engineered Systems (Exadata, ZDLRA, and ODA), as well as certified in Oracle Security and Maximum Availability Architecture (MAA). He is also certified in PostgreSQL, MySQL, and MySQL Heatwave platforms. And he is certified in multi-cloud architect (OCI, AWS and GCP).

Ravi Kumar has published over 100+ Oracle technology articles, including on Oracle Technology Network (OTN), in ORAWORLD Magazine, on UKOUG, in OTech Magazine, and on Redgate. He hasspoken four times at Oracle Cloud/Open World (OOW) in Las Vegas/San Francisco, USA. And over the last decade, he has delivered technical sessions at Oracle user groups: IOUG, OCW, NYOUG, AUSOUG, AIOUG, UTOUG, SOUG, DOUG, and Quest Oracle Community.

Ravi Kumar has designed data centers and implemented mission-critical databases for core banking solutions for two major central banks in the world. He has also received the honor of being named "TOP Data Architecture voice" from LinkedIn. And Oracle Corporation has published his profile on their OCM list and in their Spotlight on Success stories.

Naresh Kumar Miryala is a highly experienced engineering leader with 20 years of industry experience and a strong background in cloud, platform engineering, and artificial intelligence. He has been leading high-performing cloud data platforms teams in his current role at Meta Platforms, Inc. He has a proven track record of cloud transformations, infrastructure implementation, database management, ERP solutions, and DevOps deployments. His expertise spans multiple domains such as database systems, large-scale backend infrastructure, security, multi-cloud deployments, cloud infrastructure, DevOps, and artificial intelligence.

Naresh has contributed to esteemed organizations such as Oracle Corp and Computer Sciences Corporations, where he played a pivotal role in migrating or implementing Oracle technologies for Fortune 500 companies across the globe. His impact spans various industries, including pharmaceuticals, retail, banking, and gold mining companies worldwide.

Naresh's experience in cloud migrations, particularly involving relational, open-source, and NoSQL databases, middleware, and applications, has granted him a comprehensive understanding of multi-faceted technical and business challenges in the modern world and developing innovative solutions across the industry to solve large-scale data transformation and security problems using artificial intelligence.

He is also an active member of IEEE, IOUG, OATUG, and AIM leadership council, and holds certifications as a professional in cloud, database, and artificial intelligence platforms.

Arun Kumar Samayam is an experienced technology architect and a seasoned database professional with a profound passion for innovation. Arun is a Principal Cloud Solutions Architect in Cloud and Engineering platform team at a global airline company. Arun is part of the Cloud Center of Excellence (CCoE) team, where he drives the organization's cloud transformation journey through cloud governance practices.

Before this role, Arun worked as a Product Technical leader for the Enterprise Database services team, where he had the opportunity to develop and hone his technical proficiency through engineering, managing and supporting multiple database platforms like Oracle, MySQL, PostgreSQL, SQL server, and MongoDB. In addition, Arun is a multi-cloud certified professional, and his industry knowledge and experience have made him a speaker at prestigious events like Oracle OpenWorld, where he shared his insights and expertise on database products.

**Y V Ravi Kumar** 是來自美國的特殊才能 (EB1-A) 愛因斯坦簽證持有者，擁有 Oracle 認證大師資格，並且是合著者、導師、技術部落客、國際會議的常客演講者以及技術審稿人。他擁有 TOGAF 認證，已發表超過 100 篇技術文章，並且是 Oracle Open/cloud 的演講者（四次）。他是 IEEE 高級會員，擁有超過 26 年的跨國領導經驗，曾在美國、塞舌爾和印度的銀行、金融服務和保險 (BFSI) 行業工作。

Ravi Kumar 合著了四本書籍：*Oracle Database Upgrade and Migration Methods*、*Oracle High Availability, Disaster Recovery, and Cloud Services*、*Oracle GoldenGate with MicroServices* 和 *Oracle Global Data Services for Mission-Critical Systems*。他還擔任了五本書的技術審稿人：*Oracle 19c AutoUpgrade Best Practices*、*Oracle Autonomous Database in Enterprise Architecture*、*End-to-End Observability with Grafana*、*Maximum Availability Architecture (MAA) with Oracle GoldenGate MicroServices in HUB Architecture* 和 *The Cloud Computing Journey: Design and Deploy Resilient and Secure Multi-cloud Systems with Practical Guidance*。

Ravi Kumar 是 Oracle 8i、9i、10g、11g、12c 和 19c 的 Oracle 認證專業人員 (OCP)，同時也是 Oracle GoldenGate、RAC、性能調優、Oracle Cloud Infrastructure、Terraform 和 Oracle Engineered Systems (Exadata、ZDLRA 和 ODA) 的 Oracle 認證專家 (OCE)，並且在 Oracle Security 和 Maximum Availability Architecture (MAA) 方面也獲得了認證。他還在 PostgreSQL、MySQL 和 MySQL Heatwave 平台上獲得了認證，並且是多雲架構 (OCI、AWS 和 GCP) 的認證專業人員。

Ravi Kumar 已在 Oracle 技術網絡 (OTN)、ORAWORLD 雜誌、UKOUG、OTech 雜誌和 Redgate 上發表了超過 100 篇 Oracle 技術文章。他曾在美國拉斯維加斯/舊金山的 Oracle Cloud/Open World (OOW) 演講四次。在過去十年中，他在 Oracle 用戶組中進行了技術會議：IOUG、OCW、NYOUG、AUSOUG、AIOUG、UTOUG、SOUG、DOUG 和 Quest Oracle Community。

Ravi Kumar 設計了數據中心並為世界兩大中央銀行實施了關鍵任務的數據庫解決方案。他還榮獲 LinkedIn 的「TOP Data Architecture voice」稱號。Oracle 公司已在其 OCM 名單和 Spotlight on Success 故事中發佈了他的個人資料。

**Naresh Kumar Miryala** 是一位經驗豐富的工程領導者，擁有 20 年的行業經驗，並在雲端、平台工程和人工智慧方面有著堅實的背景。他目前在 Meta Platforms, Inc. 擔任高效能雲數據平台團隊的領導者。他在雲轉型、基礎設施實施、數據庫管理、ERP 解決方案和 DevOps 部署方面有著良好的記錄。他的專業知識涵蓋多個領域，如數據庫系統、大型後端基礎設施、安全性、多雲部署、雲基礎設施、DevOps 和人工智慧。

Naresh 曾為 Oracle Corp 和 Computer Sciences Corporations 等知名組織做出貢獻，在這些公司中，他在為全球 Fortune 500 公司遷移或實施 Oracle 技術方面發揮了關鍵作用。他的影響力遍及各行各業，包括全球的製藥、零售、銀行和金礦公司。

Naresh 在雲遷移方面的經驗，特別是涉及關聯式、開源和 NoSQL 數據庫、中介軟體和應用程式，使他對現代世界中多面向的技術和商業挑戰有了全面的理解，並在行業內開發創新的解決方案，以利用人工智慧解決大規模數據轉型和安全問題。

他還是 IEEE、IOUG、OATUG 和 AIM 領導委員會的活躍成員，並持有雲、數據庫和人工智慧平台的專業認證。

**Arun Kumar Samayam** 是一位經驗豐富的技術架構師和資深數據庫專業人員，對創新充滿熱情。Arun 是一家全球航空公司的雲和工程平台團隊的首席雲解決方案架構師。他是雲卓越中心 (CCoE) 團隊的一員，負責推動組織的雲轉型之旅，並實施雲治理實踐。

在此角色之前，Arun 擔任企業數據庫服務團隊的產品技術領導者，並有機會通過工程、管理和支持多個數據庫平台（如 Oracle、MySQL、PostgreSQL、SQL Server 和 MongoDB）來發展和磨練他的技術能力。此外，Arun 是多雲認證專業人員，他的行業知識和經驗使他成為 Oracle OpenWorld 等知名活動的演講者，分享他對數據庫產品的見解和專業知識。