A Cantrill - RDS Flashcards
What type of database model is DynamoDB?
DDB is a Wide Column model of database.
What type of database model is Redshift?
Column database
What are characteristics of ACID dbs in AWS exam terms?
Atomic Consistent Isolated Durable.
RDS typically. Structured. Not great at scaling
What are characteristics of BASE dbs in AWS exam terms?
BasicallyAvailable SoftState Eventually Consistent
DynamoDB. Highly scalable, NoSQL
Running DBs on an EC2 is considered a bad practice, t or f?
Running DBs on EC2 is NOT best practice. Lots of overhead.
Use case: DB vendor specific requirements. OR need more control of DB at OS level
Can one RDS instance have multiple databases on it?
Yes, multiple dbs can run on one RDS Instance.
Are snapshots automatically deleted by AWS?
Are automated backups automatically deleted by AWS?
-No, Snapshots are not automatically deleted. Must be manually deleted.
-Yes, Automated backups are deleted according to the retention period.
What happens when you restore from a snapshot in RDS?
A new RDS instance is created when you restore from a snapshot. You will need to update with the new instance name in your database
In RDS, what HA setup is used for both Synchronous and Asynchronous replications?
In RDS the following are the setups for each type of replication:
Synchronous replication = multi AZ
Asynchronous replication = Read replicas
If you are running a single instance RDS, how do you add a standby instance to this setup?
-Select your RDS database
-Modify
-Select create a standby database instance
RDS then creates the instance and DB in another AZ. Data is synchronously replicated from the primary to the new standby.
What happens when a primary RDS instance fails in a primary/standby scenario?
Upon failure, the CNAME of the db will change to point at the standby db instance. Standby then becomes the primary.
What are some use cases for Aurora Serverless?
Infrequently used applications, New Applications, Variable or unpredictable workloads, Test and DEV databases.
What is RDS Proxy?
A fully managed, DB proxy for RDS that handles connections between application and DB. Helps with connection load stress directly on the DB.
Auto scaled and HA. Provides connection pooling. Only accessible from VPC.
When should you use RDS proxy?
-When your DB is getting too many connection errors
-When using Lambda functions to your DB
-RDS can be used to reduce failover time for the DB
What is Database Migration Service (DMS) ?
The Database Migration Service (DMS) is a managed service which allows for 0 data loss, low or 0 downtime migrations between 2 database endpoints.
What are the 2 ways to use SSL to connect to your SQL Server DB instance in AWS?
-Force SSL for all connections
-Encrypt specific connections
What AWS feature can be used to authenticate to your DB with an auth token and not a password?
What DB engines is it compatible with?
IAM DB Authentication works with MySQL and PostgreSQL to allow DB authentication using an auth token
In order to encrypt traffic from APP to DB using specific connections, what must be done in the environment?
To use SSL from a specific client, you must obtain certificates for the client computer, import certificates on the client computer, and then encrypt the connections from the client computer.
-Example: Download the Root CA certificate, import the cert to your server and configure the application to use SSL to encrypt connects to your DB (RDS)
If you have a single Aurora instance (no Aurora replica), what happens during failover for the single instance ?
Aurora will attempt to create a new DB Instance in the same Availability Zone as the original instance and is done on a best-effort basis.