I’m building a url shortener that shorten the url and redirect the shortened url to the original one and also calculating metrics for each shortened url I came up with the idea of using kafka for the requests that come for the url and extract aggregates from requests metadata that is produced as message to kafka topic and then store/update the aggregates in the database (mysql).