{"id":139704,"date":"2025-07-23T11:11:54","date_gmt":"2025-07-23T09:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-4-0"},"modified":"2025-07-23T11:11:54","modified_gmt":"2025-07-23T09:11:54","slug":"vypusk-subd-mysql-9-4-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-4-0","title":{"rendered":"Vydanie datab\u00e1zy MySQL 9.4.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Spolo\u010dnos\u0165 Oracle vytvorila nov\u00fa vetvu datab\u00e1zov\u00e9ho syst\u00e9mu MySQL 9.4.0. Verzie MySQL Community Server 9.4.0 s\u00fa pripraven\u00e9 pre v\u0161etky hlavn\u00e9 distrib\u00facie Linuxu, FreeBSD, macOS a Windows. V s\u00falade s modelom vyd\u00e1vania rel\u00e1ci\u00ed, ktor\u00fd bol zaveden\u00fd v roku 2023, je MySQL 9.4 zaraden\u00fd medzi vetvy \u201eInov\u00e1ci\u00ed\u201c. Inova\u010dn\u00e9 vetvy s\u00fa odpor\u00fa\u010dan\u00e9 pre t\u00fdch, ktor\u00ed chc\u00fa sk\u00f4r z\u00edska\u0165 pr\u00edstup k novej funkcionalite, publikuj\u00fa sa ka\u017ed\u00e9 3 mesiace a podporuj\u00fa sa len do vydania nasleduj\u00facej v\u00fdznamnej verzie (napr\u00edklad po uveden\u00ed vetvy 9.4 sa prestane podporova\u0165 vetva 9.3). Na jese\u0148 sa pl\u00e1nuje vytvorenie LTS release 9.5, odpor\u00fa\u010dan\u00e9ho pre nasadenia, ktor\u00e9 potrebuj\u00fa predv\u00eddate\u013enos\u0165 a dlhodob\u00e9 zachovanie nemenn\u00e9ho spr\u00e1vania. Po LTS vetve bude vytvoren\u00e1 nov\u00e1 inova\u010dn\u00e1 vetva \u2014 MySQL 10.0.        <\/p>\n<p>Hlavn\u00e9 zmeny v MySQL 9.4:  <\/p>\n<ul>\n<li class=\"l\"> V ulo\u017een\u00fdch proced\u00farach nap\u00edsan\u00fdch v jazyku JavaScript bola implementovan\u00e1 podpora typu BIT. Hodnoty s typom BIT men\u0161ie alebo rovn\u00e9 JavaScript.MAX_SAFE_INTEGER s\u00fa konvertovan\u00e9 na typ Number jazyka JavaScript, a v\u00e4\u010d\u0161ie \u2014 na typ BigInt jazyka JavaScript.\n<li class=\"l\"> Do pr\u00edkazov\u00e9ho n\u00e1stroja mysql bola pridan\u00e1 mo\u017enos\u0165 \u201e--commands\u201c, ktor\u00e1 umo\u017e\u0148uje zapn\u00fa\u0165 podporu vykon\u00e1vania lok\u00e1lnych pr\u00edkazov (pod\u013ea predvolen\u00e9ho nastavenia s\u00fa pr\u00edkazy vypnut\u00e9):\n<ul>\n<li class=\"listitem\">charset                    <\/li>\n<li>                      clear                    <\/li>\n<li>                      connect                    <\/li>\n<li>                      edit                    <\/li>\n<li>                      ego                    <\/li>\n<li>                      exit                    <\/li>\n<li>                      go                    <\/li>\n<li>                      help                    <\/li>\n<li>                      nopager                    <\/li>\n<li>                      notee                    <\/li>\n<li>                      nowarning                    <\/li>\n<li>                      pager                    <\/li>\n<li>                      print                    <\/li>\n<li>                    prompt                    <\/li>\n<li>                      query_attributes                    <\/li>\n<li>                      quit                    <\/li>\n<li>                      rehash                    <\/li>\n<li>                      resetconnection                    <\/li>\n<li>                      ssl_session_data_print                    <\/li>\n<li>                      source                    <\/li>\n<li>                      status                    <\/li>\n<li>                      syst\u00e9m                    <\/li>\n<li>                     tee                    <\/li>\n<li>                      \\u                    <\/li>\n<li>                      warnings  <\/ul>\n<li class=\"l\"> Na miesto pluginu firewall, ktor\u00fd umo\u017e\u0148uje filtrova\u0165 SQL dopyty k DBMS na z\u00e1klade zadan\u00fdch vzorov, bol navrhnut\u00fd komponent MySQL Enterprise Firewall, ktor\u00fd realizuje identick\u00fa funkcionalitu s v\u00fdnimkou podpory profilov u\u017e\u00edvate\u013esk\u00fdch \u00fa\u010dtov (namiesto toho sa podporuj\u00fa profily skup\u00edn). Plugin firewall bol vyhl\u00e1sen\u00fd za zastaran\u00fd a bude odstr\u00e1nen\u00fd v jednom z nasleduj\u00facich vydan\u00ed. MySQL Enterprise Firewall je dostupn\u00fd len pou\u017e\u00edvate\u013eom komer\u010dnej verzie MySQL Enterprise Edition.\n<li class=\"l\"> Bolo odstr\u00e1nen\u00fdch 30 zranite\u013enost\u00ed, z ktor\u00fdch jedna m\u00f4\u017ee by\u0165 zneu\u017eit\u00e1 na dia\u013eku, ak sa m\u00e1 pr\u00edstup na zasielanie dopytov k DBMS. \u0160tyri najz\u00e1va\u017enej\u0161ie probl\u00e9my maj\u00fa \u00farove\u0148 nebezpe\u010denstva 6.5 a s\u00favisia so zranite\u013enos\u0165ami v DML a optimaliz\u00e1tore. Menej nebezpe\u010dn\u00e9 zranite\u013enosti sa t\u00fdkaj\u00fa InnoDB, optimaliz\u00e1tora, ulo\u017een\u00fdch proced\u00far, LDAP Auth a syst\u00e9mu replik\u00e1cie.    <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63616\">opennet.ru<\/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 9.4.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.4.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. \u0412 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 \u0441 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 2023 \u0433\u043e\u0434\u0443 \u043c\u043e\u0434\u0435\u043b\u044c\u044e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.4 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;. Innovation-\u0432\u0435\u0442\u043a\u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u044b \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0445\u043e\u0447\u0435\u0442 \u0440\u0430\u043d\u044c\u0448\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043d\u043e\u0432\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u044e\u0442\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0435 3 \u043c\u0435\u0441\u044f\u0446\u0430 [&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-139704","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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 9.4.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.4.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.\" \/>\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\/sk\/blog\/news\/vypusk-subd-mysql-9-4-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.4.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 9.4.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.4.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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-4-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=\"2025-07-23T09:11:54+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-07-23T09:11: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\udd47Vydanie DBMS MySQL 9.4.0 | ProHoster","description":"Spolo\u010dnos\u0165 Oracle vytvorila nov\u00fa vetvu DBMS MySQL 9.4.0. Sestavy MySQL Community Server 9.4.0 s\u00fa pripraven\u00e9 pre v\u0161etky hlavn\u00e9 distrib\u00facie Linux, FreeBSD, macOS a Windows.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-4-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.4.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 9.4.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.4.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.","og:url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-mysql-9-4-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":"2025-07-23T09:11:54+00:00","article:modified_time":"2025-07-23T09:11:54+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"139704","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":"2026-01-23 13:56:21","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 13:56:21","updated":"2026-01-23 13:56:21","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/139704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=139704"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/139704\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=139704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=139704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=139704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}