Awesome ClickHouseOps

ContentSquare/chproxy

⭐ 1481 Go repository created 2017-09-18

Chproxy is an open-source HTTP proxy and load balancer specifically designed for the ClickHouse database. It acts as an intermediary between clients and ClickHouse servers, managing and distributing incoming HTTP requests efficiently to optimize performance and reliability. This project is community-driven and not officially affiliated with ClickHouse, but it provides valuable functionality for users who want to enhance their ClickHouse deployments. The proxy supports load balancing, which helps distribute query loads evenly across multiple ClickHouse instances, improving scalability and fault tolerance. Chproxy is designed to be lightweight and performant, making it suitable for production environments where high availability and responsiveness are critical. The project includes comprehensive documentation available on its official website, guiding users through installation, configuration, and usage. Additionally, the repository encourages community contributions, with a contributing guide provided to help developers participate in the project's development. The project is actively maintained, with metrics such as code quality and test coverage publicly available, reflecting a commitment to reliability and continuous improvement. Overall, chproxy serves as a practical tool for organizations leveraging ClickHouse, enabling them to manage HTTP traffic more effectively and ensure their database infrastructure can handle high query volumes with balanced load distribution and improved fault tolerance.

https://github.com/ContentSquare/chproxy

chproxyclickhouseclickhouse-proxycommunity-projectdatabasefault-tolerancehigh-availabilityhttp-proxyload-balanceropen-sourceperformanceproxyquery-distributionscalability

Also in Ops

Altinity/clickhouse-backup

Altinity/clickhouse-backup is a tool for easy backup and restore of ClickHouse databases using various cloud and local object storage systems.

PostHog/HouseWatch

HouseWatch is an open-source tool by PostHog for monitoring and managing ClickHouse clusters, providing detailed insights into query performance, cluster load, logs, and disk usage with operational controls.

duyet/clickhouse-monitoring

ClickHouse Monitoring Dashboard is a Next.js-based UI tool that leverages system tables to provide comprehensive monitoring and visualization of ClickHouse clusters, including query, cluster, and table metrics.