{"id":97664,"date":"2020-10-20T08:42:20","date_gmt":"2020-10-20T06:42:20","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej"},"modified":"2020-10-20T08:42:20","modified_gmt":"2020-10-20T06:42:20","slug":"shifrovanie-v-mysql-hranilishhe-klyuchej","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej","title":{"rendered":"\u0160ifr\u0113\u0161ana MySQL: atsl\u0113gu kr\u0101tuve","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><b><i>Pirms jaun\u0101 kursa uzs\u0101k\u0161anas <noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/luFp\/\">\u201eDatu b\u0101zes\u201d<\/a><\/noindex> m\u0113s sagatavoj\u0101m jums noder\u012bgas raksta tulkojumu.<\/i><\/b><\/p>\n<p><img decoding=\"async\" alt=\"\u0160ifr\u0113\u0161ana MySQL: atsl\u0113gu kr\u0101tuve\" src=\"\/wp-content\/uploads\/2020\/10\/aeca40f53fe6bdf2a9897aa835ff597d.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Caurskat\u0101ma datu \u0161ifr\u0113\u0161ana (Transparent Data Encryption, TDE) par\u0101d\u012bj\u0101s <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/software\/mysql-database\/percona-server\">Percona Server for MySQL<\/a><\/noindex> un MySQL sam\u0113r\u0101 sen. Bet vai k\u0101dreiz esat dom\u0101ju\u0161i par to, k\u0101 tas darbojas aizkulis\u0113s un k\u0101du ietekmi TDE var atst\u0101t uz j\u016bsu serveri? \u0160aj\u0101 rakstu s\u0113rij\u0101 m\u0113s apl\u016bkosim, k\u0101 TDE darbojas iek\u0161pus\u0113. S\u0101ksim ar atsl\u0113gu glab\u0101\u0161anu, jo t\u0101 ir nepiecie\u0161ama jebk\u0101das \u0161ifr\u0113\u0161anas darb\u012bbai. P\u0113c tam s\u012bk\u0101k izskat\u012bsim, k\u0101 \u0161ifr\u0113\u0161ana darbojas Percona Server for MySQL\/MySQL un k\u0101das papildu iesp\u0113jas ir Percona Server for MySQL.<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h3>MySQL atsl\u0113gu kr\u0101tuve<\/h3>\n<p>\nAtsl\u0113gu kr\u0101tuve ir spraud\u0146i, kas \u013cauj serverim piepras\u012bt, izveidot un dz\u0113st atsl\u0113gas lok\u0101l\u0101 fail\u0101 (keyring_file) vai att\u0101lin\u0101t\u0101 server\u012b (piem\u0113ram, HashiCorp Vault). Atsl\u0113gas vienm\u0113r tiek ke\u0161otas lok\u0101li, lai pa\u0101trin\u0101tu to ieg\u016b\u0161anu. <\/p>\n<p>Spraud\u0146us var klasific\u0113t div\u0101s kategorij\u0101s:<\/p>\n<ul>\n<li>Lok\u0101l\u0101 glab\u0101tuve. Piem\u0113ram, lok\u0101lais fails (m\u0113s to saucam par failu pam\u0101tu atsl\u0113gu kr\u0101tuvi, file-based keyring).<\/li>\n<li>Att\u0101lin\u0101t\u0101 glab\u0101tuve. Piem\u0113ram, Vault Server (m\u0113s to saucam par servera pam\u0101tu atsl\u0113gu kr\u0101tuvi, server-based keyring).<\/li>\n<\/ul>\n<p>\n\u0160\u012b dal\u012b\u0161ana ir svar\u012bga, jo da\u017e\u0101di glab\u0101tuves veidi darba laik\u0101 uzvedas nedaudz at\u0161\u0137ir\u012bgi ne tikai atsl\u0113gu glab\u0101\u0161an\u0101 un ieg\u016b\u0161an\u0101, bet ar\u012b palai\u0161anas laik\u0101.<\/p>\n<p>Izmantojot failu pam\u0101tu glab\u0101tuvi, vis\u0101 glab\u0101tuves satur\u0101 tiek iel\u0101d\u0113ti l\u012bdz\u012bgi dati: key id, key user, key type un pati atsl\u0113ga.<\/p>\n<p>Savuk\u0101rt servera pam\u0101ta glab\u0101tuves (piem\u0113ram, Vault servera) gad\u012bjum\u0101 tiek iel\u0101d\u0113ti tikai key id un key user, t\u0101d\u0113j\u0101di atsl\u0113gu ieg\u016b\u0161ana nesamazin\u0101s palai\u0161anas \u0101trumu. Atsl\u0113gas tiek iel\u0101d\u0113tas slink\u0101ki. Tas noz\u012bm\u0113, ka pati atsl\u0113ga tiek iel\u0101d\u0113ta no Vault tikai tad, kad t\u0101 tie\u0161\u0101m ir nepiecie\u0161ama. P\u0113c iel\u0101des atsl\u0113ga tiek ke\u0161ota atmi\u0146\u0101, lai n\u0101kotn\u0113 neb\u016btu nepiecie\u0161ams atk\u0101rtoti v\u0113rsties p\u0113c t\u0101s caur TLS savienojumiem uz Vault Server. Turpm\u0101k apl\u016bkosim, k\u0101da inform\u0101cija atrodas atsl\u0113gu glab\u0101tuv\u0113.<\/p>\n<p>Inform\u0101cija par atsl\u0113gu ietver sekojo\u0161o:<\/p>\n<ul>\n<li><b>key id<\/b> \u2014 atsl\u0113gas identifikators, piem\u0113ram: <br \/>\n <code>INNODBKey-764d382a-7324-11e9-ad8f-9cb6d0d5dc99-1<\/code><\/li>\n<li><b>key type<\/b> \u2014 atsl\u0113gas tips, pamatojoties uz izmantoto \u0161ifr\u0113\u0161anas algoritmu, iesp\u0113jam\u0101s v\u0113rt\u012bbas: \u201eAES\u201d, \u201eRSA\u201d vai \u201eDSA\u201d.<\/li>\n<li><b>key length<\/b> \u2014 atsl\u0113gas garums baitos, AES: 16, 24 vai 32, RSA 128, 256, 512 un DSA 128, 256 vai 384.<\/li>\n<li><b>user<\/b> \u2014 atsl\u0113gas \u012bpa\u0161nieks. Ja atsl\u0113ga ir sist\u0113mas atsl\u0113ga, piem\u0113ram, Master Key, tad \u0161is lauks ir tuk\u0161s. Ja atsl\u0113ga tiek izveidota, izmantojot keyring_udf, tad \u0161is lauks apz\u012bm\u0113 atsl\u0113gas \u012bpa\u0161nieku.<\/li>\n<li><b>pati atsl\u0113ga<\/b><\/li>\n<\/ul>\n<p>\nAtsl\u0113ga tiek nep\u0101rprotami identific\u0113ta ar p\u0101ri: key_id, lietot\u0101js.<\/p>\n<p>T\u0101pat ir at\u0161\u0137ir\u012bbas atsl\u0113gu glab\u0101\u0161an\u0101 un dz\u0113\u0161an\u0101.<\/p>\n<p>Failu glab\u0101tuve darbojas \u0101tr\u0101k. Var\u0113tu pie\u0146emt, ka atsl\u0113gu glab\u0101tuve ir vienk\u0101r\u0161a vienreiz\u0113ja atsl\u0113gas ierakst\u012b\u0161ana fail\u0101, bet t\u0101 nav \u2014 \u0161eit notiek vair\u0101k darb\u012bbu. Jebkur\u0101 failu glab\u0101tuves modific\u0113\u0161an\u0101 vispirms tiek izveidota visa satura dubl\u0113jumkopija. Pie\u0146emsim, ka fails saucas my_biggest_secrets, tad dubl\u0113jumkopija b\u016bs my_biggest_secrets.backup. P\u0113c tam tiek main\u012bts ke\u0161atmi\u0146a (tiek pievienotas vai dz\u0113stas atsl\u0113gas) un, ja viss izpild\u012bts sekm\u012bgi, tad ke\u0161atmi\u0146a tiek iztuk\u0161ota fail\u0101. Retos gad\u012bjumos, piem\u0113ram, servera k\u013c\u016bmes gad\u012bjum\u0101, j\u016bs varat redz\u0113t \u0161o dubl\u0113jumfailu. Dubl\u0113jumfails tiek izdz\u0113sts n\u0101kamreiz, kad tiek iel\u0101d\u0113tas atsl\u0113gas (parasti p\u0113c servera restart\u0113\u0161anas).<\/p>\n<p>Saglab\u0101jot vai dz\u0113\u0161ot atsl\u0113gu servera glab\u0101tuv\u0113, glab\u0101tuve ir j\u0101savienojas ar MySQL serveri ar komandu \"s\u016bt\u012bt atsl\u0113gu\" \/ \"piepras\u012bt atsl\u0113gas dz\u0113\u0161anu\" (\"send the key\" \/ \"request key deletion\").<\/p>\n<p>Atgriez\u012bsimies pie servera palai\u0161anas \u0101truma. Papildus tam, ka uz palai\u0161anas \u0101trumu ietekm\u0113 pati glab\u0101tuve, ir ar\u012b jaut\u0101jums, cik daudz atsl\u0113gu no glab\u0101tuves ir nepiecie\u0161ams sa\u0146emt palai\u0161anas laik\u0101. Protams, tas ir \u012bpa\u0161i svar\u012bgi servera glab\u0101tuv\u0113m. Palai\u0161anas laik\u0101 serveris p\u0101rbauda, kura atsl\u0113ga ir nepiecie\u0161ama \u0161ifr\u0113tajiem tabul\u0101m \/ tabulu telp\u0101m un pieprasa atsl\u0113gu no glab\u0101tuves. Uz \"t\u012bra\" servera ar Master Key \u2014 \u0161ifr\u0113\u0161anai j\u0101b\u016bt vienai Master Key, kas ir j\u0101izvelk no glab\u0101tuves. Tom\u0113r var b\u016bt nepiecie\u0161ams ar\u012b liel\u0101ks atsl\u0113gu skaits, piem\u0113ram, kad dubl\u0113jumkopija no galven\u0101 servera tiek atjaunota rezerves server\u012b. \u0160\u0101dos gad\u012bjumos j\u0101paredz Master Key rot\u0101cija. S\u012bk\u0101k par to tiks diskut\u0113ts turpm\u0101kaj\u0101s rakstos, lai gan \u0161eit es grib\u0113tu atz\u012bm\u0113t, ka serveris, kas izmanto vair\u0101kas Master Key, var iedarbin\u0101ties nedaudz ilg\u0101k, it \u012bpa\u0161i, izmantojot servera atsl\u0113gu glab\u0101tuvi.<\/p>\n<p>Tagad nedaudz parun\u0101sim par keyring_file. Kad es izstr\u0101d\u0101ju keyring_file, man ar\u012b bija ba\u017eas par to, k\u0101 p\u0101rbaud\u012bt keyring_file izmai\u0146as servera darb\u012bbas laik\u0101. Versij\u0101 5.7 p\u0101rbaude tika veikta, balstoties uz faila statistiku, kas nebija ide\u0101ls risin\u0101jums, un 8.0 tas tika aizst\u0101ts ar SHA256 kontrolsummu.<\/p>\n<p>Pirmaj\u0101 palai\u0161anas reiz\u0113 keyring_file apr\u0113\u0137ina faila statistiku un kontrolsummu, kuras serveris atceras, un izmai\u0146as tiek piem\u0113rotas tikai tad, ja t\u0101s sakr\u012bt. Mainoties failam, kontrolsumma tiek atjaunin\u0101ta.<\/p>\n<p>M\u0113s jau esam apspriedu\u0161i daudzus jaut\u0101jumus par atsl\u0113gu kr\u0101tuv\u0113m. Tom\u0113r ir v\u0113l viena svar\u012bga t\u0113ma, par kuru bie\u017ei aizmirst vai nepareizi saprot \u2014 atsl\u0113gu sadal\u012b\u0161ana starp serveriem. <\/p>\n<p>Ko es ar to dom\u0101ju? Katram serverim (piem\u0113ram, Percona Server) klaster\u012b j\u0101b\u016bt atsevi\u0161\u0137ai vietai Vault server\u012b, kur Percona Server j\u0101uzglab\u0101 savas atsl\u0113gas. Katrs Master Key, kas saglab\u0101ts kr\u0101tuv\u0113, satur Percona Server GUID sav\u0101 identifikator\u0101. K\u0101p\u0113c tas ir svar\u012bgi? Iedom\u0101jieties, ka jums ir tikai viens Vault serveris, un visi Percona serveri klaster\u012b izmanto \u0161o vien\u012bgo Vault serveri. Probl\u0113ma \u0161\u0137iet ac\u012bmredzama. Ja visi Percona serveri izmantotu Master Key bez unik\u0101liem identifikatoriem, piem\u0113ram, id = 1, id = 2 utt., tad visi serveri klaster\u012b izmantotu to pa\u0161u Master Key. Tie\u0161i to nodro\u0161ina GUID \u2014 no\u0161\u0137ir\u0161ana starp serveriem. K\u0101p\u0113c tad run\u0101t par atsl\u0113gu sadal\u012b\u0161anu starp serveriem, ja jau past\u0101v unik\u0101ls GUID? Ir v\u0113l viens spraudnis \u2014 keyring_udf. Izmantojot \u0161o spraudni, j\u016bsu servera lietot\u0101js var glab\u0101t savas atsl\u0113gas Vault server\u012b. Probl\u0113mas rodas, kad lietot\u0101js izveido atsl\u0113gu, piem\u0113ram, server\u012b server1, un tad m\u0113\u0123ina izveidot atsl\u0113gu ar t\u0101du pa\u0161u identifikatoru server\u012b server2, piem\u0113ram:<\/p>\n<pre><code class=\"sql\">--server1:\nselect keyring_key_store('ROB_1','AES',\"123456789012345\");\n1\n--1 noz\u012bm\u0113 veiksm\u012bgu pabeig\u0161anu\n--server2:\nselect keyring_key_store('ROB_1','AES',\"543210987654321\");\n1<\/code><\/pre>\n<p>\nPagaidiet. Abi serveri izmanto to pa\u0161u Vault serveri, vai funkcion\u0101lai keyring_key_store nevajadz\u0113tu beigties ar k\u013c\u016bdu server\u012b server2? Interesanti, ka, ja j\u016bs m\u0113\u0123in\u0101t izdar\u012bt to pa\u0161u vien\u0101 server\u012b, j\u016bs sa\u0146emsiet k\u013c\u016bdu:<\/p>\n<pre><code class=\"sql\">--server1:\nselect keyring_key_store('ROB_1','AES',\"123456789012345\");\n1\nselect keyring_key_store('ROB_1','AES',\"543210987654321\");\n0<\/code><\/pre>\n<p>\nPareizi, ROB_1 jau past\u0101v.<\/p>\n<p>S\u0101ksim ar otro piem\u0113ru. K\u0101 jau iepriek\u0161 piemin\u0113j\u0101m, keyring_vault vai jebkur\u0161 cits glab\u0101\u0161anas spraudnis (keyring) ke\u0161atmi\u0146\u0101 saglab\u0101 visus atsl\u0113gu identifikatorus. T\u0101d\u0113j\u0101di, izveidojot jaunu atsl\u0113gu, ROB_1 tiek pievienots serverim server1, un, papildus nos\u016btot \u0161o atsl\u0113gu Vault, atsl\u0113ga tiek pievienota ar\u012b ke\u0161atmi\u0146ai. Tagad, kad m\u0113\u0123in\u0101m pievienot to pa\u0161u atsl\u0113gu otro reizi, keyring_vault p\u0101rbauda, vai \u0161\u012b atsl\u0113ga eksist\u0113 ke\u0161atmi\u0146\u0101, un atgrie\u017e k\u013c\u016bdu. <\/p>\n<p>Pirmaj\u0101 gad\u012bjum\u0101 situ\u0101cija ir cit\u0101da. Serveros server1 un server2 ir atsevi\u0161\u0137as ke\u0161atmi\u0146as. P\u0113c ROB_1 pievieno\u0161anas atsl\u0113gu ke\u0161\u0101 server\u012b server1 un server\u012b Vault, atsl\u0113gu ke\u0161a server\u012b server2 netiek sinhroniz\u0113ta. Ke\u0161\u0101 server\u012b server2 nav atsl\u0113gas ROB_1. T\u0101d\u0113j\u0101di atsl\u0113ga ROB_1 tiek ierakst\u012bta keyring_key_store un server\u012b Vault, kas faktiski p\u0101rraksta (!) iepriek\u0161\u0113jo v\u0113rt\u012bbu. Tagad atsl\u0113ga ROB_1 server\u012b Vault ir 543210987654321. Interesanti, ka servers Vault \u0161\u0101das darb\u012bbas neblo\u0137\u0113 un viegli p\u0101rraksta veco v\u0113rt\u012bbu.<\/p>\n<p>Tagad m\u0113s redzam, k\u0101p\u0113c serveru sadal\u012bjums Vault var b\u016bt svar\u012bgs \u2014 kad izmantojat keyring_udf un v\u0113laties glab\u0101t atsl\u0113gas Vault. K\u0101 nodro\u0161in\u0101t \u0161\u0101du sadal\u012bjumu Vault server\u012b? <\/p>\n<p>Ir divi veidi, k\u0101 sadal\u012bt Vault. Var izveidot da\u017e\u0101das piest\u0101tnes katram serverim vai izmantot da\u017e\u0101das ce\u013cus vien\u0101 piest\u0101tn\u0113. Vislab\u0101k to par\u0101d\u012bt ar piem\u0113riem. T\u0101tad, vispirms apl\u016bkosim atsevi\u0161\u0137as piest\u0101tnes: <\/p>\n<pre><code class=\"sql\">--server1:\nvault_url = http:\/\/127.0.0.1:8200\nsecret_mount_point = server1_mount\ntoken = (...)\nvault_ca = (...)\n\n--server2:\nvault_url = http:\/\/127.0.0.1:8200\nsecret_mount_point = sever2_mount\ntoken = (...)\nvault_ca = (...)<\/code><\/pre>\n<p>\n\u0160eit redzams, ka server1 un server2 izmanto da\u017e\u0101das piest\u0101tnes. Kad ce\u013ci tiek sadal\u012bti, konfigur\u0101cija izskat\u012bsies \u0161\u0101di:<\/p>\n<pre><code class=\"sql\">--server1:\nvault_url = http:\/\/127.0.0.1:8200\nsecret_mount_point = mount_point\/server1\ntoken = (...)\nvault_ca = (...)\n--server2:\nvault_url = http:\/\/127.0.0.1:8200\nsecret_mount_point = mount_point\/sever2\ntoken = (...)\nvault_ca = (...)<\/code><\/pre>\n<p>\n\u0160aj\u0101 gad\u012bjum\u0101 abi serveri izmanto to pa\u0161u mont\u0113\u0161anas punktu \u00abmount_point\u00bb, bet at\u0161\u0137ir\u012bgas ce\u013cus. Izveidojot pirmo slepenu inform\u0101ciju server\u012b server1 \u0161aj\u0101 ce\u013c\u0101, Vault serveris autom\u0101tiski izveido direktoriju \u00abserver1\u00bb. Ar\u012b server2 ir l\u012bdz\u012bgi. Kad j\u016bs dz\u0113\u0161at p\u0113d\u0113jo slepeno inform\u0101ciju mont\u0113\u0161anas punkt\u0101 mount_point\/server1 vai mount_point\/server2, Vault serveris ar\u012b dz\u0113\u0161 \u0161\u012bs direktorijas. Ja j\u016bs izmantojat ce\u013cu dal\u012b\u0161anu, jums b\u016btu j\u0101izveido tikai viens mont\u0113\u0161anas punkts un j\u0101maina konfigur\u0101cijas faili, lai serveri izmantotu atsevi\u0161\u0137us ce\u013cus. Mont\u0113\u0161anas punktu var izveidot, izmantojot HTTP piepras\u012bjumu. Ar CURL to var izdar\u012bt \u0161\u0101di:<\/p>\n<pre><code class=\"sql\">curl -L -H \"X-Vault-Token: TOKEN\" \u2013cacert VAULT_CA\n--data '{\"type\":\"generic\"}' --request POST VAULT_URL\/v1\/sys\/mounts\/SECRET_MOUNT_POINT<\/code><\/pre>\n<p>\nVisi lauki (TOKEN, VAULT_CA, VAULT_URL, SECRET_MOUNT_POINT) atbilst konfigur\u0101cijas faila parametriem. Protams, var izmantot Vault r\u012bkus, lai izdar\u012btu to pa\u0161u. Bet t\u0101 ir vienk\u0101r\u0161\u0101ka mont\u0113\u0161anas punkta izveide autom\u0101tiz\u0101cijas proces\u0101. Ceru, ka \u0161\u012b inform\u0101cija jums noder\u0113s, un tiksimies n\u0101kamajos \u0161\u012bs s\u0113rijas rakstos.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/otus.pw\/luFp\/\"><img decoding=\"async\" alt=\"\u0160ifr\u0113\u0161ana MySQL: atsl\u0113gu kr\u0101tuve\" src=\"\/wp-content\/uploads\/2020\/10\/291dcdd68660bfc312021582baa628ab.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/p>\n<blockquote>\n<h4>Las\u012bt v\u0113l:<\/h4>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/497466\/\">Sysbench un nejau\u0161u main\u012bgo sadale<\/a><\/noindex><\/li>\n<\/ul>\n<\/blockquote>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/otus\/blog\/522092\/\">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 \u00ab\u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\u00bb \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b\u0438 \u0434\u043b\u044f \u0432\u0430\u0441 \u043f\u0435\u0440\u0435\u0432\u043e\u0434 \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438. \u041f\u0440\u043e\u0437\u0440\u0430\u0447\u043d\u043e\u0435 \u0448\u0438\u0444\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (Transparent Data Encryption, TDE) \u043f\u043e\u044f\u0432\u0438\u043b\u043e\u0441\u044c \u0432 Percona Server for MySQL \u0438 MySQL \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u0434\u0430\u0432\u043d\u043e. \u041d\u043e \u0437\u0430\u0434\u0443\u043c\u044b\u0432\u0430\u043b\u0438\u0441\u044c \u043b\u0438 \u0432\u044b \u043a\u043e\u0433\u0434\u0430-\u043d\u0438\u0431\u0443\u0434\u044c \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u043e\u043d\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043f\u043e\u0434 \u043a\u0430\u043f\u043e\u0442\u043e\u043c \u0438 \u043a\u0430\u043a\u043e\u0435 \u0432\u043b\u0438\u044f\u043d\u0438\u0435 TDE \u043c\u043e\u0436\u0435\u0442 \u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0442\u044c \u043d\u0430 \u0432\u0430\u0448 \u0441\u0435\u0440\u0432\u0435\u0440? \u0412 \u044d\u0442\u043e\u0439 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":97665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-97664","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.5 - 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\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b\u0438 \u0434\u043b\u044f \u0432\u0430\u0441 \u043f\u0435\u0440\u0435\u0432\u043e\u0434 \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438.\" \/>\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\/lv\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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: \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u043a\u043b\u044e\u0447\u0435\u0439 | 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\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b\u0438 \u0434\u043b\u044f \u0432\u0430\u0441 \u043f\u0435\u0440\u0435\u0432\u043e\u0434 \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej\" \/>\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:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-10-20T06:42:20+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\udd47\u0160ifr\u0113\u0161ana MySQL: atsl\u0113gu kr\u0101tuve | ProHoster","description":"Pirms jaun\u0101 kursa \u00abDatu b\u0101zes\u00bb uzs\u0101k\u0161anas esam sagatavoju\u0161i jums noder\u012bgas raksta tulkojumu.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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: \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u043a\u043b\u044e\u0447\u0435\u0439 | 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\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b\u0438 \u0434\u043b\u044f \u0432\u0430\u0441 \u043f\u0435\u0440\u0435\u0432\u043e\u0434 \u043f\u043e\u043b\u0435\u0437\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0438.","og:url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/shifrovanie-v-mysql-hranilishhe-klyuchej","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:20+00:00","article:modified_time":"2020-10-20T06:42:20+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"97664","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:50","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/97664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=97664"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/97664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/97665"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=97664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=97664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=97664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}