Geocodio faced significant challenges in scaling their request logging system from millions to billions of requests due to issues with their deprecated MariaDB setup. They attempted to transition to ClickHouse, Kafka, and Vector but encountered major errors related to data insertion and system limits, prompting a reevaluation of their architecture. The article details their journey to optimize request tracking and overcome the limitations of their previous database solution.
request-logging ✓
clickhouse ✓
kafka ✓
vector ✓
+ database