Babelfish for AWS Aurora PostgreSQL - Hands on Learning

Name: Babelfish for AWS Aurora PostgreSQL - Hands on Learning
Rating: 4.7 (21 reviews)

With comprehensive material on each topic and demos / labs for each section

Created byAmit Arora

Last updated 10/2023

English

What you'll learn

Students will learn about Babelfish - a new database offering in AWS.
Steps to migrate Microsoft SQL Server database to Babelfish for AWS Aurora PostgreSQL
Data migration in AWS Aurora PostgreSQL
Monitoring and working with Babelfish cluster

Course content

6 sections • 47 lectures • 2h 7m total length

Introduction1:01
Instructor-Introduction0:52

Section-Introduction0:48
Explore Babelfish in Aurora Postgres, its features, including single and multi DB, and build a Babelfish cluster in AWS console, connect via SSMs or SQL Server Management Studio.
Babelfish Introduction2:08
Discover how Babelfish enables migration from SQL Server to open source by using a PostgreSQL database that understands T-SQL, offering dual endpoints for SQL Server and PostgreSQL.
Babelfish Implementation2:49
Babelfish Features2:34
Singledb vs Multidb Option1:09
Hands on: Create Babelfish Cluster8:54
Connection to Babelfish Cluster1:09
Hands-on: Connect to Aurora Babelfish Cluster using SSMS4:02
Recap..2:19

Section Introduction0:58
Migration Architecture3:02
Configure a migration architecture that connects a SQL server on EC2 or on prem to a Babelfish cluster via the DMS replication instance, with security groups controlling access.
SQL Server on EC25:14
Migration Steps3:25
Compass Tool2:37
Download and install the compas tool for Babelfish, verify 64 bit Java JRE 8 or later, unzip the GitHub zip to the Babelfish binaries folder, and run Babelfish compass --help.
Hands-on: Downloading and Configuring Compass Tool4:53
Generate Compass Report -11:53
Generate Compass Report -22:42
Hands-on: Generate Compass Report6:10
Analyze Compass Report2:21
Hands-on: Analyze Compass Report6:27
Babelfish Database pre-migration steps3:27
Create tables in Babelfish4:54
Data Migration Options1:19
Data Migration using DMS2:55
Hands-on: AWS DMS - Create Replication Instance6:59
Hands-on: AWS DMS - Endpoints6:19
Hands-on: AWS DMS - Task and Migration5:28
Migration Next steps3:41
Recap..2:01

Section-Introduction0:28
CloudWatch Monitoring1:32
Enable CloudWatch monitoring by default for RDS, including Babelfish, to track metrics such as CPU utilization, DB connections, and IOPs from hypervisor, but it misses slow queries and OS-level metrics.
Enhanced Monitoring0:48
Performance Insights1:46
Performance Insights - Database Load1:44
Hands-on: Babelfish Monitoring2:42
Recap1:09
Explain Plan in Babelfish2:02

Section-Introduction0:29
Explore backup and restore methods for Aurora, including automated and manual backups, and use the AWS backup service to automate the process, then restore backup into a new Aurora cluster.
Automatic Backup1:00
Manual Snapshot1:22
AWS Backup Service1:04
Hands-on: Backup and restore4:06
Explore backup and restore workflows in Babelfish on Aurora, including automatic and manual snapshots. Discover point-in-time recovery and create a clone for testing without storage impact.
Recap..1:03

Requirements

Basic knowledge of databases in general.
Basics of AWS and familiarity of relational databases in AWS.

Description

In this course, we will learn about Babelfish for AWS Aurora PostgreSQL.

Babelfish is a migration accelerator, it helps to migrate commercial SQL Server database to Open source AWS Aurora PostgreSQL. It supports T-SQL on PostgreSQL database using an extension. This course will provide all the steps to migrate SQL Server to AWS Aurora PostgreSQL and also list various options to load data into Babelfish including SSIS, Bulk copy, native SQL scripts and AWS Database Migration Service (DMS). AWS DMS is the reccommended option to migrate data from Microsoft SQL Server to Babelfish for AWS Aurora PostgreSQL.

Below are some of the key topics covered in this course:

1. Understand what is Babelfish, architecture, implementation, tools

2. How to manage / monitor Babelfish cluster.

3. We will focus on analysis of Babelfish using Compass tool including how to download, configure and generate report.

4. A separate lecture on how to analyze compass report and generate workarounds.

5. Data migration into Babelfish cluster using AWS DMS Service.

6. Monitoring AWS Aurora Babelfish cluster.

7. Backup and recovery options

Overall goal of this course is to provide you with good idea and get started with Babelfish and how to migrate commercial database to open source. With this learning, you will be able to migrate to Babelfish easily, play around and learn more !!

Who this course is for:

This course is intended for all levels of IT professionals looking an option to migrate commercial database (SQL Server) to Open Source database engine.

Babelfish for AWS Aurora PostgreSQL - Hands on Learning

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

Babelfish Overview9 lectures • 26min

SQL Server to Babelfish Migration20 lectures • 1hr 17min

Monitoring AWS Aurora PostgreSQL Babelfish Cluster8 lectures • 12min

Babelfish : Backup and Restore6 lectures • 9min

Next Steps2 lectures • 1min

Requirements

Description

Who this course is for: