28. Disaster Recovery & Migrations

Question 1

Disaster Recovery Strategies

Answer 1

• Backup and Restore
• Pilot Light
• Warm Standby
• Hot Site / Multi Site Approach

Question 2

DMS - Database Migration Service

Answer 2

• Quickly and securely migrate databases to AWS, resilietn, self healing
• The source database remains available during the migration
• Support
  Homogeneous migrations: ex Oracle to Oracle
  Heterogeneous migration: ex Microsoft SQL Server to Auora
• Continous Data Replication using CDC
• You must create an EC2 instance to perform the replication tasks

Question 3

Database Migration Service - Sources

Answer 3

• On-Premises and EC2 Instances databases: Oracle, MS SQL Server, MySQL, MariaDB, PostgresSQL, MongoDB, SAP, DB2
• Azure: Azure SQL Database
• Amazon RDS: all including Aurora
• Amazon S3
• DocumentDB

Question 4

Database Migration Service - Targets

Answer 4

• On-Premises and EC2 instances databases: Oracle, MS SQL Server, MySQL, MariaDB, PostgreSQL, SAP
• Amazon RDS
• Redshift, DynamoDB, S3
• OpenSearch Service
• Kinesis Data Stream
• Apache Kafka
• DocumentDB & Amazon Neptune
• Redis & Babelfish

Question 5

AWS Conversion Tool

Answer 5

• Convert your Database’s Schema from one engine to another
• Example OLTP: (SQL Server or Oracle) to MySQL, PostgreSQL, Aurora
• Example OLA: (Teradata or Oracle) to Amazon Redshift
• Prefer compute-intensive instance to optimize data convertions.