Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Amazon Aurora PostgreSQL - A to Z
1. Introduction
Your instructor (1:16)
Course layout & Tips (5:06)
2. PostgreSQL Fundamentals
Section Objectives (1:09)
Part-1 : Storage, Processes & Query processing (6:52)
Part-2 : WAL, Checkpointing, Archiver & Background processes (7:49)
Part-3 : High availability, Standby servers & Replication (9:19)
Part-4 : Scaling, Read vs Write scaling (7:01)
Part-5 : Tools, Config, Logs & Catalog (6:37)
3. Amazon RDS & Aurora
Section Objectives (1:26)
AWS PostgreSQL options (6:12)
RDS Vs Aurora PostgreSQL (8:59)
Aurora specific features (10:10)
Aurora - PostgreSQL version & releases (3:50)
Deciding between RDS & Aurora PostgreSQL (4:20)
4. Setup an Aurora DB Cluster
Section Objectives (3:52)
Development environment & project repository (6:06)
Hands on : Test VPC Setup (4:57)
Hands on : Aurora DB Cluster Setup (10:31)
Hands on : Bastion Host Setup (11:29)
Hands on : Windows Bastion Host Setup (8:01)
CLI / Utility Scripts (11:46)
Hands on : Test Setup Cleanup (3:38)
5. Amazon RDS Aurora Architecture
Section Objectives (1:09)
Aurora Storage Architecture (6:56)
Database Instance Classes & I/O performance (11:10)
Database Instance Right Sizing (7:22)
Primary instance, Replicas & Endpoints (8:41)
Hand on : Read Replica (5:16)
Aurora Reads & Writes (9:03)
AZ +1 Fault Tolerance Model (5:55)
Aurora Standby Replication (5:34)
Hands on : Replication Lag (5:34)
6. Aurora Metrics, Logging & Events
Section Objectives (4:50)
Baseline, KPI & Metric Monitoring (8:15)
Introduction to Pgbench tool (10:24)
RDS CloudWatch Metrics & Dimensions (7:56)
RDS Aurora Metrics (9:25)
Hands on : Aurora CloudWatch Metrics (9:13)
RDS Enhanced Metrics (6:48)
Hands on : Enhanced Metrics (10:55)
RDS Database Logs (6:05)
PostgreSQL Log files & configuration (8:07)
Hands on : Checkout PostgreSQL Logs (5:41)
RDS Events (8:40)
Hands on : RDS Event retention to CloudWatch (6:07)
7. Aurora Scaling & High Availability
Section objectives (0:30)
Aurora Storage Scaling (3:40)
Aurora Compute Scaling (6:41)
Hands on : Vertical Scaling (6:30)
Hands on : Auto Scaling (7:34)
Aurora Failover (8:48)
Hands on : Aurora failover (5:56)
Aurora Cluster Cache Management (7:10)
8. Cluster Configuration Management & Extensions
Section Objectives (2:34)
Parameter Groups (13:59)
Hands on : Parameter Groups (7:36)
RDS Option Groups & Extensions (5:01)
PostgreSQL Extensions (8:10)
Aurora Supported Extensions (7:31)
Hands on : Address standardizer extension (2:58)
Hands on : Using the S3 extension (9:59)
9. Query Performance Analysis
Section objectives (3:35)
PostgreSQL Stats Subsystem (10:38)
PostgreSQL Stats Functions (4:56)
Hands on : Stats views and functions (7:52)
PostgreSQL Wait events and Locks (12:36)
Hands on : Wait & Lock events (8:04)
pg_stat_statements extension (10:15)
Hands on : pg_stat_statements extension (6:55)
10. PostgreSQL commands - Vacuum, Analyze, Explain
Section objectives (2:36)
PostgreSQL Query Processing, Plan, Paths, Optimizer (12:02)
Explain command (10:42)
Hands on : Explain command (9:13)
PostgreSQL Analyze command (3:59)
Multi Version Concurrency Control (MVCC) (10:09)
Vacuuming - Addressing table bloat (11:02)
Vacuum - Addressing the wraparound (7:53)
Vacuum command (9:18)
Hands on : vacuum command (4:17)
Auto vacuuming (9:56)
11. Query performance tuning for waits
Section objectives (3:48)
Performance Insights Overview (9:17)
Performance Insights Counters (6:13)
DB Load & Active Sessions (11:45)
Hands on : Performance Insights dashboard (12:58)
IO Wait Events (10:50)
Buffer Cache Tuning (5:49)
Hand on - Performance Insights (9:43)
Aurora IO XactSync Event (4:47)
Hands on : IO XactSync Event (6:49)
IO Events : DataFileRead, BufFileRead, BufFileWrite (6:47)
Hands on : BufFileRead & BufFileWrite IO Events (6:23)
Lightweight Lock Waits (5:03)
Heavyweight Lock Waits (6:20)
Hands on : Lock transactionid (2:15)
Client & Timeout wait events (7:52)
Hands on : Timeout wait event (1:30)
12. RDS Aurora Security
Section objectives (2:48)
Data Encryption Support (4:50)
Hands on : Force TLS/SSL connection (9:26)
Database Network Security (8:20)
RDS Aurora Access & Authorization Control (4:36)
Password Authentication (9:40)
Hands on : Password Authentication (4:45)
Aurora IAM Authentication (8:21)
Hands on : IAM Authentication (11:41)
Introduction to Kerberos and AWS Managed AD (9:38)
Hands on : Setup AWS Managed AD (6:39)
RDS Aurora Kerberos Authentication (5:32)
Hands on : Setup Aurora PostgreSQL for Kerberos (12:06)
PostgreSQL Pgaudit Extension (6:41)
Hands on : pgAudit extension (5:29)
13. Aurora Global Database
Section Objectives (3:40)
Aurora Global Database (9:10)
Hands on : Setup Aurora global DB cluster (11:39)
Managing the Aurora global DB (6:02)
Hands on : Planned global DB failover (3:05)
Aurora global DB monitoring (7:38)
Disaster Recovery (DR) & Managed RPO (6:31)
DR & Aurora Endpoint management (6:21)
Hands on : Endpoint management (4:28)
Hands on : Aurora global DB cleanup (5:34)
14. Aurora Backup & Recovery
Section Objectives (4:30)
PostgreSQL backup and restore (4:30)
Hands on : PostgreSQL pg_dump (4:44)
Hands on : PostgreSQL pg_restore (3:46)
Aurora Automatic & Manual backups (6:52)
Hands on : Restoring from a snapshot (6:40)
Hands on : Point in time recovery (PITR) (5:17)
Backup Encryption, Copying and Sharing (9:24)
Hands on : Snapshot export to S3 (9:15)
Backup Costs and Monitoring (9:29)
AWS Backup Service (9:53)
15. Aurora Cloning
Section objectives (1:15)
Aurora Cloning & Copy on write protocol (3:30)
Hands on : Create an Aurora Clone (4:40)
Cross account cloning (4:07)
16. Aurora Serverless v2
Section Objectives (3:25)
Aurora Serverless V2 DB Instance (9:36)
Hands On : Build a Aurora cluster with Serverless v2 (4:12)
High availability considerations (7:11)
Serverless v2 DB instance capacity scaling (7:56)
Monitoring considerations (7:22)
17. Cluster Maintenance
RDS and PostgreSQL versioning (5:37)
Aurora PostgreSQL upgrade (5:02)
Minor version upgrade (2:34)
Major version upgrade (8:03)
Hands on - PostgreSQL native replication (11:46)
Aurora PostgreSQL releases & deprecation (4:35)
Your instructor
Complete and Continue