Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

Ravi Kumar, Y. V., Samayam, Arun Kumar, Miryala, Naresh Kumar

  • 出版商: Apress
  • 出版日期: 2024-05-03
  • 售價: $2,370
  • 貴賓價: 9.5$2,252
  • 語言: 英文
  • 頁數: 732
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 9798868802515
  • ISBN-13: 9798868802515
  • 相關分類: MySQLSQL資訊安全
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

This book is your one-stop resource on MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, and performance and troubleshooting. You will become fluent in MySQL 8.2, the latest version of the highly scalable and robust relational database system.

With a hands-on approach, the book offers step-by-step guidance on installing, upgrading, and establishing robust high availability and disaster recovery capabilities for MySQL databases. It also covers high availability with InnoDB and NDB clusters, MySQL routers and enterprise MySQL tools, along with robust security design and performance techniques. Throughout, the authors punctuate concepts with examples taken from their experience with large-scale implementations at companies such as Meta and American Airlines, anchoring this practical guide to MySQL 8.2 administration in the real world.


What You Will Learn

  • Understand MySQL architecture and best practices for administration of MySQL server
  • Configure high availability, replication, disaster recovery with InnoDB and NDB engines
  • Back up and restore with MySQL utilities and tools, and configure the database for zero data loss
  • Troubleshoot with steps for real-world critical errors and detailed solutions


Who This Book Is For

Technical professionals, database administrators, developers, and engineers seeking to optimize MySQL databases for scale, security, and performance


商品描述(中文翻譯)

這本書是針對管理員的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演講者(x4)。他是IEEE高級會員,在美國、塞舌爾和印度的銀行、金融服務和保險(BFSI)行業擁有26年以上的跨國領導經驗。

Ravi Kumar合著了四本書:《Oracle數據庫升級和遷移方法》、《Oracle高可用性、災難恢復和雲服務》、《Oracle GoldenGate與微服務》和《用於重要任務系統的Oracle全球數據服務》。他還擔任了五本書的技術審查人員:《Oracle 19c自動升級最佳實踐》、《企業架構中的Oracle自主數據庫》、《使用Grafana的端到端可觀察性》、《在HUB架構中使用Oracle GoldenGate微服務的最大可用性架構(MAA)》和《雲計算之旅:設計和部署具有實用指南的具有彈性和安全的多雲系統》。

Ravi Kumar在Oracle 8i、9i、10g、11g、12c和19c方面擁有Oracle認證專業人員(OCP)資格,他還是Oracle GoldenGate、RAC、性能調優、Oracle Cloud基礎架構、Terraform和Oracle Engineered Systems(Exadata、ZDLRA和ODA)的Oracle認證專家(OCE),並且還在Oracle安全和最大可用性架構(MAA)方面獲得了認證。他還在PostgreSQL、MySQL和MySQL Heatwave平台上獲得了認證。他還獲得了多雲架構師(OCI、AWS和GCP)的認證。

Ravi Kumar發表了100多篇Oracle技術文章,包括在Oracle Technology Network(OTN)、ORAWORLD雜誌、UKOUG、OTech雜誌和Redgate上。他在美國的Oracle Cloud/Open World(OOW)上演講了四次。在過去十年中,他在Oracle用戶組:IOUG、OCW、NYOUG、AUSOUG、AIOUG、UTOUG、SOUG、DOUG和Quest Oracle Community上進行了技術演講。

Ravi Kumar設計了數據中心並實施了世界上兩個主要中央銀行的核心銀行解決方案的重要數據庫。他還獲得了在LinkedIn上被稱為“頂級數據架構聲音”的榮譽。Oracle Corporation在其OCM名單和成功案例中發布了他的個人資料。

Naresh Kumar Miryala是一位經驗豐富的工程領導者,擁有20年的行業經驗,並在雲端、平台工程和人工智能方面具有深厚的背景。他在Meta Platforms, Inc.的現任職位上領導高效能的雲端數據平台團隊。他在雲端轉型、基礎架構實施、數據庫管理、ERP解決方案和DevOps部署方面具有豐富的實踐經驗。他的專業知識涵蓋多個領域,如數據庫系統、大規模後端基礎架構、安全性、多雲部署、雲基礎架構、DevOps和人工智能。

Naresh曾在Oracle Corp和Computer Sciences Corporations等知名組織工作,他在全球范圍內為財富500強公司遷移或實施Oracle技術發揮了關鍵作用。他的影響涵蓋了制藥、零售、銀行和黃金開采等各個行業。

Naresh在雲端遷移方面的經驗,特別是涉及關聯、開源和NoSQL數據庫、中間件和應用程序,使他對現代世界中多方面的技術和業務挑戰有了全面的理解,並開發出了解決行業大規模數據轉換和安全問題的創新解決方案,利用人工智能技術。