Deck 2 Flashcards
Difference between physical RDS replication and logical
Logical is software based and physical is block based
RDS types that use physical replication
MySQL, Oracle, & Postgres
RDS instance type that use logical replication
MSSQL (server native mirroring)
What mechanism provides the failover for RDS HA?
DNS, your clients always use an endpoint
How can you force failover on an RDS instance?
Reboot the instance
How can you reboot a RDS instance?
webUI or the RebootDBInstance
How many read replicas can you have of Postgres and MySQL?
5
What will happen if you create a read replica of a DB that does not have multi-AZ enabled?
Brief IO pause during the snapshot
What RDS database can have read replica of read replicas?
MySQL
Can you take snapshots or backup from RDS read replicas?
No
What Cloudwatch metric indicates the amount of time in seconds that the read replica is behind the source database
ReplicaLag. Bad lag can also indicate performance issues.
What might you have to do if you are unable to create read replicas RDS?
Edit and enable backups
What are the two ways you can monitor RDS
Metrics and Events
Which RDS Metric indicates the number of outstanding I/O requests (read and write) waiting to access the disk.
diskQueueDepth
Which RDS Metric indicates the number of database connections in use.
DatabaseConnections