MariaDB 10.6 siideynta xasilloon

Ka dib hal sano oo horumarineed iyo saddex sii dayn horudhac ah, sii dayntii ugu horreysay ee xasilloon ee laanta cusub ee MariaDB 10.6 DBMS ayaa la daabacay, taas oo laan ka mid ah MySQL lagu sameeyay taas oo ilaalinaysa iswaafajinta gadaalka ah waxaana lagu kala saarayaa isdhexgalka matoorada kaydinta dheeraadka ah. iyo awoodaha horumarsan. Taageerada laanta cusub waxaa la bixin doonaa 5 sano, ilaa Luulyo 2026.

Horumarinta MariaDB waxaa kormeera MariaDB Foundation oo madax-banaan, ka dib habsocod horumarineed oo dhammaystiran oo furan oo ka madax bannaan iibiyeyaasha gaarka ah. MariaDB waxaa loo bixiyaa beddelka MySQL qaybiyo badan oo Linux ah (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) waxaana lagu hirgeliyay mashaariicda waaweyn sida Wikipedia, Google Cloud SQL iyo Nimbuzz.

Horumarinta muhiimka ah ee MariaDB 10.6:

• Fulinta atomiiga ee tibaaxaha "Abuur Miisaanka | MUUQAAL| TAXANAHA si buuxda loo dhamaystiray ama wax walba lagu soo celiyo sidii ay ahayd). Marka laga hadlayo hawlgallada "QABSIGA AH" ee tirtiraya dhowr shax hal mar, atomity ayaa la hubiyaa heerka miis kasta oo gaar ah. Ujeedada isbeddelku waa in la hubiyo daacadnimada haddii ay dhacdo shil server inta lagu jiro hawlgalka. Markii hore, shil ka dib, miisaska ku meel gaadhka ah iyo faylalka ayaa sii jiri kara, isku xidhka miisaska matoorada kaydinta iyo faylalka frm waa la carqaladayn karaa, miisaska gaarka ahina waxay ahaan karaan kuwo aan la magacaabin markii dhowr miis hal mar la magacaabay. Daacadnimada waxaa lagu hubiyaa iyadoo la ilaalinayo diiwaanka soo kabashada gobolka, dariiqa lagu go'aamin karo iyada oo loo marayo ikhtiyaarka cusub "-log-ddl-recovery=file" (ddl-recovery.log by default).
• Dhismaha "Xulashada ... OFFSET ... FETCH" ee lagu qeexay heerka SQL 2008 waa la hirgeliyay, taasoo kuu oggolaaneysa inaad muujiso tiro safaf ah oo ka bilaabmaya meel cayiman, oo awood u leh inaad isticmaasho cabbirka "WITH TIES" ku lifaaq qiime kale oo xiga. Tusaale ahaan, odhaahda "XULKA I FROM t1 ORDER BY i ASC OFFSET 1 ROWS FETCH KOWAAD 3 RUS WITH TIES" waxay ka duwan tahay dhismaha "Xulashada i FROM t1 ORDER BY i ASC LIMIT 3 OFFSET 1" adoo soo saaraya hal shay oo kale oo dabada ah. (halkii 3 4 xariiq ayaa soo bixi doona).
• Matoorka InnoDB, ereyga "XULASHADA ... KA bood quful" ayaa la hirgeliyay, kaas oo kuu ogolaanaya inaad ka saarto safafka aan qufulka la dejin karin ("LOCK IN SHARE MODE" ama "UPDATE").
• Awoodda in la iska indho tiro tusmooyinka ayaa la hirgeliyay (SSQL 8, shaqadan waxaa loo yaqaan "tusmooyinka aan la arki karin"). Calaamadeynta tusaha si aan loo iloobin waxaa lagu sameeyaa iyadoo la adeegsanayo calanka IGNORED ee ku jira bayaanka SHAXDA BEDELKA, ka dib tusmada ayaa weli ah mid muuqata oo la cusbooneysiiyay, laakiin ma isticmaalo wanaajiyaha.
• Lagu daray JSON_TABLE() shaqada si loogu badalo xogta JSON qaab xidhiidhsan Tusaale ahaan, dukumeentiga JSON waxa loo bedeli karaa si loogu isticmaalo macnaha guud ee miiska, kaas oo lagu qeexi karo gudaha block-ka ee qoraalka SELECT.
• Waafaqid la wanaajiyey ee Oracle DBMS: Taageero lagu daray xog-hoosaadka qarsoodiga ah ee gudaha FROM block. Dhismaha MINUS waa la hirgeliyay (oo u dhiganta marka laga reebo). Lagu daray ADD_MONTHS(), TO_CHAR(), SYS_GUID() iyo ROWNUM() hawlo.
• Matoorka InnoDB, gelinta miisaska madhan waa la dedejiyey. Qaabka xargaha COMPRESSED waxa loo dejiyay hab wax-akhris oo kaliya. Nidaamka SYS_TABLESPACES waxa uu beddelay SYS_DATAFILES oo si toos ah uga tarjumaysa xaaladda nidaamka faylka. Taageerada qoraalka caajiska ah ayaa la siiyaa booska miiska ku meel gaarka ah. Taageerada algorithm-kii hore ee jeegagga, kaas oo loo sii hayo la jaanqaadka MariaDB 5.5, waa la joojiyay.
• Nidaamka soo-celinta, cabbirka qiimaha cabbirka master_host ayaa laga kordhiyey 60 ilaa 255 xaraf, master_userna waxaa laga dhigay 128. Doorsoomiyaha binlog_expire_logs_seconds ayaa lagu daray si loo habeeyo wakhtiga dhicitaanka ee log-ka binary-ga ee ilbidhiqsiyo (horay u ahayd, wakhtiga dib u dejinta waxa uu ahaa la go'aamiyay oo kaliya maalmo gudahood ilaa doorsoomiyaha_logs_days).
• Farsamaynta isku celcelinta sayid ee badan ee Galera waxay fulisaa doorsoomiyaha wsrep_mode si uu u habeeyo cabirrada API WSREP (Qor Set RePlication). La oggolaaday ka beddelashada Galera ee isgaadhsiinta aan qarsoodi ahayn oo loo beddelo TLS iyada oo aan la joojin kooxda
• Qorshaha sys-schema waa la fuliyay, kaas oo ka kooban ra'yi ururin, hawlo iyo habraacyo lagu falanqeynayo hawlgallada keydka macluumaadka.
• Shaxda adeegga lagu daray ee lagu falanqeynayo waxqabadka ku celcelinta.
• INFORMATION_SCHEMA.KEYWORDS iyo INFORMATION_SCHEMA.SQL_FUNCTIONS ayaa lagu daray shaxda macluumaadka, oo muujinaya liiska ereyada muhiimka ah iyo shaqooyinka la heli karo.
• Kaydka TokuDB iyo CassandraSE waa la saaray
• Codaynta utf8 waxa laga soo wareejiyay matalaad afar-byte ah utf8mb4 (U+0000..U+10FFFF) una soo wareejisay saddexda-byte utf8mb3 (waxa ay dabooshaa xadka Unicode U+0000..U+FFFF).
• Taageerada lagu daray hawlgelinta godka ee systemd.
• Qalabka GSSAPI wuxuu ku daray taageerada magacyada kooxda Tusaha Firfircoon iyo SIDs.
• Hubinta lagu daray joogitaanka faylka qaabeynta $MARIADB_HOME/my.cnf marka lagu daro $MYSQL_HOME/my.cnf.
• Doorsoomayaasha nidaamka cusub binlog_expire_logs_seconds, innodb_deadlock_report, innodb_read_only_compressed, wsrep_mode iyo Innodb_buffer_pool_pages_lru_freed ayaa la hirgaliyay.

Source: opennet.ru