In this blog, we will cover the Q&As from Day 4 of Migrate Apps & Database to Cloud (AWS Workshop) covering AWS Database Migration FAQs. This blog will help you to get started with AWS Database Migration.
In this session, We covered Module 4: AWS Database Migration which covers the following objectives.
[Q/A] Related to AWS Database Migration
Q1: What is AWS Database migration?
Ans: You can swiftly and securely move your databases and analytics workloads to AWS with the aid of the managed migration and replication solution known as AWS Database Migration Service (AWS DMS). Due to the source database’s continuing use, applications that depend on it suffer the least amount of downtime during the conversion.
Your data may be evaluated, converted, and moved to and from the most popular commercial and open-source databases using the AWS Database Migration Service. Both homogeneous migrations, such as Oracle to Oracle, and heterogeneous migrations between multiple databases, such as Oracle or Microsoft SQL Server to Amazon Aurora, are supported by the AWS Database Migration Service.
Q2: What are the stages involved in database migration?
Ans: Creating a target database, migrating the database schema, setting up the data replication process, starting the full load and a subsequent change data capture and apply, and concluding with switching over your production environment to the new database once the target database has caught up to the source database are all steps in a typical simple database migration.
Q3: What are the Challenges in AWS Database Migration?
Ans: Following are the challenges that occur during Database Migration:
- Identifying and prioritizing Database(DB) Migration
- Migration of large database in Tera Bytes(TBS) & Peta Bytes(PBS)
- Live Migration with Zero Data Loss
- Schema Migration
- Secured Database Migration
Q4: What are the types of AWS Database Migration services?
Ans: The 20+ database and analytics engines that AWS DMS supports for migration include Oracle to Amazon Redshift, MySQL to Amazon Relational Database Service (RDS), Microsoft SQL Server to Amazon Aurora PostgreSQL, MongoDB to Amazon DocumentDB, and Amazon Simple Storage Service (S3).
Q5: Which AWS services are supported by AWS database migration?
Ans:
Q6: What is AWS DynamoDB?
Ans: Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database designed to run high-performance applications at any scale. DynamoDB offers built-in security, continuous backups, automated multi-Region replication, in-memory caching, and data import and export tools.
Q7: What are the table classes in DynamoDB?
Ans: Two table classes are provided by DynamoDB to aid with cost optimization. The most common workloads should use the DynamoDB Standard table class, which is the default. The DynamoDB Standard-Seldom Access (DynamoDB Standard-IA) table class is designed for tables where storage is the primary cost and data is stored for infrequent access. Each table has a table class assigned to it, and each table class offers a separate pricing structure for read and write requests as well as data storage. Based on the storage needs and data access patterns of your table, you can choose the most affordable table class.
Q8: Why AWS CloudFormation service is used as IaaC?
Ans: AWS CloudFormation is a service that helps you model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications that run in AWS. You create a template that lists the AWS resources you need (such as Amazon EC2 instances or Amazon RDS DB instances), and CloudFormation takes care of the provisioning and configuration of those resources on your behalf.
Q9: What are the Stages of Database Migration?
Ans: The AWS DB Migration process can be divided into 3 stages
- Stage 1: Pre-Migration Stage
- Stage 2: Migration Stage
- Stage 3: Post Migration
Q10: What are the types of database migration?
Ans: Two types of database migration are:
- Homogenous: A homogeneous database migration is a migration between the source and target databases of the same database technology, for example, Changing from an Oracle database to an Oracle database, for instance, or from a MySQL database to a MySQL database.
- Heterogenous: heterogeneous migration: A migration from source databases to target databases where the source and target databases are of different database management systems from different providers.
Q11: What is the output of AWS Server Migration Service?
Ans: Each server volume replicated is saved as a new Amazon Machine Image (AMI), which can be launched as an EC2 instance (virtual machine) in the AWS cloud. Server Migration Service will launch the servers in a CloudFormation stack using an automatically created CloudFormation template if you are utilizing application groups.
Q12: What are AWS Relational Database Service (DMS) & its engines?
Ans: A relational database is a collection of data items with pre-defined relationships between them. These things are arranged in tables in the form of rows and columns. To store data about the things that will be represented in the database, tables are utilized.
It supports the following engines:
Q13: How do I integrate AWS Database Migration Service with other applications?
Ans: AWS Database Migration Service provides a provisioning API that allows creating a replication task directly from your development environment, or scripting their creation at scheduled times during the day. Developers and database administrators can automate replication task creation, restart, administration, and termination using the service API and CLI.
Q14: Can I keep track of a database migration task’s progress?
Ans: Yes. Several metrics for AWS Database Migration Service are visible in the AWS Management Console. It offers a complete picture of the data replication procedure, with performance and diagnostic information for each step in the replication pipeline.
Other AWS services like CloudTrail and CloudWatch Logs are integrated with the AWS Database Migration Service as well. You can also connect your current tools or create unique monitoring tools to meet your specific needs by using the AWS Database Migration Service API and AWS Command Line Interface (AWS CLI).
Q15: How do I update and query data items with DynamoDB?
Ans: After you have created a table using the DynamoDB console or CreateTable API, you can use the PutItem or BatchWriteItem APIs to insert items. The items you added to the table can then be retrieved using the GetItem, BatchGetItem, or, if composite primary keys are enabled and utilized in your table, the Query API.
Q16: How many databases or schemas can I run within a DB instance?
Ans: You can run schemas for these DB instances:
- RDS for Amazon Aurora: No limits by software
- RDS with MySQL: No software restrictions
- RDS for MariaDB: No software restrictions
- RDS with Oracle: One database per instance; no software restrictions on the number of schemas per database a maximum of 100 databases per instance of RDS for SQL Server
- RDS for PostgreSQL: No software restrictions
Q17: What are the Advantages of AWS RDS?
Ans:
Related Links/References:
- 5 Steps for a Cost-efficient Migration to AWS Cloud
- Top 10 Must-Have AWS Cloud Migration Tools in 2023
- AWS Database Migration Service: Everything You Need To Know
- Application Migration to AWS & Its 6 Phases
- AWS Server Migration Service
- AWS Database Migration Service
- AWS Training and Certification
- Top 100+ AWS Interview Questions for 2023
Next Task For You
Begin your journey towards an AWS Cloud by joining our FREE Informative Class on Amazon Cloud Free Class by clicking on the below image.
Leave a Reply