通过实时分析转换应用程序.pdf

1、 2024 Altinity,Inc.Elevate Your DataReal-Time Analytics on Kubernetes with ClickHouseRobert HodgesData Summit Boston-May 9th,20241 2024 Altinity,Inc.2024 Altinity,Inc.Lets make some introductionsClickHouse support and services including Altinity.Cloud Authors of Altinity Kubernetes Operator for Clic

2、kHouse and other open source projectsRobert HodgesDatabase geek with 30+years on DBMS systems.Day job:Altinity CEOAltinity EngineeringDatabase geeks with centuries of experience in DBMS and applications2 2024 Altinity,Inc.Understands SQLRuns on bare metal to cloudShared nothing architectureStores da

3、ta in columnsParallel and vectorized executionScales to many petabytesIs Open source(Apache 2.0)ClickHouse is a real-time analytic databaseIts a popular engine for real-time analyticsClickHouseEvent StreamsELTObject StorageInteractive GraphicsDashboardsAPIs3 2024 Altinity,Inc.What can we do with a d

4、atabase like ClickHouse?Enable Fast,Cost-Efficent End User Access to Trillion-Row Datasets4Consistent,sub-second response that scales linearly with resourcesDeliver query results at costs that are low and predictableMarket TICK data,DNS queries,weblogs,network flow logs,service logs,CDN telemetry,re

5、al-time ad bids,2024 Altinity,Inc.Why not just use PostgreSQL?5ClickHouseRead only selected columnsRows minimally or not compressedColumns highly compressedPostgreSQL,MySQLRead all columns in row 2024 Altinity,Inc.ClickHouse is often 1000 x faster on analytic queries659 GB(100%)21 MB(.035%)2.6 MB(.0

6、044%)1.7 GB(3%)Read 109 columns Read 3 columns from 109Read 3 compressed columnsRead 3 compressed columns over 8 threads 2024 Altinity,Inc.2024 Altinity,Inc.Kubernetes,Operators,and ClickHouse7 2024 Altinity,Inc.VMKubernetes manages container-based applications8ClickHouseContainerBlock Storage 2024