AWS Database Migration Service Flashcards Preview

Learn AWS > AWS Database Migration Service > Flashcards

Flashcards in AWS Database Migration Service Deck (17)
Loading flashcards...
1
Q

What is AWS Database Migration Service?

A

The DMS will help you migrate a database from DB-A to DB-B. This includes schema changes.

2
Q

What are the ways to migrate SQL databases to AWS, this includes using DMS?

A
  • Using SQL servers native backup and restore
  • SQL server replication
  • Using DMS to bulk load the data and replicate on-going changes
3
Q

Is DMS a fully managed service?

A

It is a managed service but a VM is deployed into a VPC, this is the VM that is used to perform the database migration?

4
Q

What sources are supported?

A
  • Mongo DB
  • DB load and capture form S3
  • Oracle
  • MS SQL Server
  • MySQL
  • MariaDB
  • Postgres
  • Db2 LUW
  • Azure SQL
  • RDS database instances
5
Q

What are the target database types?

A

-Mongo DB
- DynamoDB
- Elastic search
Kinesis data streams
- DB load and capture form S3
- Oracle
- MS SQL Server
- MySQL
- MariaDB
- Postgres
- Db2 LUW
- Azure SQL
- RDS database instances

6
Q

What is a replication instance used for in DMS?

A

It is an instance or instance + standby in Multi-AZ that is used to replicate the data from DB-A to DB-B.

7
Q

What must you consider when selecting the replication instance?

A

The size, you need to select a size that will be large enough to give you the performance you need.

8
Q

How will the replication instance connect to the databases from its VPC?

A

There are two different situations, the replication instance gets a private IP and also can have a public IP. The public IP can be used what your database can be accessed over the public internet. The private IP can be used when VPN, directconnect or database is in the vPC. You can also connect using VPC peering.

9
Q

How is security handled for the DMS service?

A

Data at rest is encrypted, this is the replication instance data, using the KMS. SSL is used for connections

10
Q

Where does cloud migration service send its logs?

A

To the CloudWatch logs service.

11
Q

What is a DMS task?

A

You specify what tables and schemas to use for your migration and any special processing, such as logging requirements, control table data, and error handling.

12
Q

How does the DS perform the migration?

A

DMS performs the following functions,

  • Copy or convert scheme to destination
  • Copy data to the destination
13
Q

What is AWS SCT?

A

AWS SCT is the AWS schema conversion tool

14
Q

What are the source and target endpoints?

A

These are the source and target endpoints for each of the databases DMS will connect to for migration.

15
Q

What type of tasks can you have in DMS?

A
  • Full load, this is where the entire database is copied in one shot.
  • Full load and replication, this is where the database is copied and then ongoing replication happens.
16
Q

What is CDC

A

Change data capture, it is when a SQL database changes data in the tables, this data is captured so it can be replicated.

17
Q

What is full load?

A

This is when we are first performing database replication, we have to prefrom an initial load of all the data and after the load, CDC is performed and the changes replicated.