Nava が Elasticsearch から ClickHouse への移行を支援し、ELO のインフラコストを 87% 削減した方法

Nava, a company founded in Brazil in 1995 to assist large organizations with data center infrastructure management, developed a real-time payment monitoring platform using ClickHouse for ELO, one of Brazil's largest card networks, processing 22 million transactions daily. This transition from Elasticsearch to ClickHouse reduced storage from 12 TB to 2 TB and infrastructure costs by 87%, from R$900,000 to R$120,000 annually. The platform supports 300 real-time dashboards updating every five seconds, with end-to-end latency under two seconds. The move was driven by increasing transaction volumes and performance limitations of Elasticsearch, with ClickHouse offering significant improvements in query speed and cost efficiency. Lucas Souza, a data engineer and architect at Nava, championed the transition, leveraging ClickHouse's capabilities to enhance performance and scalability while making data querying more accessible with ANSI SQL support. This shift has allowed ELO to detect and resolve network issues swiftly, preventing potential transaction cost increases and reinforcing Nava's reputation in the financial services sector.