{"id":36737,"date":"2019-10-31T22:13:29","date_gmt":"2019-10-31T19:13:29","guid":{"rendered":"https:\/\/prohoster.info\/blog\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov\/"},"modified":"2019-10-31T22:13:29","modified_gmt":"2019-10-31T19:13:29","slug":"kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov","title":{"rendered":"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/14e07eac02df8d1276c46c33276d8a26.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nN\u00eb vitet e fundit, databazat e serive kohore (Time-series databases) jan\u00eb transformuar nga nj\u00eb gj\u00eb e pazakont\u00eb (q\u00eb aplikohej ve\u00e7an\u00ebrisht n\u00eb sistemet e monitorimit t\u00eb hapura, q\u00eb lidhej me zgjidhje specifike, ose n\u00eb projektet Big Data) n\u00eb nj\u00eb \"produkt t\u00eb konsumit t\u00eb p\u00ebrditsh\u00ebm\". N\u00eb territori i RF, p\u00ebr k\u00ebt\u00eb duhet falenderuar ve\u00e7an\u00ebrisht Yandex dhe ClickHouse. Para k\u00ebsaj, n\u00ebse kishit nevoj\u00eb t\u00eb ruani nj\u00eb sasi t\u00eb madhe t\u00eb t\u00eb dh\u00ebnave t\u00eb serive kohore, ishit t\u00eb detyruar ose t\u00eb pranoni nevoj\u00ebn p\u00ebr t\u00eb ngritur nj\u00eb stak monst\u00ebr Hadoop dhe p\u00ebr ta mbajtur at\u00eb, ose t\u00eb komunikoni me protokollet e ve\u00e7anta p\u00ebr \u00e7do sistem. <\/p>\n<p>Mund t\u00eb duket se n\u00eb vitin 2019, artikulli n\u00eb lidhje me at\u00eb se cila TSDB duhet t\u00eb p\u00ebrdoret, do t\u00eb p\u00ebrb\u00ebhet vet\u00ebm nga nj\u00eb fraz\u00eb: \"thjesht p\u00ebrdorni ClickHouse\". Por... ka nuanca. <\/p>\n<p>N\u00eb t\u00eb v\u00ebrtet\u00eb, ClickHouse po zhvillohet me shpejt\u00ebsi, baza e p\u00ebrdoruesve po rritet, dhe mb\u00ebshtetja \u00ebsht\u00eb shum\u00eb aktive, por a kemi r\u00ebn\u00eb n\u00eb kurthin e suksesit publik t\u00eb ClickHouse, i cili \u00ebsht\u00eb mbizot\u00ebruar nga zgjidhje t\u00eb tjera, ndoshta m\u00eb efektive\/t\u00eb besueshme? <\/p>\n<p>N\u00eb fillim t\u00eb vitit t\u00eb kaluar, ne filluam rip\u00ebrpunimin e sistemit ton\u00eb t\u00eb monitorimit, gjat\u00eb procesit t\u00eb t\u00eb cilit u paraqit pyetja p\u00ebr zgjedhjen e nj\u00eb baze t\u00eb p\u00ebrshtatshme p\u00ebr ruajtjen e t\u00eb dh\u00ebnave. Historia e k\u00ebsaj zgjedhjeje \u00ebsht\u00eb ajo q\u00eb d\u00ebshiroj t\u00eb ndaj k\u00ebtu.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>Vendosja e detyr\u00ebs<\/h4>\n<p>\nPara s\u00eb gjithash \u2014 nj\u00eb parafjal\u00eb e nevojshme. Pse na duhej neve nj\u00eb sistem monitorimi dhe si ishte i organizuar?<\/p>\n<p>Ne filluam t\u00eb ofronim sh\u00ebrbime mb\u00ebshtetjeje n\u00eb vitin 2008, dhe deri n\u00eb vitin 2010 u b\u00eb e qart\u00eb se ishte e v\u00ebshtir\u00eb t\u00eb grumbulloheshin t\u00eb dh\u00ebnat mbi proceset q\u00eb ndodhnin n\u00eb infrastruktur\u00ebn e klient\u00ebve, me zgjidhjet q\u00eb ishin t\u00eb disponueshme n\u00eb at\u00eb koh\u00eb (po flasim p\u00ebr, falni Zot, Cacti, Zabbix dhe Graphite q\u00eb po fillonte t\u00eb zhvillohej).<\/p>\n<p>K\u00ebrkesat tona kryesore ishin:<\/p>\n<ul>\n<li>mb\u00ebshtetje p\u00ebr (n\u00eb at\u00eb moment \u2014 dhjet\u00ebra, dhe n\u00eb perspektiv\u00eb \u2014 qindra) klient\u00eb brenda nj\u00eb sistemi dhe nj\u00eb koh\u00ebshtu duhet t\u00eb kishte nj\u00eb sistem qendror t\u00eb menaxhimit t\u00eb njoftimeve;<\/li>\n<li>fleksibilitet n\u00eb menaxhimin e sistemit t\u00eb njoftimeve (eskalimi i njoftimeve mes turneve, mbajtja e grafikut t\u00eb orarit, baza e njohurive);<\/li>\n<li>mund\u00ebsia p\u00ebr detajimin e thell\u00eb t\u00eb grafik\u00ebve (Zabbix n\u00eb at\u00eb koh\u00eb vizatonte grafik\u00ebt si imazhe);<\/li>\n<li>ruajtje afatgjat\u00eb e nj\u00eb sasie t\u00eb madhe t\u00eb dh\u00ebnash (nj\u00eb vit e m\u00eb shum\u00eb) dhe mund\u00ebsia e marrjes s\u00eb shpejt\u00eb t\u00eb tyre.<\/li>\n<\/ul>\n<p>\nN\u00eb k\u00ebt\u00eb artikull na intereson pika e fundit.<\/p>\n<p>Duke folur p\u00ebr ruajtjen, k\u00ebrkesat ishin si m\u00eb posht\u00eb:<\/p>\n<ul>\n<li>sistemi duhet t\u00eb punoj\u00eb shpejt;<\/li>\n<li>preferohet q\u00eb sistemi t\u00eb ket\u00eb nj\u00eb nd\u00ebrfaqe SQL;<\/li>\n<li>sistemi duhet t\u00eb jet\u00eb i q\u00ebndruesh\u00ebm dhe t\u00eb ket\u00eb nj\u00eb baz\u00eb aktive p\u00ebrdoruesish dhe mb\u00ebshtetje (nj\u00ebher\u00eb na ndodhi t\u00eb mb\u00ebshtesim sisteme si MemcacheDB, q\u00eb u ndal s\u00eb zhvilluari, ose ruajtja e shp\u00ebrndar\u00eb MooseFS, p\u00ebr t\u00eb cilin bug-tracker ishte n\u00eb kinezisht: nuk do d\u00ebshironim t\u00eb p\u00ebrs\u00ebrisnim k\u00ebt\u00eb histori p\u00ebr projektin ton\u00eb);<\/li>\n<li>p\u00ebrputhshm\u00ebria me teorem\u00ebn CAP: Consistency (e nevojshme) \u2014 t\u00eb dh\u00ebnat duhet t\u00eb jen\u00eb t\u00eb azhurnuara, nuk duam q\u00eb sistemi i menaxhimit t\u00eb njoftimeve t\u00eb mos marr\u00eb t\u00eb dh\u00ebna t\u00eb reja dhe t\u00eb l\u00ebshoj\u00eb alarme p\u00ebr munges\u00ebn e t\u00eb dh\u00ebnave nga t\u00eb gjitha projektet; Partition Tolerance (e nevojshme) \u2014 nuk duam t\u00eb p\u00ebrfundojm\u00eb me nj\u00eb sistem Split Brain; Disponueshm\u00ebria (jo kritike, n\u00eb rast se ekziston nj\u00eb replik\u00eb aktive) \u2014 mund t\u00eb kalojm\u00eb vet\u00eb n\u00eb sistemin rezerv\u00eb n\u00eb rast emergjence, me kod.<\/li>\n<\/ul>\n<p>\nSi e \u00e7uditshme, n\u00eb at\u00eb moment, zgjidhja ideale p\u00ebr ne u b\u00eb MySQL. Struktura jon\u00eb e t\u00eb dh\u00ebnave ishte ekstremisht e thjesht\u00eb: id e serverit, id e numrit t\u00eb mat\u00ebsit, timestamp dhe vlera; marrja e shpejt\u00eb e t\u00eb dh\u00ebnave t\u00eb nxehta u sigurua nga nj\u00eb madh\u00ebsi e madhe e buffer pool, nd\u00ebrsa marrja e t\u00eb dh\u00ebnave historike nga SSD.<\/p>\n<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/555bff26c74badf85131c4d9198871af.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nK\u00ebshtu, ne arrit\u00ebm t\u00eb merrnim t\u00eb dh\u00ebna t\u00eb fresk\u00ebta dyjavore, me detaje deri n\u00eb sekond\u00eb p\u00ebr 200 ms deri n\u00eb momentin e plot\u00eb t\u00eb vizatimit t\u00eb t\u00eb dh\u00ebnave, dhe jetonim n\u00eb k\u00ebt\u00eb sistem p\u00ebr nj\u00eb koh\u00eb t\u00eb gjat\u00eb.<\/p>\n<p>Nd\u00ebrkoh\u00eb, koha kalonte dhe sasia e t\u00eb dh\u00ebnave rritej. Deri n\u00eb vitin 2016, volumi i t\u00eb dh\u00ebnave arriti dhjet\u00ebra terabajt, q\u00eb n\u00eb kushtet e ruajtjes SSD me qira ishte nj\u00eb shpenzim t\u00eb konsideruesh\u00ebm.<\/p>\n<p>N\u00eb at\u00eb koh\u00eb, bazat e t\u00eb dh\u00ebnave kolona ishin p\u00ebrhapur gjer\u00ebsisht, p\u00ebr t\u00eb cilat filluam t\u00eb mendojm\u00eb aktivisht: n\u00eb bazat e t\u00eb dh\u00ebnave kolona, t\u00eb dh\u00ebnat ruhen, si\u00e7 mund ta kuptoni, n\u00eb kolona, dhe n\u00ebse i shikojm\u00eb t\u00eb dh\u00ebnat tona, leht\u00eb mund t\u00eb shohim nj\u00eb num\u00ebr t\u00eb madh kopjesh q\u00eb do t\u00eb mund t\u00eb kompresoheshin n\u00eb rastin e p\u00ebrdorimit t\u00eb nj\u00eb baze t\u00eb dh\u00ebnash kolona.<\/p>\n<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/2e1a6010fcb09de8cd28ec826752d160.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nMegjithat\u00eb, sistemi ky\u00e7 p\u00ebr pun\u00ebn e kompanis\u00eb vazhdoi t\u00eb funksionoj\u00eb stabilisht, dhe nuk d\u00ebshironim t\u00eb eksperimentohem me kalimin n\u00eb di\u00e7ka tjet\u00ebr.<\/p>\n<p>N\u00eb vitin 2017, n\u00eb konferenc\u00ebn Percona Live n\u00eb San Jose, zhvilluesit e Clickhouse, ndoshta p\u00ebr her\u00eb t\u00eb par\u00eb, e shprehen veten. N\u00eb pamje t\u00eb par\u00eb, sistemi dukej i gatsh\u00ebm p\u00ebr prodhim (n\u00eb t\u00eb v\u00ebrtet\u00eb, Yandex.Metrica \u00ebsht\u00eb nj\u00eb prodhim i fort\u00eb), mb\u00ebshtetjeja ishte e shpejt\u00eb dhe e thjesht\u00eb, dhe, m\u00eb e r\u00ebnd\u00ebsishmja, eksploatimi ishte i leht\u00eb. Q\u00eb nga viti 2018, filluam procesin e kalimit. Por deri at\u00ebher\u00eb kishte shum\u00eb sisteme TSDB q\u00eb kishin p\u00ebrvoj\u00eb dhe ishin t\u00eb provuara me koh\u00eb, prandaj vendos\u00ebm t\u00eb kushtojm\u00eb nj\u00eb koh\u00eb t\u00eb konsiderueshme dhe t\u00eb krahasojm\u00eb alternativat, p\u00ebr t'u siguruar q\u00eb nuk kishte zgjidhje alternative p\u00ebr Clickhouse q\u00eb p\u00ebrputheshin me k\u00ebrkesat tona.<\/p>\n<p>S\u00eb bashku me k\u00ebrkesat tashm\u00eb t\u00eb p\u00ebrmendura p\u00ebr depot e t\u00eb dh\u00ebnave, u shfaq\u00ebn edhe disa t\u00eb reja:<\/p>\n<ul>\n<li>sistemi i ri duhet t\u00eb siguroj\u00eb, t\u00eb pakt\u00ebn, t\u00eb nj\u00ebjtin performanc\u00eb si MySQL, me t\u00eb nj\u00ebjt\u00ebn sasi harduari;<\/li>\n<li>depoja e sistemit t\u00eb ri duhet t\u00eb z\u00eb ndjesh\u00ebm m\u00eb pak hap\u00ebsir\u00eb;<\/li>\n<li>SGBD-n\u00eb duhet t\u00eb vazhdoj\u00eb t\u00eb jet\u00eb e leht\u00eb p\u00ebr t'u menaxhuar;<\/li>\n<li>do t\u00eb donim ta ndryshonim sa m\u00eb pak aplikacionin gjat\u00eb kalimit n\u00eb SGBD-n\u00eb e re.<\/li>\n<\/ul>\n<p><\/p>\n<h4>Cilat sisteme filluam t\u00eb shqyrtojm\u00eb<\/h4>\n<p>\n<b><u>Apache Hive\/Apache Impala<\/u><\/b><br \/>\nNj\u00eb stak Hadoop, i provuar nga lufta. N\u00eb thelb, kjo \u00ebsht\u00eb nj\u00eb nd\u00ebrfaqe SQL, e nd\u00ebrtuar mbi ruajtjen e t\u00eb dh\u00ebnave n\u00eb formate t\u00eb veta n\u00eb HDFS. <\/p>\n<p>Pikat e forta.<\/p>\n<ul>\n<li>Me leht\u00ebson shum\u00eb zgjerimin e t\u00eb dh\u00ebnave gjat\u00eb funksionimit t\u00eb q\u00ebndruesh\u00ebm.<\/li>\n<li>Ka zgjidhje kolumne p\u00ebr ruajtjen e t\u00eb dh\u00ebnave (m\u00eb pak hap\u00ebsir\u00eb).<\/li>\n<li>Ekzekutim shum\u00eb i shpejt\u00eb i detyrave t\u00eb paralelizuara n\u00eb prani t\u00eb burimeve.<\/li>\n<\/ul>\n<p>\nDisavantazhet.<\/p>\n<ul>\n<li>Ky \u00ebsht\u00eb Hadoop, dhe \u00ebsht\u00eb i komplikuar p\u00ebr t'u administruar. N\u00ebse nuk jemi t\u00eb gatsh\u00ebm t\u00eb marrim nj\u00eb zgjidhje p\u00ebr k\u00ebt\u00eb n\u00eb re (dhe nuk jemi t\u00eb gatsh\u00ebm p\u00ebr shkak t\u00eb kostos), e gjith\u00eb staku do t\u00eb duhet t\u00eb p\u00ebrb\u00ebhet dhe t\u00eb mb\u00ebshtetet nga administrator\u00ebt, dhe kjo \u00ebsht\u00eb di\u00e7ka q\u00eb nuk e d\u00ebshirojm\u00eb.<\/li>\n<li>T\u00eb dh\u00ebnat agregohen <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/blog\/2014\/04\/21\/using-apache-hadoop-and-impala-together-with-mysql-for-data-analysis\/\">me t\u00eb v\u00ebrtet\u00eb shpejt<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>\nMegjithat\u00eb:<\/p>\n<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/6baa1b6024def8c1c7518ef386cfc8d3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nShpejt\u00ebsia arrihet duke zgjeruar numrin e server\u00ebve t\u00eb llogaritjes. Thjesht, n\u00ebse ne jemi nj\u00eb kompani e madhe, merremi me analiz\u00ebn dhe p\u00ebr biznesin \u00ebsht\u00eb kritikisht e r\u00ebnd\u00ebsishme t\u00eb agregojm\u00eb informacionin sa m\u00eb shpejt t\u00eb jet\u00eb e mundur (edhe me kushtin e p\u00ebrdorimit t\u00eb burimeve t\u00eb shumta t\u00eb llogaritjes) \u2014 ky mund t\u00eb jet\u00eb zgjedhja jon\u00eb. Por ne nuk ishim t\u00eb gatsh\u00ebm t\u00eb rritnim ndjesh\u00ebm parku i pajisjeve p\u00ebr shpejt\u00ebsin\u00eb e realizimit t\u00eb detyrave.<\/p>\n<p><b><u>Druid\/Pinot<\/u><\/b><\/p>\n<p>Tani \u00ebsht\u00eb shum\u00eb m\u00eb tep\u00ebr p\u00ebr TSDB-n\u00eb, por p\u00ebrs\u00ebri \u2014 stack-un Hadoop.<\/p>\n<p>Ka <noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@leventov\/comparison-of-the-open-source-olap-systems-for-big-data-clickhouse-druid-and-pinot-8e042a5ed1c7\">artikull shum\u00eb i mir\u00eb q\u00eb krahasohet me p\u00ebrpar\u00ebsit\u00eb dhe disavantazhet e Druid dhe Pinot n\u00eb krahasim me ClickHouse. <\/a><\/noindex>. <\/p>\n<p>N\u00eb disa fjal\u00eb: Druid\/Pinot duken m\u00eb t\u00eb mir\u00ebt se ClickHouse n\u00eb rastet kur:<\/p>\n<ul>\n<li>Keni nj\u00eb karakter t\u00eb heterogjen t\u00eb t\u00eb dh\u00ebnave (n\u00eb rastin ton\u00eb, ne regjistrojm\u00eb vet\u00ebm serit\u00eb temporale t\u00eb metrikave t\u00eb server\u00ebve, dhe, n\u00eb thelb, kjo \u00ebsht\u00eb nj\u00eb tabel\u00eb. Por mund t\u00eb ket\u00eb edhe raste t\u00eb tjera: serit\u00eb temporale t\u00eb pajisjeve, serit\u00eb ekonomike etj. \u2013 \u00e7do nj\u00ebra me struktur\u00ebn e saj, q\u00eb duhet t\u00eb agregohen dhe p\u00ebrpunohen).<\/li>\n<li>Megjithat\u00eb, k\u00ebto t\u00eb dh\u00ebna jan\u00eb shum\u00eb t\u00eb shumta.<\/li>\n<li>Tabelat dhe t\u00eb dh\u00ebnat me serit\u00eb temporale shfaqen dhe zhduken (pra, nj\u00eb grup i caktuar t\u00eb dh\u00ebnash erdhi, u analizua dhe u fshi).<\/li>\n<li>Nuk ka nj\u00eb kriter t\u00eb qart\u00eb, sipas t\u00eb cilit t\u00eb dh\u00ebnat mund t\u00eb ndahen n\u00eb pjes\u00eb.<\/li>\n<\/ul>\n<p>\nN\u00eb raste t\u00eb tjera, ClickHouse tregon performanc\u00eb m\u00eb t\u00eb mir\u00eb, dhe kjo \u00ebsht\u00eb rasti yn\u00eb.<\/p>\n<p><b><u>ClickHouse<\/u><\/b><\/p>\n<ul>\n<li>Si SQL.<\/li>\n<li>E leht\u00eb p\u00ebr menaxhim.<\/li>\n<li>Njer\u00ebzit thon\u00eb se funksionon.<\/li>\n<\/ul>\n<p>\nShkon n\u00eb list\u00ebn e shkurt\u00ebr p\u00ebr testim.<\/p>\n<p><b><u>InfluxDB<\/u><\/b><\/p>\n<p>Alternativa nd\u00ebrkomb\u00ebtare p\u00ebr ClickHouse. N\u00eb an\u00ebn negative: Disponueshm\u00ebria e Lart\u00eb \u00ebsht\u00eb vet\u00ebm n\u00eb versionin komercial, por duhet ta krahasojm\u00eb.<\/p>\n<p>Shkon n\u00eb list\u00ebn e shkurt\u00ebr p\u00ebr testim.<\/p>\n<p><b><u>Cassandra<\/u><\/b> <\/p>\n<p>Nga nj\u00ebra an\u00eb, ne e dim\u00eb se p\u00ebrdoret p\u00ebr ruajtjen e serive temporale metrikore nga sisteme monitorimi si, p\u00ebr shembull, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.signalfx.com\/blog\/making-cassandra-perform-as-a-tsdb\/\">SignalFX<\/a><\/noindex> apo OkMeter. Megjithat\u00eb, ka specifika.<\/p>\n<p>Cassandra nuk \u00ebsht\u00eb nj\u00eb baz\u00eb t\u00eb dh\u00ebnash kolonash n\u00eb kuptimin e saj tradicional. Duket m\u00eb shum\u00eb si nj\u00eb baz\u00eb t\u00eb dh\u00ebnash rreshtash, por n\u00eb \u00e7do rresht mund t\u00eb ket\u00eb nj\u00eb num\u00ebr t\u00eb ndrysh\u00ebm kolonesh, duke e b\u00ebr\u00eb t\u00eb leht\u00eb organizimin e nj\u00eb prezantimi kolonash. N\u00eb k\u00ebt\u00eb kuptim, \u00ebsht\u00eb e qart\u00eb se me nj\u00eb kufizim prej 2 miliard kolonesh, mund t\u00eb ruhen disa t\u00eb dh\u00ebna pik\u00ebrisht n\u00eb kolona (p\u00ebr shembull serit\u00eb temporale). P\u00ebr shembull, n\u00eb MySQL ka nj\u00eb kufizim prej 4096 kolonesh dhe aty \u00ebsht\u00eb leht\u00eb t\u00eb has\u00ebsh nj\u00eb gabim me kodin 1117, n\u00ebse p\u00ebrpiqesh t\u00eb b\u00ebsh t\u00eb nj\u00ebjt\u00ebn gj\u00eb.<\/p>\n<p>Motorri Cassandra \u00ebsht\u00eb i fokusuar n\u00eb ruajtjen e volumesh t\u00eb m\u00ebdha t\u00eb dh\u00ebnash n\u00eb nj\u00eb sistem t\u00eb shp\u00ebrndar\u00eb pa nj\u00eb master, dhe n\u00eb teorem\u00ebn e p\u00ebrmendur CAP, Cassandra \u00ebsht\u00eb m\u00eb shum\u00eb n\u00eb lidhje me AP, q\u00eb do t\u00eb thot\u00eb disponueshm\u00ebrin\u00eb e dh\u00ebnave dhe q\u00ebndrueshm\u00ebrin\u00eb ndaj ndarje-s\u00eb s\u00eb partitive. K\u00ebshtu, ky instrument mund t\u00eb jet\u00eb i shk\u00eblqyer n\u00ebse duhet t\u00eb shkruani vet\u00ebm n\u00eb k\u00ebt\u00eb baz\u00eb dhe lexoni mjaft rrall\u00eb nga ajo. N\u00eb k\u00ebt\u00eb rast, \u00ebsht\u00eb logjike t\u00eb p\u00ebrdoret Cassandra si nj\u00eb depo \u201ct\u00eb ftoht\u00eb\u201d. Pra, si nj\u00eb vend i besuesh\u00ebm p\u00ebr ruajtjen e p\u00ebrkohshme t\u00eb sasis\u00eb t\u00eb madhe t\u00eb dh\u00ebnash historike, t\u00eb cilat k\u00ebrkohen rrall\u00eb, por q\u00eb mund t\u00eb nxirren kur \u00ebsht\u00eb e nevojshme. Megjithat\u00eb, p\u00ebr t\u00eb par\u00eb t\u00eb gjith\u00eb pamjen, do ta testojm\u00eb edhe at\u00eb. Por, si\u00e7 e kam th\u00ebn\u00eb m\u00eb par\u00eb, nuk kam d\u00ebshir\u00eb t\u00eb riprogramoj aktivisht kodin p\u00ebr zgjidhjen e zgjedhur t\u00eb DB, k\u00ebshtu q\u00eb do ta testojm\u00eb at\u00eb n\u00eb m\u00ebnyr\u00eb disi t\u00eb kufizuar \u2014 pa adaptimin e struktur\u00ebs s\u00eb baz\u00ebs sipas specifikave t\u00eb Cassandra.<\/p>\n<p><b><u>Prometheus<\/u><\/b><\/p>\n<p>Po ashtu, nga kurioziteti, vendos\u00ebm t\u00eb testojm\u00eb performanc\u00ebn e ruajtjes Prometheus \u2014 thjesht p\u00ebr t\u00eb kuptuar n\u00ebse jemi m\u00eb t\u00eb shpejt\u00eb se zgjidhjet aktuale apo m\u00eb t\u00eb ngadalt\u00eb dhe sa.<\/p>\n<h4>Metodika dhe rezultatet e testimit<\/h4>\n<p>\nPra fituam, ne kemi testuar 5 baza t\u00eb dh\u00ebnash n\u00eb 6 konfiguracione t\u00eb ndryshme: ClickHouse (1 nod), ClickHouse (tabela e shp\u00ebrndar\u00eb n\u00eb 3 node), InfluxDB, Mysql 8, Cassandra (3 node) dhe Prometheus. Plani i testimit \u00ebsht\u00eb si m\u00eb posht\u00eb:<\/p>\n<ol>\n<li>ngarkojm\u00eb t\u00eb dh\u00ebna historike p\u00ebr nj\u00eb jav\u00eb (840 milion vlera n\u00eb dit\u00eb; 208 mij\u00eb metrika);<\/li>\n<li>gjenerojm\u00eb ngarkes\u00eb n\u00eb shkrim (kemi shqyrtuar 6 skema ngarkese, shih m\u00eb posht\u00eb);<\/li>\n<li>paralelisht me shkrimin, her\u00eb pas here b\u00ebjm\u00eb mostrat, duke simuluar pyetje nga p\u00ebrdoruesi q\u00eb punon me grafike. P\u00ebr t\u00eb mos e komplikuar shum\u00eb, zgjodh\u00ebm t\u00eb dh\u00ebnat p\u00ebr 10 metrika (aq sa ka n\u00eb grafikun e CPU) p\u00ebr jav\u00ebn.<\/li>\n<\/ol>\n<p>\nNgarkojm\u00eb, duke simuluar sjelljen e agjentit ton\u00eb t\u00eb monitorimit, i cili d\u00ebrgon n\u00eb \u00e7do metrik\u00eb vlerat \u00e7do 15 sekonda. N\u00eb k\u00ebt\u00eb rast, na intereson t\u00eb varirojm\u00eb:<\/p>\n<ul>\n<li>numrin e p\u00ebrgjithsh\u00ebm t\u00eb metrikave q\u00eb shkruhen t\u00eb dh\u00ebna;<\/li>\n<li>intervalin e d\u00ebrgimit t\u00eb vlerave n\u00eb nj\u00eb metrik\u00eb;<\/li>\n<li>shk\u00eblqimin e paket\u00ebs.<\/li>\n<\/ul>\n<p>\nP\u00ebr madh\u00ebsin\u00eb e paket\u00ebs. Duke qen\u00eb se pothuajse t\u00eb gjitha bazat tona t\u00eb testuara nuk rekomandohet t\u00eb ngarkohen me inserte t\u00eb vetme, na nevojitet nj\u00eb rregullator q\u00eb mbledh metrikat e ardhura dhe i grupon p\u00ebr disa dhe i shkruan n\u00eb baz\u00eb me inserte t\u00eb paketuar.<\/p>\n<p>Po ashtu, p\u00ebr t\u00eb kuptuar m\u00eb mir\u00eb se si t\u00eb interpretojm\u00eb t\u00eb dh\u00ebnat e marra, le t\u00eb imagjinojm\u00eb se nuk po d\u00ebrgojm\u00eb thjesht nj\u00eb grusht metrike, por metrike t\u00eb organizuara n\u00eb servera \u2014 125 metrika p\u00ebr server. K\u00ebtu serveri \u00ebsht\u00eb thjesht nj\u00eb entitet virtual \u2014 n\u00eb m\u00ebnyr\u00eb q\u00eb t\u00eb kuptojm\u00eb se, p\u00ebr shembull, 10000 metrika p\u00ebrputhen n\u00eb m\u00ebnyr\u00eb t\u00eb p\u00ebraf\u00ebrt me rreth 80 servera.<\/p>\n<p>Dhe tani, duke marr\u00eb parasysh gjith\u00e7ka, kemi 6 modet e ngarkes\u00ebs t\u00eb baz\u00ebs n\u00eb shkrim:<\/p>\n<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/3ba70050dc7e711cb8f3d14ac1a6707b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nK\u00ebtu jan\u00eb dy aspekte. S\u00eb pari, p\u00ebr Cassandra k\u00ebto dimensione t\u00eb grupeve rezultuan tep\u00ebr t\u00eb m\u00ebdha, aty kemi p\u00ebrdorur vlera 50 ose 100. Dhe s\u00eb dyti, p\u00ebrderisa Prometheus punon ndryshe n\u00eb m\u00ebnyr\u00eb pull, dmth. vet\u00eb shkon dhe merr t\u00eb dh\u00ebnat nga burimet e metrikeve (madje edhe pushgateway, pavar\u00ebsisht emrit, nuk ndryshon asgj\u00eb), ngarkesat p\u00ebrkat\u00ebse u realizuan me nj\u00eb kombinim t\u00eb konfigurimeve statike.<\/p>\n<p>Rezultatet e testimit jan\u00eb k\u00ebto:<\/p>\n<p><img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/9df12bee66ad8c5df720ba08472efead.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/891090bf0461c7e3c48e38eb36f9e217.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Si testuam disa baza t\u00eb dh\u00ebnash p\u00ebr seri kohore\" src=\"\/wp-content\/uploads\/2019\/08\/137f944b3578ab5bad4ebc5fa6f96b79.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b>\u00c7ka \u00ebsht\u00eb e r\u00ebnd\u00ebsishme t\u00eb theksohet<\/b>: t\u00ebrheqje fantastikisht t\u00eb shpejta nga Prometheus, t\u00ebrheqje t\u00eb ngadalta nga Cassandra, dhe t\u00ebrheqje t\u00eb papranueshme nga InfluxDB; n\u00eb shpejt\u00ebsin\u00eb e shkarkimit, ClickHouse doli fitues, nd\u00ebrsa Prometheus nuk merr pjes\u00eb n\u00eb gar\u00eb, sepse realizon insertet brenda vetes dhe ne nuk masim asgj\u00eb.<\/p>\n<p><u><b>Si rezultat<\/b><\/u>: ClickHouse dhe InfluxDB treguan performanc\u00ebn m\u00eb t\u00eb mir\u00eb, por nj\u00eb kluster nga Influx mund t\u00eb nd\u00ebrtohet vet\u00ebm mbi baz\u00ebn e versionit Enterprise, i cili ka nj\u00eb kosto, nd\u00ebrsa ClickHouse \u00ebsht\u00eb falas dhe \u00ebsht\u00eb krijuar n\u00eb Rusi. Logjikisht, n\u00eb SHBA, ndoshta zgjedhja \u00ebsht\u00eb n\u00eb favor t\u00eb InfluxDB, nd\u00ebrsa k\u00ebtu \u00ebsht\u00eb p\u00ebr ClickHouse.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/itsumma\/blog\/462111\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0417\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043b\u0435\u0442 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 (Time-series databases) \u043f\u0440\u0435\u0432\u0440\u0430\u0442\u0438\u043b\u0438\u0441\u044c \u0438\u0437 \u0434\u0438\u043a\u043e\u0432\u0438\u043d\u043d\u043e\u0439 \u0448\u0442\u0443\u043a\u0438 (\u0443\u0437\u043a\u043e\u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0435\u0439\u0441\u044f \u043b\u0438\u0431\u043e \u0432 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 (\u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0439 \u043a \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u044f\u043c), \u043b\u0438\u0431\u043e \u0432 Big Data \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445) \u0432 \u00ab\u0442\u043e\u0432\u0430\u0440 \u043d\u0430\u0440\u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f\u00bb. \u041d\u0430 \u0442\u0435\u0440\u0440\u0438\u0442\u043e\u0440\u0438\u0438 \u0420\u0424 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0441\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u044d\u0442\u043e \u043d\u0430\u0434\u043e \u0441\u043a\u0430\u0437\u0430\u0442\u044c \u042f\u043d\u0434\u0435\u043a\u0441\u0443 \u0438 ClickHouse\u2019\u0443. \u0414\u043e \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u0431\u044b\u043b\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27518,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0417\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043b\u0435\u0442 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 (Time-series databases) \u043f\u0440\u0435\u0432\u0440\u0430\u0442\u0438\u043b\u0438\u0441\u044c \u0438\u0437 \u0434\u0438\u043a\u043e\u0432\u0438\u043d\u043d\u043e\u0439 \u0448\u0442\u0443\u043a\u0438 (\u0443\u0437\u043a\u043e\u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0435\u0439\u0441\u044f \u043b\u0438\u0431\u043e \u0432 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 (\u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0439 \u043a \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u044f\u043c), \u043b\u0438\u0431\u043e \u0432 Big Data \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445) \u0432 \u00ab\u0442\u043e\u0432\u0430\u0440 \u043d\u0430\u0440\u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f\u00bb. \u041d\u0430 \u0442\u0435\u0440\u0440\u0438\u0442\u043e\u0440\u0438\u0438 \u0420\u0424 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0441\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u044d\u0442\u043e \u043d\u0430\u0434\u043e \u0441\u043a\u0430\u0437\u0430\u0442\u044c \u042f\u043d\u0434\u0435\u043a\u0441\u0443 \u0438 ClickHouse\u2019\u0443. \u0414\u043e \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u0431\u044b\u043b\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c\" \/>\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\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\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\u041a\u0430\u043a \u043c\u044b \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0417\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043b\u0435\u0442 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 (Time-series databases) \u043f\u0440\u0435\u0432\u0440\u0430\u0442\u0438\u043b\u0438\u0441\u044c \u0438\u0437 \u0434\u0438\u043a\u043e\u0432\u0438\u043d\u043d\u043e\u0439 \u0448\u0442\u0443\u043a\u0438 (\u0443\u0437\u043a\u043e\u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0435\u0439\u0441\u044f \u043b\u0438\u0431\u043e \u0432 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 (\u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0439 \u043a \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u044f\u043c), \u043b\u0438\u0431\u043e \u0432 Big Data \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445) \u0432 \u00ab\u0442\u043e\u0432\u0430\u0440 \u043d\u0430\u0440\u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f\u00bb. \u041d\u0430 \u0442\u0435\u0440\u0440\u0438\u0442\u043e\u0440\u0438\u0438 \u0420\u0424 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0441\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u044d\u0442\u043e \u043d\u0430\u0434\u043e \u0441\u043a\u0430\u0437\u0430\u0442\u044c \u042f\u043d\u0434\u0435\u043a\u0441\u0443 \u0438 ClickHouse\u2019\u0443. \u0414\u043e \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u0431\u044b\u043b\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov\" \/>\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=\"2019-10-31T19:13:29+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:13:29+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\udd47Si e testuam disa baza t\u00eb dh\u00ebnash p\u00ebr serit\u00eb e koh\u00ebs | ProHoster","description":"Gjat\u00eb viteve t\u00eb fundit, bazat e t\u00eb dh\u00ebnave p\u00ebr serit\u00eb e koh\u00ebs (Time-series databases) jan\u00eb shnd\u00ebrruar nga nj\u00eb gj\u00eb e \u00e7uditshme (p\u00ebrdorur ngusht\u00ebsisht ose n\u00eb sistemet e hapura t\u00eb monitorimit (dhe t\u00eb lidhura me zgjidhje t\u00eb caktuara), ose n\u00eb projektet Big Data) n\u00eb \"mall p\u00ebr konsumatorin e zakonsh\u00ebm\". N\u00eb territorin e RF, atyre duhet t'u shprehim fal\u00ebnderime t\u00eb ve\u00e7anta Yandex-it dhe ClickHouse-it. Para k\u00ebtij momenti, n\u00ebse ju nevojitej t\u00eb ruanit","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov","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\u041a\u0430\u043a \u043c\u044b \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 | ProHoster","og:description":"\u0417\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043b\u0435\u0442 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u044f\u0434\u043e\u0432 (Time-series databases) \u043f\u0440\u0435\u0432\u0440\u0430\u0442\u0438\u043b\u0438\u0441\u044c \u0438\u0437 \u0434\u0438\u043a\u043e\u0432\u0438\u043d\u043d\u043e\u0439 \u0448\u0442\u0443\u043a\u0438 (\u0443\u0437\u043a\u043e\u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044e\u0449\u0435\u0439\u0441\u044f \u043b\u0438\u0431\u043e \u0432 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 (\u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0439 \u043a \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u043c \u0440\u0435\u0448\u0435\u043d\u0438\u044f\u043c), \u043b\u0438\u0431\u043e \u0432 Big Data \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445) \u0432 \u00ab\u0442\u043e\u0432\u0430\u0440 \u043d\u0430\u0440\u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u0435\u043d\u0438\u044f\u00bb. \u041d\u0430 \u0442\u0435\u0440\u0440\u0438\u0442\u043e\u0440\u0438\u0438 \u0420\u0424 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0441\u043f\u0430\u0441\u0438\u0431\u043e \u0437\u0430 \u044d\u0442\u043e \u043d\u0430\u0434\u043e \u0441\u043a\u0430\u0437\u0430\u0442\u044c \u042f\u043d\u0434\u0435\u043a\u0441\u0443 \u0438 ClickHouse\u2019\u0443. \u0414\u043e \u044d\u0442\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430, \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u0431\u044b\u043b\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-my-testirovali-neskolko-baz-dannyh-vremennyh-ryadov","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":"2019-10-31T19:13:29+00:00","article:modified_time":"2019-10-31T19:13:29+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36737","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-22 04:38:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:39:24","updated":"2026-01-22 04:38:20","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36737","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=36737"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36737\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/27518"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=36737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=36737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=36737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}