Skip to content

Latest commit

 

History

History
59 lines (40 loc) · 4.72 KB

File metadata and controls

59 lines (40 loc) · 4.72 KB

1. What is Amazon RDS?

Amazon RDS is a managed relational database service that simplifies database setup, operation, and scaling. It supports various database engines like MySQL, PostgreSQL, Oracle, SQL Server, and Amazon Aurora.

2. How does Amazon RDS work?

Amazon RDS automates common database management tasks such as provisioning, patching, backup, recovery, and scaling. It allows you to focus on your application without managing the underlying infrastructure.

3. What are the key features of Amazon RDS?

Amazon RDS offers automated backups, automated software patching, high availability through Multi-AZ deployments, read replicas for scaling read operations, and the ability to create custom database snapshots.

4. What is Multi-AZ deployment in Amazon RDS?

Multi-AZ deployment is a feature that provides high availability by automatically maintaining a standby replica in a different Availability Zone (AZ). If the primary database fails, the standby replica is promoted.

5. How can you improve read performance in Amazon RDS?

You can improve read performance by creating read replicas. Read replicas replicate data from the primary database and can be used to distribute read traffic.

6. What is Amazon Aurora?

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database engine that provides high performance, availability, and durability. It's designed to be compatible with these engines while offering improved performance and features.

7. What is the purpose of the RDS option group?

An RDS option group is a collection of database engine-specific settings that can be applied to your DB instance. It allows you to configure features and settings that are not enabled by default.

8. How can you encrypt data in Amazon RDS?

You can encrypt data at rest and in transit in Amazon RDS. Data at rest can be encrypted using Amazon RDS encryption or Amazon Aurora encryption, while data in transit can be encrypted using SSL.

9. What is a DB parameter group in Amazon RDS?

A DB parameter group is a collection of database engine configuration values that can be applied to one or more DB instances. It allows you to customize database settings.

10. How can you monitor Amazon RDS instances?

Amazon RDS provides metrics and logs through Amazon CloudWatch. You can set up alarms based on these metrics to get notified of performance issues.

11. What is the difference between Amazon RDS and Amazon DynamoDB?

Amazon RDS is a managed relational database service, while Amazon DynamoDB is a managed NoSQL database service. RDS supports SQL databases like MySQL and PostgreSQL, while DynamoDB is designed for fast and flexible NoSQL data storage.

12. How can you take backups of Amazon RDS databases?

Amazon RDS provides automated backups. You can also create manual backups or snapshots using the AWS Management Console, AWS CLI, or APIs.

13. Can you change the DB instance type for an existing Amazon RDS instance?

Yes, you can modify the DB instance type for an existing Amazon RDS instance using the AWS Management Console, AWS CLI, or API.

14. What is the purpose of the RDS Read Replica?

An RDS Read Replica is a copy of a source DB instance that can be used to offload read traffic from the primary instance. It enhances read scalability and can be in a different region than the source.

15. How can you replicate data between Amazon RDS and on-premises databases?

You can use Amazon Database Migration Service (DMS) to replicate data between Amazon RDS and on-premises databases. DMS supports various migration scenarios.

16. What is the maximum storage capacity for an Amazon RDS instance?

The maximum storage capacity for an Amazon RDS instance depends on the database engine and instance type. It can range from a few gigabytes to several terabytes.

17. How can you restore an Amazon RDS instance from a snapshot?

You can restore an Amazon RDS instance from a snapshot using the AWS Management Console, AWS CLI, or APIs. The restored instance will have the data from the snapshot.

18. What is the significance of the RDS DB Subnet Group?

An RDS DB Subnet Group is used to specify the subnets where you want to place your DB instances in a VPC. It helps determine the network availability for your database.

19. How does Amazon RDS handle automatic backups?

Amazon RDS automatically performs backups according to the backup retention period you set. Backups are stored in Amazon S3 and can be used for restoration.

20. Can you run custom scripts or install custom software on Amazon RDS instances?

Amazon RDS is a managed service that abstracts the underlying infrastructure, so you can't directly access the operating system. However, you can use parameter groups and option groups to configure certain settings.