ClickHouse is an open source annual application database management system for online analysis (OLAP). ClickHouse supports primary key tables and allows the use of SQL real-time query to generate data analysis reports. CK supports multi-core and multi-node parallelized large queries.
As a container cluster management tool, Kubernetes considers the requirements of container cross-machine connection and supports a variety of network solutions. It has a good performance in automatic deployment, automatic restart, and automatic expansion and contraction.
Docker containers can not only realize the isolation of resources and processes, but also avoid the waste of resources such as CPU and memory for each task. Each machine is running unrelated containers, all containers share the host's cpu, disk, network, memory, etc.
The row storage system organizes data in rows (most relational database storage methods), and the data in a column in column storage is stored continuously. For analytical loads on wide tables, column storage can effectively reduce unnecessary I/O and improve data compression.