How we solved request logging at scale by moving from MariaDB to ClickHouse, Kafka, and Vector after our deprecated database engine couldn't keep up with billions of monthly requests.This article is based on a talk that I gave at PHP[tek] in 2025. Scaling Request Logging from Millions to Billions with ClickHouse, Kafka, and Vector Why Track All These Requests? Geocodio offers a pay-as-you-go metered plan where users get 2,500 free geocoding lookups per day. This means we need to: Track the 2,500...