{"id":111102,"date":"2023-10-26T15:10:14","date_gmt":"2023-10-26T13:10:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-8-2-0"},"modified":"2023-10-26T15:10:14","modified_gmt":"2023-10-26T13:10:14","slug":"dostupna-subd-mysql-8-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/dostupna-subd-mysql-8-2-0","title":{"rendered":"Pieejama MySQL 8.2.0 datu b\u0101ze","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle uz\u0146\u0113mums ir izveidojis jaunu MySQL 8.2 datu b\u0101zes versiju un public\u0113jis labojuma atjaunin\u0101jumus MySQL 8.0.35 un 5.7.44. MySQL Community Server 8.2.0 izdevumi ir sagatavoti vis\u0101m galvenaj\u0101m Linux, FreeBSD, macOS un Windows distrib\u016bcij\u0101m.    <\/p>\n<p>MySQL 8.2.0 ir otrais izlaidums, kas izveidots saska\u0146\u0101 ar jauno versiju veido\u0161anas modeli, kas paredz divu veidu MySQL zarus \u2014 \u00abInov\u0101cija\u00bb un \u00abLTS\u00bb. Inov\u0101cijas zaru, uz kuriem attiecas MySQL 8.1 un 8.2, ieteicams izmantot tiem, kas v\u0113las \u0101tr\u0101k piek\u013c\u016bt jauniem funkcion\u0101lajiem risin\u0101jumiem. \u0160ie zari tiek public\u0113ti reizi tr\u012bs m\u0113ne\u0161os un tiek atbalst\u012bti tikai l\u012bdz n\u0101kam\u0101 noz\u012bm\u012bg\u0101 izlaiduma public\u0113\u0161anai (piem\u0113ram, p\u0113c 8.2 zara par\u0101d\u012b\u0161an\u0101s 8.1 zara atbalsts tiek p\u0101rtraukts). LTS zari ir ieteicami ievie\u0161anai, kam nepiecie\u0161ama prognoz\u0113jam\u012bba un ilgs saglab\u0101\u0161an\u0101s nemain\u012bgais uzved\u012bbas modelis. LTS zari tiks izlaisti reizi divos gados un tiks atbalst\u012bti standarta re\u017e\u012bm\u0101 5 gadus. Papildus tam b\u016bs iesp\u0113jams sa\u0146emt v\u0113l 3 gadus pagarin\u0101t\u0101 atbalsta. 2024. gada pavasar\u012b tiek gaid\u012bts LTS izlaidums MySQL 8.4, p\u0113c kura tiks izveidots jauns Inov\u0101cijas zars 9.0.      <\/p>\n<p>Galvenie jaunumi MySQL 8.2:  <\/p>\n<ul>\n<li class=\"l\"> Tika pievienota atbalsta meh\u0101nisms autentifik\u0101cijai, kas balst\u012bta uz Webauthn (FIDO2) specifik\u0101ciju, \u013caujot izmantot daudzfaktoru autentifik\u0101ciju un apstiprin\u0101t savienojumu ar <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/lv\/server\/dts-shicago\/\"   title=\"serverim\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2927\">serverim<\/a> MySQL bez parol\u0113m, izmantojot aparat\u016bras tokenus ar FIDO2 atbalstu vai biometrijas autentifik\u0101ciju. Webauthn atbalsto\u0161ais spraudnis pagaid\u0101m ir pieejams tikai MySQL Enterprise.\n<li class=\"l\"> Servera spraudnis mysql_native_password, kas nodro\u0161ina autentifik\u0101ciju ar parol\u0113m, ir p\u0101rcelts uz oblig\u0101ti nenoteikto kategoriju un var tikt atsl\u0113gts. Viet\u0101 mysql_native_password ieteicams p\u0101riet uz spraudni caching_sha2_password, kas izmanto SHA2 algoritmu, lai veiktu hash\u0113\u0161anu, nevis SHA1. Lai p\u0101rvietotu lietot\u0101jus uz spraudni caching_sha2_password ar paroles aizst\u0101\u0161anu ar nejau\u0161u, var izmantot komandu: ALTER USER 'username'@'localhost' IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2;\n<li class=\"l\"> Tika optimiz\u0113ti ha\u0161a tabulas, kas pa\u0101trin\u0101ja EXCEPT un INTERSECT oper\u0101ciju izpildi.\n<li class=\"l\"> Ir papla\u0161in\u0101tas atk\u013c\u016bdo\u0161anas iesp\u0113jas. SELECT, INSERT, REPLACE, UPDATE un DELETE oper\u0101cij\u0101s ir pievienota atbalsts izteiksm\u0113m \u201eEXPLAIN FORMAT=JSON\u201d, lai izveidotu diagnostisko izvadi JSON form\u0101t\u0101 (piem\u0113ram, \u201eEXPLAIN FORMAT=JSON INTO @var select_stmt;\u201d).\n<li class=\"l\"> Ir pievienota izteiksme \u201eEXPLAIN FOR SCHEMA\u201d, lai izvad\u012btu diagnostiku, kas saist\u012bta tikai ar konkr\u0113tu datu sh\u0113mu.\n<li class=\"l\"> R\u012bkam mysqldump ir pievienota opcija \u201e--output-as-version\u201d dumpu izveidei, kas ir sader\u012bgi ar konkr\u0113tu vec\u0101ko MySQL versiju (piem\u0113ram, var nor\u0101d\u012bt BEFORE_8_2_0 vai BEFORE_8_0_23, lai atgrieztu nepolitkorektu terminolo\u0123iju master\/slave, kas tika pasludin\u0101ta par novecojusi izlaidumos 8.2.0 un 8.0.23).\n<li class=\"l\"> C bibliot\u0113k\u0101 klientam pievienota iesp\u0113ja izmantot nosauktos atrib\u016btus parametriz\u0113t\u0101s vaic\u0101jumos (prepared statement), ko realiz\u0113 jaun\u0101 funkcija mysql_stmt_bind_named_param(), kas aizst\u0101j funkciju mysql_stmt_bind_param().\n<li class=\"l\"> Vienk\u0101r\u0161ota SQL trafika sadale MySQL serveru klaster\u012b. Nodro\u0161in\u0101tas iesp\u0113jas organiz\u0113t caursp\u012bd\u012bgas savienojumus ar sekund\u0101rajiem vai prim\u0101rajiem serveriem, kuras lietojumprogrammas neredz.\n<li class=\"l\"> Pievienota jauna privil\u0113\u0123ija SET_ANY_DEFINER, kas pie\u0161\u0137ir ties\u012bbas izveidot objektus ar DEFINER izteiksmi, k\u0101 ar\u012b privil\u0113\u0123ija ALLOW_NONEXISTENT_DEFINER, lai aizsarg\u0101tu objektus ar tr\u016bksto\u0161u \u012bpa\u0161nieku.\n<li class=\"l\"> Ir deklar\u0113tas par novecoju\u0161\u0101m: main\u012bg\u0101s old un new, maskas \u201e%\u201d un \u201e_\u201d datu b\u0101zes piek\u013cuves oper\u0101cij\u0101s, opcija \u201e--character-set-client-handshake\u201d, main\u012bg\u0101 binlog_transaction_dependency_tracking un privil\u0113\u0123ija SET_USER_ID.\n<li class=\"l\"> Saist\u012bb\u0101 ar nepolitkorektas terminolo\u0123ijas kori\u0123\u0113\u0161anu, attiec\u012bb\u0101 uz replik\u0101ciju ir pasludin\u0101ti par novecoju\u0161iem izteicieni \u201eRESET MASTER\u201c, \u201eSHOW MASTER STATUS\u201c, \u201eSHOW MASTER LOGS\u201c un \u201ePURGE MASTER LOGS\u201c, viet\u0101 kuriem b\u016btu j\u0101izmanto izteicieni \u201eRESET BINARY LOGS AND GTIDS\u201c, \u201eSHOW BINARY LOG STATUS\u201c, \u201eSHOW BINARY LOGS\u201c un \u201ePURGE BINARY LOGS\u201c.\n<li class=\"l\"> Ir no\u0146emtas iepriek\u0161 novecoju\u0161\u0101s iesp\u0113jas: funkcija WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), main\u012bgais expire_logs_days, opcijas \u201e--abort-slave-event-count\u201c un \u201e--disconnect-slave-event-count\u201c.\n<li class=\"l\"> Nov\u0113rstas 26 ievainojam\u012bbas. Divas ievainojam\u012bbas, kas saist\u012btas ar Curl paketes un OpenSSL bibliot\u0113kas izmanto\u0161anu, var tikt izmantotas att\u0101lin\u0101ti.      <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=59995\">opennet.lv<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 8.2.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. MySQL 8.2.0 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432\u0442\u043e\u0440\u044b\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u043c, \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043d\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, \u043f\u0440\u0435\u0434\u0443\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430\u043b\u0438\u0447\u0438\u0435 \u0434\u0432\u0443\u0445 \u0442\u0438\u043f\u043e\u0432 \u0432\u0435\u0442\u043e\u043a MySQL &#8212; &#171;Innovation&#187; \u0438 &#171;LTS&#187;. \u0412\u0435\u0442\u043a\u0438 Innovation, [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-111102","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.\" \/>\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\/news\/dostupna-subd-mysql-8-2-0\" \/>\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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.2.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/news\/dostupna-subd-mysql-8-2-0\" \/>\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=\"2023-10-26T13:10:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-10-26T13:10:14+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\udd47Pieejama MySQL 8.2.0 datub\u0101ze | ProHoster","description":"Uz\u0146\u0113mums Oracle izveidojis jaunu MySQL 8.2 datub\u0101zes zarbu un public\u0113jis labojumus MySQL 8.0.35 un 5.7.44.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/dostupna-subd-mysql-8-2-0","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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.2.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.2 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f MySQL 8.0.35 \u0438 5.7.44.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/dostupna-subd-mysql-8-2-0","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":"2023-10-26T13:10:14+00:00","article:modified_time":"2023-10-26T13:10:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"111102","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":"default","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":"2026-02-09 21:42:05","updated":"2026-02-09 21:42:05","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\/111102","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=111102"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/111102\/revisions"}],"predecessor-version":[{"id":160207,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/111102\/revisions\/160207"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=111102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=111102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=111102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}