What are the 6 database types supported by AWS?
- Postgres
- Oracle
- MySQL
- MariaDB
- Microsoft SQL Server
- Aurora
How many Read Replicas can you have?
5
What is the consistency of the replication in Read Replicas?
It is ASYNC, so eventual consistency
How do instances leverage a Read replica?
The update the connection string to connect to the Read Replica
How do you enforce SSL in PostgreSQL or SQL Server?
On the AWS RDS Console in Parameter Groups, set rds.force_ssl=1
How do you enforce SSL in MySQL or MariaDB?
In the DB, set:
GRANT USAGE ON . TO ‘mysqluser’@’%’ REQUIRE SLL;
How many Read Replicas can Aurora have?
15
What are 5 possible scenarios that would cause a RDS Failover in a Multi AZ setup?
- The primary DB instance fails
- An Availability Zone Outage
- The DB instance server type is changed
- Software patch of OS instance hosting the RDS instance
- A manual Reboot with Failover was initiated
Does the RDS endpoint change of there is a failover?
No
What 4 things do you not have access to in RDS, as it is managed by AWS?
- No SSH access
- No manual DB patching
- No manual OS patching
- No way to monitor underlying architecture
What 7 Cloudwatch Metrics are collected by the RDS hypervisor?
- DatabaseConnections
- SwapUsage
- ReadIOPS / WriteIOPS
- ReadLatency / WriteLatency
- ReadThroughput / WriteThroughput
- DiskQueueDepth
- FreeStorageSpace
What is RDS?
It is an in-memory key-value store used for cache
What is Memcached?
It is an in-memory object store for cache
