{"id":54918,"date":"2020-01-07T00:00:00","date_gmt":"2020-01-06T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb"},"modified":"2020-02-18T14:02:58","modified_gmt":"2020-02-18T11:02:58","slug":"ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb","title":{"rendered":"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/clickhouse.yandex\/\">Clickhouse<\/a><\/noindex> \u2014 \u00ebsht\u00eb nj\u00eb sistem menaxhimi bazash t\u00eb dh\u00ebnash me kolona p\u00ebr p\u00ebrpunimin online t\u00eb k\u00ebrkesave analitike (OLAP) me kod t\u00eb hapur, i krijuar nga Yandex. P\u00ebrdoret nga Yandex, CloudFlare, VK.com, Badoo dhe sh\u00ebrbime t\u00eb tjera n\u00eb mbar\u00eb bot\u00ebn p\u00ebr ruajtjen e v\u00ebllimeve t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave (inserimi i mij\u00ebra rreshtave n\u00eb sekond\u00eb ose petabayt t\u00eb dh\u00ebnash t\u00eb ruajtura n\u00eb disk).<\/p>\n<p>N\u00eb nj\u00eb DBMS t\u00eb zakonsh\u00ebm, t\u00eb quajtur 't\u00eb rreshtave', shembuj t\u00eb t\u00eb cil\u00ebve jan\u00eb MySQL, Postgres, MS SQL Server, t\u00eb dh\u00ebnat ruhen n\u00eb k\u00ebt\u00eb rend: <\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/398f260de0152baf3cc11d884fa0d52d.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nN\u00eb k\u00ebt\u00eb rast, vlerat q\u00eb i p\u00ebrkasin nj\u00eb rreshti ruhen fizikisht pran\u00eb nj\u00ebra-tjetr\u00ebs. N\u00eb DBMS-t\u00eb me kolona, vlerat nga kolona t\u00eb ndryshme ruhen ve\u00e7mas, nd\u00ebrsa t\u00eb dh\u00ebnat e nj\u00eb kolone \u2013 bashk\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/938a2ee3d588ac866ec92bb3ea09c253.png\" style=\"display:block;margin: 0 auto;\" \/><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p>Shembuj t\u00eb DBMS-ve me kolona jan\u00eb Vertica, Paraccel (Actian Matrix, Amazon Redshift), Sybase IQ, Exasol, Infobright, InfiniDB, MonetDB (VectorWise, Actian Vector), LucidDB, SAP HANA, Google Dremel, Google PowerDrill, Druid, kdb+.<\/p>\n<p>Kompania \u2013 mailforwarder <noindex><a rel=\"nofollow\" href=\"https:\/\/qwintry.com\/\">Qwintry<\/a><\/noindex> filloi t\u00eb p\u00ebrdor\u00eb Clickhouse n\u00eb vitin 2018 p\u00ebr p\u00ebrgatitjen e raporteve dhe u impresionua shum\u00eb nga thjesht\u00ebsia, shkall\u00ebzueshm\u00ebria, mb\u00ebshtetja SQL dhe shpejt\u00ebsia e saj. Shpejt\u00ebsia e pun\u00ebs s\u00eb k\u00ebtij DBMS ishte n\u00eb prag t\u00eb magjis\u00eb.<\/p>\n<h3>Thjesht\u00ebsia<\/h3>\n<p>\nClickhouse instalohet n\u00eb Ubuntu me nj\u00eb komand\u00eb t\u00eb vetme. N\u00ebse e njihni SQL-in, mund t\u00eb filloni menj\u00ebher\u00eb ta p\u00ebrdorni Clickhouse p\u00ebr nevojat tuaja. Megjithat\u00eb, kjo nuk do t\u00eb thot\u00eb se mund t\u00eb kryeni \"show create table\" n\u00eb MySQL dhe t\u00eb kopjoni-pastoni SQL-in n\u00eb Clickhouse. <\/p>\n<p>N\u00eb krahasim me MySQL, n\u00eb k\u00ebt\u00eb DBMS ekzistojn\u00eb dallime t\u00eb r\u00ebnd\u00ebsishme n\u00eb llojet e t\u00eb dh\u00ebnave n\u00eb definicionet e skemave t\u00eb tabelave, k\u00ebshtu q\u00eb p\u00ebr t\u00eb punuar rehat ju nevojitet pak koh\u00eb p\u00ebr t\u00eb ndryshuar definicionet e skemave t\u00eb tabelave dhe p\u00ebr t\u00eb studiuar motor\u00ebt e tabelave.<\/p>\n<p>Clickhouse funksionon shk\u00eblqyer pa ndonj\u00eb softuer t\u00eb shtes\u00eb, por n\u00ebse d\u00ebshironi t\u00eb p\u00ebrdorni replikimin, do t'ju nevojitet t\u00eb instaloni ZooKeeper. Analiza e performanc\u00ebs s\u00eb pyetjeve tregon rezultate t\u00eb shk\u00eblqyera \u2014 tabelat sistemike p\u00ebrmbajn\u00eb t\u00eb gjitha informacionet, dhe t\u00eb gjitha t\u00eb dh\u00ebnat mund t\u00eb merren p\u00ebrmes SQL-it t\u00eb vjet\u00ebr dhe t\u00eb m\u00ebrzitsh\u00ebm.<\/p>\n<h3>Performanca<\/h3>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/clickhouse.yandex\/benchmark.html#%5B%2522100000000%2522,%5B%2522ClickHouse%2522,%2522Vertica%2522,%2522MySQL%2522%5D,%5B%25220%2522,%25221%2522%5D%5D\">Bencmarr<\/a><\/noindex> krahasimi i Clickhouse me Vertica dhe MySQL n\u00eb serverin me konfigurim: dy socket-e Intel\u00ae Xeon\u00ae CPU E5-2650 v2 @ 2.60GHz; 128 GiB RAM; md RAID-5 me 8 6TB SATA HDD, ext4.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.altinity.com\/blog\/2017\/6\/20\/clickhouse-vs-redshift\">Bencmarr<\/a><\/noindex> krahasimi i Clickhouse me magazin\u00ebn e t\u00eb dh\u00ebnave n\u00eb cloud Amazon RedShift.<\/li>\n<li>P\u00ebrmbledhje nga blogu <noindex><a rel=\"nofollow\" href=\"https:\/\/blog.cloudflare.com\/how-cloudflare-analyzes-1m-dns-queries-per-second\/\">Sclodflare mbi performanc\u00ebn e Clickhouse<\/a><\/noindex>:<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/b6ef9fbad8e8c864a227bcffd97ec0fe.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nBaza e t\u00eb dh\u00ebnave ClickHouse ka nj\u00eb dizajn shum\u00eb t\u00eb thjesht\u00eb \u2014 t\u00eb gjith\u00eb nyjat n\u00eb klaster kan\u00eb funksionalitete t\u00eb nj\u00ebjta dhe p\u00ebrdorin vet\u00ebm ZooKeeper p\u00ebr koordinim. Ne nd\u00ebrtuam nj\u00eb klaster t\u00eb vog\u00ebl prej disa nyjash dhe kryem testime, gjat\u00eb t\u00eb cilave zbuluam se sistemi ka nj\u00eb performanc\u00eb mjaft mbres\u00ebl\u00ebn\u00ebse, e cila p\u00ebrputhet me avantazhet e deklaruara n\u00eb benchmarket e DB-ve analitike. Vendos\u00ebm t\u00eb shqyrtonim m\u00eb n\u00eb detaje konceptin n\u00eb thelb t\u00eb ClickHouse. Pengesa e par\u00eb p\u00ebr hulumtimin ishte mungesa e mjeteve dhe pak\u00ebsia e komunitetit ClickHouse, prandaj u thelluam n\u00eb dizajnin e k\u00ebsaj DB-je p\u00ebr t\u00eb kuptuar si funksionon.<\/p>\n<p>ClickHouse nuk mb\u00ebshtet marrjen e t\u00eb dh\u00ebnave drejtp\u00ebrdrejt nga Kafka, pasi kjo \u00ebsht\u00eb vet\u00ebm nj\u00eb baz\u00eb t\u00eb dh\u00ebnash, prandaj ne shkruam nj\u00eb sh\u00ebrbim adaptues t\u00eb nd\u00ebrtuar me gjuh\u00ebn Go. Ai lexonte mesazhet e koduara Cap\u2019n Proto nga Kafka, i shnd\u00ebrronte ato n\u00eb TSV dhe i insertonte n\u00eb ClickHouse n\u00eb grupe p\u00ebrmes HTTP-it. M\u00eb von\u00eb, ne e riparametruam k\u00ebt\u00eb sh\u00ebrbim p\u00ebr t\u00eb p\u00ebrdorur biblioteken Go s\u00eb bashku me nd\u00ebrfaqen ton\u00eb t\u00eb ClickHouse p\u00ebr t\u00eb rritur performanc\u00ebn. Gjat\u00eb vler\u00ebsimit t\u00eb performanc\u00ebs s\u00eb marrjes s\u00eb grupeve, zbuluam nj\u00eb gj\u00eb t\u00eb r\u00ebnd\u00ebsishme \u2013 doli se p\u00ebr ClickHouse, kjo performanc\u00eb varet shum\u00eb nga madh\u00ebsia e grupit, dmth, numri i rreshtave q\u00eb insertohen n\u00eb nj\u00eb koh\u00eb. P\u00ebr t\u00eb kuptuar pse ndodh kjo, ne studiuam se si ClickHouse ruan t\u00eb dh\u00ebnat.<\/p>\n<p>Motori kryesor\u00eb, m\u00eb sakt\u00ebsisht, familja e motor\u00ebve p\u00ebr tabela q\u00eb p\u00ebrdoret nga ClickHouse p\u00ebr ruajtjen e t\u00eb dh\u00ebnave \u00ebsht\u00eb MergeTree. Ky motor \u00ebsht\u00eb konceptualisht i ngjash\u00ebm me algoritmin LSM, i cili aplikohet n\u00eb Google BigTable ose Apache Cassandra, megjithat\u00eb shmang nd\u00ebrtimin e nj\u00eb tabele nd\u00ebrmjet\u00ebse n\u00eb memorie dhe shkruan t\u00eb dh\u00ebnat drejtp\u00ebrdrejt n\u00eb disk. Kjo i jep atij nj\u00eb kapacitet t\u00eb shk\u00eblqyer t\u00eb shkrimit, pasi \u00e7do paket\u00eb e futur renditet vet\u00ebm sipas \u201c\u00e7el\u00ebsit primar\u201d primary key, kompresohet dhe shkruhet n\u00eb disk p\u00ebr t\u00eb formuar nj\u00eb segment. <\/p>\n<p>Mungesa e nj\u00eb tabele t\u00eb memories ose ndonj\u00eb koncepti t\u00eb 'risis\u00eb' s\u00eb t\u00eb dh\u00ebnave gjithashtu do t\u00eb thot\u00eb se ato mund t\u00eb shtohen vet\u00ebm; modifikimi ose fshirja nuk mb\u00ebshtetet nga sistemi. Aktualisht, m\u00ebnyra e vetme p\u00ebr t\u00eb fshir\u00eb t\u00eb dh\u00ebnat \u00ebsht\u00eb t'i fshini ato sipas muajve kalendarik\u00eb, pasi segmentet kurr\u00eb nuk kalojn\u00eb kufirin e muajit. Ekipi i ClickHouse po punon aktivisht p\u00ebr ta b\u00ebr\u00eb k\u00ebt\u00eb funksionalitet t\u00eb personalizuesh\u00ebm. Nga ana tjet\u00ebr, kjo e b\u00ebn regjistrimin dhe bashkimin e segmenteve pa konflikte, k\u00ebshtu q\u00eb kapaciteti i pranimit rritet n\u00eb m\u00ebnyr\u00eb lineare me numrin e inserteve paralele deri n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb kur ndodh saturimi i I\/O ose b\u00ebrthamave. <br \/>\nMegjithat\u00eb, kjo situat\u00eb gjithashtu do t\u00eb thot\u00eb se sistemi nuk \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr paketa t\u00eb vogla, prandaj p\u00ebrdoren sh\u00ebrbime Kafka dhe inserter p\u00ebr buferizimin. M\u00eb pas, ClickHouse vazhdon t\u00eb kryej\u00eb vazhdimisht bashkimin e segmenteve n\u00eb sfond, k\u00ebshtu q\u00eb shum\u00eb pjes\u00eb t\u00eb vogla informacioni do t\u00eb kombinohen dhe do t\u00eb shkruhen m\u00eb shum\u00eb her\u00eb, duke rritur k\u00ebshtu intensitetin e shkruarjes. N\u00eb k\u00ebt\u00eb proces, nj\u00eb num\u00ebr i tepruar pjes\u00ebsh t\u00eb pazakont\u00eb do t\u00eb shkaktoj\u00eb nj\u00eb trotllem t\u00eb agresiv t\u00eb inserteve derisa bashkimi t\u00eb vazhdoj\u00eb. Ne zbuluam se kompromisi m\u00eb i mir\u00eb midis pranimit t\u00eb t\u00eb dh\u00ebnave n\u00eb koh\u00eb reale dhe performanc\u00ebs \u00ebsht\u00eb marrja n\u00eb nj\u00eb tabel\u00eb e nj\u00eb numri t\u00eb kufizuar insertesh n\u00eb sekond\u00eb.<\/p>\n<p>\u00c7el\u00ebsi p\u00ebr performanc\u00ebn e leximit t\u00eb tabelave \u00ebsht\u00eb indeksimi dhe vendosja e dh\u00ebnave n\u00eb disk. Pavar\u00ebsisht sa e shpejt\u00eb \u00ebsht\u00eb p\u00ebrpunimi, kur motorit i nevojitet t\u00eb skanoj\u00eb terabajt t\u00eb dh\u00ebnash nga disku dhe t\u00eb p\u00ebrdor\u00eb vet\u00ebm nj\u00eb pjes\u00eb t\u00eb tyre, do t\u00eb marr\u00eb koh\u00eb. ClickHouse \u00ebsht\u00eb nj\u00eb magazin\u00eb kolonash, prandaj \u00e7do segment p\u00ebrmban nj\u00eb sked\u00eb p\u00ebr \u00e7do kolone me vlera t\u00eb renditura p\u00ebr \u00e7do rresht. K\u00ebshtu, kolona t\u00eb t\u00ebra, q\u00eb nuk jan\u00eb t\u00eb pranishme n\u00eb k\u00ebrkes\u00eb, mund t\u00eb kalohen fillimisht, dhe pastaj disa qeliza mund t\u00eb p\u00ebrpunohen paralelisht me ekzekutimin e vektorizuar. P\u00ebr t\u00eb shmangur skanimin e plot\u00eb, \u00e7do segment ka nj\u00eb sked\u00eb t\u00eb vog\u00ebl indeksi. <\/p>\n<p>Duke pasur parasysh se t\u00eb gjitha kolonet jan\u00eb t\u00eb renditura sipas '\u00e7el\u00ebsit t\u00eb par\u00eb', skeda e indeksit p\u00ebrmban vet\u00ebm etiketat (rreshtat e kapur) t\u00eb \u00e7do rreshti N-t\u00eb, p\u00ebr t\u00eb pasur mund\u00ebsi t'i ruaj\u00eb ato n\u00eb memorie edhe p\u00ebr tabela shum\u00eb t\u00eb m\u00ebdha. P\u00ebr shembull, mund t\u00eb vendosen cil\u00ebsimet e paracaktuara 't\u00eb etiketohen \u00e7do 8192 rresht', at\u00ebher\u00eb 'indeksimi i skajsh\u00ebm' i nj\u00eb tabele me 1 trilion rreshtash, e cila leht\u00eb p\u00ebrshtatet n\u00eb memorie, do t\u00eb marr\u00eb vet\u00ebm 122,070 karaktere. <\/p>\n<h3>Zhvillimi i sistemit<\/h3>\n<p>\nZhvillimi dhe p\u00ebrmir\u00ebsimi i Clickhouse mund t\u00eb ndiqen n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/yandex\/ClickHouse\/pulse\">repo-n\u00eb Github<\/a><\/noindex> dhe t\u00eb siguroheni se procesi i \"rritjes\" po ndodh me ritme t\u00eb habitshme. <\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/19211da28e42178d26dff7623689df71.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>Popullariteti<\/h3>\n<p>\nDuket se popullariteti i Clickhouse po rritet eksponencialisht, ve\u00e7an\u00ebrisht n\u00eb komunitetin anglishtfol\u00ebs. Konferenca e vitit t\u00eb kaluar High Load 2018 (Mosk\u00eb, 8-9 n\u00ebntor 2018) tregoi se monstru t\u00eb till\u00eb si vk.com dhe Badoo, p\u00ebrdorin Clickhouse p\u00ebr t\u00eb futur t\u00eb dh\u00ebna (p.sh., loge) nga dhjet\u00ebra mij\u00ebra server\u00eb n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb. N\u00eb videon 40-minut\u00ebshe <noindex><a rel=\"nofollow\" href=\"https:\/\/www.youtube.com\/watch?v=pbbcMcrQoXw\">Yuri Nasretdinov nga ekipi i VKontakte flet p\u00ebr m\u00ebnyr\u00ebn se si b\u00ebhet kjo<\/a><\/noindex>. Shpejt do t\u00eb publikojm\u00eb transkriptin n\u00eb Habr p\u00ebr leht\u00ebsimin e pun\u00ebs me materialin.<\/p>\n<h3>Fushat e aplikimit<\/h3>\n<p>\nPas disa koh\u00ebsh hulumtimi, mendoj se ka fusha ku ClickHouse mund t\u00eb jet\u00eb e dobishme ose t\u00eb jet\u00eb n\u00eb gjendje t\u00eb z\u00ebvend\u00ebsoj\u00eb plot\u00ebsisht zgjidhje t\u00eb tjera, m\u00eb tradicionale dhe t\u00eb njohura, si MySQL, PostgreSQL, ELK, Google Big Query, Amazon RedShift, TimescaleDB, Hadoop, MapReduce, Pinot dhe Druid. M\u00eb posht\u00eb jan\u00eb p\u00ebrshkrime t\u00eb detajuara t\u00eb p\u00ebrdorimit t\u00eb ClickHouse p\u00ebr modernizimin ose z\u00ebvend\u00ebsimin e plot\u00eb t\u00eb sistemeve t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave t\u00eb p\u00ebrmendura. <\/p>\n<h3>Zgjerimi i mund\u00ebsive t\u00eb MySQL dhe PostgreSQL<\/h3>\n<p>\nPara pak dit\u00eb m\u00eb par\u00eb, ne z\u00ebvend\u00ebsuam pjes\u00ebrisht MySQL me ClickHouse p\u00ebr platform\u00ebn e buletin\u00ebve informativ\u00eb. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.mautic.org\/\">Buletini Mautic<\/a><\/noindex>. Problemi ishte se MySQL, p\u00ebr shkak t\u00eb nj\u00eb dizajni t\u00eb paplanifikuar, regjistronte \u00e7do email t\u00eb d\u00ebrguar dhe \u00e7do lidhje n\u00eb k\u00ebt\u00eb email me nj\u00eb hash base64, duke krijuar nj\u00eb tabel\u00eb t\u00eb madhe MySQL (email_stats). Pas d\u00ebrgimit t\u00eb vet\u00ebm 10 milion email-e p\u00ebr abonent\u00ebt e sh\u00ebrbimit, kjo tabel\u00eb zinte 150 GB hap\u00ebsir\u00eb dyshe dhe MySQL fillonte t\u00eb 'ngadal\u00ebsohej' n\u00eb k\u00ebrkesat e thjeshta. P\u00ebr t\u00eb zgjidhur problemin e hap\u00ebsir\u00ebs s\u00eb skedar\u00ebve, ne p\u00ebrdor\u00ebm me sukses kompresimin e tabel\u00ebs InnoDB, e cila e zvog\u00ebloi at\u00eb me 4 her\u00eb. Megjithat\u00eb, nuk ka sens t\u00eb ruhet m\u00eb shum\u00eb se 20-30 milion email-e n\u00eb MySQL thjesht p\u00ebr t\u00eb lexuar historin\u00eb, pasi \u00e7do k\u00ebrkes\u00eb e thjesht\u00eb q\u00eb p\u00ebr nj\u00eb arsye ndonj\u00ebher\u00eb duhet t\u00eb p\u00ebrfitoj\u00eb nj\u00eb skanim t\u00eb plot\u00eb sjell n\u00eb swap dhe ngarkes\u00eb t\u00eb madhe n\u00eb I\/O, p\u00ebr t\u00eb cil\u00ebn ne rregullisht merrnim paralajm\u00ebrime nga Zabbix.<\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/11b3ee4b1a8b7c9457bd3871bd12049f.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nClickHouse p\u00ebrdor dy algoritme kompresimi, t\u00eb cil\u00ebt reduktojn\u00eb volumet e t\u00eb dh\u00ebnave rreth <noindex><a rel=\"nofollow\" href=\"https:\/\/www.altinity.com\/blog\/2017\/11\/21\/compression-in-clickhouse\">3-4 her\u00eb<\/a><\/noindex>, por n\u00eb k\u00ebt\u00eb rast t\u00eb ve\u00e7ant\u00eb t\u00eb dh\u00ebnat ishin ve\u00e7an\u00ebrisht 't\u00eb kompresueshme'. <\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/d192502073d57967620aa07da0bbfa0c.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h3>Z\u00ebvend\u00ebsimi i ELK<\/h3>\n<p>\nDuke p\u00ebrvoj\u00ebs sime, staku ELK (ElasticSearch, Logstash dhe Kibana, n\u00eb k\u00ebt\u00eb rast konkret ElasticSearch) k\u00ebrkon shum\u00eb m\u00eb tep\u00ebr burime p\u00ebr t\u00eb funksionuar se sa \u00ebsht\u00eb e nevojshme p\u00ebr ruajtjen e log\u00ebve. ElasticSearch \u00ebsht\u00eb nj\u00eb motor i shk\u00eblqyer, n\u00ebse ju nevojitet nj\u00eb k\u00ebrkim i mir\u00eb me tekst t\u00eb plot\u00eb n\u00eb log\u00eb (dhe nuk mendoj se realisht ju duhet), por m\u00eb intereson, pse de-fakto ka ndodhur q\u00eb ai t\u00eb b\u00ebhet standardi p\u00ebr mbajtjen e eksperiencave. Performanca e pranimit t\u00eb tij bashk\u00eb me Logstash na ka krijuar probleme edhe me ngarkesa mjaft t\u00eb vogla dhe ka k\u00ebrkuar gjithnj\u00eb e m\u00eb shum\u00eb memorie RAM dhe hap\u00ebsir\u00eb disku. Si nj\u00eb DB, Clickhouse \u00ebsht\u00eb m\u00eb i mir\u00eb se ElasticSearch p\u00ebr arsye t\u00eb m\u00ebposhtme:<\/p>\n<ul>\n<li>Mb\u00ebshtetje p\u00ebr dialektin SQL;<\/li>\n<li>Shkalla m\u00eb e mir\u00eb e kompresionit t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura;<\/li>\n<li>Mb\u00ebshtetje p\u00ebr k\u00ebrkimin me shprehje t\u00eb rregullta Regex p\u00ebrve\u00e7 k\u00ebrkimit t\u00eb tekstit t\u00eb plot\u00eb;<\/li>\n<li>Planifikim t\u00eb p\u00ebrmir\u00ebsuar t\u00eb pyetjeve dhe performanc\u00eb m\u00eb t\u00eb lart\u00eb n\u00eb p\u00ebrgjith\u00ebsi.<\/li>\n<\/ul>\n<p>\nAktualisht, problemi m\u00eb i madh q\u00eb lind kur krahasohet ClickHouse me ELK \u00ebsht\u00eb mungesa e zgjidhjeve p\u00ebr eksportimin e logeve, si dhe mungesa e dokumentacionit dhe materialeve m\u00ebsimore mbi k\u00ebt\u00eb tem\u00eb. Megjithat\u00eb, \u00e7do p\u00ebrdorues mund ta konfiguroj\u00eb ELK duke p\u00ebrdorur udh\u00ebzimin e Digital Ocean, gj\u00eb q\u00eb \u00ebsht\u00eb shum\u00eb e r\u00ebnd\u00ebsishme p\u00ebr nj\u00eb implementim t\u00eb shpejt\u00eb t\u00eb teknologjive t\u00eb tilla. Ka nj\u00eb motor databazash k\u00ebtu, por ende nuk ka Filebeat p\u00ebr ClickHouse. Po, aty ka <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fluentd.org\/\">fluentd<\/a><\/noindex> dhe nj\u00eb sistem p\u00ebr pun\u00eb me loge <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/flant\/loghouse\">loghouse<\/a><\/noindex>, ekziston nj\u00eb mjet <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Altinity\/clicktail\">clicktail<\/a><\/noindex> p\u00ebr futjen n\u00eb ClickHouse t\u00eb t\u00eb dh\u00ebnave nga skedar\u00ebt e logeve, por gjith\u00e7ka k\u00ebrkon m\u00eb shum\u00eb koh\u00eb. Megjithat\u00eb, ClickHouse vazhdon t\u00eb mbetet n\u00eb krye p\u00ebr shkak t\u00eb thjesht\u00ebsis\u00eb s\u00eb tij, k\u00ebshtu q\u00eb edhe fillestar\u00ebt e instalojn\u00eb leht\u00ebsisht dhe fillojn\u00eb p\u00ebrdorimin e plot\u00eb funksional brenda vet\u00ebm 10 minutash. <\/p>\n<p>Duke preferuar zgjidhje minimalistike, p\u00ebrpiqesha t\u00eb p\u00ebrdorja FluentBit, nj\u00eb mjet p\u00ebr eksportimin e logeve me shum\u00eb pak kujtes\u00eb, s\u00eb bashku me ClickHouse, duke u munduar t\u00eb shmang p\u00ebrfshirjen e Kafka-s. Megjithat\u00eb, \u00ebsht\u00eb e nevojshme t\u00eb eliminohen disa moskompatibilitete t\u00eb vogla, si\u00e7 jan\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/fluent\/fluent-bit\/issues\/848\">problemet me formatin e dat\u00ebs<\/a><\/noindex>, \u043f\u0440\u0435\u0436\u0434\u0435 \u0447\u0435\u043c \u044d\u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0431\u0443\u0434\u0435\u0442 \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u0431\u0435\u0437 proxy-\u0441\u043b\u043e\u044f, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 FluentBit \u0432 ClickHouse.<\/p>\n<p>\u0412 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u044b Kibana \u043c\u043e\u0436\u043d\u043e \u0432 \u0440\u043e\u043b\u0438 \u0431\u044d\u043a\u0435\u043d\u0434\u0430 ClickHouse \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Vertamedia\/clickhouse-grafana\">Grafana<\/a><\/noindex>. \u041d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u044f \u043f\u043e\u043d\u044f\u043b, \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u043c\u043e\u0433\u0443\u0442 \u0432\u043e\u0437\u043d\u0438\u043a\u0430\u0442\u044c \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u043f\u0440\u0438 \u0440\u0435\u043d\u0434\u0435\u0440\u0438\u043d\u0433\u0435 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0433\u043e \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u0430 \u043f\u0443\u043d\u043a\u0442\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445, \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0441 \u0431\u043e\u043b\u0435\u0435 \u0441\u0442\u0430\u0440\u044b\u043c\u0438 \u0432\u0435\u0440\u0441\u0438\u044f\u043c\u0438 Grafana. \u0412 Qwintry \u043c\u044b \u043f\u043e\u043a\u0430 \u0447\u0442\u043e \u044d\u0442\u043e \u043d\u0435 \u043f\u0440\u043e\u0431\u043e\u0432\u0430\u043b\u0438, \u043d\u043e \u0436\u0430\u043b\u043e\u0431\u044b \u043d\u0430 \u0442\u0430\u043a\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043e\u0442 \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u043f\u043e\u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u043d\u0430 \u043a\u0430\u043d\u0430\u043b\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 ClickHouse \u0432 Telegram. <\/p>\n<h3>\u0417\u0430\u043c\u0435\u043d\u0430 Google Big Query \u0438 Amazon RedShift (\u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0439)<\/h3>\n<p>\n\u0418\u0434\u0435\u0430\u043b\u044c\u043d\u044b\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f BigQuery \u2013 \u044d\u0442\u043e \u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u044c 1 \u0422\u0411 \u0434\u0430\u043d\u043d\u044b\u0445 JSON \u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u043f\u043e \u043d\u0438\u043c \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b. Big Query \u2014 \u044d\u0442\u043e \u043e\u0442\u043b\u0438\u0447\u043d\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442, \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u0443\u0435\u043c\u043e\u0441\u0442\u044c \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u0442\u0440\u0443\u0434\u043d\u043e \u043f\u0435\u0440\u0435\u043e\u0446\u0435\u043d\u0438\u0442\u044c. \u042d\u0442\u043e \u0433\u043e\u0440\u0430\u0437\u0434\u043e \u0431\u043e\u043b\u0435\u0435 \u0441\u043b\u043e\u0436\u043d\u043e\u0435 \u041f\u041e, \u0447\u0435\u043c ClickHouse, \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u043d\u0430 \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0435\u043c \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0435, \u043d\u043e \u0441 \u0442\u043e\u0447\u043a\u0438 \u0437\u0440\u0435\u043d\u0438\u044f \u043a\u043b\u0438\u0435\u043d\u0442\u0430 \u043e\u043d\u043e \u0438\u043c\u0435\u0435\u0442 \u043c\u043d\u043e\u0433\u043e \u043e\u0431\u0449\u0435\u0433\u043e \u0441 ClickHouse. BigQuery \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0441\u0442\u0440\u043e \u00ab\u043f\u043e\u0434\u043e\u0440\u043e\u0436\u0430\u0442\u044c\u00bb, \u043a\u0430\u043a \u0442\u043e\u043b\u044c\u043a\u043e \u0432\u044b \u0441\u0442\u0430\u043d\u0435\u0442\u0435 \u043f\u043b\u0430\u0442\u0438\u0442\u044c \u0437\u0430 \u043a\u0430\u0436\u0434\u044b\u0439 SELECT, \u0442\u0430\u043a \u0447\u0442\u043e \u044d\u0442\u043e \u043d\u0430\u0441\u0442\u043e\u044f\u0449\u0435\u0435 \u0440\u0435\u0448\u0435\u043d\u0438\u0435 SaaS \u0441\u043e \u0432\u0441\u0435\u043c\u0438 \u0435\u0433\u043e \u043f\u043b\u044e\u0441\u0430\u043c\u0438 \u0438 \u043c\u0438\u043d\u0443\u0441\u0430\u043c\u0438. <\/p>\n<p>ClickHouse \u00ebsht\u00eb zgjidhja m\u00eb e mir\u00eb n\u00ebse po kryeni shum\u00eb k\u00ebrkesa t\u00eb shtrenjta n\u00eb m\u00ebnyr\u00eb llogarithmike. Sa m\u00eb shum\u00eb k\u00ebrkesa SELECT q\u00eb kryeni \u00e7do dit\u00eb, aq m\u00eb shum\u00eb ka kuptim t\u00eb z\u00ebvend\u00ebsoni Big Query me ClickHouse, sepse nj\u00eb z\u00ebvend\u00ebsim i till\u00eb do t'ju ndihmoj\u00eb t\u00eb kurseni mij\u00ebra dollar\u00eb kur flasim p\u00ebr shum\u00eb terabajt\u00eb t\u00eb dh\u00ebnash n\u00eb p\u00ebrpunim. Kjo nuk i referohet t\u00eb dh\u00ebnave t\u00eb ruajtura, p\u00ebrpunimi i t\u00eb cilave n\u00eb Big Query \u00ebsht\u00eb relativisht i lir\u00eb.<\/p>\n<p>N\u00eb artikullin e bashk\u00ebnd\u00ebrtuesit t\u00eb kompanis\u00eb Altinity, Aleksand\u00ebr Zajtsev <noindex><a rel=\"nofollow\" href=\"https:\/\/www.altinity.com\/blog\/2017\/10\/23\/migration-to-clickhouse\">\u00abKalim n\u00eb ClickHouse\u00bb<\/a><\/noindex> p\u00ebrshkruhen p\u00ebrfitimet e nj\u00eb migre t\u00eb till\u00eb t\u00eb DBMS.<\/p>\n<h3>Z\u00ebvend\u00ebsimi i TimescaleDB<\/h3>\n<p>\nTimescaleDB \u00ebsht\u00eb nj\u00eb zgjerim i PostgreSQL q\u00eb optimizon pun\u00ebn me serit\u00eb e koh\u00ebs (timeseries) n\u00eb nj\u00eb baz\u00eb t\u00eb dh\u00ebnash normale<noindex><a rel=\"nofollow\" href=\"https:\/\/docs.timescale.com\/v1.0\/introduction\">https:\/\/docs.timescale.com\/v1.0\/introduction<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/zabbix\/blog\/458530\/\">https:\/\/habr.com\/ru\/company\/zabbix\/blog\/458530\/<\/a><\/noindex>). <\/p>\n<p>Megjith\u00ebse ClickHouse nuk \u00ebsht\u00eb nj\u00eb konkurent i r\u00ebnd\u00ebsish\u00ebm n\u00eb ni\u015f\u00ebn e serive temporale, struktura kolone dhe ekzekutimi vektorial i k\u00ebrkesave e b\u00ebjn\u00eb at\u00eb shum\u00eb m\u00eb t\u00eb shpejt\u00eb se TimescaleDB n\u00eb shumic\u00ebn e rasteve t\u00eb p\u00ebrpunimit t\u00eb k\u00ebrkesave analitike. Performanca e pranimit t\u00eb t\u00eb dh\u00ebnave n\u00eb grupe nga ClickHouse \u00ebsht\u00eb rreth 3 her\u00eb m\u00eb e lart\u00eb, dhe p\u00ebr m\u00eb tep\u00ebr, ai p\u00ebrdor 20 her\u00eb m\u00eb pak hap\u00ebsir\u00eb disk, gj\u00eb q\u00eb \u00ebsht\u00eb me t\u00eb v\u00ebrtet\u00eb e r\u00ebnd\u00ebsishme p\u00ebr p\u00ebrpunimin e volumit t\u00eb madh t\u00eb t\u00eb dh\u00ebnave historike:<noindex><a rel=\"nofollow\" href=\"https:\/\/www.altinity.com\/blog\/ClickHouse-for-time-series\">https:\/\/www.altinity.com\/blog\/ClickHouse-for-time-series<\/a><\/noindex>.<\/p>\n<p>N\u00eb ndryshim nga ClickHouse, m\u00ebnyra e vetme p\u00ebr t\u00eb kursyer ndonj\u00eb hap\u00ebsir\u00eb disk n\u00eb TimescaleDB \u00ebsht\u00eb p\u00ebrdorimi i ZFS ose sistemeve t\u00eb ngjashme t\u00eb skedar\u00ebve.<\/p>\n<p>P\u00ebrdit\u00ebsimet e ardhshme t\u00eb ClickHouse, me siguri do t\u00eb prezantojn\u00eb kompresimin delta, i cili do ta b\u00ebj\u00eb at\u00eb edhe m\u00eb t\u00eb p\u00ebrshtatsh\u00ebm p\u00ebr p\u00ebrpunimin dhe ruajtjen e t\u00eb dh\u00ebnave t\u00eb serive temporale. TimescaleDB mund t\u00eb b\u00ebhet zgjedhja m\u00eb e mir\u00eb se \"ClickHouse i pap\u00ebrpunuar\" n\u00eb rastet e m\u00ebposhtme:<\/p>\n<ul>\n<li>instalime t\u00eb vogla me sasi shum\u00eb t\u00eb vog\u00ebl t\u00eb memorjes s\u00eb brendshme (&lt;3 GB);<\/li>\n<li>nj\u00eb num\u00ebr t\u00eb madh INSERT-esh t\u00eb vogla q\u00eb nuk d\u00ebshironi t'i bufferizoni n\u00eb fragmente t\u00eb m\u00ebdha;<\/li>\n<li>koherenc\u00eb m\u00eb e mir\u00eb, nj\u00eb form\u00eb dhe k\u00ebrkesa ACI;<\/li>\n<li>mb\u00ebshtetje p\u00ebr PostGIS;<\/li>\n<li>Integrimi me tabelat ekzistuese PostgreSQL, pasi n\u00eb thelb Timescale DB \u00ebsht\u00eb PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<h3>Konkurrenca me sistemet Hadoop dhe MapReduce<\/h3>\n<p>\nHadoop dhe produkte t\u00eb tjera MapReduce mund t\u00eb kryejn\u00eb shum\u00eb llogaritje komplekse, por zakonisht funksionojn\u00eb me vonesa t\u00eb m\u00ebdha. ClickHouse zgjidh k\u00ebt\u00eb problem duke trajtuar terabajt t\u00eb dh\u00ebnash dhe duke e nxjerr\u00eb rezultatin pothuajse menj\u00ebher\u00eb. K\u00ebshtu, ClickHouse \u00ebsht\u00eb shum\u00eb m\u00eb efektiv p\u00ebr kryerjen e studimeve analitike t\u00eb shpejta dhe interaktive, q\u00eb duhet t\u00eb t\u00ebrheq\u00eb specialist\u00ebt n\u00eb fush\u00ebn e p\u00ebrpunimit t\u00eb t\u00eb dh\u00ebnave.<\/p>\n<h3>Konkurrenca me Pinot dhe Druid<\/h3>\n<p>\nKonkurrent\u00ebt m\u00eb t\u00eb af\u00ebrt t\u00eb ClickHouse jan\u00eb produktet open source columnar dhe linear-scaling Pinot dhe Druid. Nj\u00eb krahasim i shk\u00eblqyer i k\u00ebtyre sistemeve \u00ebsht\u00eb publikuar n\u00eb artikullin <noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@leventov\/comparison-of-the-open-source-olap-systems-for-big-data-ClickHouse-druid-and-pinot-8e042a5ed1c7\">Roman Leventov<\/a><\/noindex> m\u00eb 1 shkurt 2018. <\/p>\n<p><img decoding=\"async\" alt=\"P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB.\" src=\"\/wp-content\/uploads\/2020\/01\/fe58814aa97b287b70c2f724b72b448a.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nKy artikull k\u00ebrkon p\u00ebrdit\u00ebsim \u2013 p\u00ebrmendet se ClickHouse nuk mb\u00ebshtet operacionet UPDATE dhe DELETE, q\u00eb nuk \u00ebsht\u00eb plot\u00ebsisht e sakt\u00eb p\u00ebr versionet e fundit.<\/p>\n<p>\u0423 \u043d\u0430\u0441 \u043d\u0435\u0442 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e\u0433\u043e \u043e\u043f\u044b\u0442\u0430 \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u044d\u0442\u0438\u043c\u0438 \u0421\u0423\u0411\u0414, \u043d\u043e \u043c\u043d\u0435 \u0441\u043e\u0432\u0441\u0435\u043c \u043d\u0435 \u043d\u0440\u0430\u0432\u0438\u0442\u0441\u044f \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u0439 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0437\u0430\u043f\u0443\u0441\u043a\u0430 Druid \u0438 Pinot \u00a0&#8212; \u044d\u0442\u043e \u0446\u0435\u043b\u0430\u044f \u043a\u0443\u0447\u0430 \u00ab\u043f\u043e\u0434\u0432\u0438\u0436\u043d\u044b\u0445 \u0447\u0430\u0441\u0442\u0435\u0439\u00bb, \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u043d\u044b\u0445 Java \u0441\u043e \u0432\u0441\u0435\u0445 \u0441\u0442\u043e\u0440\u043e\u043d.<\/p>\n<p>Druid dhe Pinot jan\u00eb projekte inkubator n\u00eb Apache, dhe zhvillimi i tyre \u00ebsht\u00eb ndjekur n\u00eb detaje nga Apache n\u00eb faqet e projekteve t\u00eb tyre n\u00eb GitHub. Pinot u shfaq n\u00eb inkubator n\u00eb tetor 2018, nd\u00ebrsa Druid u lind 8 muaj m\u00eb her\u00ebt \u2013 n\u00eb shkurt.<\/p>\n<p>Mungesa e informacionit mbi m\u00ebnyr\u00ebn se si funksionon AFS, m\u00eb ngre disa, ndoshta, pyetje t\u00eb \u00e7uditshme. \u00cbsht\u00eb interesante, a kan\u00eb v\u00ebn\u00eb re autor\u00ebt e Pinot se Fondacioni Apache \u00ebsht\u00eb m\u00eb i prirur ndaj Druid, dhe a ka shkaktuar nj\u00eb ndjenj\u00eb zili p\u00ebr konkurrenc\u00ebn? A do t\u00eb ngadal\u00ebsohet zhvillimi i Druid dhe do t\u00eb p\u00ebrshpejtohet zhvillimi i Pinot, n\u00ebse sponsor\u00ebt q\u00eb mb\u00ebshtesin t\u00eb parin, papritur interesohen p\u00ebr t\u00eb dytin?<\/p>\n<h3>Disavantazhet e ClickHouse<\/h3>\n<p>\nPjekuria: \u00ebsht\u00eb e qart\u00eb se kjo \u00ebsht\u00eb ende nj\u00eb teknologji e papjekur, por n\u00eb \u00e7do rast, nuk ka asgj\u00eb t\u00eb ngjashme n\u00eb DBMS t\u00eb tjera me kolona. <\/p>\n<p>Injektet e vogla funksionojn\u00eb keq me shpejt\u00ebsi t\u00eb lart\u00eb: injektet duhet t\u00eb ndahen n\u00eb pjes\u00eb t\u00eb m\u00ebdha, sepse performanca e injekteve t\u00eb vogla zvog\u00eblohet proporcionalisht me numrin e kolonave n\u00eb \u00e7do rresht. K\u00ebshtu ruhet t\u00eb dh\u00ebnat n\u00eb ClickHouse n\u00eb disk \u2014 \u00e7do kolon\u00eb p\u00ebrfaq\u00ebson 1 skedarin ose m\u00eb shum\u00eb, prandaj, p\u00ebr t\u00eb injektuar 1 rresht q\u00eb p\u00ebrmban 100 kolona, \u00ebsht\u00eb e nevojshme t\u00eb hapen dhe shkruhen t\u00eb pakt\u00ebn 100 skedar\u00eb. Prandaj, nevojitet nj\u00eb nd\u00ebrmjet\u00ebs p\u00ebr buferimin e injekteve (n\u00ebse klienti vet\u00eb nuk siguron buferimin) \u2014 zakonisht \u00ebsht\u00eb Kafka ose ndonj\u00eb sistem menaxhimi t\u00eb radh\u00ebve. Gjithashtu mund t\u00eb p\u00ebrdoret motori Buffer table p\u00ebr t\u00eb kopjuar m\u00eb von\u00eb fragmente t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave n\u00eb tabelat MergeTree.<\/p>\n<p>K\u00ebputjet e tabelave jan\u00eb t\u00eb kufizuara nga memoria operativ\u00eb e serverit, megjithat\u00eb, t\u00eb pakt\u00ebn, ato ekzistojn\u00eb atje! P\u00ebr shembull, Druid dhe Pinot nuk kan\u00eb fare k\u00ebto k\u00ebputje, duke qen\u00eb se \u00ebsht\u00eb e v\u00ebshtir\u00eb t'i implementosh drejtp\u00ebrdrejt n\u00eb sistemet e shp\u00ebrndara q\u00eb nuk mb\u00ebshtesin transferimin e copave t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave midis nyjave. <\/p>\n<h3>P\u00ebrfundimet<\/h3>\n<p>\nN\u00eb vitet n\u00eb vijim, ne planifikojm\u00eb t\u00eb p\u00ebrdorim gjer\u00ebsisht ClickHouse n\u00eb Qwintry, pasi kjo baz\u00eb e t\u00eb dh\u00ebnash ofron nj\u00eb balancim t\u00eb shk\u00eblqyer midis performanc\u00ebs, kostove t\u00eb ulta, shkall\u00ebzueshm\u00ebris\u00eb dhe thjesht\u00ebsis\u00eb. Jam pothuajse i sigurt se ajo do t\u00eb filloj\u00eb t\u00eb p\u00ebrhapet shpejt, sapo komuniteti ClickHouse t\u00eb gjej\u00eb m\u00eb shum\u00eb m\u00ebnyra p\u00ebr ta p\u00ebrdorur n\u00eb instalime t\u00eb vogla dhe t\u00eb mesme.<\/p>\n<h3>Pak reklam\u00eb \ud83d\ude42<\/h3>\n<p>\nFaleminderit q\u00eb q\u00ebndroni me ne. Ju p\u00eblqejn\u00eb artikujt tan\u00eb? D\u00ebshironi t\u00eb shihni m\u00eb shum\u00eb materiale interesante? Na mb\u00ebshtetni duke b\u00ebr\u00eb nj\u00eb porosi ose duke na rekomanduar njohurive tuaj, <noindex><a rel=\"nofollow\" href=\"https:\/\/ua-hosting.company\/cloudvps\/nl\">VPS cloud p\u00ebr zhvillues nga $4.99<\/a><\/noindex>, <b>nj\u00eb analog unik i server\u00ebve entry-level, i nd\u00ebrtuar p\u00ebr ju:<\/b> <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/company\/ua-hosting\/blog\/347386\/\">E gjith\u00eb e v\u00ebrteta rreth VPS (KVM) E5-2697 v3 (6 Nuclea) 10GB DDR4 480GB SSD 1Gbps nga $19 ose si ta ndajm\u00eb sakt\u00ebsisht serverin?<\/a><\/noindex> (disponohen variante me RAID1 dhe RAID10, deri n\u00eb 24 b\u00ebrthama dhe deri n\u00eb 40GB DDR4).<\/p>\n<p><b>Dell R730xd dyfish m\u00eb i lir\u00eb n\u00eb qendr\u00ebn e t\u00eb dh\u00ebnave Equinix Tier IV n\u00eb Amsterdam?<\/b> Vet\u00ebm k\u00ebtu <b><noindex><a rel=\"nofollow\" href=\"https:\/\/ua-hosting.company\/serversnl\">2 x Intel TetraDeca-Core Xeon 2x E5-2697v3 2.6GHz 14C 64GB DDR4 4x960GB SSD 1Gbps 100 TB nga $199<\/a><\/noindex> n\u00eb Holand\u00eb! <b>Dell R420 \u2014 2x E5-2430 2.2Ghz 6C 128GB DDR3 2x960GB SSD 1Gbps 100TB \u2014 nga $99!<\/b><\/b> Lexoni rreth <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/company\/ua-hosting\/blog\/329618\/\">Si t\u00eb nd\u00ebrtosh nj\u00eb infrastruktur\u00eb t\u00eb klas\u00ebs korporative me p\u00ebrdorimin e server\u00ebve Dell R730xd E5-2650 v4 me \u00e7mim prej 9000 euro p\u00ebr pak para?<\/a><\/noindex><br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/ua-hosting\/blog\/483112\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>Clickhouse \u2014 \u044d\u0442\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u043d\u043b\u0430\u0439\u043d \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 (OLAP) \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u0430\u044f \u042f\u043d\u0434\u0435\u043a\u0441\u043e\u043c. \u0415\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u042f\u043d\u0434\u0435\u043a\u0441, CloudFlare, VK.com, Badoo \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u0441\u0435\u0440\u0432\u0438\u0441\u044b \u043f\u043e \u0432\u0441\u0435\u043c\u0443 \u043c\u0438\u0440\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445 (\u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0442\u044b\u0441\u044f\u0447 \u0441\u0442\u0440\u043e\u043a \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443 \u0438\u043b\u0438 \u043f\u0435\u0442\u0430\u0431\u0430\u0439\u0442\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u044f\u0449\u0438\u0445\u0441\u044f \u043d\u0430 \u0434\u0438\u0441\u043a\u0435). \u0412 \u043e\u0431\u044b\u0447\u043d\u043e\u0439, \u00ab\u0441\u0442\u0440\u043e\u043a\u043e\u0432\u043e\u0439\u00bb \u0421\u0423\u0411\u0414, \u043f\u0440\u0438\u043c\u0435\u0440\u0430\u043c\u0438 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-54918","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Clickhouse \u2014 \u044d\u0442\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u043d\u043b\u0430\u0439\u043d \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 (OLAP) \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u0430\u044f \u042f\u043d\u0434\u0435\u043a\u0441\u043e\u043c. \u0415\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u042f\u043d\u0434\u0435\u043a\u0441, CloudFlare, VK.com, Badoo \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u0441\u0435\u0440\u0432\u0438\u0441\u044b \u043f\u043e \u0432\u0441\u0435\u043c\u0443 \u043c\u0438\u0440\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445 (\u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0442\u044b\u0441\u044f\u0447 \u0441\u0442\u0440\u043e\u043a \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443 \u0438\u043b\u0438 \u043f\u0435\u0442\u0430\u0431\u0430\u0439\u0442\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u044f\u0449\u0438\u0445\u0441\u044f \u043d\u0430 \u0434\u0438\u0441\u043a\u0435). \u0412 \u043e\u0431\u044b\u0447\u043d\u043e\u0439, \u00ab\u0441\u0442\u0440\u043e\u043a\u043e\u0432\u043e\u0439\u00bb \u0421\u0423\u0411\u0414, \u043f\u0440\u0438\u043c\u0435\u0440\u0430\u043c\u0438 \u043a\u043e\u0442\u043e\u0440\u044b\u0445\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 Clickhouse \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0437\u0430\u043c\u0435\u043d\u044b ELK, Big Query \u0438 TimescaleDB | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"Clickhouse \u2014 \u044d\u0442\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u043d\u043b\u0430\u0439\u043d \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 (OLAP) \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u0430\u044f \u042f\u043d\u0434\u0435\u043a\u0441\u043e\u043c. \u0415\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u042f\u043d\u0434\u0435\u043a\u0441, CloudFlare, VK.com, Badoo \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u0441\u0435\u0440\u0432\u0438\u0441\u044b \u043f\u043e \u0432\u0441\u0435\u043c\u0443 \u043c\u0438\u0440\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445 (\u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0442\u044b\u0441\u044f\u0447 \u0441\u0442\u0440\u043e\u043a \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443 \u0438\u043b\u0438 \u043f\u0435\u0442\u0430\u0431\u0430\u0439\u0442\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u044f\u0449\u0438\u0445\u0441\u044f \u043d\u0430 \u0434\u0438\u0441\u043a\u0435). \u0412 \u043e\u0431\u044b\u0447\u043d\u043e\u0439, \u00ab\u0441\u0442\u0440\u043e\u043a\u043e\u0432\u043e\u0439\u00bb \u0421\u0423\u0411\u0414, \u043f\u0440\u0438\u043c\u0435\u0440\u0430\u043c\u0438 \u043a\u043e\u0442\u043e\u0440\u044b\u0445\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-01-06T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T11:02:58+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47P\u00ebrdorimi i Clickhouse si z\u00ebvend\u00ebsim p\u00ebr ELK, Big Query dhe TimescaleDB | ProHoster","description":"Clickhouse \u00ebsht\u00eb nj\u00eb sistem i menaxhimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave kolumnar p\u00ebr p\u00ebrpunimin online t\u00eb k\u00ebrkesave analitike (OLAP) me burim t\u00eb hapur, i krijuar nga Yandex. Ajo p\u00ebrdoret nga Yandex, CloudFlare, VK.com, Badoo dhe sh\u00ebrbime t\u00eb tjera n\u00eb mbar\u00eb bot\u00ebn p\u00ebr t\u00eb ruajtur sasi jasht\u00ebzakonisht t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave (meq\u00eb po shtohen mij\u00ebra rreshta n\u00eb sekond\u00eb ose petabajt t\u00eb dh\u00ebnash q\u00eb ruhen n\u00eb disk). N\u00eb nj\u00eb baz\u00eb t\u00eb dh\u00ebnash","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 Clickhouse \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0437\u0430\u043c\u0435\u043d\u044b ELK, Big Query \u0438 TimescaleDB | ProHoster","og:description":"Clickhouse \u2014 \u044d\u0442\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432\u0430\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u043d\u043b\u0430\u0439\u043d \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 (OLAP) \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u0430\u044f \u042f\u043d\u0434\u0435\u043a\u0441\u043e\u043c. \u0415\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442 \u042f\u043d\u0434\u0435\u043a\u0441, CloudFlare, VK.com, Badoo \u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u0441\u0435\u0440\u0432\u0438\u0441\u044b \u043f\u043e \u0432\u0441\u0435\u043c\u0443 \u043c\u0438\u0440\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u043e\u0431\u044a\u0435\u043c\u043e\u0432 \u0434\u0430\u043d\u043d\u044b\u0445 (\u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0442\u044b\u0441\u044f\u0447 \u0441\u0442\u0440\u043e\u043a \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443 \u0438\u043b\u0438 \u043f\u0435\u0442\u0430\u0431\u0430\u0439\u0442\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0445\u0440\u0430\u043d\u044f\u0449\u0438\u0445\u0441\u044f \u043d\u0430 \u0434\u0438\u0441\u043a\u0435). \u0412 \u043e\u0431\u044b\u0447\u043d\u043e\u0439, \u00ab\u0441\u0442\u0440\u043e\u043a\u043e\u0432\u043e\u0439\u00bb \u0421\u0423\u0411\u0414, \u043f\u0440\u0438\u043c\u0435\u0440\u0430\u043c\u0438 \u043a\u043e\u0442\u043e\u0440\u044b\u0445","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/ispolzovanie-clickhouse-v-kachestve-zameny-elk-big-query-i-timescaledb","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-01-06T21:00:00+00:00","article:modified_time":"2020-02-18T11:02:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"54918","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-24 13:09:54","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 19:55:36","updated":"2026-01-24 13:09:54"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/54918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=54918"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/54918\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=54918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=54918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=54918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}