SQL Server 2019 AlwaysOn - Peter A. Carter

SQL Server 2019 AlwaysOn

Supporting 24x7 Applications with Continuous Uptime

(Autor)

Buch | Softcover
267 Seiten
2020 | 3rd ed.
Apress (Verlag)
978-1-4842-6478-2 (ISBN)
64,19 inkl. MwSt
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.

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.

1. High Availability and Disaster Recovery Concepts .- 2. Understanding High Availability and Disaster Recovery Technologies.- 3. Implementing A Cluster.- 4. Implementing an AlwaysOn Failover Clustered Instance.- 5. Implementing AlwaysOn Availability Groups on Windows.- 6. Implementing AlwaysOn Availability Groups on Linux.- 7. Atypical Availability Group Implementations.- 8. Administering AlwaysOn.- 9. Monitoring AlwaysOn Availability Groups.- 10. Troubleshooting AlwaysOn.

Erscheinungsdatum
Zusatzinfo 116 Illustrations, black and white; XV, 267 p. 116 illus.
Verlagsort Berkley
Sprache englisch
Maße 178 x 254 mm
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Software Entwicklung
Schlagworte 24x7 • Always On • AlwaysOn • Availability Groups • Disaster Recovery • Distributed Availability Groups • Failover • Failover Cluster • high-availability • Linux • Log Shipping • MIRRORING • Recovery Point Objectives • Recovery Time Objectives • SQL Server • Standby • Standby Server • Windows Cluster
ISBN-10 1-4842-6478-9 / 1484264789
ISBN-13 978-1-4842-6478-2 / 9781484264782
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90