Kadib sanad horumarineed iyo lix nooc oo hordhac ah, nooca cusub ee xasilloon ee laanta cusub ee DBMS MariaDB 10.4 ayaa horeyba loo sii daayay., kaas oo lagu soo saaray laan ka mid ah MySQL, oo ilaalinaysa waafaqsanaanta noocyadii hore waxayna soo bandhigaysaa is-dhexgalka matoorada keydinta dheeriga ah iyo howlaha horumarsan.
Horumarinta MariaDB waxaa kormeeraya hay'ad madax banaan oo ah MariaDB Foundation iyadoo la raacayo geedi socod horumarineed oo gebi ahaanba furfuran oo daah furan, kana madaxbanaan shaqsiyaadka wax iibiya.
MariaDB waxay ku timid meesha MySQL ee qaybinta Linux badan (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) waxaana lagu hirgeliyaa mashaariic muhiim ah sida Wikipedia, Google Cloud SQL iyo Nimbuzz.
Waxyaabaha cusub ee ugu muhiimsan ee MariaDB 10.4
Mid ka mid ah astaamaha ugu muhiimsan ee noocaan ah 'MariaDB' ayaa ah contara oo leh taageero 5-sano ah, marka nuucaan ayaa la taageeri doonaa illaa Juun 2024.
Loogu gudbiyay adeegsiga heerka C ++ 11 (Hawlgallada Atomiga ayaa ku lug leh) iyo waxqabadka guryaha "Isugeynta" aagagga ee 'Unicode' si aad ah ayaa loo kordhiyay, taas oo kuu oggolaanaysa inaad dejiso sharciyada kala soocidda iyo qaababka isbarbardhigga, iyadoo la tixgelinayo macnaha jilayaasha.
Qaab dhismeedka waxaa ka mid ah Galera 4 isku-dubbarida teknolojiyad badan oo sayid ah taas oo awood u siinaysa firfircoonida firfircoon ee firfircoon ee sayniska in lagu dabaqo, u oggolaanaya akhriska iyo qorista noodh kasta.
Ku soocelinta isku mid ah, dhammaan noodhadhku had iyo jeer waxay ku jiraan xog dhab ah, taasi waa, waxay damaanad qaaday maqnaanshaha macaamil ganacsi lumay, maaddaama macaamil ganacsi la duubay oo keliya ka dib marka xogta loo qaybiyo dhammaan noodhadhka.
Kordhinta waxaa lagu sameeyaa qaab is barbar socda, oo ah heerka safka, iyadoo kaliya laga helayo macluumaadka ku saabsan isbeddelada la kala qaado.
Nidaamyada Unix-like-ka ah, fiilada aqoonsiga unix_socket waa la shaqeysiiyay marka la eego, kuu oggolaanaya inaad isticmaasho koontooyinka nidaamka si aad ugu xirto DBMS adoo isticmaalaya godka Unix ee maxalliga ah.
Waxaan sidoo kale ka heli karnaa taas awood lagu daray oo lagu meeleeyo cimriga ereyga sirta ah, ka dib markaa lambarka sirta ah lagu calaamadeeyay inuu dhacay.
Si loo dejiyo ereyga ansaxnimada erayga sirta ah ee hawlgalada "ISKU ABUUR USER" iyo "ISTICMAAL ISTICMAAL" waa inaan ku darnaa ereyga "PASSWORD EXPIRE INTERVAL N DAY".
Dhanka kale taageero ayaa la heli doonaa si loo joojiyo isticmaalahas laga bilaabo DBMS iyada oo la adeegsanayo weedha "ACCOUNT LOCK" ee hawlgalada "CREATE USER" iyo "ALTER USER".
Intaa waxaa dheer fulinta jeegaga mudnaanta si weyn ayaa loo dheereeyay qaabeynta tiro badan oo isticmaaleyaal ah ama xeerar marin loogu helo.
Joojinta isticmaalka miisaska mysql.user iyo mysql.host. Miiska mysql.global_priv waxaa hadda loo isticmaalaa in lagu keydiyo xisaabaadka isticmaalaha iyo mudnaanta caalamiga ah.
Taageerada miisaska qaabaysan, taas oo aan kaliya lagu kaydin qaybta xogta hadda jirta, laakiin macluumaadka ku saabsan dhammaan isbeddelada hore loo sameeyay ayaa lagu hayaa, sWaxaa lagu ballaadhiyay hawlgallo waqti-dhaaf ah.
Lagu daray amar cusub "FLUSH SSL" si dib loogu cusbooneysiiyo shahaadooyinka SSL iyadoon dib loo bilaabin serverka;
Hawlgalada "INSTALL PLUGIN", "UNINSTALL PLUGIN" iyo "UNINSTALL SONAME", taageerada ayaa loogu daray ereyada "HADDII AAN JIRIN" iyo "HADDII AY JIRTO".
Looxyada nidaamka u adkaysiga naxdinta leh ayaa loo soo jeediyay in lagu keydiyo mashiinka Aria.
Ugu dambeyntiina waxaan sidoo kale iftiimin karnaa in awoodda lagu adeegsan karo wax ka badan hal shey oo xaqiijin ah akoon kasta lagu daray.
Isbedelada kale ee laga heli karo noocani waa:
- Qalabka wax lagu caddeeyo ayaa lagu daray muujinta taageerada "SET PASSWORD"
- Fursad lagu daray si loo qeexo noocyadaada duurka
- Taageero dheeri ah oo loogu talagalay howlaha daaqada UDF (Waxqabadyada la Sharaxay Isticmaalaha)
- Hawlgalka "FLUSH TABLES" wuxuu hirgeliyaa qaabka "BACKUP LOCK", oo loo isticmaali karo markii la kaydinayo faylasha keydka
- Taageero dheeraad ah oo loogu talagalay amarrada server-ka ee ka bilaabma magaca mariadb, oo ka duwan amarrada ka bilaabma "mysql" (tusaale ahaan, mariadump halkii laga heli lahaa mysqldump).