Ngemuva konyaka wentuthuko nezinguqulo eziyisithupha zokuqala, inguqulo entsha ezinzile yegatsha elisha le-DBMS MariaDB 10.4 isivele ikhishiwe., lapho kwakhiwa khona igatsha le-MySQL, eligcina ukuhambisana nezinguqulo zangaphambilini futhi linikeze ukuhlanganiswa kwezinjini zokugcina ezengeziwe nemisebenzi esezingeni eliphakeme.
Intuthuko kaMariaDB yenganyelwe yiMariaDB Foundation ezimele ngokwenqubo yentuthuko evuleke ngokuphelele futhi esobala, ezimele kubathengisi abangabodwana.
IMariaDB iza esikhundleni seMySQL ekusatshalalisweni okuningi kweLinux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) futhi isetshenziswa kumaphrojekthi abaluleke njengeWikipedia, Google Cloud SQL neNimbuzz.
Izici ezintsha eziyinhloko zeMariaDB 10.4
Esinye sezici eziyinhloko zalolu hlobo lweMariaDB ukuthi contara ngokusekelwa kweminyaka emihlanu, ngakho-ke le nguqulo izosekelwa kuze kube nguJuni 5.
Ushintshele ekusebenziseni indinganiso ye-C ++ 11 (Ukusebenza kwe-Atomic kuyabandakanyeka) nokusebenza kwezakhiwo ze- "Collation" ze-Unicode kukhuliswe kakhulu, kukuvumela ukuthi usethe imithetho yokuhlukanisa nezindlela zokuqhathanisa, ucabangele okushiwo ngabalingiswa.
Isakhiwo kufaka phakathi ubuchwepheshe be-Galera 4 synchronous multiple master replication, enika amandla ukusebenza kwe-master topology esebenzayo okuningi okusebenzayo, okuvumela ukufunda nokubhala kunoma iyiphi i-node.
Ngokuphindaphinda okuvumelanayo, wonke ama-node ahlala aqukethe idatha yangempela, okungukuthi, kwaqinisekisa ukungabikho kwemisebenzi elahlekile, ngoba ukuthengiselana kuqoshwa kuphela ngemuva kokuthi idatha isatshalaliswe kuwo wonke ama-node.
Ukuphindaphindeka kwenziwa ngemodi efanayo, ezingeni lomugqa, ngolwazi kuphela mayelana nezinguquko ezidlulisiwe.
Kuzinhlelo ezifana ne-Unix, i-plugin ye-unix_socket yokuqinisekisa inikwe amandla ngokuzenzakalela, kukuvumela ukuthi usebenzise ama-akhawunti asohlelweni ukuxhuma kwi-DBMS usebenzisa isokhethi yendawo ye-Unix.
Singakuthola futhi lokho amandla angeziwe okunikeza isikhathi sokuphila sephasiwedi yomsebenzisi, ngemuva kwalokho iphasiwedi imakwa ukuthi iphelelwe yisikhathi.
Ukusungula isikhathi sokusebenza kwephasiwedi ekusebenzeni kwe- "CREATE USER" kanye ne- "ALTER USER" kuyo kufanele sengeze igama elithi "PASSWORD EXPIRE INTERVAL N DAY".
Ngakolunye uhlangothi support kuzotholakala ukuvimba umsebenzisis kusuka ku-DBMS kusetshenziswa igama elithi "ACCOUNT LOCK" ekusebenzeni kwe- "CREATE USER" kanye ne- "ALTER USER".
Futhi ukwenziwa kwamalungelo okuhlola amalungelo kwashesha kakhulu ngokulungiselelwa ngenombolo enkulu yabasebenzisi noma imithetho yokufinyelela.
Ukususwa ukusebenza kwamatafula e-mysql.user kanye ne-mysql.host. Ithebula le-mysql.global_priv manje selisetshenziselwa ukugcina ama-akhawunti womsebenzisi namalungelo omhlaba wonke.
Ukusekelwa kwamatafula ahlelwe ngendlela ehlelekile, lapho kugcinwa khona kuphela ingxenye yedatha yamanje, kepha imininingwane mayelana nazo zonke izinguquko ezenziwe ngaphambilini igcinwa, sKunwetshwa ngokusebenza kwesikhathi.
Kungezwe umyalo omusha "i-FLUSH SSL" yokulayisha kabusha izitifiketi ze-SSL ngaphandle kokuqalisa kabusha iseva;
Emisebenzini ye- "INSTALL PLUGIN", "UNINSTALL PLUGIN" ne "UNINSTALL SONAME", kungezwe ukusekelwa kwezinkulumo ezithi "UMA KUNGEKHONA" nokuthi "UMA IKHONA".
Amabhodi wesistimu amelana nokushaqeka ahlongozelwa ukugcinwa lapho kusetshenziswa khona injini ye-Aria.
Ekugcineni singabuye sigqamise ukuthi amandla wokusebenzisa ama-plugin wokuqinisekisa angaphezu kweyodwa ku-akhawunti ngayinye engeziwe.
Ezinye izinguquko ezingatholakala kule nguqulo yilezi:
- I-plugin yokufakazela ubuqiniso ingeze isengezo sokweseka "SET PASSWORD"
- Kungezwe i-plugin ukuze uchaze izinhlobo zakho zensimu
- Kungezwe ukusekelwa kwemisebenzi yewindows ye-UDF (Imisebenzi Echazwe Umsebenzisi)
- Umsebenzi we- "FLUSH TABLES" usebenzisa imodi ye- "BACKUP LOCK", engasetshenziswa lapho wenza isipele amafayela e-database
- Kungezwe ukusekelwa kwemiyalo yeseva eqala ngegama elithi mariadb, okuhlukile kwemiyalo eqala ngo- "mysql" (ngokwesibonelo, i-mariadump esikhundleni se-mysqldump).