SQL Queries queues

Question

I have N+ users, for each user backend send queue of SQL FIFO queries (each may took some time to execute), but queues of different users must run concurrently.
How i can realize this? 
In single SQS i can't do this: FIFO option applies to full SQS, not separate queue.

Answer

You can do what you need using the message group ID when sending messages in a FIFO queue
https://docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/using-messagegroupid-property.html

If you attach lambda to consume SQS with concurrency greater than 1, lambda will consume the messages from SQS maintaining the order based on the message group ID with the lambda concurrency that you have specified.

Answer

I seek solution for pure serverless event driven srchitect

SQL Queries queues

相關內容