Simple Queue Service Quiz
A database hosted in AWS is currently encountering an extended number of write operations and is not able to handle the load. What can be done to the architecture to ensure that the write operations are not lost under any circumstance?
A. Add more IOPS to the existing EBS Volume used by the database.
B. Consider using DynamoDB instead of AWS RDS.
C. Use SQS Queues to queue the database writes.
D. Use SNS to send notification on missed database writes and then add them manuallyat a later stage.
C. Use SQS Queues to queue the database writes.
SQS Queues can be used to store the pending database writes, and these writes can then be added to the database. It is the perfect queuing system for such architecture.
Note that adding more IOPS may help the situation but will not totally eliminate chances of losing database writes.
For more information on AWS SQS, please refer to the URL below:
https://aws.amazon.com/sqs/faqs/Note:The scenario in the question is that the database is unable to handle the write operations and the requirement is that with out loosing any data we need to perform data writes on to the database.For this requirement, we can use an SQS queue to store the pending write requests, which will ensure the delivery of these messages.Increasing IOPS can handle the traffic bit more efficiently but it has a limit of .40,000 IOPS where as SQS queues can handle 120,000 messages inflight.
