MySQLãPostgresãMS SQL Server ãªã©ã®éåžžã®ãæååãDBMS ã§ã¯ãããŒã¿ã¯æ¬¡ã®é åºã§ä¿åãããŸãã
ãã®å ŽåãXNUMX ã€ã®è¡ã«é¢é£ããå€ãç©ççã«è¿ãã«æ ŒçŽãããŸãã åæå DBMS ã§ã¯ãç°ãªãåã®å€ã¯åå¥ã«ä¿åãããXNUMX ã€ã®åã®ããŒã¿ã¯äžç·ã«ä¿åãããŸãã
åå DBMS ã®äŸãšããŠã¯ãVerticaãParaccel (Actian MatrixãAmazon Redshift)ãSybase IQãExasolãInfobrightãInfiniDBãMonetDB (VectorWiseãActian Vector)ãLucidDBãSAP HANAãGoogle DremelãGoogle PowerDrillãDruidãkdb+ ããããŸãã
éµäŸ¿è»¢éäŒç€Ÿ
ç·©å
Clickhouse ã¯ã³ãã³ã XNUMX ã€ã§ Ubuntu ã«ã€ã³ã¹ããŒã«ãããŸãã SQL ã®ç¥èãããå Žåã¯ãããŒãºã«åãããŠããã« Clickhouse ã䜿ãå§ããããšãã§ããŸãã ãã ããããã¯ãMySQL ã§ãshow create tableããå®è¡ããClickhouse 㧠SQL ãã³ããŒïŒããŒã¹ãã§ãããšããæå³ã§ã¯ãããŸããã
MySQL ãšæ¯èŒãããšãããŒãã« ã¹ããŒãå®çŸ©ã«éèŠãªããŒã¿åã®éãããããããããŒãã« ã¹ããŒãå®çŸ©ãå€æŽããããŒãã« ãšã³ãžã³ã«æ £ãããŸã§ã«ã¯ãŸã æéããããã§ãããã
Clickhouse ã¯è¿œå ã®ãœãããŠã§ã¢ãªãã§ããŸãåäœããŸãããã¬ããªã±ãŒã·ã§ã³ã䜿çšãããå Žåã¯ãZooKeeper ãã€ã³ã¹ããŒã«ããå¿ èŠããããŸãã ã¯ãšãª ããã©ãŒãã³ã¹åæã§ã¯åªããçµæã瀺ãããŠããŸããã·ã¹ãã ããŒãã«ã«ã¯ãã¹ãŠã®æ å ±ãå«ãŸããŠããããã¹ãŠã®ããŒã¿ã¯å€ããŠéå±ãª SQL ã䜿çšããŠååŸã§ããŸãã
ÐÑПОзвПЎОÑелÑМПÑÑÑ
åºæº ãµãŒããŒæ§æã«ããã Clickhouse ãš Vertica ããã³ MySQL ã®æ¯èŒ: 5 ãœã±ãã Intel® Xeon® CPU E2650-2 v2.60 @ 128GHzã 5 GiB RAM; 8 6TB SATA HDD äžã® md RAID-4ãextXNUMXãåºæº Clickhouse ãš Amazon RedShift ã¯ã©ãŠã ã¹ãã¬ãŒãžã®æ¯èŒã- ããã°ã®æç²
Cloudflare ã«ããã¯ãªãã¯ããŠã¹ã®ããã©ãŒãã³ã¹ :
ClickHouse ããŒã¿ããŒã¹ã®èšèšã¯éåžžã«ã·ã³ãã«ã§ããã¯ã©ã¹ã¿ãŒå
ã®ãã¹ãŠã®ããŒãã¯åãæ©èœãæã¡ã調æŽã«ã¯ ZooKeeper ã®ã¿ã䜿çšããŸãã ç§ãã¡ã¯è€æ°ã®ããŒããããªãå°èŠæš¡ãªã¯ã©ã¹ã¿ãŒãæ§ç¯ãããã¹ããå®è¡ããŸããããã®éãã·ã¹ãã ãéåžžã«åªããããã©ãŒãã³ã¹ãåããŠããããšãããããŸãããããã¯ãåæ DBMS ãã³ãããŒã¯ã§è¿°ã¹ãããŠããå©ç¹ã«çžåœããŸãã ç§ãã¡ã¯ãClickHouse ã®èåŸã«ããã³ã³ã»ããã詳ããèŠãŠã¿ãããšã«ããŸããã ç 究ã®æåã®é害ã¯ãããŒã«ã®æ¬ åŠãš ClickHouse ã³ãã¥ããã£ã®å°ããã§ãããããã§ãç§ãã¡ã¯ãã® DBMS ã®èšèšã詳ãã調ã¹ãŠããããã©ã®ããã«æ©èœããããç解ããŸããã
ClickHouse ã¯åãªãããŒã¿ããŒã¹ã§ãããããKafka ããã®ããŒã¿ã®çŽæ¥åä¿¡ããµããŒãããŠããŸããããã®ãããGo ã§ç¬èªã®ã¢ããã¿ãŒ ãµãŒãã¹ãäœæããŸããã Kafka ãã Cap'n Proto ã§ãšã³ã³ãŒããããã¡ãã»ãŒãžãèªã¿åããTSV ã«å€æããHTTP ã€ã³ã¿ãŒãã§ã€ã¹çµç±ã§ããã㧠ClickHouse ã«æ¿å ¥ããŸããã ãã®åŸãããã©ãŒãã³ã¹ãåäžãããããã«ãGo ã©ã€ãã©ãªã ClickHouse ç¬èªã®ã€ã³ã¿ãŒãã§ã€ã¹ãšçµã¿åãããŠäœ¿çšââããããã«ãã®ãµãŒãã¹ãæžãçŽããŸããã ãã±ããåä¿¡ã®ããã©ãŒãã³ã¹ãè©äŸ¡ãããšãã«ãéèŠãªããšãããããŸãããClickHouse ã®å Žåããã®ããã©ãŒãã³ã¹ã¯ãã±ããã®ãµã€ãºãã€ãŸãåæã«æ¿å ¥ãããè¡ã®æ°ã«å€§ããäŸåããããšãããããŸããã ãªããããèµ·ããã®ããç解ããããã«ãClickHouse ãããŒã¿ãã©ã®ããã«ä¿åãããã調ã¹ãŸããã
ClickHouse ãããŒã¿ãä¿åããããã«äœ¿çšããã¡ã€ã³ ãšã³ãžã³ãã€ãŸãããŒãã« ãšã³ãžã³ã®ãã¡ããªãŒã¯ MergeTree ã§ãã ãã®ãšã³ãžã³ã¯æŠå¿µçã«ã¯ Google BigTable ã Apache Cassandra ã§äœ¿çšããã LSM ã¢ã«ãŽãªãºã ã«äŒŒãŠããŸãããäžéã¡ã¢ãª ããŒãã«ã®æ§ç¯ãåé¿ããããŒã¿ããã£ã¹ã¯ã«çŽæ¥æžã蟌ã¿ãŸãã ããã«ãããæ¿å ¥ãããåãã±ãããäž»ããŒã®ã¿ã§ãœãŒããããå§çž®ãããŠãã£ã¹ã¯ã«æžã蟌ãŸããŠã»ã°ã¡ã³ãã圢æããããããåªããæžã蟌ã¿ã¹ã«ãŒããããåŸãããŸãã
ã¡ã¢ãª ããŒãã«ãããŒã¿ã®ã鮮床ãã®æŠå¿µãååšããªããšããããšã¯ãããŒã¿ã¯è¿œå ã®ã¿å¯èœã§ãããã·ã¹ãã ã¯å€æŽãåé€ããµããŒãããŠããªãããšãæå³ããŸãã çŸåšãã»ã°ã¡ã³ãã¯æã®å¢çãè¶ããããšããªããããããŒã¿ãåé€ããå¯äžã®æ¹æ³ã¯æŠæããšã«åé€ããããšã§ãã ClickHouse ããŒã ã¯ããã®æ©èœãã«ã¹ã¿ãã€ãºå¯èœã«ããããã«ç©æ¥µçã«åãçµãã§ããŸãã äžæ¹ãæžã蟌ã¿ã»ã°ã¡ã³ããšããŒãžã»ã°ã¡ã³ãã®ç«¶åããªããªããããI/O ãŸãã¯ã³ã¢ã®é£œåãçºçãããŸã§ãåä¿¡ã¹ã«ãŒãããã¯åææ¿å
¥ã®æ°ã«æ¯äŸããŠå¢å ããŸãã
ãã ããããã¯ã·ã¹ãã ãå°ããªãã±ããã«ã¯é©ããŠããªãããšãæå³ããããããããã¡ãªã³ã°ã«ã¯ Kafka ãµãŒãã¹ãšã€ã³ãµãŒã¿ã䜿çšãããŸãã 次ã«ãããã¯ã°ã©ãŠã³ãã® ClickHouse ãã»ã°ã¡ã³ãã®ããŒãžãç¶ç¶çã«å®è¡ãç¶ãããããå€æ°ã®å°ããªæ
å ±ãçµåãããããå€ãã®åæ°èšé²ããããããèšé²åŒ·åºŠãé«ãŸããŸãã ãã ããæªæ¥ç¶ã®éšåãå€ããããšãããŒãžãç¶ç¶ããéããæ¿å
¥ã®ç©æ¥µçãªã¹ãããã«ãçºçããŸãã ãªã¢ã«ã¿ã€ã ã®åã蟌ã¿ãšåã蟌ã¿ã®ããã©ãŒãã³ã¹ã®éã®æè¯ã®åŠ¥åç¹ã¯ãXNUMX ç§ãããã®ããŒãã«ãžã®æ¿å
¥ã®æ°ãå¶éããããšã§ããããšãããããŸããã
ããŒãã«èªã¿åãããã©ãŒãã³ã¹ã®éµãšãªãã®ã¯ãã€ã³ããã¯ã¹ä»ããšãã£ã¹ã¯äžã®ããŒã¿ã®å Žæã§ãã åŠçãã©ãã»ã©é«éã§ãã£ãŠãããšã³ãžã³ããã£ã¹ã¯ãããã©ãã€ãåäœã®ããŒã¿ãã¹ãã£ã³ãããã®äžéšã®ã¿ã䜿çšããå¿ èŠãããå ŽåãæéãããããŸãã ClickHouse ã¯ååã¹ãã¢ã§ãããããåã»ã°ã¡ã³ãã«ã¯ãåè¡ã®ãœãŒããããå€ãå«ãåå (å) ã®ãã¡ã€ã«ãå«ãŸããŠããŸãã ãã®æ¹æ³ã§ã¯ãã¯ãšãªã«å«ãŸããŠããªãåå šäœãæåã«ã¹ãããããŠãããè€æ°ã®ã»ã«ããã¯ãã«åãããå®è¡ã§äžŠè¡ããŠåŠçã§ããŸãã ãã« ã¹ãã£ã³ãåé¿ããããã«ãåã»ã°ã¡ã³ãã«ã¯å°ããªã€ã³ããã¯ã¹ ãã¡ã€ã«ããããŸãã
ãã¹ãŠã®åããäž»ããŒãã§ãœãŒããããŠããå Žåãã€ã³ããã¯ã¹ ãã¡ã€ã«ã«ã¯ N è¡ããšã®ã©ãã« (ãã£ããã£ãããè¡) ã®ã¿ãå«ãŸããŠãããéåžžã«å€§ããªããŒãã«ã§ãã£ãŠãã©ãã«ãã¡ã¢ãªå ã«ä¿æã§ããŸãã ããšãã°ãããã©ã«ãèšå®ãã8192 è¡ããšã«ããŒã¯ãããããã«èšå®ãã1 å ã®ããŒãã«ã®ã貧匱ãªãã€ã³ããã¯ã¹ãèšå®ã§ããŸãã ã¡ã¢ãªã«ç°¡åã«åãŸãè¡ã§ããã°ãããã 122 æåããããããŸããã
ã·ã¹ãã éçº
Clickhouse ã®éçºãšæ¹åã¯æ¬¡ã®å Žæã§è¿œè·¡ã§ããŸãã
人æ°
Clickhouse ã®äººæ°ã¯ãç¹ã«ãã·ã¢èªåã®ã³ãã¥ããã£ã§æ¥æ¿ã«é«ãŸã£ãŠããããã§ãã æšå¹Žã® Highload 2018 ã«ã³ãã¡ã¬ã³ã¹ (ã¢ã¹ã¯ã¯ã8 幎 9 æ 2018 ïœ 40 æ¥) ã§ã¯ãvk.com ã Badoo ãªã©ã®ã¢ã³ã¹ã¿ãŒã Clickhouse ã䜿çšããæ°äžã®ãµãŒããŒããåæã«ããŒã¿ (ãã°ãªã©) ãæ¿å
¥ããŠããããšã瀺ãããŸããã XNUMXåã®ãããªã§
ã¢ããªã±ãŒã·ã§ã³
æéããããŠèª¿æ»ããçµæãClickHouse ã圹ç«ã€åéããŸã㯠MySQLãPostgreSQLãELKãGoogle Big QueryãAmazon RedShiftãTimescaleDBãHadoopãMapReduceãPinot ãªã©ã®ä»ã®ããäŒçµ±çã§äººæ°ã®ãããœãªã¥ãŒã·ã§ã³ãå®å šã«çœ®ãæããããšãã§ããåéããããšæããŸãããã«ã€ãå§ã 以äžã§ã¯ãClickHouse ã䜿çšããŠäžèšã® DBMS ãææ°åãŸãã¯å®å šã«çœ®ãæããæ¹æ³ã®è©³çŽ°ã説æããŸãã
MySQL ãš PostgreSQL ã®æ©èœã®æ¡åŒµ
ã€ãæè¿ããã¥ãŒã¹ã¬ã¿ãŒ ãã©ãããã©ãŒã ã® MySQL ã ClickHouse ã«éšåçã«çœ®ãæããŸããã
Clickhouse 㯠XNUMX ã€ã®å§çž®ã¢ã«ãŽãªãºã ã䜿çšããŠãããŒã¿éãçŽ XNUMX/XNUMX åæžããŸãã
ELKã®çœ®ãæã
ç§èªèº«ã®çµéšã«åºã¥ããšãELK ã¹ã¿ã㯠(ElasticSearchãLogstashãKibanaããã®äŸã§ã¯ ElasticSearch) ã®å®è¡ã«ã¯ããã°ã®ä¿åã«å¿ èŠãªãªãœãŒã¹ãããã¯ããã«å€ãã®ãªãœãŒã¹ãå¿ èŠã§ãã ElasticSearch ã¯ãåªããå šæãã°æ€çŽ¢ãå¿ èŠãªå Žå (å®éã«ã¯å¿ èŠãªããšæããŸã) ã«ã¯åªãããšã³ãžã³ã§ããããªããããäºå®äžã®æšæºã®ãã° ãšã³ãžã³ã«ãªã£ãã®ãçåã«æã£ãŠããŸãã Logstash ãšçµã¿åããããã®åã蟌ã¿ããã©ãŒãã³ã¹ã«ãããè² è·ãããªã軜ãå Žåã§ãåé¡ãçºçããRAM ãšãã£ã¹ã¯é åãããã«è¿œå ããå¿ èŠããããŸããã ããŒã¿ããŒã¹ãšããŠã¯ãClickhouse ã ElasticSearch ãããåªããŠããã®ã¯ã次ã®çç±ããã§ãã
- SQL æ¹èšã®ãµããŒãã
- ä¿åãããããŒã¿ã®æé©ãªå§çž®åºŠã
- å šææ€çŽ¢ã®ä»£ããã« Regex æ£èŠè¡šçŸæ€çŽ¢ããµããŒãã
- ã¯ãšãªã®ã¹ã±ãžã¥ãŒãªã³ã°ãæ¹åãããå šäœçãªããã©ãŒãã³ã¹ãåäžããŸããã
çŸåšãClickHouse ãš ELK ãæ¯èŒãããšãã«çããæ倧ã®åé¡ã¯ããã°ãã¢ããããŒãããããã®ãœãªã¥ãŒã·ã§ã³ãäžè¶³ããŠããããšãšããã®ãããã¯ã«é¢ããããã¥ã¡ã³ãããã¥ãŒããªã¢ã«ãäžè¶³ããŠããããšã§ãã ããã«ãåãŠãŒã¶ãŒã¯ Digital Ocean ããã¥ã¢ã«ã䜿çšã㊠ELK ãèšå®ã§ããŸããããã¯ããã®ãããªãã¯ãããžãŒãè¿
éã«å®è£
ããããã«éåžžã«éèŠã§ãã ããŒã¿ããŒã¹ ãšã³ãžã³ã¯ãããŸãããClickHouse çšã® Filebeat ã¯ãŸã ãããŸããã ã¯ããããã«ãããŸã
ç§ã¯æå°éã®ãœãªã¥ãŒã·ã§ã³ã奜ã¿ãKafka ã®äœ¿çšãé¿ããªãããClickHouse ãšãšãã«ãéåžžã«å°ãªãã¡ã¢ãªã§ãã°ãé
åžããããŒã«ã§ãã FluentBit ã䜿çšããŠã¿ãŸããã ãã ãã次ã®ãããªè»œåŸ®ãªéäºææ§ã«å¯ŸåŠããå¿
èŠããããŸãã
代ããã«ãKibana ã ClickHouse ããã¯ãšã³ããšããŠäœ¿çšã§ããŸãã
Google Big QueryãšAmazon RedShiftã®çœ®ãæãïŒå€§äŒæ¥åããœãªã¥ãŒã·ã§ã³ïŒ
BigQuery ã®çæ³çãªãŠãŒã¹ã±ãŒã¹ã¯ã1 TB ã® JSON ããŒã¿ãèªã¿èŸŒã¿ãããã«å¯ŸããŠåæã¯ãšãªãå®è¡ããããšã§ãã Big Query ã¯ããã®ã¹ã±ãŒã©ããªãã£ãèªåŒµããŠãããããããšã®ãªãåªãã補åã§ãã ããã¯ãå éšã¯ã©ã¹ã¿ãŒäžã§å®è¡ããã ClickHouse ãããã¯ããã«è€éãªãœãããŠã§ã¢ã§ãããã¯ã©ã€ã¢ã³ãã®èŠ³ç¹ããèŠããšãClickHouse ãšå€ãã®å ±éç¹ããããŸãã BigQuery ã¯ãSELECT ããšã«æ¯æããéå§ãããšããã«é«äŸ¡ã«ãªãå¯èœæ§ããããããé·æãšçæããã¹ãŠåããçã® SaaS ãœãªã¥ãŒã·ã§ã³ã§ãã
ClickHouse ã¯ã倧éã®èšç®ã³ã¹ãã®ãããã¯ãšãªãå®è¡ããå Žåã«æé©ãªéžæè¢ã§ãã æ¯æ¥å®è¡ãã SELECT ã¯ãšãªãå¢ããã»ã©ãBig Query ã ClickHouse ã«çœ®ãæããããšã¯çã«ããªã£ãŠããŸããæ°ãã©ãã€ãã®ããŒã¿ãåŠçããå Žåããã®ãããªçœ®ãæãã«ããæ°åãã«ãç¯çŽã§ããããã§ãã ããã¯ãBig Query ã§ã®åŠçãéåžžã«äœã³ã¹ãã§ããä¿åããŒã¿ã«ã¯é©çšãããŸããã
Altinity ã®å
±ååµèšè
ãAlexander Zaitsev æ°ã®èšäº
TimescaleDB ã®çœ®ãæã
TimescaleDB ã¯ãéåžžã®ããŒã¿ããŒã¹ã§ã® timeseries æç³»åã®æäœãæé©åãã PostgreSQL æ¡åŒµæ©èœã§ã (
ClickHouse ã¯ãæç³»åã®ããããªåéã§ã¯æ·±å»ãªç«¶åçžæã§ã¯ãããŸããããåæ§é ãšãã¯ãã« ã¯ãšãªã®å®è¡ã§ã¯ãåæã¯ãšãªåŠçã®ã»ãšãã©ã®ã±ãŒã¹ã§ TimescaleDB ãããã¯ããã«é«éã§ãã åæã«ãClickHouse ããããã ããŒã¿ãåä¿¡ããããã©ãŒãã³ã¹ã¯çŽ 3 ååäžãã䜿çšãããã£ã¹ã¯å®¹éã 20 åã® XNUMX ã«åæžãããŸããããã¯ã倧éã®å±¥æŽããŒã¿ãåŠçããå Žåã«éåžžã«éèŠã§ãã âš
ClickHouse ãšã¯ç°ãªããTimescaleDB ã§ãã£ã¹ã¯é åãç¯çŽããå¯äžã®æ¹æ³ã¯ãZFS ãŸãã¯åæ§ã®ãã¡ã€ã« ã·ã¹ãã ã䜿çšããããšã§ãã
ClickHouse ã®ä»åŸã®ã¢ããããŒãã§ã¯ããã«ã¿å§çž®ãå°å ¥ãããå¯èœæ§ãé«ããæç³»åããŒã¿ã®åŠçãšä¿åã«ããé©ãããã®ã«ãªããŸãã 次ã®å Žåã«ã¯ãTimescaleDB ã裞㮠ClickHouse ãããåªããéžæè¢ãšãªãå¯èœæ§ããããŸãã
- RAM ãéåžžã«å°ãªã (3 GB æªæº) å°èŠæš¡ãªã€ã³ã¹ããŒã«ã
- 倧ããªãã©ã°ã¡ã³ãã«ãããã¡ãªã³ã°ããããªãå€æ°ã®å°ã㪠INSERTã
- äžè²«æ§ãåäžæ§ãACID èŠä»¶ã®åäžã
- PostGIS ã®ãµããŒãã
- Timescale DB ã¯æ¬è³ªçã« PostgreSQL ã§ãããããæ¢åã® PostgreSQL ããŒãã«ãšçµåããŸãã
Hadoop ããã³ MapReduce ã·ã¹ãã ãšã®ç«¶å
Hadoop ããã®ä»ã® MapReduce 補åã¯å€ãã®è€éãªèšç®ãå®è¡ã§ããŸãããå®è¡ãããšåŸ ã¡æéã倧ãããªãåŸåããããŸãããClickHouse ã¯ãã©ãã€ãèŠæš¡ã®ããŒã¿ãåŠçããã»ãŒç¬æã«çµæãçæããããšã§ãã®åé¡ã解決ããŸãã ãããã£ãŠãClickHouse ã¯ãããŒã¿ ãµã€ãšã³ãã£ã¹ãã«ãšã£ãŠèå³æ·±ãã¯ãã®ãé«éã§ã€ã³ã¿ã©ã¯ãã£ããªåæ調æ»ãããå¹æçã«å®è¡ã§ããŸãã
ãããšãã«ã€ããšã®ç«¶äº
ClickHouse ã®æãè¿ã競åçžæã¯ãã«ã©ã åã§çŽç·çã«ã¹ã±ãŒã©ãã«ãªãªãŒãã³ãœãŒã¹è£œåã§ãã Pinot ãš Druid ã§ãã ãããã®ã·ã¹ãã ãæ¯èŒããåªããç 究ãèšäºã«æ²èŒãããŠããŸãã
ãã®èšäºã¯æŽæ°ããå¿
èŠããããŸããClickHouse 㯠UPDATE ããã³ DELETE æäœããµããŒãããŠããªããšæžãããŠããŸãããããã¯ææ°ããŒãžã§ã³ã«å®å
šã«åœãŠã¯ãŸãããã§ã¯ãããŸããã
ç§ãã¡ã¯ãããã®ããŒã¿ããŒã¹ã®äœ¿çšçµéšãããŸããããŸããããDruid ãš Pinot ãå®è¡ããããã«å¿ èŠãªã€ã³ãã©ã¹ãã©ã¯ãã£ã®è€éããããŸã奜ãã§ã¯ãããŸãããããã¯ãåæ¹å «æ¹ã Java ã§å²ãŸããå¯åéšåã®å¡ã§ãã
Druid ãš Pinot 㯠Apache ã€ã³ãã¥ããŒã¿ãŒ ãããžã§ã¯ãã§ããããã®é²æç¶æ³ã¯ Apache ã® GitHub ãããžã§ã¯ã ããŒãžã§è©³ãã説æãããŠããŸãã ããã¯2018幎8æã«ä¿è²åšã«çŸãããã«ã€ãã¯XNUMXãæåã®XNUMXæã«çãŸããŸããã
AFS ãã©ã®ããã«æ©èœãããã«ã€ããŠã®æ å ±ãäžè¶³ããŠãããããããã€ãã®ãããããæããªçåãç§ã«çããŸããã Pinot ã®èè ãã¡ã¯ãApache Foundation ã Druid ã«å¯ŸããŠå¥œæçã§ããããšã«æ°ã¥ããã®ã ãããããŸã競åä»ç€Ÿã«å¯Ÿãããã®æ 床ã矚æã®ææ ãåŒãèµ·ãããã®ã ããã? ãã«ã€ãã®æ¯æŽè ãçªç¶åŸè ã«èå³ãæã¡å§ãããããã«ã€ãã®çºå±ã¯æžéããããã®çºå±ã¯å éããã§ãããã?
ã¯ãªãã¯ããŠã¹ã®ãã¡ãªãã
æªçã: ãã¡ãããããã¯ãŸã éå±ãªãã¯ãããžã§ã¯ãããŸãããããããã«ããŠãããã®ãããªããšã¯ä»ã®ã«ã©ã å DBMS ã§ã¯èŠãããŸããã
å°ããªæ¿å ¥ã¯é«éã§ã¯ããã©ãŒãã³ã¹ãè¯ããããŸãããå°ããªæ¿å ¥ã®ããã©ãŒãã³ã¹ã¯åè¡ã®åæ°ã«æ¯äŸããŠäœäžãããããæ¿å ¥ã¯å€§ããªãã£ã³ã¯ã«åå²ããå¿ èŠããããŸãã ClickHouse ãããŒã¿ããã£ã¹ã¯ã«ä¿åããæ¹æ³ã¯æ¬¡ã®ãšããã§ããåå㯠1 ã€ä»¥äžã®ãã¡ã€ã«ãè¡šãããã1 åãå«ã 100 è¡ãæ¿å ¥ããã«ã¯ãå°ãªããšã 100 åã®ãã¡ã€ã«ãéããŠæžã蟌ãå¿ èŠããããŸãã ãããããããã¡ãªã³ã°æ¿å ¥ã«ä»²ä»è (ã¯ã©ã€ã¢ã³ãèªäœããããã¡ãªã³ã°ãæäŸããªãéã) - é垞㯠Kafka ãŸãã¯ããçš®ã®ãã¥ãŒç®¡çã·ã¹ãã ãå¿ èŠãšããçç±ã§ãã ãããã¡ ããŒãã« ãšã³ãžã³ã䜿çšããŠãåŸã§å€§ããªããŒã¿ ãã£ã³ã¯ã MergeTree ããŒãã«ã«ã³ããŒããããšãã§ããŸãã
ããŒãã«çµåã¯ãµãŒããŒã® RAM ã«ãã£ãŠå¶éãããŸãããå°ãªããšãååšããŸãã ããšãã°ãDruid ãš Pinot ã«ã¯ãã®ãããªæ¥ç¶ããŸã£ãããããŸãããããã¯ãããŒãéã§å€§éã®ããŒã¿ã移åããããšããµããŒãããŠããªãåæ£ã·ã¹ãã ã«çŽæ¥å®è£ ããããšãé£ããããã§ãã
æèŠ
ãã® DBMS ã¯ããã©ãŒãã³ã¹ãäœãªãŒããŒããããã¹ã±ãŒã©ããªãã£ãã·ã³ãã«ãã®åªãããã©ã³ã¹ãæäŸãããããä»åŸæ°å¹Žé㧠Qwintry 㧠ClickHouse ãåºã䜿çšããäºå®ã§ãã ClickHouse ã³ãã¥ããã£ãå°èŠæš¡ããäžèŠæš¡ã®ã€ã³ã¹ããŒã«ã§äœ¿çšããæ¹æ³ãããã«èæ¡ããããããã«æ®åãå§ãããšç¢ºä¿¡ããŠããŸãã
ããã€ãã®åºå ð
ãã€ãã宿æ³ããã ãããããšãããããŸãã ç§ãã¡ã®èšäºãæ°ã«å
¥ã£ãŠããŸãã? ãã£ãšèå³æ·±ãã³ã³ãã³ããèŠããã§ãã? 泚æããããå人ã«å§ãããããŠç§ãã¡ããµããŒãããŠãã ããã
ã¢ã ã¹ãã«ãã ã®ãšã¯ã€ãã¯ã¹ Tier IV ããŒã¿ã»ã³ã¿ãŒã§ã¯ Dell R730xd ã 2 åå®ã? ããã ã
åºæïŒ habr.com