{"id":95999,"date":"2020-10-06T13:41:58","date_gmt":"2020-10-06T11:41:58","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/poka-vse-prazdnovali-moj-den-rozhdeniya-ya-do-utra-chinil-klaster-a-razraby-valili-na-menya-svoi-oshibki"},"modified":"2020-10-06T13:41:58","modified_gmt":"2020-10-06T11:41:58","slug":"poka-vse-prazdnovali-moj-den-rozhdeniya-ya-do-utra-chinil-klaster-a-razraby-valili-na-menya-svoi-oshibki","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/poka-vse-prazdnovali-moj-den-rozhdeniya-ya-do-utra-chinil-klaster-a-razraby-valili-na-menya-svoi-oshibki","title":{"rendered":"Nd\u00ebrsa t\u00eb gjith\u00eb festonin dit\u00eblindjen time, un\u00eb po riparova grupin deri n\u00eb m\u00ebngjes \u2014 zhvilluesit m\u00eb dor\u00ebzuan gabimet e tyre.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"Nd\u00ebrsa
\n
\nK\u00ebtu \u00ebsht\u00eb nj\u00eb histori q\u00eb ndryshoi p\u00ebrher\u00eb qasjen time ndaj pun\u00ebs s\u00eb DevOps. Edhe n\u00eb koh\u00ebn para COVID-it, shum\u00eb koh\u00eb p\u00ebrpara, kur ne dhe djemt\u00eb po mendonim p\u00ebr biznesin ton\u00eb dhe bam\u00eb projekte t\u00eb rastit si freelancer, m\u00eb ra nj\u00eb propozim n\u00eb Telegram. <\/p>\n

Kompania q\u00eb e shkroi, merrej me analiz\u00eb t\u00eb t\u00eb dh\u00ebnave. Ajo p\u00ebrpunonte mij\u00ebra k\u00ebrkesa \u00e7do dit\u00eb. K\u00ebtu erdh\u00ebn me fjal\u00ebt: djem, kemi ClickHouse dhe duam ta automatizojm\u00eb konfigurimin dhe instalimin e tij. Duam Ansible, Terraform, Docker dhe q\u00eb gjith\u00e7ka t\u00eb ruhet n\u00eb Git. Duam nj\u00eb grup me kat\u00ebr nodo me nga dy replika n\u00eb secil\u00ebn. <\/p>\n

K\u00ebrkesa standarde, ka dhjet\u00ebra t\u00eb tilla, dhe ne duheshim t\u00eb ofronim nj\u00eb zgjidhje standarde t\u00eb till\u00eb t\u00eb mir\u00eb. Ne tham\u00eb \"mir\u00eb\", dhe pas 2-3 jav\u00ebsh gjith\u00e7ka ishte gati. Ata pranuan pun\u00ebn dhe filluan t\u00eb kalonin n\u00eb grupin e ri t\u00eb ClickHouse me ndihm\u00ebn e utilitetit ton\u00eb.
\n<\/a><\/noindex>
\nAskush nuk kishte d\u00ebshir\u00eb dhe nuk dinte t\u00eb merrej me Clickhouse. At\u00ebher\u00eb menduam se kjo ishte problemi i tyre kryesor, dhe p\u00ebr k\u00ebt\u00eb arsye, CTO i kompanis\u00eb thjesht i dha komand\u00ebn ekipit tim q\u00eb t\u00eb \u0430\u0432\u0442\u043e\u043c\u0430\u0442izonte maksimalisht pun\u00ebn, q\u00eb t\u00eb mos e shkelnim m\u00eb atje kurr\u00eb.<\/p>\n

Ne ndoq\u00ebm transferimin, u shfaq\u00ebn detyra t\u00eb tjera \u2014 t\u00eb vendosnim backupet dhe monitorimin. N\u00eb at\u00eb moment, CTO i k\u00ebsaj kompanie kaloi n\u00eb projekt tjet\u00ebr, duke na l\u00ebn\u00eb n\u00ebn komand\u00eb nj\u00eb nga ata \u2014 Leonidin. L\u0451nja nuk ishte ndonj\u00eb djal\u00eb shum\u00eb i talentuar. Nj\u00eb zhvillues i zakonsh\u00ebm, t\u00eb cilin papritur e em\u00ebruan krye te Clickhouse. Duket se ishte em\u00ebrimi i tij i par\u00eb p\u00ebr t\u00eb drejtuar di\u00e7ka, dhe nga nderi q\u00eb iu ngarkua, ai filloi t\u00eb zhvillonte sindrom\u00ebn e yjeve. <\/p>\n

S\u00eb bashku filluam me backupet. Un\u00eb propozova q\u00eb t\u00eb b\u00ebhej menj\u00ebher\u00eb backup i t\u00eb dh\u00ebnave t\u00eb origjin\u00ebs. Thjesht ta merrnim, ta ziponim dhe ta vendosnim elegantisht n\u00eb ndonj\u00eb s3. T\u00eb dh\u00ebnat e origjin\u00ebs \u2014 jan\u00eb ar. Ishte edhe nj\u00eb opsion tjet\u00ebr \u2014 t\u00eb b\u00ebhej backup i vet\u00eb tabelave n\u00eb Clickhouse, duke p\u00ebrdorur ngrirjen dhe kopjimin. Por L\u0451nja erdhi me zgjidhjen e tij.<\/p>\n

Ai shpallur se na nevojitet nj\u00eb grup i dyt\u00eb i Clickhouse. Q\u00eb nga tani do t\u00eb shkruajm\u00eb t\u00eb dh\u00ebnat n\u00eb dy grupe \u2014 grupin kryesor dhe at\u00eb rezerv\u00eb. I thash\u00eb, Leonia, se do t\u00eb dal\u00eb jo rezerva \u2014 por nj\u00eb replik\u00eb aktive. Dhe n\u00ebse t\u00eb dh\u00ebnat fillojn\u00eb t\u00eb humbin n\u00eb prodhim, n\u00eb rezerv\u00ebn t\u00ebnde do t\u00eb ndodh\u00eb e nj\u00ebjta gj\u00eb. <\/p>\n

Por Leonia e mbajti fort timonin dhe refuzoi t\u00eb d\u00ebgjonte arsyetimet e mia. Ne u zvarrit\u00ebm p\u00ebr nj\u00eb koh\u00eb n\u00eb bised\u00eb, por nuk kishim \u00e7far\u00eb t\u00eb b\u00ebnim \u2014 Leonia po udh\u00ebheqte projektin, ne ishim thjesht djem t\u00eb angazhuar nga rruga.<\/p>\n

Ne po monitoronim gjendjen e grupit dhe merrnim pages\u00eb vet\u00ebm p\u00ebr pun\u00ebn e administrator\u00ebve. Administrimi i past\u00ebr i Clickhouse pa nd\u00ebrhyrje n\u00eb t\u00eb dh\u00ebna. Grupi ishte n\u00eb dispozicion, disku ishte n\u00eb rregull, nodet ishin n\u00eb rregull. <\/p>\n

Ne nuk dyshonim akoma se kishim marr\u00eb k\u00ebt\u00eb porosi p\u00ebr shkak t\u00eb nj\u00eb keqkuptimi t\u00eb tmerrsh\u00ebm brenda ekipit t\u00eb tyre.<\/h3>\n

\nShefi ishte i pak\u00ebnaqur se Clickhouse punonte ngadal\u00eb dhe ndonj\u00ebher\u00eb humbeshin t\u00eb dh\u00ebna. Ai i dha CTO-s\u00eb s\u00eb tij detyr\u00ebn t\u00eb merret me k\u00ebt\u00eb. Ai u p\u00ebrpoq si\u00e7 mundi dhe arriti n\u00eb p\u00ebrfundimin se duhet thjesht ta automatizojm\u00eb Clickhouse \u2014 dhe kaq. Por si\u00e7 doli m\u00eb von\u00eb, ata kishin nevoj\u00eb p\u00ebr nj\u00eb ekip krejtesisht ndryshe devops.<\/p>\n

E gjitha kjo doli shum\u00eb, shum\u00eb e dhimbshme. Dhe m\u00eb e pak\u00ebndshme, ndodhi n\u00eb dit\u00eblindjen time.<\/p>\n

\nE premte, mbr\u00ebmje. Kam rezervuar nj\u00eb tavolin\u00eb n\u00eb barin tim t\u00eb preferuar t\u00eb ver\u00ebs dhe thirra shok\u00ebt. <\/p>\n

Gati p\u00ebr t\u00eb dal\u00eb, na erdhi nj\u00eb detyr\u00eb p\u00ebr t\u00eb b\u00ebr\u00eb nj\u00eb alternativ\u00eb, ne e kryem, gjith\u00e7ka ishte n\u00eb rregull. Alternativa kaloi, ClickHouse e konfirmoi. Ne ishim gati p\u00ebr n\u00eb bar, dhe na shkruajn\u00eb se t\u00eb dh\u00ebnat mungojn\u00eb. Llogarit\u00ebm - dukej se kishte gjith\u00e7ka. Dhe u larguam p\u00ebr t\u00eb festuar.<\/p>\n

N\u00eb restorant ishte zhurmsh\u00ebm si zakonisht p\u00ebr t\u00eb premten. Pas porosis\u00eb s\u00eb pijes, ushqimit, u shtr\u00ebnguam n\u00eb divan. Gjat\u00eb gjith\u00eb k\u00ebsaj kohe, Slack-u im filloi t\u00eb boshll\u00ebqehet me mesazhe. Shkruanin di\u00e7ka p\u00ebr munges\u00ebn e t\u00eb dh\u00ebnave. Mendova - m\u00ebngjesi \u00ebsht\u00eb m\u00eb i men\u00e7ur se mbr\u00ebmja. Sidomos sot.<\/p>\n

Af\u00ebrsisht n\u00eb or\u00ebn nj\u00ebmb\u00ebdhjet\u00eb filluan t\u00eb telefonojn\u00eb. Ishte drejtori i kompanis\u00eb... 'Ndoshta vendosi t\u00eb m\u00eb uroj\u00eb,' mendoja shum\u00eb pa siguri, dhe e ngrita telefonin.<\/p>\n

Dhe d\u00ebgjova di\u00e7ka n\u00eb frym\u00ebn e: 'Keni humbur t\u00eb dh\u00ebnat tona! Po ju paguaj, por asgj\u00eb nuk punon! Ju ishit p\u00ebrgjegj\u00ebs p\u00ebr backup-et, dhe nuk keni b\u00ebr\u00eb asgj\u00eb! Lajm\u00ebroni!' - vet\u00ebm edhe m\u00eb ashp\u00ebr.<\/p>\n

\u2014 E di \u00e7a, ik shkoj p\u00ebr dreq! Sot \u00ebsht\u00eb dita ime e lindjes dhe tani do t\u00eb pi, e jo t\u00eb merrem me eksperimentet tuaja amatoreske me pisll\u00ebk!<\/p>\n

K\u00ebshtu nuk thash\u00eb. N\u00eb vend t\u00eb k\u00ebsaj, nxora laptopin dhe fillova t\u00eb punoj.<\/p>\n

Jo, un\u00eb isha shum\u00eb i zem\u00ebruar, isha jasht\u00ebzakonisht i zem\u00ebruar! G\u00ebrdhisja n\u00eb chat mesazhe t\u00eb hidhura \"e thash\u00eb un\u00eb\" - sepse backup-i q\u00eb nuk ishte fare backup, natyrisht, nuk shp\u00ebtoi asgj\u00eb. <\/p>\n

Me djemt\u00eb e mi shpik\u00ebm se si t\u00eb ndalonim regjistrimin manualisht dhe t\u00eb kontrollonim gjith\u00e7ka. Me t\u00eb v\u00ebrtet\u00eb u siguruam q\u00eb nj\u00eb pjes\u00eb e t\u00eb dh\u00ebnave nuk po shkruhej.<\/p>\n

Ndaluam regjistrimin, num\u00ebruam ngjarjet q\u00eb kishte p\u00ebr nj\u00eb dit\u00eb. Shtuam m\u00eb shum\u00eb t\u00eb dh\u00ebna, nga t\u00eb cilat vet\u00ebm nj\u00eb t\u00eb tret\u00ebn nuk u regjistruan. Tre sharde me 2 replika. Vendosni 100,000 rreshta - 33,000 nuk regjistrohen.<\/p>\n

Ishte nj\u00eb kaos total. T\u00eb gjith\u00eb na derdh\u00ebn nj\u00ebri-tjetrin p\u00ebr dreq nj\u00ebri pas tjetrit: i pari ishte Leon, pas tij isha un\u00eb vet\u00eb dhe themeluesi i kompanis\u00eb. Vet\u00ebm CTO i sapo bashkuar u p\u00ebrpoq t\u00eb nxirrte bisedat tona me thirrje dhe shkrimet n\u00eb drejtim t\u00eb gjetjes s\u00eb nj\u00eb zgjidhjeje. <\/p>\n

Askush nuk e kuptonte se \u00e7far\u00eb po ndodhte n\u00eb t\u00eb v\u00ebrtet\u00eb.<\/h3>\n

\nNe e d\u00ebgjuar kurr\u00eb q\u00eb ne dhe djemt\u00eb u \u00e7mend\u00ebm kur kuptuam se nj\u00eb e tret\u00eb e t\u00eb dh\u00ebnave jo vet\u00ebm q\u00eb nuk ishte regjistruar, por ishte humbur! Doli q\u00eb rregulli n\u00eb kompanin\u00eb ton\u00eb ishte i till\u00eb: pas futjes, t\u00eb dh\u00ebnat fshiheshin p\u00ebrher\u00eb, dhe ngjarjet humbeshin masivisht. Imagjinoj se si Sergey do ta konvertonte gjith\u00eb k\u00ebt\u00eb n\u00eb rubla t\u00eb humbur.<\/p>\n

Dit\u00eblindja ime gjithashtu p\u00ebrfundoi n\u00eb plehra. Ne ishim n\u00eb nj\u00eb bar, duke gjeneruar ide, p\u00ebrpiqeshim t\u00eb zgjidhnim enigmat q\u00eb ishin hedhur. Shkaku i r\u00ebnies s\u00eb ClickHouse-it nuk ishte i duksh\u00ebm. Ndoshta \u00ebsht\u00eb rrjeti, ndoshta \u00ebsht\u00eb problemi n\u00eb konfigurimin e Linux-it. Mund t\u00eb jet\u00eb \u00e7far\u00ebdo gj\u00ebje, hipotezat u shpreh\u00ebn mjaftuesh\u00ebm.<\/p>\n

Nuk b\u00ebra betimin e zhvilluesit, por duke i l\u00ebn\u00eb djemt\u00eb n\u00eb an\u00ebn tjet\u00ebr t\u00eb telit ishte e pap\u00ebrshtatshme, edhe n\u00ebse ata na akuzonin p\u00ebr gjith\u00e7ka. Ishim 99% t\u00eb sigurt q\u00eb problemi nuk ishte n\u00eb zgjidhjet tona, nuk ishte nga ana jon\u00eb. 1% mund\u00ebsie q\u00eb t\u00eb ishim ne ata q\u00eb b\u00ebm\u00eb gabimin, m\u00eb shqet\u00ebsonte. Por, \u00e7far\u00ebdo q\u00eb t\u00eb ndodhte, duhej t\u00eb rregullohej. T\u00eb l\u00ebm\u00eb klient\u00ebt, pa marr\u00eb parasysh se \u00e7far\u00ebdo ishin ata, me nj\u00eb rrjedhje t\u00eb till\u00eb t\u00eb tmerrshme t\u00eb t\u00eb dh\u00ebnave, ishte shum\u00eb e ashp\u00ebr.<\/p>\n

Derisa punonim deri n\u00eb or\u00ebn tre t\u00eb m\u00ebngjesit n\u00eb tavolin\u00ebn e restorantit. Shtonim evente, insert select \u2014 dhe vazhduam t\u00eb plot\u00ebsonim boshll\u00ebqet. Kur ke humbur t\u00eb dh\u00ebnat, e b\u00ebn k\u00ebshtu \u2014 merr t\u00eb dh\u00ebnat mesatare nga dit\u00ebt e kaluara dhe i vendos ato n\u00eb t\u00eb humburat.<\/p>\n

Pas or\u00ebs tre, un\u00eb dhe shoku im shkruam n\u00eb sht\u00ebpin\u00eb time, por porosit\u00ebm birra nga marketi. Isha ulur me laptopin dhe problemet e Clickhouse, shoku m\u00eb tregonte di\u00e7ka. N\u00eb fund, pas nj\u00eb ore, ai u ofendua sepse un\u00eb punoja dhe nuk pija birr\u00eb me t\u00eb, dhe iku. Klasik \u2014 kalova si shok i devopsit.<\/p>\n

N\u00eb or\u00ebn 6 t\u00eb m\u00ebngjesit e krijova s\u00ebrish tabel\u00ebn dhe t\u00eb dh\u00ebnat filluan t\u00eb mbushen. T\u00eb gjitha funksionuan pa humbje.<\/p>\n

<\/p>\n

M\u00eb pas ishte e v\u00ebshtir\u00eb. T\u00eb gjith\u00eb akuzonin nj\u00ebri-tjetrin p\u00ebr humbjen e t\u00eb dh\u00ebnave. N\u00ebse ndodhte nj\u00eb bog i ri, jam i sigurt q\u00eb do t\u00eb kishte nj\u00eb shk\u00ebmbim zjarri.<\/h3>\n

\nN\u00eb k\u00ebto grindje filluam t\u00eb kuptonim m\u00eb n\u00eb fund \u2014 n\u00eb kompani mendonin se ne ishim ata djem q\u00eb punonin me t\u00eb dh\u00ebnat dhe mbik\u00ebqyrnin struktur\u00ebn e tabelave. Ata ngat\u00ebrruan administrator\u00ebt me DBA-t\u00eb. Dhe erdh\u00ebn t\u00eb na pyesin aspak si administrator\u00eb.<\/p>\n

Ankesa e tyre kryesore \u00ebsht\u00eb \u2014 \u00e7'\u00ebsht' e gjall\u00eb, ju ishit p\u00ebrgjegj\u00ebs p\u00ebr backupet dhe nuk i b\u00ebt\u00eb si\u00e7 duhej, humb\u00ebt t\u00eb dh\u00ebnat. Dhe gjith\u00eb kjo me fyerje t\u00eb r\u00ebnda.<\/p>\n

Desha p\u00ebr drejt\u00ebsi. Un\u00eb zbulova bisedat dhe p\u00ebrfshiva t\u00eb gjitha screenshot-et, ku Leonid me gjith\u00eb forc\u00ebn e tij e detyron p\u00ebr t\u00eb b\u00ebr\u00eb nj\u00eb backup t\u00eb till\u00eb, si\u00e7 ishte b\u00ebr\u00eb. CTO i tyre u vu n\u00eb an\u00ebn ton\u00eb pas telefonat\u00ebs time. M\u00eb pas e pranoi fajin e tij dhe Lenya.<\/p>\n

Kreu i kompanis\u00eb, p\u00ebrkundrazi, nuk donte t\u00eb faj\u00ebsonte t\u00eb tijt\u00eb. Screenshote dhe fjal\u00ebt nuk kishin efekt mbi t\u00eb. Ai mendonte se pasi ne ishim k\u00ebtu ekspert\u00eb, duhej t'i bindnim t\u00eb gjith\u00eb dhe t\u00eb insistonim n\u00eb vendimin ton\u00eb. Duke duket, detyra jon\u00eb p\u00ebrfshinte m\u00ebsimin e Lenya-s dhe, p\u00ebr m\u00eb tep\u00ebr, p\u00ebr t\u00eb kaluar p\u00ebrtej tij, t\u00eb cilin e em\u00ebruam udh\u00ebheq\u00ebs t\u00eb projektit, p\u00ebr t\u00eb arritur te kryetari dhe p\u00ebr t'i shprehur t\u00eb gjitha dyshimet tona mbi konceptin e backup-eve. <\/p>\n

Chat-i po l\u00ebshonte urrejtje, agresion t\u00eb fshehur dhe t\u00eb hapur. Nuk dija si t\u00eb veproja. T\u00eb gjitha kishin arritur n\u00eb nj\u00eb pik\u00eb t\u00eb ngurt\u00eb. Dhe k\u00ebtu m\u00eb sugjeruan m\u00ebnyr\u00ebn m\u00eb t\u00eb thjesht\u00eb \u2014 t\u00eb shkruaj n\u00eb privat udh\u00ebheq\u00ebsit dhe t\u00eb rregulloj nj\u00eb takim me t\u00eb. Vasya, njer\u00ebzit n\u00eb jet\u00eb nuk jan\u00eb aq t\u00eb guximsh\u00ebm sa n\u00eb chat. N\u00eb mesazhin tim, shefi p\u00ebrgjigjej: vjen, s'ka problem.<\/p>\n

\nIshte takimi m\u00eb i friksh\u00ebm n\u00eb karrier\u00ebn time. Aleati im nga klienti \u2014 CTO \u2014 nuk arriti t\u00eb gjej\u00eb koh\u00eb. Po shkoja n\u00eb takim me shefin dhe L\u0451nya.<\/p>\n

Her\u00eb pas here e kam rrotulluar n\u00eb mendjen time dialogun ton\u00eb t\u00eb mundsh\u00ebm. Kam arritur shum\u00eb her\u00ebt, gjysm\u00eb ore p\u00ebrpara. Nisa t\u00eb nervozohem, kam konsumuar 10 cigare. E kuptoja, gjith\u00e7ka\u2014isha, p\u00ebr zot, i vetmi. Nuk do t\u00eb mund t'i bindja ata. Dhe hapa der\u00ebn e ashensorit.<\/p>\n

Nd\u00ebrsa ngjitesha, sa b\u00ebn\u00eb flaka, e thyva at\u00eb.<\/p>\n

M\u00eb n\u00eb fund, Leoni nuk ishte n\u00eb takim. Dhe biseduam shum\u00eb mir\u00eb p\u00ebr gjith\u00e7ka me t\u00eb kryesori! Sergey m\u00eb tregoi p\u00ebr dhimbjen e tij. Ai nuk donte t\u00eb \"automatizonte Clickhouse\"\u2014ai d\u00ebshironte q\u00eb \"k\u00ebrkesat t\u00eb funksiononin.\"<\/p>\n

Un\u00eb nuk pash\u00eb nj\u00eb budalla, por nj\u00eb djal\u00eb t\u00eb mir\u00eb, q\u00eb u shqet\u00ebsonte p\u00ebr biznesin e tij, i zhytur n\u00eb pun\u00eb 24\/7. \u00c7ati shpesh na vizaton armiq, tradh\u00ebtar\u00eb dhe injorant\u00eb. Por n\u00eb jet\u00eb ata jan\u00eb njer\u00ebz t\u00eb nj\u00ebjt\u00eb si ti. <\/p>\n

Sergei nuk kishte nevoj\u00eb p\u00ebr disa devops t\u00eb angazhuar. Problemi q\u00eb kishin doli t\u00eb ishte shum\u00eb m\u00eb i madh. <\/p>\n

I thash\u00eb se mund t'i zgjidhja problemet e tij\u2014thjesht kjo ishte nj\u00eb pun\u00eb krejt e ndryshme, dhe p\u00ebr t\u00eb kisha nj\u00eb kontakt dibi\u00ebsh. Po t\u00eb kishim ditur nga fillimi se kjo ishte p\u00ebr ta, do t\u00eb kishim shmangur shum\u00eb. Von\u00eb, por kuptuam se problemi ishte n\u00eb menaxhimin e keq t\u00eb t\u00eb dh\u00ebnave, jo n\u00eb infrastruktur\u00eb. <\/p>\n

Nej m\u00eb dor\u00ebzuan dor\u00ebn, na rrit\u00ebn \u00e7mimin p\u00ebr dy her\u00eb e gjysm\u00eb, por me kushtin q\u00eb un\u00eb t\u00eb merrja mbi vete t\u00eb gjith\u00eb ngarkes\u00ebn me t\u00eb dh\u00ebnat e tyre dhe ClickHouse. N\u00eb ashensor, kontaktova at\u00eb dibiayshikun Max dhe e lidha me pun\u00ebn. Duhej t\u00eb rregulloja t\u00eb gjith\u00eb klastrin.<\/p>\n

\nIshte shum\u00eb kaos n\u00eb projektin e pranuar. Duke filluar nga 'backup'-i p\u00ebrmendur. Doli q\u00eb ky 'backup' klaster nuk ishte i izoluar. Aty testonin gjith\u00e7ka, ndonj\u00ebher\u00eb madje e p\u00ebrshtaten n\u00eb prodhim.<\/p>\n

Programuesit e brendsh\u00ebm krijuan nj\u00eb 'shtes\u00eb' t\u00eb personalizuar p\u00ebr t\u00eb dh\u00ebnat. Ajo punonte k\u00ebshtu: b\u00ebnte nj\u00eb s\u00ebr\u00eb skedar\u00ebsh, lan\u00e7onin skriptin dhe derdhni t\u00eb dh\u00ebnat n\u00eb tabel\u00eb. Por problemi kryesor ishte se nj\u00eb sasi e madhe e t\u00eb dh\u00ebnave merrej p\u00ebr nj\u00eb k\u00ebrkes\u00eb shum\u00eb t\u00eb thjesht\u00eb. K\u00ebrkesa bashkonte t\u00eb dh\u00ebnat p\u00ebr sekond\u00eb. T\u00eb gjitha p\u00ebr nj\u00eb num\u00ebr - totalin p\u00ebr dit\u00ebn.<\/p>\n

Zhvilluesit tan\u00eb nuk e p\u00ebrdor\u00ebn si\u00e7 duhet mjetin p\u00ebr analiz\u00eb. Ata shkonin n\u00eb Grafana, shkruanin k\u00ebrkesat e tyre t\u00eb posa\u00e7me. Ajo shkarkonte t\u00eb dh\u00ebna p\u00ebr 2 jav\u00eb. Krijohej nj\u00eb grafik i bukur. Por n\u00eb t\u00eb v\u00ebrtet\u00eb, k\u00ebrkesa e t\u00eb dh\u00ebnave ndodhte \u00e7do 10 sekonda. T\u00eb gjitha k\u00ebto grumbulloheshin n\u00eb radh\u00eb, pasi ClickHouse thjesht nuk mund t\u00eb p\u00ebrballonte \u043e\u0431\u0440\u0430\u0431\u043e\u0442k\u00ebn. K\u00ebtu e kishte shkakun kryesor. N\u00eb Grafana nuk punonte asgj\u00eb, k\u00ebrkesat ishin n\u00eb radh\u00eb, vazhdimisht mb\u00ebrrinin t\u00eb dh\u00ebna t\u00eb vjetra dhe jo n\u00eb p\u00ebrputhje.<\/p>\n

Ne rikonfiguruam klasterin, rip\u00ebrpunuam insertin. Zhvilluesit tan\u00eb e rishkruan \u00abinserter-in\u00bb e tyre dhe tani filloi t\u00eb sharded t\u00eb dh\u00ebna n\u00eb m\u00ebnyr\u00eb korrekte.<\/p>\n

Maxi realizoi nj\u00eb audit t\u00eb plot\u00eb t\u00eb infrastruktur\u00ebs. Ai b\u00ebri nj\u00eb plan p\u00ebr kalimin n\u00eb nj\u00eb backend t\u00eb plota. Por kjo nuk i k\u00ebnaqte kompanin\u00eb. Ata prisnin nga Maxi nj\u00eb sekret magjik q\u00eb do t'u lejonte t\u00eb punonin n\u00eb m\u00ebnyr\u00eb tradicionale, por me efikasitet. Projekti vazhdonte t\u00eb ishte n\u00ebn p\u00ebrgjegj\u00ebsin\u00eb e Ljon\u00ebs, i cili nuk kishte m\u00ebsuar asgj\u00eb. Nga gjith\u00e7ka e propozuar, ai p\u00ebrs\u00ebri zgjodhi alternativ\u00ebn e tij. Si gjithmon\u00eb, ishte nj\u00eb zgjidhje e ve\u00e7ant\u00eb... e guximshme. Ljoni besonte se kompania e tij kishte nj\u00eb rrug\u00eb t\u00eb ve\u00e7ant\u00eb. E p\u00ebrfolur dhe plot akullore.<\/p>\n

Pra\u00adv\u00eb\u00adrisht, k\u00ebshtu u ndam\u00eb \u2014 b\u00ebm\u00eb at\u00eb q\u00eb mund\u00ebm.<\/p>\n

\nMe plag\u00eb t\u00eb shumta, t\u00eb men\u00e7ur nga kjo histori, hap\u00ebm biznesin ton\u00eb dhe formuam disa principe p\u00ebr ne. Tani ne kurr\u00eb nuk e fillojm\u00eb pun\u00ebn si at\u00ebher\u00eb.<\/p>\n

Dibi\u00ebjshi Max pas k\u00ebtij projekti na u bashkua, dhe ne ende punojm\u00eb shk\u00eblqyesh\u00ebm s\u00eb bashku. Rastin me ClickHouse na m\u00ebsuan t\u00eb b\u00ebjm\u00eb nj\u00eb auditim t\u00eb plot\u00eb dhe t\u00eb thell\u00eb t\u00eb infrastruktur\u00ebs para fillimit t\u00eb pun\u00ebs. Ne kuptojm\u00eb se si funksionon gjith\u00e7ka, dhe vet\u00ebm pastaj pranojm\u00eb detyrat. Dhe n\u00ebse m\u00eb par\u00eb do t\u00eb ishim nisur menj\u00ebher\u00eb p\u00ebr t\u00eb sh\u00ebrbyer infrastruktur\u00ebn, tani s\u00eb pari b\u00ebjm\u00eb nj\u00eb projekt nj\u00eb her\u00eb p\u00ebr ta kuptuar si ta sjellim at\u00eb n\u00eb gjendje pune. <\/p>\n

Dhe po, ne i shmangim projektet me infrastruktur\u00eb t\u00eb dob\u00ebt. Edhe n\u00ebse p\u00ebr para t\u00eb m\u00ebdha, edhe n\u00ebse p\u00ebr miq\u00ebsi. T\u00eb menaxhosh projekte t\u00eb s\u00ebmura \u00ebsht\u00eb e pavler\u00eb. Nd\u00ebrgjegj\u00ebsimi mbi k\u00ebt\u00eb na ndihmoi t\u00eb rritemi. Ose nj\u00eb projekt nj\u00eb her\u00eb p\u00ebr t\u00eb sjell\u00eb rregullin n\u00eb infrastruktur\u00eb dhe pastaj nj\u00eb kontrat\u00eb p\u00ebr sh\u00ebrbim, ose thjesht kalojm\u00eb p\u00ebrmes. Rreth nj\u00eb ajsberg tjet\u00ebr.<\/p>\n

P.S. Pra, n\u00ebse keni pyetje p\u00ebr infrastruktur\u00ebn tuaj, mos hezitoni t\u00eb l\u00ebni nj\u00eb k\u00ebrkes\u00eb<\/b><\/a><\/noindex>.<\/p>\n

Ne kemi 2 auditime falas n\u00eb muaj, ndoshta projekti juaj do t\u00eb jet\u00eb nj\u00eb nga ato.<\/i>
\n
Burimi: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0412\u043e\u0442 \u0438\u0441\u0442\u043e\u0440\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043d\u0430\u0432\u0441\u0435\u0433\u0434\u0430 \u043f\u0435\u0440\u0435\u0432\u0435\u0440\u043d\u0443\u043b\u0430 \u043c\u043e\u0439 \u043f\u043e\u0434\u0445\u043e\u0434 \u043a \u0440\u0430\u0431\u043e\u0442\u0435 \u0434\u0435\u0432\u043e\u043f\u0441\u0430. \u0415\u0449\u0435 \u0432 \u0434\u043e\u043a\u043e\u0432\u0438\u0434\u043d\u044b\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u0430, \u0437\u0430\u0434\u043e\u043b\u0433\u043e-\u0437\u0430\u0434\u043e\u043b\u0433\u043e \u0434\u043e \u043d\u0438\u0445, \u043a\u043e\u0433\u0434\u0430 \u043c\u044b \u0441 \u043f\u0430\u0440\u043d\u044f\u043c\u0438 \u0442\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u0434\u0443\u043c\u044b\u0432\u0430\u043b\u0438 \u0441\u0432\u043e\u0435 \u0434\u0435\u043b\u043e \u0438 \u0444\u0440\u0438\u043b\u0430\u043d\u0441\u0438\u043b\u0438 \u043d\u0430 \u0441\u043b\u0443\u0447\u0430\u0439\u043d\u044b\u0445 \u0437\u0430\u043a\u0430\u0437\u0430\u0445, \u043c\u043d\u0435 \u0432 \u0442\u0435\u043b\u0435\u0433\u0443 \u0443\u043f\u0430\u043b\u043e \u043e\u0434\u043d\u043e \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u0438\u0435. \u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043d\u0430\u043f\u0438\u0441\u0430\u043b\u0430, \u0437\u0430\u043d\u0438\u043c\u0430\u043b\u0430\u0441\u044c \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u0415\u0436\u0435\u0434\u043d\u0435\u0432\u043d\u043e \u043e\u043d\u0430 \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u043b\u0430 \u0442\u044b\u0441\u044f\u0447\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041a \u043d\u0430\u043c \u043e\u043d\u0438 \u043f\u0440\u0438\u0448\u043b\u0438 \u0441\u043e \u0441\u043b\u043e\u0432\u0430\u043c\u0438: \u0440\u0435\u0431\u044f\u0442, \u0443 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":96000,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-95999","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Nd\u00ebrkoh\u00eb q\u00eb t\u00eb gjith\u00eb festonin dit\u00eblindjen time, un\u00eb po riparojta klasterin deri n\u00eb m\u00ebngjes \u2014 dhe zhvilluesit m\u00eb d\u00ebrgonin gabimet e tyre | ProHoster","description":"Kjo \u00ebsht\u00eb nj\u00eb histori q\u00eb ka ndryshuar p\u00ebrgjithmon\u00eb qasjen time ndaj pun\u00ebs si devops. Edhe n\u00eb koh\u00ebt para COVID-it, shum\u00eb koh\u00eb p\u00ebrpara, kur me shok\u00ebt fillonim t\u00eb mendonim p\u00ebr biznesin ton\u00eb dhe punonim si freelancer p\u00ebr porosi rast\u00ebsore, n\u00eb Telegram m\u00eb ra nj\u00eb propozim. Nj\u00eb kompani q\u00eb merrej me analiz\u00ebn e t\u00eb dh\u00ebnave. \u00c7do dit\u00eb p\u00ebrpunonte mij\u00ebra k\u00ebrkesa. Na erdh\u00ebn me fjal\u00ebt: djem, ne","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/poka-vse-prazdnovali-moj-den-rozhdeniya-ya-do-utra-chinil-klaster-a-razraby-valili-na-menya-svoi-oshibki","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\u041f\u043e\u043a\u0430 \u0432\u0441\u0435 \u043f\u0440\u0430\u0437\u0434\u043d\u043e\u0432\u0430\u043b\u0438 \u043c\u043e\u0439 \u0434\u0435\u043d\u044c \u0440\u043e\u0436\u0434\u0435\u043d\u0438\u044f, \u044f \u0434\u043e \u0443\u0442\u0440\u0430 \u0447\u0438\u043d\u0438\u043b \u043a\u043b\u0430\u0441\u0442\u0435\u0440 \u2014 \u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u044b \u0432\u0430\u043b\u0438\u043b\u0438 \u043d\u0430 \u043c\u0435\u043d\u044f \u0441\u0432\u043e\u0438 \u043e\u0448\u0438\u0431\u043a\u0438 | ProHoster","og:description":"\u0412\u043e\u0442 \u0438\u0441\u0442\u043e\u0440\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043d\u0430\u0432\u0441\u0435\u0433\u0434\u0430 \u043f\u0435\u0440\u0435\u0432\u0435\u0440\u043d\u0443\u043b\u0430 \u043c\u043e\u0439 \u043f\u043e\u0434\u0445\u043e\u0434 \u043a \u0440\u0430\u0431\u043e\u0442\u0435 \u0434\u0435\u0432\u043e\u043f\u0441\u0430. \u0415\u0449\u0435 \u0432 \u0434\u043e\u043a\u043e\u0432\u0438\u0434\u043d\u044b\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u0430, \u0437\u0430\u0434\u043e\u043b\u0433\u043e-\u0437\u0430\u0434\u043e\u043b\u0433\u043e \u0434\u043e \u043d\u0438\u0445, \u043a\u043e\u0433\u0434\u0430 \u043c\u044b \u0441 \u043f\u0430\u0440\u043d\u044f\u043c\u0438 \u0442\u043e\u043b\u044c\u043a\u043e \u0437\u0430\u0434\u0443\u043c\u044b\u0432\u0430\u043b\u0438 \u0441\u0432\u043e\u0435 \u0434\u0435\u043b\u043e \u0438 \u0444\u0440\u0438\u043b\u0430\u043d\u0441\u0438\u043b\u0438 \u043d\u0430 \u0441\u043b\u0443\u0447\u0430\u0439\u043d\u044b\u0445 \u0437\u0430\u043a\u0430\u0437\u0430\u0445, \u043c\u043d\u0435 \u0432 \u0442\u0435\u043b\u0435\u0433\u0443 \u0443\u043f\u0430\u043b\u043e \u043e\u0434\u043d\u043e \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u0438\u0435. \u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043d\u0430\u043f\u0438\u0441\u0430\u043b\u0430, \u0437\u0430\u043d\u0438\u043c\u0430\u043b\u0430\u0441\u044c \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u0415\u0436\u0435\u0434\u043d\u0435\u0432\u043d\u043e \u043e\u043d\u0430 \u043e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u043b\u0430 \u0442\u044b\u0441\u044f\u0447\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041a \u043d\u0430\u043c \u043e\u043d\u0438 \u043f\u0440\u0438\u0448\u043b\u0438 \u0441\u043e \u0441\u043b\u043e\u0432\u0430\u043c\u0438: \u0440\u0435\u0431\u044f\u0442, \u0443","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/poka-vse-prazdnovali-moj-den-rozhdeniya-ya-do-utra-chinil-klaster-a-razraby-valili-na-menya-svoi-oshibki","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-10-06T11:41:58+00:00","article:modified_time":"2020-10-06T11:41:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"95999","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:53:26","updated":"2022-10-01 11:21:07"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/95999","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=95999"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/95999\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/96000"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=95999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=95999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=95999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}