{"id":82116,"date":"2020-05-19T13:42:54","date_gmt":"2020-05-19T11:42:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt"},"modified":"2020-05-19T13:42:54","modified_gmt":"2020-05-19T11:42:54","slug":"orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt","title":{"rendered":"Orkestratori p\u00ebr MySQL: pse nuk mund t\u00eb nd\u00ebrtohet nj\u00eb projekt i pap\u00ebrshkuesh\u00ebm nga d\u00ebshtimet pa t\u00eb","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u00c7do projekt i madh ka nisur me disa server\u00eb. Fillimisht kishte nj\u00eb server DB, m\u00eb pas iu shtuan slave p\u00ebr t\u00eb skalier leximin. Dhe k\u00ebtu \u2014 ndal! Masteri \u00ebsht\u00eb nj\u00eb, nd\u00ebrsa slave jan\u00eb shum\u00eb; n\u00ebse nj\u00eb nga slave ik\u00ebn, gjith\u00e7ka do t\u00eb jet\u00eb n\u00eb rregull, por n\u00ebse masteri ik\u00ebn \u2014 do t\u00eb jet\u00eb keq: koh\u00eb e pashpjegueshme, administrator\u00ebt do t\u00eb rikthejn\u00eb serverin me v\u00ebshtir\u00ebsi. \u00c7far\u00eb t\u00eb b\u00ebjm\u00eb? T\u00eb rezervojm\u00eb masterin. Kolegu im Pavel ka shkruar tashm\u00eb p\u00ebr k\u00ebt\u00eb, <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/citymobil\/blog\/491044\/\">artikullin<\/a><\/noindex>, nuk do ta p\u00ebrs\u00ebris. N\u00eb vend t\u00eb k\u00ebsaj, do t\u00eb tregoj pse ju nevojitet patjet\u00ebr Orchestrator p\u00ebr MySQL!<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nT\u00eb fillojm\u00eb me pyetjen kryesore: \"Si do ta kalojm\u00eb kodin n\u00eb makin\u00eb t\u00eb re kur masteri ik\u00ebn?\".<\/p>\n<ul>\n<li>Skema me VIP (Virtual IP) m\u00eb p\u00eblqen m\u00eb shum\u00eb, mbi t\u00eb do t\u00eb flasim m\u00eb posht\u00eb. Ajo \u00ebsht\u00eb m\u00eb e thjesht\u00eb dhe m\u00eb e dukshme, megjithat\u00eb ka nj\u00eb kufizim t\u00eb qart\u00eb: masteri, i cili do t\u00eb rezervojm\u00eb, duhet t\u00eb jet\u00eb n\u00eb segmentin L2 me makin\u00ebn e re, pra mund t\u00eb harrojm\u00eb mbi qendr\u00ebn e dyt\u00eb. Po ashtu, n\u00ebse ndiqet rregulli se nj\u00eb L2 i madh \u00ebsht\u00eb i keq, sepse L2 \u00ebsht\u00eb vet\u00ebm p\u00ebr raft, nd\u00ebrsa mes raftesh \u00ebsht\u00eb L3, dhe kjo skem\u00eb ka edhe m\u00eb shum\u00eb kufizime.<\/li>\n<li>Mund t\u00eb specifikohet emri DNS n\u00eb kod dhe t\u00eb zgjidhet p\u00ebrmes \/etc\/hosts. N\u00eb t\u00eb v\u00ebrtet\u00eb, do t\u00eb ket\u00eb pasiguri n\u00eb zgjidhje. Avantazhi i skem\u00ebs: nuk ka kufizime q\u00eb karakterizojn\u00eb metod\u00ebn e par\u00eb, dometh\u00ebn\u00eb, mund t\u00eb krijoni nj\u00eb arkitektur\u00eb cross-DC. Por at\u00ebher\u00eb lind pyetja e qart\u00eb, se sa shpejt do ta p\u00ebrshtasim ndryshimin n\u00eb \/etc\/hosts p\u00ebrmes Puppet-Ansible.<\/li>\n<li>Mund t\u00eb ndryshoni pak metod\u00ebn e dyt\u00eb: n\u00eb t\u00eb gjitha serverat web vendosim nj\u00eb DNS cache, p\u00ebrmes t\u00eb cilit kodi do t\u00eb lidh\u00eb n\u00eb master baz\u00eb. Mund t\u00eb specifikohet TTL 60 p\u00ebr k\u00ebt\u00eb regjistrim n\u00eb DNS. Duket se, me realizimin e duhur, ky \u00ebsht\u00eb nj\u00eb metod\u00eb e mir\u00eb.<\/li>\n<li>Nj\u00eb skem\u00eb me zbulim sh\u00ebrbimi, q\u00eb n\u00ebnkupton p\u00ebrdorimin e Consul dhe etcd.<\/li>\n<li>Nj\u00eb variant interesant me <noindex><a rel=\"nofollow\" href=\"https:\/\/proxysql.com\/\">ProxySQL<\/a><\/noindex>. Duhet t\u00eb drejtohet e gjith\u00eb trafiku n\u00eb MySQL p\u00ebrmes ProxySQL, i cili vet\u00eb di t\u00eb identifikoj\u00eb se kush \u00ebsht\u00eb aktualisht master. P\u00ebr nj\u00eb nga variantet e p\u00ebrdorimit t\u00eb k\u00ebtij produkti mund t\u00eb lexoni n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/citymobil\/blog\/501730\/\">artikullin<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>\nAutori Orchestrator, duke punuar n\u00eb Github, fillimisht realizoi skem\u00ebn e par\u00eb me VIP, e m\u00eb pas e riparoi n\u00eb skem\u00ebn me consul.<\/p>\n<p>Nj\u00eb skem\u00eb tipike infrastrukture:<\/p>\n<p><img decoding=\"async\" alt=\"Orkestratori p\u00ebr MySQL: pse nuk mund t\u00eb nd\u00ebrtohet nj\u00eb projekt i pap\u00ebrshkuesh\u00ebm nga d\u00ebshtimet pa t\u00eb\" src=\"\/wp-content\/uploads\/2020\/05\/b08220e7aa6336229cbbfedd78afdcc3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nMenj\u00ebher\u00eb do t\u00eb p\u00ebrshkruaj situatat evidente q\u00eb duhet t\u00eb merren parasysh:<\/p>\n<ul>\n<li>VIP adresa nuk duhet t\u00eb jet\u00eb e regjistruar n\u00eb konfigurim n\u00eb asnj\u00eb nga server\u00ebt. Imagjinoni nj\u00eb situat\u00eb: masteri rindez, dhe nd\u00ebrkoh\u00eb q\u00eb po ngarkohet, Orchestrator kalon n\u00eb modalitetin failover dhe b\u00ebn nj\u00eb nga slave-t master; pastaj rindez masteri i vjet\u00ebr, dhe tani VIP \u00ebsht\u00eb n\u00eb dy makina. Kjo \u00ebsht\u00eb e keqe.<\/li>\n<li>P\u00ebr orchestratorin do t\u00eb nevojitet nj\u00eb skript p\u00ebr t'u drejtuar n\u00eb masterin e vjet\u00ebr dhe masterin e ri. N\u00eb masterin e vjet\u00ebr duhet t\u00eb ekzekutohet ifdown, nd\u00ebrsa n\u00eb masterin e ri \u2014 ifup vip. Do t\u00eb ishte mir\u00eb t\u00eb p\u00ebrfshihej gjithashtu n\u00eb k\u00ebt\u00eb skript q\u00eb n\u00eb rast failover porti n\u00eb switch-in e masterit t\u00eb vjet\u00ebr thjesht t\u00eb mbyllet, p\u00ebr t\u00eb shmangur ndonj\u00eb splitbrain.<\/li>\n<li>Pas thirrjes s\u00eb skriptit tuaj nga Orchestrator, p\u00ebr t\u00eb \u00e7aktivizuar fillimisht VIP dhe\/ose p\u00ebr t\u00eb mbyllur portin n\u00eb switch, dhe pastaj n\u00eb masterin e ri t\u00eb thirrni skriptin p\u00ebr aktivizimin e VIP, mos harroni t\u00eb thoni t\u00eb gjith\u00ebve me komand\u00ebn arping se tani VIP i ri \u00ebsht\u00eb k\u00ebtu.<\/li>\n<li>N\u00eb t\u00eb gjitha slave-t duhet t\u00eb jet\u00eb read_only=1, dhe sa her\u00eb q\u00eb promovoni nj\u00eb slave n\u00eb master, atij duhet t'i ndryshohet n\u00eb read_only=0.<\/li>\n<li>Mos e harroni se \u00e7do skllav q\u00eb kemi zgjedhur p\u00ebr k\u00ebt\u00eb mund t\u00eb b\u00ebhet mjesht\u00ebr (Orchestrator ka nj\u00eb mekaniz\u00ebm t\u00eb plot\u00eb preferencash p\u00ebr t\u00eb vendosur se cili skllav duhet konsideruar si kandidat p\u00ebr mjeshtrin e ri n\u00eb radh\u00eb t\u00eb par\u00eb, cili n\u00eb radh\u00eb t\u00eb dyt\u00eb, dhe cili skllav nuk duhet zgjedhur p\u00ebr mjesht\u00ebr aspak). N\u00ebse nj\u00eb skllav b\u00ebhet mjesht\u00ebr, ai do t\u00eb mbaj\u00eb ngarkes\u00ebn e skllavit dhe do t'i shtohet ngarkesa e mjeshtrit, k\u00ebshtu q\u00eb duhet ta merrni parasysh k\u00ebt\u00eb.<\/li>\n<\/ul>\n<p>\nPse ju nevojitet patjet\u00ebr Orchestrator n\u00ebse nuk e keni at\u00eb?<\/p>\n<ul>\n<li>Orchestrator ka nj\u00eb nd\u00ebrfaqe grafike shum\u00eb t\u00eb p\u00ebrshtatshme q\u00eb tregon t\u00eb gjith\u00eb topologjin\u00eb (shikoni screenshotin m\u00eb posht\u00eb).<\/li>\n<li>Orchestrator mund t\u00eb ndjek\u00eb se cil\u00ebt skllav\u00eb jan\u00eb prapa dhe ku replikimi \u00ebsht\u00eb prishur krejt\u00ebsisht (ne kemi skriptet e lidhura me Orchestrator p\u00ebr t\u00eb d\u00ebrguar SMS).<\/li>\n<li>Orchestrator ju thot\u00eb se n\u00eb cil\u00ebt skllav\u00eb ka nj\u00eb gabim GTID errant.<\/li>\n<\/ul>\n<p>\nNd\u00ebrfaqja e Orchestrator:<\/p>\n<p><img decoding=\"async\" alt=\"Orkestratori p\u00ebr MySQL: pse nuk mund t\u00eb nd\u00ebrtohet nj\u00eb projekt i pap\u00ebrshkuesh\u00ebm nga d\u00ebshtimet pa t\u00eb\" src=\"\/wp-content\/uploads\/2020\/05\/5129a85ad1c0a5db8e3ecf501cff0d0d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\u00c7far\u00eb \u00ebsht\u00eb GTID errant?<\/p>\n<p>Ka dy k\u00ebrkesa themelore p\u00ebr funksionimin e Orchestrator:<\/p>\n<ul>\n<li>\u00cbsht\u00eb e nevojshme q\u00eb n\u00eb t\u00eb gjitha makinat e klasterit MySQL t\u00eb jet\u00eb aktivizuar pseudo GTID, ne kemi aktivizuar GTID.<\/li>\n<li>Duhet q\u00eb t\u00eb ket\u00eb nj\u00eb lloj binlogu kudo, mund\u00ebsisht statement. Ne kishim nj\u00eb konfigurim t\u00eb till\u00eb, ku n\u00eb master dhe n\u00eb shumic\u00ebn e slaveve ishte Row, nd\u00ebrsa n\u00eb dy mbeti historikisht m\u00ebnyra Mixed. Si rezultat, k\u00ebto slave Orchestrator thjesht nuk d\u00ebshironin t\u00eb lidhnin me masterin e ri.<\/li>\n<\/ul>\n<p>\nKujtoni se m\u00eb e r\u00ebnd\u00ebsishme n\u00eb nj\u00eb production-slave \u00ebsht\u00eb konsistenca e tij me masterin! N\u00ebse keni Global Transaction ID (GTID) aktiv n\u00eb master dhe slave, at\u00ebher\u00eb p\u00ebrmes funksionit gtid_subset mund t\u00eb m\u00ebsoni n\u00ebse n\u00eb k\u00ebto makina jan\u00eb ekzekutuar t\u00eb nj\u00ebjtat k\u00ebrkesa p\u00ebr ndryshimin e t\u00eb dh\u00ebnave. Mund t\u00eb lexoni m\u00eb shum\u00eb rreth k\u00ebsaj. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/blog\/2014\/05\/19\/errant-transactions-major-hurdle-for-gtid-based-failover-in-mysql-5-6\/\">k\u00ebtu<\/a><\/noindex>.<\/p>\n<p>K\u00ebshtu, Orchestrator tregon p\u00ebrmes gabimit GTID errant se n\u00eb slave ka transaksione q\u00eb nuk ekzistojn\u00eb n\u00eb master. Pse ndodh kjo?<\/p>\n<ul>\n<li>N\u00eb slave nuk \u00ebsht\u00eb aktivizuar read_only=1, dikush u lidh dhe ekzekutoi nj\u00eb k\u00ebrkes\u00eb p\u00ebr ndryshimin e t\u00eb dh\u00ebnave.<\/li>\n<li>N\u00eb slave nuk \u00ebsht\u00eb aktivizuar super_read_only=1, at\u00ebher\u00eb admini, duke u ngat\u00ebrruar me serverin, hyri dhe ekzekutoi atje nj\u00eb k\u00ebrkes\u00eb.<\/li>\n<li>N\u00ebse keni marr\u00eb parasysh t\u00eb dy pikat e m\u00ebparshme, at\u00ebher\u00eb ka edhe nj\u00eb truk tjet\u00ebr: n\u00eb MySQL, k\u00ebrkesa p\u00ebr flush-in e binlog\u00ebve gjithashtu p\u00ebrfshihet n\u00eb binlog, prandaj me flush-in e par\u00eb n\u00eb master dhe n\u00eb t\u00eb gjitha slave-t do t\u00eb shfaqet GTID errant. Si t\u00eb shmangni k\u00ebt\u00eb? N\u00eb versionin perona-5.7.25-28 u shtua konfigurimi binlog_skip_flush_commands=1, q\u00eb ndalon shkruajtjen e flush n\u00eb binlog. N\u00eb faqen mysql.com ka nj\u00eb regjistrim <noindex><a rel=\"nofollow\" href=\"https:\/\/bugs.mysql.com\/bug.php?id=88720\">defekti<\/a><\/noindex>.<\/li>\n<\/ul>\n<p>\nP\u00ebrmbledh t\u00eb gjitha t\u00eb th\u00ebna m\u00eb sip\u00ebr. N\u00ebse ende nuk d\u00ebshironi t\u00eb p\u00ebrdorni Orchestrator n\u00eb modin failover, vendoseni at\u00eb n\u00eb modin e monitorimit. At\u00ebher\u00eb do t\u00eb keni gjithmon\u00eb para syve nj\u00eb hart\u00eb t\u00eb nd\u00ebrveprimit t\u00eb makinave MySQL dhe informacion t\u00eb qart\u00eb mbi at\u00eb se \u00e7far\u00eb lloji replikimi ka n\u00eb \u00e7do makin\u00eb, n\u00ebse slave-t jan\u00eb n\u00eb vones\u00eb dhe, m\u00eb e r\u00ebnd\u00ebsishmja, sa konsistent\u00eb jan\u00eb ata me master-in!<\/p>\n<p>Pyetjes evidente: \"Si duhet t\u00eb punoj\u00eb Orchestrator?\" Ai duhet t\u00eb zgjedh\u00eb nj\u00eb master t\u00eb ri nga skllav\u00ebt aktual\u00eb dhe pastaj t\u00eb rikonfiguroj\u00eb t\u00eb gjith\u00eb skllav\u00ebt me t\u00eb (pik\u00ebrisht p\u00ebr k\u00ebt\u00eb \u00ebsht\u00eb e nevojshme GTID; n\u00ebse p\u00ebrdoret mekanizmi i vjet\u00ebr me binlog_name dhe binlog_pos, kalimi i skllavit nga masteri aktual n\u00eb t\u00eb riun \u00ebsht\u00eb thjesht e pamundur!). Para se t\u00eb kishim Orchestrator, nj\u00eb her\u00eb m\u00eb doli t\u00eb b\u00ebja gjith\u00eb k\u00ebt\u00eb manualisht. Masteri i vjet\u00ebr mbetej i ngjallur p\u00ebr shkak t\u00eb nj\u00eb kontrolluesi t\u00eb gabuar Adaptec, kishte rreth 10 skllav\u00eb. Duhej t\u00eb kaloja VIP nga masteri n\u00eb nj\u00eb nga skllav\u00ebt dhe t\u00eb rikonfiguroja t\u00eb gjith\u00eb skllav\u00ebt e tjer\u00eb me t\u00eb. Sa ekrane m\u00eb duhej t\u00eb hapja, sa komanda t\u00eb nj\u00ebkohshme t\u00eb jepja\u2026 Duhej t\u00eb prisja deri n\u00eb or\u00ebn 3 t\u00eb m\u00ebngjesit, t\u00eb heqja ngarkes\u00ebn nga t\u00eb gjith\u00eb skllav\u00ebt, p\u00ebrve\u00e7 dy, t\u00eb b\u00ebnte master makin\u00ebn e par\u00eb nga dy, menj\u00ebher\u00eb t\u00eb lidhesha me makin\u00ebn e dyt\u00eb, e pastaj t\u00eb lidhesha me t\u00eb gjith\u00eb skllav\u00ebt e tjer\u00eb dhe ta ktheja ngarkes\u00ebn. N\u00eb p\u00ebrgjith\u00ebsi, nj\u00eb tmerr\u2026<\/p>\n<p>Si funksionon Orchestrator kur kalon n\u00eb modin failover? \u00cbsht\u00eb m\u00eb e leht\u00eb ta tregosh me nj\u00eb shembull situate kur duam t\u00eb b\u00ebjm\u00eb master nj\u00eb makin\u00eb m\u00eb t\u00eb fuqishme dhe m\u00eb moderne se ajo q\u00eb kemi tani. <\/p>\n<p><img decoding=\"async\" alt=\"Orkestratori p\u00ebr MySQL: pse nuk mund t\u00eb nd\u00ebrtohet nj\u00eb projekt i pap\u00ebrshkuesh\u00ebm nga d\u00ebshtimet pa t\u00eb\" src=\"\/wp-content\/uploads\/2020\/05\/d2afe9c74b33765e55641b34def3145e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nN\u00eb skem\u00eb paraqitet mesazhi i procesit. \u00c7far\u00eb ka ndodhur deri n\u00eb k\u00ebt\u00eb moment? Ne tham\u00eb se duam ta b\u00ebjm\u00eb nj\u00eb slave si nj\u00eb master t\u00eb ri, Orchestrator filloi thjesht t\u00eb ri\u00e7konte t\u00eb gjith\u00eb slave-t e tjer\u00eb me t\u00eb, nd\u00ebrkoh\u00eb q\u00eb master-i i ri luan rolin e makin\u00ebs tranzite. Me k\u00ebt\u00eb skem\u00eb nuk ndodhin gabime, t\u00eb gjith\u00eb slave-t funksionojn\u00eb, Orchestrator hoqi VIP nga master-i i vjet\u00ebr, e transferon tek i ri, e b\u00ebn read_only=0 dhe harron p\u00ebr master-in e vjet\u00ebr. Mjaft! Koh\u00ebzgjatja e sh\u00ebrbimit ton\u00eb \u00ebsht\u00eb koha e transferimit t\u00eb VIP-it, kjo \u00ebsht\u00eb 2-3 sekonda.<\/p>\n<p>Kjo \u00ebsht\u00eb gjith\u00e7ka p\u00ebr sot, faleminderit t\u00eb gjith\u00ebve. Shpejt do t\u00eb jet\u00eb artikulli i dyt\u00eb p\u00ebr Orchestrator. N\u00eb nj\u00eb film t\u00eb njohur sovjetik \"Garazh\", nj\u00eb personazh tha: \"Un\u00eb s'do t\u00eb shkoja n\u00eb zbulim me t\u00eb!\" Pra, Orchestrator, un\u00eb do t\u00eb shkoja n\u00eb zbulim me ty!<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/citymobil\/blog\/501994\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041b\u044e\u0431\u043e\u0439 \u043a\u0440\u0443\u043f\u043d\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u043b\u0441\u044f \u0441 \u043f\u0430\u0440\u044b \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432. C\u043d\u0430\u0447\u0430\u043b\u0430 \u0431\u044b\u043b \u043e\u0434\u0438\u043d DB-\u0441\u0435\u0440\u0432\u0435\u0440, \u043f\u043e\u0442\u043e\u043c \u043a \u043d\u0435\u043c\u0443 \u0434\u043e\u0431\u0430\u0432\u0438\u043b\u0438\u0441\u044c \u0441\u043b\u0435\u0439\u0432\u044b, \u0447\u0442\u043e\u0431\u044b \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0447\u0442\u0435\u043d\u0438\u0435. \u0418 \u0442\u0443\u0442 \u2014 \u0441\u0442\u043e\u043f! \u041c\u0430\u0441\u0442\u0435\u0440 \u043e\u0434\u0438\u043d, \u0430 \u0441\u043b\u0435\u0439\u0432\u043e\u0432 \u043c\u043d\u043e\u0433\u043e; \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043e\u0434\u0438\u043d \u0438\u0437 \u0441\u043b\u0435\u0439\u0432\u043e\u0432, \u0442\u043e \u0432\u0441\u0451 \u0431\u0443\u0434\u0435\u0442 \u0445\u043e\u0440\u043e\u0448\u043e, \u0430 \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043c\u0430\u0441\u0442\u0435\u0440 \u2014 \u0431\u0443\u0434\u0435\u0442 \u043f\u043b\u043e\u0445\u043e: \u0434\u0430\u0443\u043d\u0442\u0430\u0439\u043c, \u0430\u0434\u043c\u0438\u043d\u044b \u0432 \u043c\u044b\u043b\u0435 \u043f\u043e\u0434\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0435\u0440\u0432\u0435\u0440. \u0427\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c? \u0420\u0435\u0437\u0435\u0440\u0432\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043c\u0430\u0441\u0442\u0435\u0440. \u041c\u043e\u0439 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":82117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-82116","post","type-post","status-publish","format-standard","has-post-thumbnail","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=\"\u041b\u044e\u0431\u043e\u0439 \u043a\u0440\u0443\u043f\u043d\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u043b\u0441\u044f \u0441 \u043f\u0430\u0440\u044b \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432. C\u043d\u0430\u0447\u0430\u043b\u0430 \u0431\u044b\u043b \u043e\u0434\u0438\u043d DB-\u0441\u0435\u0440\u0432\u0435\u0440, \u043f\u043e\u0442\u043e\u043c \u043a \u043d\u0435\u043c\u0443 \u0434\u043e\u0431\u0430\u0432\u0438\u043b\u0438\u0441\u044c \u0441\u043b\u0435\u0439\u0432\u044b, \u0447\u0442\u043e\u0431\u044b \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0447\u0442\u0435\u043d\u0438\u0435. \u0418 \u0442\u0443\u0442 \u2014 \u0441\u0442\u043e\u043f! \u041c\u0430\u0441\u0442\u0435\u0440 \u043e\u0434\u0438\u043d, \u0430 \u0441\u043b\u0435\u0439\u0432\u043e\u0432 \u043c\u043d\u043e\u0433\u043e; \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043e\u0434\u0438\u043d \u0438\u0437 \u0441\u043b\u0435\u0439\u0432\u043e\u0432, \u0442\u043e \u0432\u0441\u0451 \u0431\u0443\u0434\u0435\u0442 \u0445\u043e\u0440\u043e\u0448\u043e, \u0430 \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043c\u0430\u0441\u0442\u0435\u0440 \u2014 \u0431\u0443\u0434\u0435\u0442 \u043f\u043b\u043e\u0445\u043e: \u0434\u0430\u0443\u043d\u0442\u0430\u0439\u043c, \u0430\u0434\u043c\u0438\u043d\u044b \u0432 \u043c\u044b\u043b\u0435 \u043f\u043e\u0434\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0435\u0440\u0432\u0435\u0440. \u0427\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c? \u0420\u0435\u0437\u0435\u0440\u0432\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043c\u0430\u0441\u0442\u0435\u0440. \u041c\u043e\u0439\" \/>\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\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt\" \/>\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\udd47Orchestrator \u0434\u043b\u044f MySQL: \u043f\u043e\u0447\u0435\u043c\u0443 \u0431\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435\u043b\u044c\u0437\u044f \u0441\u0442\u0440\u043e\u0438\u0442\u044c \u043e\u0442\u043a\u0430\u0437\u043e\u0443\u0441\u0442\u043e\u0439\u0447\u0438\u0432\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041b\u044e\u0431\u043e\u0439 \u043a\u0440\u0443\u043f\u043d\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u043b\u0441\u044f \u0441 \u043f\u0430\u0440\u044b \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432. C\u043d\u0430\u0447\u0430\u043b\u0430 \u0431\u044b\u043b \u043e\u0434\u0438\u043d DB-\u0441\u0435\u0440\u0432\u0435\u0440, \u043f\u043e\u0442\u043e\u043c \u043a \u043d\u0435\u043c\u0443 \u0434\u043e\u0431\u0430\u0432\u0438\u043b\u0438\u0441\u044c \u0441\u043b\u0435\u0439\u0432\u044b, \u0447\u0442\u043e\u0431\u044b \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0447\u0442\u0435\u043d\u0438\u0435. \u0418 \u0442\u0443\u0442 \u2014 \u0441\u0442\u043e\u043f! \u041c\u0430\u0441\u0442\u0435\u0440 \u043e\u0434\u0438\u043d, \u0430 \u0441\u043b\u0435\u0439\u0432\u043e\u0432 \u043c\u043d\u043e\u0433\u043e; \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043e\u0434\u0438\u043d \u0438\u0437 \u0441\u043b\u0435\u0439\u0432\u043e\u0432, \u0442\u043e \u0432\u0441\u0451 \u0431\u0443\u0434\u0435\u0442 \u0445\u043e\u0440\u043e\u0448\u043e, \u0430 \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043c\u0430\u0441\u0442\u0435\u0440 \u2014 \u0431\u0443\u0434\u0435\u0442 \u043f\u043b\u043e\u0445\u043e: \u0434\u0430\u0443\u043d\u0442\u0430\u0439\u043c, \u0430\u0434\u043c\u0438\u043d\u044b \u0432 \u043c\u044b\u043b\u0435 \u043f\u043e\u0434\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0435\u0440\u0432\u0435\u0440. \u0427\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c? \u0420\u0435\u0437\u0435\u0440\u0432\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043c\u0430\u0441\u0442\u0435\u0440. \u041c\u043e\u0439\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt\" \/>\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-05-19T11:42:54+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-05-19T11:42:54+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\udd47Orkestratori p\u00ebr MySQL: pse nuk mund t\u00eb nd\u00ebrtohet nj\u00eb projekt i besuesh\u00ebm pa t\u00eb | ProHoster","description":"\u00c7do projekt i madh ka filluar me disa servera. N\u00eb fillim kishte nj\u00eb DB-server, pastaj iu shtuan slave-t p\u00ebr t\u00eb shkall\u00ebzuar leximin. Dhe k\u00ebtu \u2014 ndal! Master-i \u00ebsht\u00eb nj\u00eb, por slave-t jan\u00eb shum\u00eb; n\u00ebse nj\u00eb nga slave-t largohet, \u00e7do gj\u00eb do t\u00eb jet\u00eb mir\u00eb, por n\u00ebse master-i largohet \u2014 do t\u00eb jet\u00eb keq: koh\u00ebzgjatje, administrator\u00ebt me nerva e rrisin serverin. \u00c7far\u00eb t\u00eb b\u00ebjm\u00eb? T\u00eb rezervohet master-i. M\u00ebnj","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt","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\udd47Orchestrator \u0434\u043b\u044f MySQL: \u043f\u043e\u0447\u0435\u043c\u0443 \u0431\u0435\u0437 \u043d\u0435\u0433\u043e \u043d\u0435\u043b\u044c\u0437\u044f \u0441\u0442\u0440\u043e\u0438\u0442\u044c \u043e\u0442\u043a\u0430\u0437\u043e\u0443\u0441\u0442\u043e\u0439\u0447\u0438\u0432\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 | ProHoster","og:description":"\u041b\u044e\u0431\u043e\u0439 \u043a\u0440\u0443\u043f\u043d\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u043b\u0441\u044f \u0441 \u043f\u0430\u0440\u044b \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432. C\u043d\u0430\u0447\u0430\u043b\u0430 \u0431\u044b\u043b \u043e\u0434\u0438\u043d DB-\u0441\u0435\u0440\u0432\u0435\u0440, \u043f\u043e\u0442\u043e\u043c \u043a \u043d\u0435\u043c\u0443 \u0434\u043e\u0431\u0430\u0432\u0438\u043b\u0438\u0441\u044c \u0441\u043b\u0435\u0439\u0432\u044b, \u0447\u0442\u043e\u0431\u044b \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0447\u0442\u0435\u043d\u0438\u0435. \u0418 \u0442\u0443\u0442 \u2014 \u0441\u0442\u043e\u043f! \u041c\u0430\u0441\u0442\u0435\u0440 \u043e\u0434\u0438\u043d, \u0430 \u0441\u043b\u0435\u0439\u0432\u043e\u0432 \u043c\u043d\u043e\u0433\u043e; \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043e\u0434\u0438\u043d \u0438\u0437 \u0441\u043b\u0435\u0439\u0432\u043e\u0432, \u0442\u043e \u0432\u0441\u0451 \u0431\u0443\u0434\u0435\u0442 \u0445\u043e\u0440\u043e\u0448\u043e, \u0430 \u0435\u0441\u043b\u0438 \u0443\u0439\u0434\u0435\u0442 \u043c\u0430\u0441\u0442\u0435\u0440 \u2014 \u0431\u0443\u0434\u0435\u0442 \u043f\u043b\u043e\u0445\u043e: \u0434\u0430\u0443\u043d\u0442\u0430\u0439\u043c, \u0430\u0434\u043c\u0438\u043d\u044b \u0432 \u043c\u044b\u043b\u0435 \u043f\u043e\u0434\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0435\u0440\u0432\u0435\u0440. \u0427\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c? \u0420\u0435\u0437\u0435\u0440\u0432\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043c\u0430\u0441\u0442\u0435\u0440. \u041c\u043e\u0439","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/orchestrator-dlya-mysql-pochemu-bez-nego-nelzya-stroit-otkazoustojchivyj-proekt","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-05-19T11:42:54+00:00","article:modified_time":"2020-05-19T11:42:54+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"82116","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 15:44:22","updated":"2022-10-07 20:28:08"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/82116","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=82116"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/82116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/82117"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=82116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=82116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=82116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}