SQL Server AlwaysOn Revealed (eBook)
XIII, 150 Seiten
Apress (Verlag)
978-1-4842-1763-4 (ISBN)
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter's Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.
Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.
SQL Server AlwaysOn Revealed offers 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. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.- Teaches you to build HA and DR solutions using the AlwaysOn feature set
- Provides real-world advice on configuration and performance considerations
- Demonstrates administrative techniques for the AlwaysOn feature set
What You Will Learn
- Understand high availability and disaster recovery concepts and terminology.
- Understand the technologies available, to implement HA and DR.
- Build and configure a Windows Cluster.
- Build and configure an AlwaysOn failover clustered instance.
- Implement AlwaysOn Availability Groups and appropriately configure them.
- Administer AlwaysOn technologies post implementation.
Who This Book Is For
SQL Server AlwaysOn Revealed is for database administrators interested in growing their knowledge and skills in Microsoft SQL Server's high-availability and disaster recovery feature set.
Peter 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.
Get a fast start tousing AlwaysOn, the SQL Server solution to high-availability anddisaster recovery. Read this short, 150-page book that is adapted from PeterCarter's Pro SQL Server Administration to gain a solid and accurateunderstanding of how to implement systems requiring consistent and continuousuptime.Begin with anintroduction to high-availability and disaster recovery concepts such asRecovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availabilitylevels, and the cost of downtime. Then move into detailed coverage ofimplementing and configuring the AlwaysOn feature set in order to meet thebusiness objectives set by your organization.SQL Server AlwaysOn Revealed offers real-world advice on how to build andconfigure the most appropriate topology to meet the high-availability anddisaster recovery requirements you are faced with. Content includes strongcoverage on implementing clusters, on building AlwaysOn failover clusteredinstances, and on configuring AlwaysOn Availability Groups. This is a practicaland hand-on book to get you started quickly in using one of the most talked-aboutSQL Server feature sets. Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature setWhat You Will Learn Understand high availability and disaster recovery concepts and terminology. Understand the technologies available, to implement HA and DR. Build and configure a Windows Cluster. Build and configure an AlwaysOn failover clustered instance. Implement AlwaysOn Availability Groups and appropriately configure them. Administer AlwaysOn technologies post implementation.Who This Book Is ForSQL Server AlwaysOn Revealed is for database administrators interested ingrowing their knowledge and skills in Microsoft SQL Server's high-availabilityand disaster recovery feature set.
Peter 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.
Chapter 1: HA and DR ConceptsLearn the concepts and terminology behind high availability and disaster recovery.Level of AvailabilityRecovery Point Objective and Recovery Time ObjectiveCost of DowntimeClassification of Standby ServersChapter 2: Understanding HA and DR TechnologiesGain understanding of the various technologies that can be leveraged to obtain high availability and disaster recovery for their data-tier applications.AlwaysOn Failover ClusteringDatabase MirroringAlwaysOn Availability GroupsLog ShippingCombining TechnologiesChapter 3: Implementing a ClusterImplement and configure a Windows failover cluster using Windows Server 2012 R2. The cluster will form the base to support either an AlwaysOn Failover Clustered Instance or AlwaysOn Availability Groups.Building the ClusterConfiguring the ClusterChapter 4: Implementing an AlwaysOn Failover Clustered InstanceLearn the differences between building a stand-alone instance and building an AlwaysOn Failover Clustered Instance. Also learn to add a node to an existing AlwaysOn Failover Clustered Instance.Building the InstanceAdding a NodeChapter 5: Implementing AlwaysOn Availability GroupsImplement AlwaysOn Availability Groups for the purposes of both high availability and disaster recovery. Gain an insight into the impact synchronous Availability Groups can have on performance.Implementing High Availability with AlwaysOn Availability GroupsImplementing Disaster Recovery with AlwaysOn Availability GroupsAdding AlwaysOn Readable Secondary ReplicasChapter 6: Administering AlwaysOnPerform important administration tasks against AlwaysOn Availability Groups. Fail over to other nodes as needed, and monitoring ongoing operations. Also perform maintenance tasks against clusters, such as applying rolling patch upgrades and removing nodes.Managing a ClusterManaging AlwaysOn Availability Groups
| Erscheint lt. Verlag | 11.12.2015 |
|---|---|
| Zusatzinfo | XIII, 150 p. 100 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Wirtschaft ► Betriebswirtschaft / Management ► Wirtschaftsinformatik | |
| Schlagworte | 24x7 • AlwaysOn • Availability Groups • Disaster Recovery • Failover • Failover Cluster • high-availability • Log Shipping • MIRRORING • Recovery Point Objectives • Recovery Time Objectives • SQL Server • Standby • Standby Server • Windows Cluster |
| ISBN-10 | 1-4842-1763-2 / 1484217632 |
| ISBN-13 | 978-1-4842-1763-4 / 9781484217634 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 6,4 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Zusätzliches Feature: Online Lesen
Dieses eBook können Sie zusätzlich zum Download auch online im Webbrowser lesen.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
