Module 08 of 10

High Availability & Replication

Lessons

About This Module

Servers fail, networks drop, and maintenance windows still need to happen. High availability & replication is how a DBA keeps a database reachable and its data safe in the face of all of that, so that a single failure does not turn into an outage.

You'll start with Always On Availability Groups in SQL Server: what they are, how they provide high availability and disaster recovery, and how to configure one step by step. From there the module moves to replication in other engines, with a MySQL source-replica setup and a comparison of physical and logical replication in PostgreSQL, so you can see how each system keeps copies of your data in sync.

With your databases resilient, you'll be ready for the next module, Monitoring & Automation, where you keep watch over them and automate the routine work.

Lessons

4 videos
01

Always On Availability Groups in SQL Server - A HA-DR Solution

An introduction to Always On Availability Groups, SQL Server's high availability and disaster recovery feature and the enterprise alternative to database mirroring.

02

SQL Server 2019 Always On Availability Group Configuration Step by Step

A hands-on demo of configuring an Always On Availability Group in SQL Server 2019 on Windows Server.

03

Create a MySQL Replica Database in 4 Short Steps

A short walkthrough of setting up source-replica replication in MySQL to scale a database.

04

Physical vs Logical Replication in PostgreSQL

An explanation of the key differences between physical and logical replication in PostgreSQL, and when each one fits.