Module 5: Storage and Databases (Part 2) Flashcards
What is Amazon Relational Database Service (Amazon RDS)?
Amazon Relational Database Service (Amazon RDS) is a managed service provided by AWS that allows you to run relational databases in the AWS Cloud. It automates tasks such as hardware provisioning, database setup, patching, and backups, freeing you from administrative tasks and allowing you to focus on using your data for application innovation. Amazon RDS supports multiple database engines and provides various security options, including encryption at rest and in transit.
What are the supported database engines in Amazon RDS?
Amazon RDS supports the following database engines:
Amazon Aurora (compatible with MySQL and PostgreSQL)
PostgreSQL
MySQL
MariaDB
Oracle Database
Microsoft SQL Server
What are the benefits of using Amazon Aurora?
Amazon Aurora is an enterprise-class relational database engine compatible with MySQL and PostgreSQL. Its benefits include:
Performance: Amazon Aurora is up to five times faster than standard MySQL databases and up to three times faster than standard PostgreSQL databases, reducing unnecessary input/output (I/O) operations.
High Availability: Amazon Aurora replicates data across multiple Availability Zones and continuously backs up data to Amazon S3, providing high availability and durability.
Cost Optimization: By reducing I/O operations and improving resource reliability, Amazon Aurora helps to reduce database costs.
Compatibility: Amazon Aurora is compatible with existing MySQL and PostgreSQL applications, making it easy to migrate to and integrate with.
Scalability: Amazon Aurora can scale resources automatically to handle increasing workloads, providing scalability and performance as your database needs grow.
What is a nonrelational database?
A nonrelational database, also known as a NoSQL database, is a type of database that uses structures other than rows and columns to organize data. In nonrelational databases, data is typically organized into key-value pairs or other flexible data models, and attributes can vary between items in a table.
What is Amazon DynamoDB?
Amazon DynamoDB is a key-value database service provided by AWS. It offers single-digit millisecond performance at any scale, making it a high-performance choice for applications that require fast and scalable data storage. DynamoDB is serverless, meaning that AWS manages the underlying infrastructure, and it automatically scales to handle changes in capacity while maintaining consistent performance.
What are the benefits of using Amazon DynamoDB?
The benefits of using Amazon DynamoDB include:
Serverless: DynamoDB eliminates the need to provision, patch, or manage servers, as well as install and operate software.
Automatic Scaling: DynamoDB automatically scales to accommodate changes in the size and traffic of your database, ensuring consistent performance.
High Performance: DynamoDB provides single-digit millisecond response times, making it suitable for applications with demanding performance requirements.
Flexible Data Model: DynamoDB supports flexible schemas, allowing attributes to vary between items in a table and enabling easy addition or removal of attributes.
Built-in Security: DynamoDB integrates with AWS Identity and Access Management (IAM) for access control and supports encryption at rest and in transit for enhanced data security.
What is AWS Database Migration Service (AWS DMS)?
AWS Database Migration Service (AWS DMS) is a service provided by AWS that allows you to migrate data between different types of databases, including relational databases, nonrelational databases, and other data stores. AWS DMS facilitates the movement of data from a source database to a target database, which can be of the same type or different types.
How does AWS DMS reduce downtime during database migration?
AWS DMS enables database migration with minimal downtime by keeping the source database operational during the migration process. This means that applications relying on the source database can continue to access and use the database while the data is being migrated to the target database.
What are some use cases for AWS DMS?
Some use cases for AWS Database Migration Service (AWS DMS) include:
Development and test database migrations: AWS DMS allows developers to test applications against production data without impacting production users by migrating a copy of the database to a separate environment.
Database consolidation: AWS DMS enables the consolidation of multiple databases into a single database, simplifying management and reducing costs.
Continuous replication: AWS DMS supports continuous replication, allowing ongoing copies of data to be sent to other target sources in real time, rather than performing a one-time migration. This is useful for scenarios such as data backup or data distribution across multiple databases.
