{"id":86434,"date":"2020-06-25T01:42:11","date_gmt":"2020-06-24T23:42:11","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/stabilnyj-vypusk-subd-mariadb-10-5"},"modified":"2020-06-25T01:42:11","modified_gmt":"2020-06-24T23:42:11","slug":"stabilnyj-vypusk-subd-mariadb-10-5","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","title":{"rendered":"L\u00ebshimi stabil i DBMS MariaDB 10.5","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pas nj\u00eb viti zhvillimi dhe kat\u00ebr versioneve t\u00eb para, <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.org\/mariadb-10-5-4-now-available\/\">\u00ebsht\u00eb p\u00ebrgatitur<\/a><\/noindex> l\u00ebshimi i par\u00eb stabil i deg\u00ebs s\u00eb re t\u00eb DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-1054-release-notes\/\">MariaDB 10.4<\/a><\/noindex>, n\u00eb kuadrin e t\u00eb cilit zhvillohet nj\u00eb deg\u00eb e MySQL, duke ruajtur p\u00ebrputhshm\u00ebrin\u00eb e prapambetur dhe   <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=39444#note\">p\u00ebrmban<\/a><\/noindex> integrare motor\u00eb shtes\u00eb ruajtjeje dhe mund\u00ebsi t\u00eb zgjeruara. Mb\u00ebshtetje p\u00ebr deg\u00ebn e re do t\u00eb ofrohet p\u00ebr 5 vjet, deri n\u00eb qershor 2025. <\/p>\n<p>Zhvillimi i MariaDB mbik\u00ebqyr\u00ebt nga organizata e pavarur MariaDB Foundation n\u00eb p\u00ebrputhje me nj\u00eb proces t\u00eb plot\u00eb t\u00eb hapur dhe transparent zhvillimi, q\u00eb nuk varet nga prodhues t\u00eb ve\u00e7ant\u00eb. MariaDB ofrohet n\u00eb vend t\u00eb MySQL n\u00eb shum\u00eb shp\u00ebrndarje Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) dhe \u00ebsht\u00eb implementuar n\u00eb projekte t\u00eb m\u00ebdha si <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36759\">Wikipedia<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=37905\">Google Cloud SQL<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36506\">Nimbuzz<\/a><\/noindex>.<\/p>\n<p>Karakteristikat kryesore <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mdb-1054-rn\/\">p\u00ebrmir\u00ebsime<\/a><\/noindex> <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/changes-improvements-in-mariadb-105\/\">MariaDB 10.5<\/a><\/noindex>:\n<\/p>\n<ul>\n<li class=\"l\"> \u00cbsht\u00eb shtuar motor ruajtjeje <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/s3-storage-engine\/\">S3<\/a><\/noindex>, q\u00eb lejon ruajtjen e tabelave MariaDB n\u00eb Amazon S3 ose n\u00eb ndonj\u00eb depo publike ose private, q\u00eb mb\u00ebshtet API S3. Mb\u00ebshtetet ruajtja n\u00eb S3 si tabelave normale ashtu edhe t\u00eb shtresuara (t\u00eb ndara). Kur depozitohen tabelat e shtresuara n\u00eb re, ato mund t\u00eb p\u00ebrdoren drejtp\u00ebrdrejt, p\u00ebrfshir\u00eb nga nj\u00eb server tjet\u00ebr q\u00eb ka qasje n\u00eb depotin S3.\n<li class=\"l\"> \u00cbsht\u00eb shtuar motor ruajtjeje <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-columnstore\/\">ColumnStore<\/a><\/noindex>, i cili ruan t\u00eb dh\u00ebnat n\u00eb lidhje me kolona dhe p\u00ebrdor <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/%D0%9C%D0%B0%D1%81%D1%81%D0%BE%D0%B2%D0%BE-%D0%BF%D0%B0%D1%80%D0%B0%D0%BB%D0%BB%D0%B5%D0%BB%D1%8C%D0%BD%D0%B0%D1%8F_%D0%B0%D1%80%D1%85%D0%B8%D1%82%D0%B5%D0%BA%D1%82%D1%83%D1%80%D0%B0\">arkitektur\u00eb t\u00eb shp\u00ebrndar\u00eb<\/a><\/noindex> me shum\u00eb-koh\u00ebzgjatshme. Motori \u00ebsht\u00eb i bazuar n\u00eb zhvillimet e ruajtjes MySQL <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=25267\">InfiniDB<\/a><\/noindex> dhe \u00ebsht\u00eb i destinuar p\u00ebr organizimin e p\u00ebrpunimit dhe ekzekutimin e k\u00ebrkesave analitike mbi grupe t\u00eb m\u00ebdha t\u00eb dh\u00ebnash (Data Warehouse).<br \/>\nColumnStore ruan t\u00eb dh\u00ebnat jo rresht rresht, por me ndarje sipas kolonave, q\u00eb lejon optimizimin e ekzekutimit t\u00eb grumbujve sipas kolonave nga nj\u00eb DB me p\u00ebrmasa t\u00eb m\u00ebdha, q\u00eb p\u00ebrfshin petabajt t\u00eb dh\u00ebnash. Mb\u00ebshtetet shkall\u00ebzimi linear, ruajtja e t\u00eb dh\u00ebnave n\u00eb form\u00eb t\u00eb kompresuar, ndarja vertikale dhe horizontale, dhe ekzekutimi efikas i k\u00ebrkesave konkurruese.<\/p>\n<li class=\"l\"> T\u00eb gjitha skedar\u00ebt ekzekutiv\u00eb q\u00eb fillojn\u00eb me fjal\u00ebn &#171;mysql&#187; jan\u00eb rinovuar duke p\u00ebrdorur fjal\u00ebn &#171;mariadb&#187;. Emrat e vjet\u00ebr jan\u00eb ruajtur n\u00eb form\u00ebn e lidhjeve simbolike.\n<li class=\"l\"> \u00ebsht\u00eb shtuar nj\u00eb lloj t\u00eb dh\u00ebnash t\u00eb ri <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/inet6\/\">INET6<\/a><\/noindex> p\u00ebr ruajtjen e adresave IPv6.\n<li class=\"l\"> \u00cbsht\u00eb b\u00ebr\u00eb pun\u00eb p\u00ebr ndarjen e privilegjeve n\u00eb komponent\u00eb m\u00eb t\u00eb vegj\u00ebl. N\u00eb vend t\u00eb privilegjit t\u00eb p\u00ebrgjithsh\u00ebm SUPER, \u00ebsht\u00eb propozuar nj\u00eb seri privilegjesh selektive &#171;BINLOG ADMIN&#187;,<br \/>\n    &#171;BINLOG REPLAY&#187;,<br \/>\n    &#171;CONNECTION ADMIN&#187;,<br \/>\n    &#171;FEDERATED ADMIN&#187;,<br \/>\n    &#171;READ_ONLY ADMIN&#187;,<br \/>\n    &#171;REPLICATION MASTER ADMIN&#187;,<br \/>\n    \u00abADMINI I REPLIKIMIT SLAVE\u00bb dhe<br \/>\n    \u00abSET USER\u00bb. <\/p>\n<li class=\"l\"> Privilegji \u00abKLIENTI I REPLIKIMIT\u00bb u ristilizua si \u00abMONITORI I BINLOG\u00bb, dhe shprehja \u00abSHFAQ STATUSIN E MASTERIT\u00bb u prezantua si \u00abSHFAQ STATUSIN E BINLOG\u00bb. Ristilizimi p\u00ebrcakton sjelljen dhe nuk \u00ebsht\u00eb i lidhur me korrekt\u00ebsin\u00eb politike, projekti nuk heq dor\u00eb nga terminologjit\u00eb master\/slave dhe madje ka shtuar privilegje t\u00eb reja \u00abADMINI I MASTERIT\u00bb dhe \u00abADMINI I SLAVEIT\u00bb. N\u00eb k\u00ebt\u00eb kontekst, n\u00eb shprehjet SQL \u00ebsht\u00eb shtuar nj\u00eb \u00e7el\u00ebs i ri \u00abREPLIKA\u00bb, q\u00eb \u00ebsht\u00eb sinonim i \u00abSLAVE\u00bb.\n<li class=\"l\"> P\u00ebr disa shprehje jan\u00eb ndryshuar privilegjet e nevojshme p\u00ebr realizimin e tyre. \u00abSHFAQ NGJARJET E BINLOG\u00bb tani k\u00ebrkon t\u00eb drejta \u00abMONITORI I BINLOG\u00bb n\u00eb vend t\u00eb \u00abREPLIKIMIT SLAVE\u00bb, \u00abSHFAQ HOSTET SLAVE\u00bb k\u00ebrkon privilegjin \u00abADMINI I MASTERIT\u00bb n\u00eb vend t\u00eb \u00abREPLIKIMIT SLAVE\u00bb, \u00abSHFAQ STATUSIN SLAVE\u00bb k\u00ebrkon t\u00eb drejta \u00abADMINI I REPLIKIMIT SLAVE\u00bb ose \u00abSUPER\u00bb n\u00eb vend t\u00eb \u00abKLIENTIT T\u00cb REPLIKIMIT\u00bb, \u00abSHFAQ NGJARJET E RELAYLOG\u00bb k\u00ebrkon t\u00eb drejta \u00abADMINI I REPLIKIMIT SLAVE\u00bb n\u00eb vend t\u00eb \u00abREPLIKIMIT SLAVE\u00bb.\n<li class=\"l\"> Jan\u00eb shtuar konstrukcione \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/insertreturning\/\">INSERT \u2026 KTHIMI<\/a><\/noindex>\u00bb dhe \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/replacereturning\/\">REPLACE \u2026 KTHIMI<\/a><\/noindex>\u00ab, q\u00eb kthejn\u00eb nj\u00eb list\u00eb t\u00eb t\u00eb dh\u00ebnave t\u00eb futur\/ndryshuar n\u00eb form\u00ebn si\u00e7 do t\u00eb ktheheshin vlerat duke p\u00ebrdorur shprehjen SELECT (n\u00eb p\u00ebrputhje me \u00abFSHIJ \u2026 KTHIMI\u00bb).\n<p>   INSERT INTO t2 VALUES (1,\u2018Qeni\u2019),(2,\u2018Luani\u2019),(3,\u2018Tigri\u2019),(4,\u2018Leopardi\u2019)<br \/>\n   KTHIMI id2,id2+id2,id2&amp;id2,id2||id2;<br \/>\n   +\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014-+<br \/>\n   | id2 | id2+id2 | id2&amp;id2 | id2||id2 |<br \/>\n   +\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014-+<br \/>\n   |   1 |       2 |       1 |        1 |<br \/>\n   |   2 |       4 |       2 |        1 |<br \/>\n   |   3 |       6 |       3 |        1 |<br \/>\n   |   4 |       8 |       4 |        1 |<br \/>\n   +\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014-+<\/p>\n<li class=\"l\"> Jan\u00eb shtuar shprehjet \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/except\/\">P\u00cbRJASHTO T\u00cb GJITHA<\/a><\/noindex>\u00bb dhe \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/intersect\/\">INTERSECT ALL<\/a><\/noindex>\u00bb p\u00ebr p\u00ebrjashtimin\/shtimin e rezultatit nga nj\u00eb grup t\u00eb caktuar vlerash.\n<li class=\"l\"> \u00c8sht\u00eb mund\u00ebsuar q\u00eb t\u00eb p\u00ebrcaktohen komente brenda blloqeve \u00abKRIJO DATABASE\u00bb dhe \u00abNDRYSHO DATABASE\u00bb.\n<li class=\"l\"> Jan\u00eb shtuar konstrukcione p\u00ebr ndryshimin e emrave t\u00eb indekseve dhe kolonave \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-indexkey\">ALTER TABLE \u2026 RENAME INDEX \/ KEY<\/a><\/noindex>\u00bb dhe \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/alter-table\/#rename-column\">ALTER TABLE \u2026 RENAME COLUMN<\/a><\/noindex>&#171;.\n<li class=\"l\"> N\u00eb operacionin \u00abALTER TABLE\u00bb dhe \u00abRENDA TABLE\u00bb \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr kushtin \u00abN\u00cbSE EKZISTON\u00bb p\u00ebr t\u00eb realizuar operacionin vet\u00ebm n\u00ebse tabela ekziston;\n<li class=\"l\"> P\u00ebr indekset n\u00eb \u00abKRIJO TABLE\u00bb \u00ebsht\u00eb realizuar atributi \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/create-table\/#visible-index-option\">I DUHSH\u00cbM<\/a><\/noindex>&#171;.\n<li class=\"l\"> \u00cbsht\u00eb shtuar shprehja \u00abCYCLE\u00bb p\u00ebr identifikimin e cikleve rekurzive <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/common-table-expressions\/\">CTE<\/a><\/noindex>.\n<li class=\"l\"> Jan\u00eb shtuar funksionet <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_arrayagg\/\">JSON_ARRAYAGG<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/json_objectagg\/\">JSON_OBJECTAGG<\/a><\/noindex> p\u00ebr kthimin e nj\u00eb array ose objekti JSON me vlerat e kolon\u00ebs s\u00eb caktuar.\n<li class=\"l\"> Jan\u00eb shtuar tabela informative t\u00eb sh\u00ebrbimit (THREAD_POOL_GROUPS, THREAD_POOL_QUEUES, THREAD_POOL_STATS dhe THREAD_POOL_WAITS) p\u00ebr grupin e fijeve (thread_pool).\n<li class=\"l\"> Shprehja ANALYZE \u00ebsht\u00eb zgjeruar me tregimin e koh\u00ebs q\u00eb aktive n\u00eb kontrollin e bllokut WHERE dhe realizimin e operacioneve ndihm\u00ebse.\n<li class=\"l\"> N\u00eb optimizuesin e p\u00ebrpunimit t\u00eb intervaleve jan\u00eb p\u00ebrfshir\u00eb karakteristikat &#171;IS NOT NULL&#187;\n<li class=\"l\"> Ka reduktuar ndjesh\u00ebm madh\u00ebsin\u00eb e skedar\u00ebve t\u00eb p\u00ebrkohsh\u00ebm q\u00eb p\u00ebrdoren kur \u0441\u043e\u0440\u0442iranje me tipet VARCHAR, CHAR dhe BLOB.\n<li class=\"l\"> N\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/binary-log\/\">logu binar<\/a><\/noindex>, i p\u00ebrdorur p\u00ebr organizimin e replikimit, jan\u00eb shtuar fusha t\u00eb reja me meta t\u00eb dh\u00ebna, duke p\u00ebrfshir\u00eb \u00c7el\u00ebsin Kryesor, Emrin e Kolon\u00ebs, Setin e Karaktereve dhe Llojin e Geometris\u00eb. N\u00eb utilitarin mariadb-binlog dhe komandat &#171;SHOW BINLOG EVENTS&#187; dhe &#171;SHOW RELAYLOG EVENTS&#187; \u00ebsht\u00eb garantuar tregimi i flagjeve t\u00eb replikimit.\n<li class=\"l\"> Konstruksioni <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/drop-table\/\">DROP TABLE<\/a><\/noindex> tani \u00ebsht\u00eb i besuesh\u00ebm <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-11412\">heq<\/a><\/noindex> tabelat q\u00eb mbeten n\u00eb motorin e ruajtjes, edhe n\u00eb munges\u00eb t\u00eb skedar\u00ebve &#171;.frm&#187; ose &#171;.par&#187;.\n<li class=\"l\"> \u00cbsht\u00eb realizuar nj\u00eb version i p\u00ebrshpejtuar nga hardueri i funksionit crc32() p\u00ebr CPU AMD64, ARMv8 dhe POWER 8.\n<li class=\"l\"> Jan\u00eb ndryshuar disa cil\u00ebsime t\u00eb paracaktuara. Parametri innodb_encryption_threads \u00ebsht\u00eb rritur n\u00eb 255, nd\u00ebrsa vlera max_sort_length \u00ebsht\u00eb rritur nga 4 n\u00eb 8.\n<li class=\"l\"> Jan\u00eb paraqitur shum\u00eb optimizime t\u00eb performanc\u00ebs s\u00eb motorit InnoDB.\n<li class=\"l\"> N\u00eb mekanizmin e replikimit multi-master sinkron Galera \u00ebsht\u00eb shtuar mb\u00ebshtetje e plot\u00eb  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/gtid\/\">GTID<\/a><\/noindex> (Global Transaction ID), identifikues unik p\u00ebr t\u00eb gjitha nodet e klasterit.\n<li class=\"l\"> \u00cbsht\u00eb realizuar kalimi n\u00eb deg\u00ebn e re t\u00eb bibliotek\u00ebs <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/pcre\/\">PCRE2<\/a><\/noindex> (Perl Compatible Regular Expressions), n\u00eb vend t\u00eb seris\u00eb klasike PCRE 8.x.\n<li class=\"l\"> Jan\u00eb propozuar versione t\u00eb reja t\u00eb mb\u00ebshtetjeve p\u00ebr lidhje me DBMS MariaDB dhe MySQL nga programet n\u00eb gjuh\u00ebt Python dhe C: <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-python-100-release-notes\/\">MariaDB Connector\/Python 1.0.0<\/a><\/noindex> dhe  <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-connector-c-319-release-notes\/\">MariaDB Connector\/C 3.1.9<\/a><\/noindex>. Mb\u00ebshtetje p\u00ebr Python i p\u00ebrgjigjet Python DB API 2.0, e shkruar n\u00eb gjuh\u00ebn C dhe p\u00ebrdor bibliotek\u00ebn Connector\/C p\u00ebr lidhjen me serverin.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Burimi: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53225\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414 MariaDB 10.4, \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \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 \u0438 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u044b\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0435\u0439. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0435\u0442 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0442\u044c\u0441\u044f 5 \u043b\u0435\u0442, \u0434\u043e \u0438\u044e\u043d\u044f 2025 \u0433\u043e\u0434\u0430. \u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 MariaDB \u043a\u0443\u0440\u0438\u0440\u0443\u0435\u0442 \u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u0430\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f MariaDB Foundation \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 [&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-86434","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\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\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.5 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5\" \/>\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-06-24T23:42:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-24T23:42:11+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\udd47L\u00ebshimi i q\u00ebndruesh\u00ebm i SGBD MariaDB 10.5 | ProHoster","description":"Pas nj\u00eb vit zhvillimi dhe kat\u00ebr versione paraprake, \u00ebsht\u00eb p\u00ebrgatitur l\u00ebshimi i par\u00eb stabil i deg\u00ebs s\u00eb re t\u00eb SGBD.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.5 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0447\u0435\u0442\u044b\u0440\u0451\u0445 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-5","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-06-24T23:42:11+00:00","article:modified_time":"2020-06-24T23:42:11+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"86434","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 14:15:25","updated":"2022-10-03 01:36:14","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/86434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=86434"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/86434\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=86434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=86434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=86434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}