Architectual Trad-off Decisions

Question 1

Database trad0off options

Answer 1

Running database on EC2 instances vs Managed RDS database.

Question 2

Running databases on EC2 instances

Answer 2

• have to manage the underlying OS
• have to build for high availability
• • Have to apply your own back ups
• • Can use additional software to cluster My SQL
• • Requires more time to manage than RDS

Question 3

Managed RDS database

Answer 3

Provides:

• Fully managed database updates and does not require managing of the underlying OS.
• automatic point in time backups.
• Easily enable multiAZ failover, and when a failover occurs the DNS is switched from the primary instance to the standby instance.
• if multi Az is enabled then backups are taken against the stand-by to reduce I/O freezes and updates are applied to the standby then is switched to th eprimary.
• • easily create read replicas.