{"id":97667,"date":"2020-10-20T08:42:25","date_gmt":"2020-10-20T06:42:25","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-master-key"},"modified":"2020-10-20T08:42:25","modified_gmt":"2020-10-20T06:42:25","slug":"shifrovanie-v-mysql-ispolzovanie-master-key","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-master-key","title":{"rendered":"Andmete kr\u00fcpteerimine MySQL-is: Master Key'i kasutamine","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<h2><\/h2>\n<p><strong><em>Uue kursuse alguse eel\u00f5htul&nbsp;<\/em><\/strong><noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/wMyj\/\"><strong><em>Andmebaasid<\/em><\/strong><\/a><\/noindex><strong><em>&nbsp;j\u00e4tkame MySQL-i \u0161ifreerimist k\u00e4sitleva artiklisarjaga.<\/em><\/strong><\/p>\n<p><img decoding=\"async\" alt=\"Andmete kr\u00fcpteerimine MySQL-is: Master Key&#039;i kasutamine\" src=\"\/wp-content\/uploads\/2020\/10\/762866d2c321acd726e30606c9108122.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Eelmises artiklis selles sarjas (<noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/522092\/\"><u>Andmete kr\u00fcpteerimine MySQL-is: v\u00f5tmehoidjad<\/u><\/a><\/noindex>) r\u00e4\u00e4kisime v\u00f5tmehoidlatest. Selles artiklis k\u00e4sitleme, kuidas kasutatakse peamist v\u00f5tit (master key) ning arutame \u00fcmbriku \u0161ifreerimise (envelope encryption) eeliseid ja puudusi.&nbsp;<\/p>\n<p>\u00dcmbriku \u0161ifreerimise idee seisneb selles, et \u0161ifreerimiseks kasutatavad v\u00f5tmed (ruumiv\u00f5tmed) \u0161ifreeritakse teise v\u00f5tmega (peamine v\u00f5ti, master key). Andmete \u0161ifreerimiseks kasutatakse tegelikult ruumiv\u00f5tmeid. Graafiliselt v\u00f5ib seda kujutada j\u00e4rgmiselt:<\/p>\n<p><img decoding=\"async\" alt=\"Andmete kr\u00fcpteerimine MySQL-is: Master Key&#039;i kasutamine\" src=\"\/wp-content\/uploads\/2020\/10\/385afda0eff739f4720f59799c35b51f.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Peamine v\u00f5ti (master key) asub v\u00f5tmehordis (keyring) ja tabeliruumi v\u00f5tmed on \u0161ifreeritud tabeliruumi pealkirjades (tabeliruumi lehe 0).&nbsp;<\/p>\n<p>\u00dclaltoodud joonisel:<\/p>\n<ul>\n<li>\n<p>Tabel A on \u0161ifreeritud v\u00f5tmega 1 (Key 1). V\u00f5ti 1 on \u0161ifreeritud peamise v\u00f5tmega (master key) ja s\u00e4ilitab \u0161ifreeritud kujul tabeli A pealkirjas.<\/p>\n<\/li>\n<li>\n<p>Tabel B on \u0161ifreeritud v\u00f5tmega 2 (Key 2). V\u00f5ti 2 on \u0161ifreeritud peamise v\u00f5tmega (master key) ja s\u00e4ilitab \u0161ifreeritud kujul tabeli B pealkirjas.<\/p>\n<\/li>\n<li>\n<p>Ja nii edasi.<\/p>\n<\/li>\n<\/ul>\n<p>Kui server peab tabel A de\u0161ifreerima, siis saab ta v\u00f5tmehoidlast peamise v\u00f5tme, loeb \u0161ifreeritud v\u00f5tme 1 tabeli A pealkirjast ja de\u0161ifreerib v\u00f5tme 1. De\u0161ifreeritud v\u00f5ti 1 vahepeetakse serveri m\u00e4lus ja seda kasutatakse tabeli A de\u0161ifreerimiseks.<\/p>\n<h3>InnoDB<\/h3>\n<p>InnoDB-s toimub tegelik \u0161ifreerimine ja de\u0161ifreerimine sisend-v\u00e4ljund tasemel. See t\u00e4hendab, et leht \u0161ifreeritakse otse enne, kui see kirjutatakse ketta, ja de\u0161ifreeritakse vahetult p\u00e4rast lugemist kettalt.<\/p>\n<p>InnoDB-s toimub \u0161ifreerimine ainult ruumide tasemel. Ja vaikimisi luuakse k\u00f5ik tabelid eraldi ruumides (<noindex><a rel=\"nofollow\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/innodb-file-per-table-tablespaces.html\"><u>file-per-table tablespace<\/u><\/a><\/noindex>). Teisis\u00f5nu luuakse ruum, mis v\u00f5ib sisaldada ainult \u00fchte tabelit. Kuigi v\u00f5ite luua tabeleid ka peamises ruumis (<noindex><a rel=\"nofollow\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/general-tablespaces.html\"><u>general tablespace<\/u><\/a><\/noindex>). Kuid igal juhul on tabel alati mingis ruumis. Ja kuna \u0161ifreerimine toimub ruumide tasemel, siis on see kas t\u00e4ielikult \u0161ifreeritud v\u00f5i mitte. See t\u00e4hendab, et peamises ruumis ei saa ainult osa tabelitest \u0161ifreerida.&nbsp;<\/p>\n<p>Kui teil on mingil p\u00f5hjusel keelatud file-per-table, luuakse k\u00f5ik tabelid s\u00fcsteemi tabeliruumi (system tablespace) sisse. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/software\/mysql-database\/percona-server\"><u>Percona Server for MySQL<\/u><\/a><\/noindex> v\u00f5ib kr\u00fcpteerida s\u00fcsteemi tabeliruumi muutuja innodb<em>sys<\/em>tabeliruumi<em>kr\u00fcpteerimise (encryption threads) abil, kuid see on endiselt katsetamisfaasis. MySQL-s seda ei ole.<\/em><\/p>\n<p><em>Enne edasi liikumist peame vaatama peamise v\u00f5tme identifikaatori (master key ID) struktuuri. See koosneb UUID-st, AVA<\/em>ID ja ette (prefix) \u201eINNODBKey\u201c. See n\u00e4eb v\u00e4lja j\u00e4rgmine: INNODBKey-UUID-KEY<em>ID.<\/em><\/p>\n<p><em>UUID on serveri uuid, millel on \u0161ifreeritud tabeliruum. KEY<\/em>ID on lihtsalt pidevalt suurenev v\u00e4\u00e4rtus. Peamise v\u00f5tme KEY esmakordsel loomisel<em>ID on alguses 1. V\u00f5tme \u00fcmberp\u00f6\u00f6ramise korral, kui luuakse uus peamine v\u00f5tme, AVA<\/em>ID = 2 ja nii edasi. Peamise v\u00f5tme \u00fcmberp\u00f6\u00f6ramisest r\u00e4\u00e4gime j\u00e4rgmistes artiklites selles seerias.<\/p>\n<p>N\u00fc\u00fcd, kui me teame, milline n\u00e4eb v\u00e4lja peamise v\u00f5tme identifikaator, vaatame kr\u00fcpteeritud tabeliruumi p\u00e4ist. Kui tabeliruum on kr\u00fcpteeritud, lisatakse kr\u00fcpteerimise teave p\u00e4isele. See n\u00e4eb v\u00e4lja j\u00e4rgmiselt:<\/p>\n<p><img decoding=\"async\" alt=\"Andmete kr\u00fcpteerimine MySQL-is: Master Key&#039;i kasutamine\" src=\"\/wp-content\/uploads\/2020\/10\/0703933a85f0a106c07c0dbd6b7f4186.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>KEY ID on KEY<em>Peamise v\u00f5tme ID, millest oleme juba r\u00e4\u00e4kinud. UUID on serveri uuid, mida kasutatakse ka peamise v\u00f5tme identifikaatoris. TABLESPACE KEY on tabeliruumi v\u00f5ti, mis koosneb 256 bitist, mis on juhuslikult genereeritud serveri poolt. Kinnitatud vektor (IV, initialization vector) koosneb samuti 256 juhuslikult genereeritud bitist (kuigi see peaks olema 128 bitine). IV-d kasutatakse AES-i kr\u00fcpteerimise ja dekr\u00fcpteerimise algatamiseks (256 bitist kasutatakse ainult 128). L\u00f5pus on TABLESPACE KEY ja IV jaoks CRC32 kontrollsumma.<\/em><\/p>\n<p><em>Miks on CRC32 vajalik?<\/em><\/p>\n<h3>Miks on vajalik CRC32?<\/h3>\n<p><em>Kahes s\u00f5nas \u00f6eldes, t\u00f5endab peamise v\u00f5tme kehtivust. P\u00e4rast ruumiv\u00f5tme ja initsialiseerimism\u00f5\u00f5turi dekodeerimist arvutatakse kontrollsummad ja v\u00f5rreldakse tabeli p\u00e4ises salvestatud CRC32-ga. Kui kontrollsummad \u00fchtivad, siis on meil \u00f5ige peamine v\u00f5ti ja ruumiv\u00f5ti. Vastasel juhul m\u00e4rgistatakse ruum nagu puuduv (me ei suuda seda ikkagi dekodeerida).<\/em><\/p>\n<p><em>V\u00f5ite k\u00fcsida: millal toimub v\u00f5tmete kontrollimine? Vastus on - serveri k\u00e4ivitamisel. Server, millel on \u0161ifreeritud tabelid \/ tabeliruumid, loeb k\u00e4ivitamisel UUID, KEY<\/em>Pealkirja ID ja genereerib peamise v\u00f5tme identifikaatori. Seej\u00e4rel saab see vajaliku peamise v\u00f5tme v\u00f5tmehordist (keyring), dekr\u00fcpteerib tabeliruumi v\u00f5tme ja kontrollib kontrollsummat. Veel kord, kui kontrollsumma \u00fchtib, siis on k\u00f5ik korras, kui ei - tabeliruum m\u00e4rgitakse kadunuks.<\/p>\n<p>Kui olete lugenud selle seeria eelmist artiklit (<noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/522092\/\"><u>Andmete kr\u00fcpteerimine MySQL-is: v\u00f5tmehoidjad<\/u><\/a><\/noindex>), siis v\u00f5ite ehk meenutada, et serveri v\u00f5tmehoidla kasutamisel saab server k\u00e4ivitamisel ainult v\u00f5tme ID-de nimekirja, t\u00e4psemalt key id ja user id, kuna see paar tuvastab v\u00f5tme \u00fchem\u00f5tteliselt. Ja n\u00fc\u00fcd \u00fctlen, et server saab k\u00e4ivitamisel k\u00f5ik v\u00f5tmed, mis on vajalikud, et kontrollida tabeli v\u00f5tmete dekodeerimise v\u00f5imalust. Nii et miks laaditakse serveri v\u00f5tmehoidla initsialiseerimisel vaid key<em>id ja user<\/em>id, mitte k\u00f5ik v\u00f5tmed? Sest k\u00f5iki v\u00f5tmeid ei pruugi vaja minna. Enamasti on see seotud peamise v\u00f5tme rotatsiooniga. Peamise v\u00f5tme rotatsiooni korral luuakse hoidlasse uus peamine v\u00f5ti, kuid vanad v\u00f5tmed ei k\u00f5rvaldata. Nii et serveri v\u00f5tmehoidlas v\u00f5ib olla palju v\u00f5tmeid, mida server ei vaja ja seega ei laadita neid serveri k\u00e4ivitamisel.<\/p>\n<p>On aeg r\u00e4\u00e4kida peamistest plussidest ja miinustest, mis on seotud peamise v\u00f5tmega kr\u00fcpteerimisega. Suurim eelis on see, et teil on vaja vaid \u00fchte kr\u00fcpteerimisv\u00f5tit (peamine v\u00f5ti), mis hoitakse eraldi teie kr\u00fcpteeritud andmetest. See teeb serveri k\u00e4ivitamise kiireks ja salvestusruumi v\u00e4heseks, mis lihtsustab haldamist. Samuti on ainus peamine v\u00f5ti kergesti uuesti genereeritav.<\/p>\n<p>Siiski on peamise v\u00f5tmega kr\u00fcpteerimisel \u00fcks suur puudus: p\u00e4rast seda, kui tabeliruum on kr\u00fcpteeritud tablespace_key abil, j\u00e4\u00e4b see alati sama v\u00f5tmega kr\u00fcpteerituks. Peamise v\u00f5tme vahetamine ei aita siin. Miks see on puuduseks? Teame, et MySQL-is on vigu, mis v\u00f5ivad viia ootamatu kokkuvarisemiseni ja core-faili loomise nii. Kuna core-fail sisaldab serveri m\u00e4lu dumpi, v\u00f5ib juhtuda, et dumpis on kr\u00fcpteerimata tabeliruumi v\u00f5tme. Mis veel hullem, dekr\u00fcpteeritud tabeliruumi v\u00f5tmed hoitakse m\u00e4lu sees, mis v\u00f5ib vahetuda kettale. V\u00f5ite \u00f6elda, et see ei ole puudus, kuna teil on nende failide ja vahetusala juurde p\u00e4\u00e4semiseks vajalikud root \u00f5igused. Jah. Kuid root on vajalik vaid m\u00f5neks ajaks. Kui keegi p\u00e4\u00e4seb juurde dekr\u00fcpteeritud tabeliruumi v\u00f5tmele, saab ta \/ ta j\u00e4tkata selle kasutamist andmete dekr\u00fcpteerimiseks, isegi ilma root \u00f5igusteta. Lisaks v\u00f5ib ketas olla varastatud ja vahetusala \/ core-failid v\u00f5ivad olla kolmandate osapoolte vahenditega loetavad. TDE eesm\u00e4rk on muuta see loetamatuks, isegi kui ketas on varastatud. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/software\/mysql-database\/percona-server\"><u>Percona Server for MySQL<\/u><\/a><\/noindex> on v\u00f5imalus tabeliruumi uuesti kr\u00fcpteerida uute genereeritud v\u00f5tmetega. Seda funktsiooni nimetatakse kr\u00fcpteerimise voogudeks (encryption threads) ja selle artikli kirjutamise hetkel on see endiselt katsej\u00e4rgus.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/wMyj\/\"><strong>Pi-KVM \u2014 avatud IP-KVM projekt Raspberry Pi-l<\/strong><\/a><\/noindex><\/p>\n<h3>Loe edasi:<\/h3>\n<ul>\n<li>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/522092\/\">Andmete kr\u00fcpteerimine MySQL-is: v\u00f5tmehoidjad<\/a><\/noindex><\/p>\n<\/li>\n<\/ul>\n<p>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/524050\/\">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 (\u0428\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0432 MySQL: \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u043a\u043b\u044e\u0447\u0435\u0439) \u043c\u044b \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u0438 \u043e \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430\u0445 \u043a\u043b\u044e\u0447\u0435\u0439. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0433\u043b\u0430\u0432\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 (master key), \u0430 \u0442\u0430\u043a\u0436\u0435 \u043e\u0431\u0441\u0443\u0434\u0438\u043c \u0434\u043e\u0441\u0442\u043e\u0438\u043d\u0441\u0442\u0432\u0430 \u0438 \u043d\u0435\u0434\u043e\u0441\u0442\u0430\u0442\u043a\u0438 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043c\u0435\u0442\u043e\u0434\u043e\u043c \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u043e\u0432 (envelope encryption).&nbsp; \u0418\u0434\u0435\u044f \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043a\u043e\u043d\u0432\u0435\u0440\u0442\u043e\u0432 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":97668,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-97667","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.1.1 - 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.\" \/>\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\/et\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-master-key\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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: \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-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-20T06:42:25+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-10-20T06:42:25+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\udd47Kr\u00fcpteerimine MySQL-is: peamise v\u00f5tme kasutamine | ProHoster","description":"Uue andmebaasi kursuse alguse eel\u00f5htul j\u00e4tkame.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-master-key","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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: \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 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.","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/shifrovanie-v-mysql-ispolzovanie-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-20T06:42:25+00:00","article:modified_time":"2020-10-20T06:42:25+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"97667","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:15:28","updated":"2022-10-03 07:13:51","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/97667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=97667"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/97667\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/97668"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=97667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=97667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=97667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}