SQL Server 2019 Alwayson: Supporting 24x7 Applications with Continuous Uptime
暫譯: SQL Server 2019 AlwaysOn：支援 24x7 應用程式的持續運行時間
Carter, Peter A.
商品描述
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running and reliable. This edition is updated to account for all new major functionality and also includes coverage of implementing atypical configurations, such as clusterless and domain-independent Availability Groups, distributed Availability Groups, and implementing Availability Groups on Azure.
The book begins with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTOs), availability levels, and the cost of downtime. You'll then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. Content includes coverage on implementing clusters, building AlwaysOn failover clustered instances, and configuring AlwaysOn Availability Groups.
SQL Server 2019 AlwaysOn is chock full of real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with, as well as how to use AlwaysOn Availability Groups to scale-out read-only workloads. This is a practical and hands-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.
What You Will Learn
- Understand high availability and disaster recovery in SQL Server 2019
- Build and configure a Windows Cluster in Windows Server 2019
- Create and configure an AlwaysOn failover clustered instance
- Implement AlwaysOn Availability Groups and appropriately configure them
- Implement AlwaysOn Availability Groups on Linux servers
- Configure Availability Groups on Azure IaaS
- Administer AlwaysOn technologies post implementation
- Understand typical configurations, such as clusterless and distributed Availability Groups
Who This Book Is For
For Microsoft SQL Server database administrators who interested in growing their knowledge and skills in SQL Server's high-availability and disaster recovery feature set.
商品描述(中文翻譯)
快速開始使用 AlwaysOn，這是 SQL Server 的高可用性和災難恢復解決方案。本書的第三版已更新，以涵蓋 2019 版的 SQL Server 和 Windows Server，並強調在 Windows 和 Linux 操作系統上實施 AlwaysOn 可用性群組的內容。本書提供了對於如何實施需要持續和穩定運行的系統的堅實且準確的理解，以及如何排除這些系統的故障以保持其運行和可靠性。本版已更新以考慮所有新的主要功能，並包括實施非典型配置的內容，例如無叢集和域獨立的可用性群組、分佈式可用性群組，以及在 Azure 上實施可用性群組。
本書首先介紹高可用性和災難恢復的概念，例如恢復點目標 (RPO)、恢復時間目標 (RTO)、可用性級別和停機成本。接著，您將深入了解如何實施和配置 AlwaysOn 功能集，以滿足您組織設定的業務目標。內容包括實施叢集、建立 AlwaysOn 故障轉移叢集實例以及配置 AlwaysOn 可用性群組的相關內容。
SQL Server 2019 AlwaysOn 充滿了如何構建和配置最合適拓撲以滿足您面臨的高可用性和災難恢復需求的實用建議，以及如何使用 AlwaysOn 可用性群組來擴展只讀工作負載。本書是一本實用且動手操作的指南，幫助您快速開始使用最受關注的 SQL Server 功能集之一。
您將學到什麼
- 了解 SQL Server 2019 中的高可用性和災難恢復
- 在 Windows Server 2019 中構建和配置 Windows 叢集
- 創建和配置 AlwaysOn 故障轉移叢集實例
- 實施 AlwaysOn 可用性群組並適當配置它們
- 在 Linux 伺服器上實施 AlwaysOn 可用性群組
- 在 Azure IaaS 上配置可用性群組
- 實施後管理 AlwaysOn 技術
- 了解典型配置，例如無叢集和分佈式可用性群組
本書適合誰
適合對於擴展其在 SQL Server 的高可用性和災難恢復功能集的知識和技能感興趣的 Microsoft SQL Server 數據庫管理員。
作者簡介
Peter A. Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.
作者簡介(中文翻譯)
彼得·A·卡特是一位 SQL Server 專家，擁有超過十年的 SQL Server 平台和數據層應用程式的開發、管理和架構經驗。彼得於 2011 年獲得微軟的 MCC 認證，並且擁有從 2005 版本起的多項 SQL Server 認證，包括 MCTS、MCITP、MCSA 和 MCSE。他對 SQL Server 的熱情體現在他所做的每一件事上，他的目標是希望他對這項技術的熱情能夠激勵他人。
