What are people’s preferred data storage for keeping track of requests for a user/org? Especially for horizontal scaling of services severing the API?

Redis/valkey? Postgres? DynamoDB?