Настройка высокой доступности SQL Server 2016 (55246)

После прохождения этого курса студенты смогут:

• Понимать высокую доступность AlwaysOn
• Настраивать и использовать отказоустойчивого кластера Windows Server 2016
• Конфигурировать отказоустойчивый кластер MS SQL
• Выполнять обслуживание
• Мониторинг и устранение неполадок групп доступности

Целевая аудитория

Этот курс предназначен для опытных администраторов баз данных и профессионалов в Windows Server, руководителей ИТ.

Предварительные требования

Перед посещением этого курса студенты должны иметь опыт работы с SQL DBA и Windows Server 2012/2016. Будет полезным прослушивание курса Администрирование инфраструктуры баз данных SQL.

Программа курса

1. Введение

2. AlwaysOn и понятия высокой доступности

• Concepts and Terminology
• Table of Availability
• High Availability
• Causes of Downtime
• Planned downtime
• Unplanned downtime
• Disaster Recovery
• Recovery Time Objective (RTO)
• Recovery Point Objective (RPO)
• Recovery Level Objective (RLO)
• Storage Area Networks (SAN)
• Edition Changes from SQL 2012
• SQL Server 2014 Changes
• SQL Server 2016 Changes
• Legacy Solutions prior to Always On
• Failover Cluster Instances
• Log Shipping
• A Typical Log Shipping Configuration
• Monitor Server
• Replication
• Database Mirroring
• Database Mirroring Terminology
• Principle
• Mirror
• Witness (red box in image above)
• Database Snapshots
• Limitations of legacy solutions:
• What do we mean by Always On?
• Table of Always On Comparison

3. Отказоустойчивая кластеризация Windows Server 2016

• Understanding Failover Clustering in Server 2016
• Statefull High Availability Solution
• Supported in both Standard and Datacenter
• Servers should run similar hardware
• Should run same edition
• Hyper-V best with datacenter
• Certified for Windows server logo
• Shared Storage
• Quorums
• Node Majority
• Node and Disk Majority configuration:
• Node and File Share Majority
• No Majority
• Configuration
• Cluster Networks Best Practices
• Connection to nodes to shared storage
• Private network for internal cluster
• Public network for client connections
• Cluster Aware Updating
• Virtual Machine Failover Clustering
• Preferred Owners
• Failover Failback
• Resources
• Dependences
• Heartbeat

• Lab 1: Set up iSCSI Server
• Lab 2: Install the iSCSI VMS
• Lab 3: Add Servers to Server Manager for Ease of Management
• Lab 4: Add the Windows Cluster Feature to SQL1, SQL2 And SQL3
• Lab 5: Create the iSCSI Initators to add the shared storage
• Lab 6: Create the Windows Cluster
• Lab 7: Add a Clustered Service
• Lab 8: Test The Failover Of The Windows Service
• Lab 9: Delete Role
• Lab 10: Examine the Quorum Settings

4. Экземпляры отказоустойчивого кластера SQL 2016

• Failover Cluster Instance
• As A FCI Appears To A Client

• Lab 1: Create A Configuration File By Running The Advanced Cluster Preparation Wizard
• Lab 2: Complete The SQL Cluster Installation On SQL1
• Lab 3: Install The Cluster On SQL2 And SQL3
• Lab 4: Test the SQL Cluster

5. SQL 2016 AlwaysOn и группы доступности

• Availability Groups and Replicas
• Primary Replica
• Secondary Replicas
• Availability Group Listener
• Availability Mode
• Synchronous Commit Mode
• Asynchronous Commit Mode
• Failover Modes
• Automatic Failover Without Data Loss
• Automatic Failover Requirements:
• Manual
• Manual Failover Requirements
• Common Topologies

• Lab 1: Create a SQL Instance For The Availability Group
• Lab 2: Enable the SQL Server AlwaysOn Availability Group Feature
• Lab 3: Set Up For Availability Groups
• Lab 4: The Availability Group Wizard
• Lab 5: SSMS and Availability Groups

6. Панель инструментов

• The Dashboard
• How to view logs
• Using replication with Logins
• Using partially contained databases

• Lab 1: The Dashboard
• Lab 2: Replicating Logins and Jobs
• Lab 3: Contained or Partially Contained Databases

7. Активная вторичная группа доступности

• Reporting with Secondary Replicas
• Configuring a Readable secondary
• Read-Only Routing
• Load Balancing
• Lab: Configure a Read-Only Secondary
• Database Backups with Secondary
• Steps of Backup Using secondary
• Backup Preference Options

• Lab 1: Database Backup Using Secondary Replica
• Lab 2: Configure a Read-Only secondary

8. Техническое обслуживание

• DBCC Checks
• Database Adding and Removing

• Lab 1: Add a Database
• Lab 2: Remove a Database
• Lab 3: Add a Replica
• Lab 4: Remove a Replica

9. Мониторинг и устранение неполадок групп доступности

• The Dashboard in Depth
• Events
• Policy Based Managemnt for Availability Groups

• Lab 1: Dashboard Wizards
• Lab 2: Create an Extended Event Session
• Lab 3: Using T-SQL
• Lab 4: Policy based management for Availability Groups
• Lab 5: Observe a Policy In Action
• Lab 6: Create Three Conditions To Be Used In The RTO And RPO Policies
• Lab 7: Create Two Policies RTO and RPO
• Lab 8: Test The Policies
• Lab 9: Change Endpoint Owner

Документы об окончании курса

• Сертификат Учебного центра Softline
• Cертификат об обучении установленного образца