I have the scenario below and what I want to do is to build a retry mechanism to retrieve a status. So, what we have is a payment system and we want to call a 3rd party provided periodically in order to retrieve the payment status. More specifically, we want to do it exponentially, 1st time after 1s, 2nd time after 2s, 3rd time after 4s, etc.
I am thinking of a naive solution using SQL table in order to store every different action or using a message broker like Kafka as a Queue.
What do you think that is a good solution on that?