{"id":98088,"date":"2020-10-24T02:42:34","date_gmt":"2020-10-24T00:42:34","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/shifrovanie-v-mysql-rotacziya-master-key"},"modified":"2020-11-18T00:58:48","modified_gmt":"2020-11-17T22:58:48","slug":"shifrovanie-v-mysql-rotacziya-master-key","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/shifrovanie-v-mysql-rotacziya-master-key","title":{"rendered":"Kriptimi n\u00eb MySQL: rotacioni i Master Key.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<\/p>\n<p><strong><em>N\u00eb prag t\u00eb fillimit t\u00eb nj\u00eb grupi t\u00eb ri p\u00ebr kursin&nbsp;<\/em><\/strong><noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/dADq\/\"><strong><em>\u00abBaza t\u00eb dh\u00ebnash\u00bb<\/em><\/strong><\/a><\/noindex><strong><em>&nbsp;vazhdojm\u00eb t\u00eb publikojm\u00eb nj\u00eb seri artikujsh mbi enkriptimin n\u00eb MySQL.<\/em><\/strong><\/p>\n<p>N\u00eb artikullin e m\u00ebparsh\u00ebm t\u00eb k\u00ebsaj serie ne diskutuam, <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/524050\/\"><u>si funksionon enkriptimi me \u00e7el\u00ebsi kryesor (Master Key)<\/u><\/a><\/noindex>. Sot, duke u bazuar n\u00eb njohurit\u00eb e marra m\u00eb par\u00eb, do t\u00eb shohim mbi rotacionin e \u00e7el\u00ebsave kryesor\u00eb.<\/p>\n<p>Rotacioni i \u00e7el\u00ebsit kryesor p\u00ebrfshin gjenerimin e nj\u00eb \u00e7el\u00ebsi t\u00eb ri kryesor dhe fuqit\u00eb e t\u00eb gjitha \u00e7el\u00ebsave t\u00eb tablove dhe tabelave (t\u00eb cilat ruhen n\u00eb titujt e tabloave).<\/p>\n<p>Le t\u00eb rikujtojm\u00eb se si duket titulli i nj\u00eb tablice t\u00eb enkriptuar:<\/p>\n<p><img decoding=\"async\" alt=\"Kriptimi n\u00eb MySQL: rotacioni i Master Key.\" src=\"\/wp-content\/uploads\/2020\/10\/24057c50b96236c5ee2647aeca4b575f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Nga artikulli i m\u00ebparsh\u00ebm dim\u00eb se serveri gjat\u00eb nisjes lexon titujt e t\u00eb gjitha tablove t\u00eb enkriptuara dhe kujton ID-n\u00eb m\u00eb t\u00eb madhe t\u00eb \u00c7el\u00ebsit. P\u00ebr shembull, n\u00ebse kemi tre tabela me KEY<em>ID = 3 dhe nj\u00eb tabel\u00eb me KEY<\/em>ID = 4, do t\u00eb thot\u00eb se identifikuesi maksimal i \u00e7el\u00ebsit do t\u00eb jet\u00eb 4. Le t\u00eb e quajm\u00eb k\u00ebt\u00eb KEY ID \u2014 MAX KEY ID.<\/p>\n<h3>Si funksionon rotacioni i \u00e7el\u00ebsit kryesor<\/h3>\n<p>1. P\u00ebrdoruesi ekzekuton ALTER INNODB MASTER KEY.<\/p>\n<p>2. Serveri k\u00ebrkon n\u00eb magazin\u00ebn e \u00e7el\u00ebsave (keyring) gjenerimin e nj\u00eb \u00e7el\u00ebsi t\u00eb ri kryesor me UUID t\u00eb serverit dhe KEY<em>ID, i barabart\u00eb me MAX t\u00eb rritur me nj\u00ebsi<\/em>\u00c7ELSI<em>ID. K\u00ebshtu, ne marrim identifikuesin e \u00e7el\u00ebsit kryesor, i barabart\u00eb me INNODB<\/em>\u00c7ELSI-UUID- (MAX<em>\u00c7ELSI<\/em>ID + 1). Me suksesin n\u00eb gjenerimin e \u00e7el\u00ebsit kryesor, MAX KEY ID rritet me nj\u00ebsi (dmth. MAX<em>\u00c7ELSI<\/em>ID = MAX<em>\u00c7ELSI<\/em>ID + 1).<\/p>\n<p>3. Serveri shikon t\u00eb gjitha hap\u00ebsirat tabelore t\u00eb enkriptuara me \u00e7el\u00ebsin kryesor dhe p\u00ebr \u00e7do hap\u00ebsir\u00eb tabelore:<\/p>\n<ul>\n<li>\n<p>enkripton \u00e7el\u00ebsin e hap\u00ebsir\u00ebs tabelore me \u00e7el\u00ebsin e ri kryesor;<\/p>\n<\/li>\n<li>\n<p>p\u00ebrdit\u00ebson identifikuesin e \u00e7el\u00ebsit n\u00eb MAX t\u00eb ri<em>\u00c7ELSI<\/em>ID;<\/p>\n<\/li>\n<li>\n<p>n\u00ebse UUID ndryshon nga UUID i serverit, at\u00ebher\u00eb p\u00ebrdit\u00ebson UUID e serverit.<\/p>\n<\/li>\n<\/ul>\n<p>Si\u00e7 e dim\u00eb, identifikuesi i \u00e7el\u00ebsit kryesor (Master Key ID), i p\u00ebrdorur p\u00ebr dekriptimin e tabel\u00ebs, p\u00ebrb\u00ebhet nga UUID dhe KEY ID, t\u00eb lexuara nga titulli i hap\u00ebsir\u00ebs tabelore. Ajo q\u00eb po b\u00ebjm\u00eb tani \u00ebsht\u00eb p\u00ebrdit\u00ebsimi i k\u00ebsaj informacioni n\u00eb titullin e enkriptimit t\u00eb hap\u00ebsir\u00ebs tabelore, n\u00eb m\u00ebnyr\u00eb q\u00eb serveri t\u00eb marr\u00eb \u00e7el\u00ebsin kryesor t\u00eb sakt\u00eb.<\/p>\n<p>N\u00ebse kemi hap\u00ebsira tabelash q\u00eb vijn\u00eb nga vende t\u00eb ndryshme, p\u00ebr shembull, nga kopje t\u00eb ndryshme rezerv\u00eb, ato mund t\u00eb p\u00ebrdorin \u00e7el\u00ebsa kryesor\u00eb t\u00eb ndrysh\u00ebm. T\u00eb gjith\u00eb k\u00ebta \u00e7el\u00ebsa kryesor\u00eb do t\u00eb duhet t\u00eb nxirren nga depoja n\u00eb momentin e nisjes s\u00eb serverit. Kjo mund t\u00eb ngadal\u00ebsoj\u00eb nisjen e serverit, ve\u00e7an\u00ebrisht n\u00ebse p\u00ebrdoret depoja e \u00e7el\u00ebsave t\u00eb serverit. Me nd\u00ebrrimin e \u00e7el\u00ebsit kryesor, ne ri-enkriptojm\u00eb \u00e7el\u00ebsat e hap\u00ebsirave tabelash me nj\u00eb \u00e7el\u00ebs kryesor t\u00eb vet\u00ebm, q\u00eb \u00ebsht\u00eb i nj\u00ebjt\u00eb p\u00ebr t\u00eb gjitha hap\u00ebsirat tabelash. Tani, n\u00eb momentin e nisjes, serveri duhet t\u00eb marr\u00eb vet\u00ebm nj\u00eb \u00e7el\u00ebs kryesor.<\/p>\n<p>Kjo, natyrisht, \u00ebsht\u00eb vet\u00ebm nj\u00eb efekt an\u00ebsor i k\u00ebndsh\u00ebm. Q\u00ebllimi kryesor i nd\u00ebrrimit t\u00eb \u00e7el\u00ebsave kryesor\u00eb \u00ebsht\u00eb t\u00eb b\u00ebjm\u00eb serverin ton\u00eb m\u00eb t\u00eb sigurt. N\u00eb rast se \u00e7el\u00ebsi kryesor \u00ebsht\u00eb vjedhur ndonj\u00ebher\u00eb nga depoja (p\u00ebr shembull, nga Vault Server), ne mund t\u00eb gjenerojm\u00eb nj\u00eb \u00e7el\u00ebs kryesor t\u00eb ri dhe t\u00eb ri-enkriptojm\u00eb \u00e7el\u00ebsat e hap\u00ebsirave tabelash, duke e b\u00ebr\u00eb \u00e7el\u00ebsin e vjedhur t\u00eb pavlefsh\u00ebm. Ne jemi t\u00eb sigurt... pothuajse.<\/p>\n<p>N\u00eb artikullin e m\u00ebparsh\u00ebm, p\u00ebrmenda se pas vjedhjes s\u00eb \u00e7el\u00ebsit t\u00eb hap\u00ebsir\u00ebs s\u00eb tabel\u00ebs, nj\u00eb pal\u00eb e tret\u00eb mund ta p\u00ebrdor\u00eb at\u00eb p\u00ebr t\u00eb dekrypruar t\u00eb dh\u00ebnat, p\u00ebr sa koh\u00eb q\u00eb ka akses n\u00eb diskun ton\u00eb. N\u00eb rastin e vjedhjes s\u00eb \u00e7el\u00ebsit kryesor dhe me qasje n\u00eb t\u00eb dh\u00ebnat e enkriptuara, mund t\u00eb p\u00ebrdorim \u00e7el\u00ebsin kryesor t\u00eb vjedhur p\u00ebr t\u00eb dekrypruar \u00e7el\u00ebsin e hap\u00ebsir\u00ebs s\u00eb tabel\u00ebs dhe p\u00ebr t\u00eb marr\u00eb t\u00eb dh\u00ebna t\u00eb dekrypruara. Si\u00e7 shohim, rotacioni i \u00e7el\u00ebsit kryesor n\u00eb k\u00ebt\u00eb rast nuk ndihmon. Ne e enkriptojm\u00eb p\u00ebrs\u00ebri \u00e7el\u00ebsin e hap\u00ebsir\u00ebs s\u00eb tabel\u00ebs me nj\u00eb \u00e7el\u00ebs kryesor t\u00eb ri, por \u00e7el\u00ebsi real q\u00eb p\u00ebrdoret p\u00ebr enkriptimin \/ dekryprimin e t\u00eb dh\u00ebnave mbetet i nj\u00ebjt\u00eb. Prandaj, 'hakeri' mund ta p\u00ebrdor\u00eb at\u00eb p\u00ebr t\u00eb dekrypruar t\u00eb dh\u00ebnat. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/software\/mysql-database\/percona-server\"><u>Percona Server p\u00ebr MySQL<\/u><\/a><\/noindex> mund t\u00eb realizoj\u00eb rivendosje t\u00eb v\u00ebrtet\u00eb t\u00eb hap\u00ebsirave t\u00eb tabelave, jo vet\u00ebm nj\u00eb rivendosje t\u00eb thjesht\u00eb t\u00eb \u00e7el\u00ebsit t\u00eb hap\u00ebsir\u00ebs s\u00eb tabel\u00ebs. Ky funksion quhet kthesa t\u00eb kodimit (encryption threads). Megjithat\u00eb, deri tani kjo funksionalitet ende \u00ebsht\u00eb eksperimentale.<\/p>\n<p>Rrotacioni i \u00e7el\u00ebsit kryesor \u00ebsht\u00eb i dobish\u00ebm kur \u00e7el\u00ebsi kryesor \u00ebsht\u00eb vjedhur, por sulmuesi nuk ka m\u00ebnyr\u00eb ta p\u00ebrdor\u00eb dhe t\u00eb dekodoj\u00eb \u00e7el\u00ebsat e hap\u00ebsirave t\u00eb tabelave.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/dADq\/\"><strong>Regjistrohuni p\u00ebr nj\u00eb m\u00ebsim demonstrativ falas.<\/strong><\/a><\/noindex><\/p>\n<h4>Lexoni m\u00eb shum\u00eb:<\/h4>\n<ul>\n<li>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/522092\/\">Kriptimi n\u00eb MySQL: depoja e \u00e7el\u00ebsave<\/a><\/noindex><\/p>\n<\/li>\n<li>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/524050\/\">Kriptimi n\u00eb MySQL: p\u00ebrdorimi i \u00c7el\u00ebsit Kryesor<\/a><\/noindex><\/p>\n<\/li>\n<\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/524624\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u043f\u0440\u0435\u0434\u0434\u0432\u0435\u0440\u0438\u0438 \u0441\u0442\u0430\u0440\u0442\u0430 \u043d\u043e\u0432\u043e\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430 \u043d\u0430 \u043a\u0443\u0440\u0441&nbsp;\u00ab\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\u00bb&nbsp;\u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u0442\u044c \u0441\u0435\u0440\u0438\u044e \u0441\u0442\u0430\u0442\u0435\u0439 \u043f\u0440\u043e \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL. \u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044d\u0442\u043e\u0439 \u0441\u0435\u0440\u0438\u0438 \u043c\u044b \u043e\u0431\u0441\u0443\u0434\u0438\u043b\u0438, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u0433\u043b\u0430\u0432\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c (Master Key). \u0421\u0435\u0433\u043e\u0434\u043d\u044f, \u043e\u0441\u043d\u043e\u0432\u044b\u0432\u0430\u044f\u0441\u044c \u043d\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0445 \u0440\u0430\u043d\u0435\u0435 \u0437\u043d\u0430\u043d\u0438\u044f\u0445, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u0440\u043e\u0442\u0430\u0446\u0438\u044e \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439. \u0420\u043e\u0442\u0430\u0446\u0438\u044f \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u043e\u0432\u044b\u0439 \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u0438 \u044d\u0442\u0438\u043c \u043d\u043e\u0432\u044b\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":98089,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-98088","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=\"\u0412 \u043f\u0440\u0435\u0434\u0434\u0432\u0435\u0440\u0438\u0438 \u0441\u0442\u0430\u0440\u0442\u0430 \u043d\u043e\u0432\u043e\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430 \u043d\u0430 \u043a\u0443\u0440\u0441 \u00ab\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\u00bb \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u0442\u044c \u0441\u0435\u0440\u0438\u044e \u0441\u0442\u0430\u0442\u0435\u0439 \u043f\u0440\u043e \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL.\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044d\u0442\u043e\u0439 \u0441\u0435\u0440\u0438\u0438 \u043c\u044b \u043e\u0431\u0441\u0443\u0434\u0438\u043b\u0438, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u0433\u043b\u0430\u0432\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c (Master Key). \u0421\u0435\u0433\u043e\u0434\u043d\u044f, \u043e\u0441\u043d\u043e\u0432\u044b\u0432\u0430\u044f\u0441\u044c \u043d\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0445 \u0440\u0430\u043d\u0435\u0435 \u0437\u043d\u0430\u043d\u0438\u044f\u0445, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u0440\u043e\u0442\u0430\u0446\u0438\u044e \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439.\u0420\u043e\u0442\u0430\u0446\u0438\u044f \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u043e\u0432\u044b\u0439 \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u0438 \u044d\u0442\u0438\u043c \u043d\u043e\u0432\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e\" \/>\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\/shifrovanie-v-mysql-rotacziya-master-key\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0428\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL: \u0440\u043e\u0442\u0430\u0446\u0438\u044f Master Key | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u043f\u0440\u0435\u0434\u0434\u0432\u0435\u0440\u0438\u0438 \u0441\u0442\u0430\u0440\u0442\u0430 \u043d\u043e\u0432\u043e\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430 \u043d\u0430 \u043a\u0443\u0440\u0441 \u00ab\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\u00bb \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u0442\u044c \u0441\u0435\u0440\u0438\u044e \u0441\u0442\u0430\u0442\u0435\u0439 \u043f\u0440\u043e \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL.\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044d\u0442\u043e\u0439 \u0441\u0435\u0440\u0438\u0438 \u043c\u044b \u043e\u0431\u0441\u0443\u0434\u0438\u043b\u0438, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u0433\u043b\u0430\u0432\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c (Master Key). \u0421\u0435\u0433\u043e\u0434\u043d\u044f, \u043e\u0441\u043d\u043e\u0432\u044b\u0432\u0430\u044f\u0441\u044c \u043d\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0445 \u0440\u0430\u043d\u0435\u0435 \u0437\u043d\u0430\u043d\u0438\u044f\u0445, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u0440\u043e\u0442\u0430\u0446\u0438\u044e \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439.\u0420\u043e\u0442\u0430\u0446\u0438\u044f \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u043e\u0432\u044b\u0439 \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u0438 \u044d\u0442\u0438\u043c \u043d\u043e\u0432\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/shifrovanie-v-mysql-rotacziya-master-key\" \/>\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-10-24T00:42:34+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-11-17T22:58:48+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\udd47Kriptimi n\u00eb MySQL: rrotacioni i \u00c7el\u00ebsit Kryesor | ProHoster","description":"P\u00ebrpara fillimit t\u00eb grupit t\u00eb ri t\u00eb kursit \"Baza t\u00eb dh\u00ebnash\", vazhdojm\u00eb t\u00eb publikojm\u00eb nj\u00eb seri artikujsh mbi kriptimin n\u00eb MySQL. N\u00eb artikullin e m\u00ebparsh\u00ebm t\u00eb k\u00ebsaj serie, diskutuan si funksionon kriptimi me \u00e7el\u00ebsin kryesor (Master Key). Sot, duke u bazuar n\u00eb njohurit\u00eb e fituara m\u00eb par\u00eb, do t\u00eb shohim rrotacionin e \u00e7el\u00ebsave kryesor\u00eb. Rrotacioni i \u00e7el\u00ebsave kryesor\u00eb p\u00ebrfshin gjenerimin e nj\u00eb \u00e7el\u00ebsi t\u00eb ri kryesor dhe p\u00ebrdorimin e k\u00ebtij \u00e7el\u00ebsi t\u00eb ri p\u00ebrs\u00ebri.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/shifrovanie-v-mysql-rotacziya-master-key","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\u0428\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL: \u0440\u043e\u0442\u0430\u0446\u0438\u044f Master Key | ProHoster","og:description":"\u0412 \u043f\u0440\u0435\u0434\u0434\u0432\u0435\u0440\u0438\u0438 \u0441\u0442\u0430\u0440\u0442\u0430 \u043d\u043e\u0432\u043e\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430 \u043d\u0430 \u043a\u0443\u0440\u0441 \u00ab\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\u00bb \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u043c \u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u0442\u044c \u0441\u0435\u0440\u0438\u044e \u0441\u0442\u0430\u0442\u0435\u0439 \u043f\u0440\u043e \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL.\u0412 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044d\u0442\u043e\u0439 \u0441\u0435\u0440\u0438\u0438 \u043c\u044b \u043e\u0431\u0441\u0443\u0434\u0438\u043b\u0438, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0441 \u0433\u043b\u0430\u0432\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c (Master Key). \u0421\u0435\u0433\u043e\u0434\u043d\u044f, \u043e\u0441\u043d\u043e\u0432\u044b\u0432\u0430\u044f\u0441\u044c \u043d\u0430 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0445 \u0440\u0430\u043d\u0435\u0435 \u0437\u043d\u0430\u043d\u0438\u044f\u0445, \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0430 \u0440\u043e\u0442\u0430\u0446\u0438\u044e \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439.\u0420\u043e\u0442\u0430\u0446\u0438\u044f \u0433\u043b\u0430\u0432\u043d\u044b\u0445 \u043a\u043b\u044e\u0447\u0435\u0439 \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u043e\u0432\u044b\u0439 \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 \u0438 \u044d\u0442\u0438\u043c \u043d\u043e\u0432\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/shifrovanie-v-mysql-rotacziya-master-key","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-24T00:42:34+00:00","article:modified_time":"2020-11-17T22:58:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"98088","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:05:50","updated":"2022-10-03 07:13:53"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/98088","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=98088"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/98088\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/98089"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=98088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=98088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=98088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}