Ways to handle a stopped queue consumer?
In a scenario where a consumer application reads data from a queue and inserts into some database, you could run into an issue where the database becomes available and so the queue starts filling up. If the outage lasts even a few hours and your data rate is high enough you could run into a spool problem pretty quickly.
Has anyone developed any creative solutions for such as scenario to prevent data loss, assuming you don't want to impact publishers? Maybe spinning up an on-demand consumer that dumps the data somewhere with more storage (e.g. SQS)? It'd be nice to have a strategy like this in place in case of an emergency.