{"id":136040,"date":"2025-06-09T15:05:09","date_gmt":"2025-06-09T13:05:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8"},"modified":"2025-06-09T15:05:09","modified_gmt":"2025-06-09T13:05:10","slug":"opublikovana-novaya-lts-vetka-subd-mariadb-11-8","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8","title":{"rendered":"Objavljena nova LTS grana DBMS-a MariaDB 11.8.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Predstavljen je izdanak SUSTAVA BAZA PODATAKA MariaDB 11.8.2, koji je ozna\u010den kao prvo stabilno izdanje grane 11.8. Grana MariaDB 11.8 svrstana je me\u0111u izdanja s dugoro\u010dnom podr\u0161kom i bit \u0107e podr\u017eavana najmanje 5 godina. Istovremeno je dostupan izdanak MariaDB 12.0.1, koji ima status kandidata za izdanja.      <\/p>\n<p>Projekt MariaDB razvija ogranak od MySQL-a koji zadr\u017eava unazad kompatibilnost i uklju\u010duje integraciju dodatnih sustava za pohranu i pro\u0161irene mogu\u0107nosti. Razvoj MariaDB nadzire neovisna organizacija MariaDB Foundation u skladu s otvorenim i transparentnim procesom razvoja, neovisnim o pojedina\u010dnim proizvo\u0111a\u010dima. MariaDB se isporu\u010duje umjesto MySQL-a u mnogim distribucijama Linuxa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) i koristi se u velikim projektima poput Wikipedije, Google Cloud SQL i Nimbuzz.       <\/p>\n<p>Me\u0111u promjenama u grani MariaDB 11.8 u odnosu na prethodno LTS izdanje 11.4:  <\/p>\n<ul>\n<li class=\"l\"> U sastav su integrirane inovacije projekta MariaDB Vector, koji razvija mogu\u0107nosti za vektorsko pretra\u017eivanje, koje je tra\u017eeno u sustavima strojnog u\u010denja. Implementirana je ugra\u0111ena podr\u0161ka za tip podataka VECTOR, funkcije VEC_DISTANCE_EUCLIDEAN(), VEC_DISTANCE_COSINE() i VEC_DISTANCE() za izra\u010dunavanje sli\u010dnosti izme\u0111u vektora, kao i funkcije VEC_FromText() i VEC_ToText() za pretvaranje izme\u0111u binarnog i tekstualnog prikaza vektora. Implementirane su optimizacije rada s vektorima, koje koriste SIMD pro\u0161irenja CPU-a Intel (AVX2 i AVX512), ARM i IBM Power10. U provedenim testovima, performanse vektorskih upita u MariaDB nadma\u0161uju Redis, pgvector, qdrant i weaviate.      <center><img decoding=\"async\" alt=\"Objavljena nova LTS grana DBMS-a MariaDB 11.8. \" src=\"\/wp-content\/uploads\/2025\/06\/5dab0cbe2844dfeca0434c966be5ee52.png\" style=\"display:block;margin: 0 auto;\" \/><\/center>\n<li class=\"l\"> Rije\u0161en je problem godine 2038. Grani\u010dna vrijednost tipa TIMESTAMP pove\u0107ana je s 2038 na 2106.\n<li class=\"l\"> Zadano je da se umjesto latin1 koristi Unicode (utf8mb4) s punom podr\u0161kom za emoji. Svojstva lokaliteta \u201eCollation\u201c, koja definiraju pravila sortiranja i usporedbe uzimaju\u0107i u obzir zna\u010denje simbola, a\u017eurirana su na verziju UCA 14.0.0.\n<li class=\"l\"> Dodan je novi dodatak za autentifikaciju lozinkama PARSEC (Password Authentication with Response Signed by Elliptic Curves), koji koristi funkciju PBKDF2 za generiranje hash-a lozinke i verificira odgovore koriste\u0107i javni klju\u010d temeljene na shemi digitalnih potpisa ed25519.\n<li class=\"l\"> Pobolj\u0161ana je autentifikacija prilikom pristupa SUSTAVU BAZA PODATAKA s lokalnog sustava, koriste\u0107i UNIX socket.\n<li class=\"l\"> U mariadb-dump i mariadb-import dodana je podr\u0161ka za vi\u0161estruko stvaranje i obnavljanje sigurnosnih kopija. Paralelizacija se primjenjuje i prilikom dumpanja jedne velike baze podataka, kao i prilikom istodobnog sigurnosnog kopiranja nekoliko baza podataka.\n<li class=\"l\"> Zna\u010dajno je pove\u0107ana u\u010dinkovitost replikacije. Da bi se ubrzalo prihva\u0107anje vrlo velikih transakcija, implementiran je mehanizam prebacivanja segmenta binarnog dnevnika (binlog), koji omogu\u0107uje izbjegavanje resursno intenzivnih operacija kopiranja datoteka. Kako bi se smanjilo ponovno pokretanje nakon kvara, omogu\u0107eno je poni\u0161tavanje transakcija (rollback) u asinhronom re\u017eimu. Dodana je opcija \u201eslave_replication_delay_abort_timeout\u201c, koja automatski mo\u017ee poni\u0161titi transakcije koje predugo blokiraju replikaciju.\n<li class=\"l\"> Expanded monitoring tools. Additional columns for performance analysis and problem diagnostics have been added to the statistics tables.\n<li class=\"l\"> A USERS table has been added with information about users, the restrictions applied to them, and the duration of their passwords.\n<li class=\"l\"> Dodane su naredbe \u201eFLUSH GLOBAL STATUS\u201c, \u201eREPAIR TABLE \u2026 FORCE\u201c i \u201eSHOW CREATE SERVER\u201c.\n<li class=\"l\"> The ability to return values of type ROW from stored procedures has been added.\n<li class=\"l\"> Pobolj\u0161ana je kompatibilnost s DBMS-om Oracle prilikom rada s sekvencama (sequence). Operacija \u201eCREATE SEQUENCE \u2026 AS\u201c sada se mo\u017ee koristiti s bilo kojim cjelobrojnim tipovima, uklju\u010duju\u0107i \u201eBIGINT UNSIGNED\u201c.\n<li class=\"l\"> Dodane su nove funkcije za generiranje UUID \u2014 UUID_v7 i UUID_v4.\n<li class=\"l\"> The FORMAT_BYTES function has been added to convert byte numbers into a readable format (for example, FORMAT_BYTES(1000000000) will output 953.67 MiB).\n<li class=\"l\"> The ability to limit disk space used for temporary files and temporary tables has been added. The settings max_tmp_session_space_usage and max_tmp_total_space_usage have been added to set limits, related to both individual users and all users.\n<li class=\"l\"> U optimizeru upita ubrzana je obrada operacija UPDATE\/DELETE s jednom tablicom. Zadano su uklju\u010dene optimizacije smanjenja kodiranja na manju podskupinu simbola. Ubrzani su upiti s izrazima \u201eSUBSTR(col, 1, n) = const_str\u201c. Dodana je podr\u0161ka za optimizaciju virtualnih stupaca.          <\/ul>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63378\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.8.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 11.8. \u0412\u0435\u0442\u043a\u0430 MariaDB 11.8 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u0430 \u043a \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u0441 \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u0440\u043e\u043a\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 \u0438 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0442\u044c\u0441\u044f \u043a\u0430\u043a \u043c\u0438\u043d\u0438\u043c\u0443\u043c 5 \u043b\u0435\u0442. \u041e\u0434\u043d\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a MariaDB 12.0.1, \u0438\u043c\u0435\u044e\u0449\u0438\u0439 \u0441\u0442\u0430\u0442\u0443\u0441 \u043a\u0430\u043d\u0434\u0438\u0434\u0430\u0442\u0430 \u0432 \u0440\u0435\u043b\u0438\u0437\u044b. \u041f\u0440\u043e\u0435\u043a\u0442\u043e\u043c MariaDB \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0432\u0435\u0442\u0432\u043b\u0435\u043d\u0438\u0435 \u043e\u0442 MySQL, \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u044e\u0449\u0435\u0435 \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \u0438 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0435\u0435\u0441\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0435\u0439 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0434\u0432\u0438\u0436\u043a\u043e\u0432 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":136041,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-136040","post","type-post","status-publish","format-standard","has-post-thumbnail","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=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.8.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 11.8. \u0412\u0435\u0442\u043a\u0430 MariaDB 11.8 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u0430 \u043a \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u0441 \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u0440\u043e\u043a\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 \u0438 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0442\u044c\u0441\u044f \u043a\u0430\u043a \u043c\u0438\u043d\u0438\u043c\u0443\u043c 5 \u043b\u0435\u0442.\" \/>\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\/hr\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"hr_HR\" \/>\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\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f LTS-\u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 MariaDB 11.8 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.8.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 11.8. \u0412\u0435\u0442\u043a\u0430 MariaDB 11.8 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u0430 \u043a \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u0441 \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u0440\u043e\u043a\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 \u0438 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0442\u044c\u0441\u044f \u043a\u0430\u043a \u043c\u0438\u043d\u0438\u043c\u0443\u043c 5 \u043b\u0435\u0442.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8\" \/>\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-06-09T13:05:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-06-09T13:05:10+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\udd47A new LTS branch of the MariaDB 11.8 database has been released | ProHoster","description":"The release of the MariaDB 11.8.2 database, marked as the first stable release of the 11.8 branch, has been introduced. The MariaDB 11.8 branch is classified as long-term support releases and will be supported for at least 5 years.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","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\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f LTS-\u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 MariaDB 11.8 | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 11.8.2, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u043c\u0435\u0447\u0435\u043d \u043a\u0430\u043a \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0432\u0435\u0442\u043a\u0438 11.8. \u0412\u0435\u0442\u043a\u0430 MariaDB 11.8 \u043e\u0442\u043d\u0435\u0441\u0435\u043d\u0430 \u043a \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u0441 \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u0440\u043e\u043a\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 \u0438 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0442\u044c\u0441\u044f \u043a\u0430\u043a \u043c\u0438\u043d\u0438\u043c\u0443\u043c 5 \u043b\u0435\u0442.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/opublikovana-novaya-lts-vetka-subd-mariadb-11-8","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-06-09T13:05:10+00:00","article:modified_time":"2025-06-09T13:05:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"136040","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:13:39","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 13:13:39","updated":"2026-01-23 13:13:39","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/136040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=136040"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/136040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media\/136041"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=136040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=136040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=136040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}