Inguqulelo entsha yedatha kaMariaDB 10.4 sele ikhutshiwe

MariaDB

Emva konyaka wophuhliso kunye neenguqulelo zokuqala ezintandathu, inguqulelo entsha ezinzileyo yesebe elitsha leDBMS MariaDB 10.4 sele ikhutshiwe., ngaphakathi apho isebe le-MySQL liphuhliswa, eligcina ukuhambelana neenguqulelo zangaphambili kwaye libonelela ngokudityaniswa kweinjini zokugcina kunye nemisebenzi ephambili.

Uphuhliso lukaMariaDB lujongwa sisiseko esizimeleyo seMariaDB ngokwenkqubo evulekileyo necacileyo yophuhliso, ezimeleyo kubathengisi abazimeleyo.

UMariaDB uza endaweni ye-MySQL kuninzi losasazo lweLinux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kwaye iphunyezwe kwiiprojekthi ezibalulekileyo ezinje ngeWikipedia, Google Cloud SQL kunye neNimbuzz.

Iimpawu ezintsha eziphambili zikaMariaDB 10.4

Enye yeempawu eziphambili zolu hlobo lukaMariaDB kukuba contara ngenkxaso yeminyaka emi-5, ke le nguqulo iya kuxhaswa kude kube nguJuni 2024.

Utshintshele ekusebenziseni umgangatho we-C ++ 11 (Ukusebenza kweAtomic kuyabandakanyeka) kwaye ukusebenza kweepropathi ze "Collation" ze Unicode kunyuswe kakhulu, kukuvumela ukuba usete imigaqo yokuhlela kunye neendlela zokuthelekisa, kuthathelwa ingqalelo intsingiselo yabalinganiswa.

Ulwakhiwo ibandakanya iGalera 4 yolungelelwaniso lobuchwephesha obuninzi bokuphindaphindeka kwetekhnoloji, eyenza ukuba i-topology esebenzayo esebenzayo isebenze, ivumela ukufunda nokubhala kuyo nayiphi na indawo.

Ukuphindaphinda ngokuhambelana, zonke iindawo zihlala zinedatha yokwenyani, Oko kukuthi, kwaqinisekisa ukungabikho kwemicimbi elahlekileyo, kuba intengiselwano irekhodwa kuphela emva kokuba idatha ihanjisiwe kuzo zonke iindawo.

Ukuphindaphinda kwenziwa kwimowudi efanayo, kwinqanaba lomqolo, ngolwazi kuphela malunga notshintsho olwenziweyo.

Kwiinkqubo ezifana ne-Unix, i-unix_socket yokuqinisekisa iplagi yenziwe ngokungagqibekanga, ukuvumela ukuba usebenzise iiakhawunti kwinkqubo ukunxibelelana ne-DBMS usebenzisa isokethi yendawo yeUnix.

Singayifumana loo nto Wongeze amandla okwabela ixesha lokuphila lomsebenzisi, emva koko iphasiwedi iphawulwa njengephelelwe lixesha.

Ukuseka ixesha lokusebenza kwephasiwedi ekusebenzeni "YENZA UMSEBENZI" kunye "NOMSEBENZI WOMSEBENZI" kuyo kufuneka songeze igama elithi "IPASSWORD EXPIRE INTERVAL N DAY".

Ngakolunye uhlangothi Inkxaso iya kufunyanwa ibhloka umsebenzisis evela kwi-DBMS isebenzisa ibinzana "ACCOUNT LOCK" kwimisebenzi "YENZA UMSEBENZI" kunye "NOMSEBENZI WOMSEBENZI".

Kwakhona Ukuphunyezwa kokujongwa kwelungelo kwakukhawuleziswe kakhulu kuqwalaselo nenani elikhulu labasebenzisi okanye imigaqo yofikelelo.

Ukuphelisa ukusetyenziswa kwe-mysql.user kunye neetafile zam mysql.host. Itafile ye-mysql.global_priv ngoku isetyenziselwa ukugcina iiakhawunti zomsebenzisi kunye nelungelo lehlabathi.

Inkxaso yeetafile eziguqulelweyo zenkqubo, ekungagcinwanga kuphela icandelo ledatha yangoku, kodwa ulwazi malunga nalo lonke utshintsho olwenziwe ngaphambili lugcinwa, sIyandiswa ngokusebenza kwexesha.

Yongeze umyalelo omtsha "i-FLUSH SSL" yokulayisha kwakhona izatifikethi ze-SSL ngaphandle kokuqalisa kwakhona iserver;

Kwi- "INSTALL PLUGIN", "UNINSTALL PLUGIN" kunye ne "UNINSTALL SONAME", kuye kwongezwa inkxaso kumabinzana athi "UKUBA AKUKHO" na "UKUBA IKHO".

Inkqubo yeebhodi ezinganyangekiyo ezothusayo zicetyiswa ukuba zigcinwe apho kusetyenziswa i-Aria injini.

Okokugqibela sinokuqaqambisa ukuba isakhono sokusebenzisa ngaphezulu kweplagin yokuqinisekisa kwiakhawunti nganye yongezwa.

Olunye utshintsho olunokufumaneka kule nguqulo zezi:

  • Iplagi yokuqinisekisa yongeze intetho yenkxaso "SET IPHEPHA ELINGCWELE"
  • Yongeze iplagi yokuchaza iintlobo zakho zentsimi
  • Inkxaso eyongeziweyo yemisebenzi yewindows ye-UDF (Imisebenzi echaziweyo yomsebenzisi)
  • Kwi «ITHUBA LOKUGQIBELA» ukusebenza kwe «BACKUP LOCK» imo iyenziwa, enokusetyenziswa ngexesha lokugcinwa kweefayile zedatha
  • Yongezwe inkxaso yemiyalelo yeseva eqala ngegama elithi mariadb, enye indlela eya kwimiyalelo eqala ngo "mysql" (umzekelo, mariadump endaweni ye-mysqldump).

Yiba ngowokuqala ukuphawula

Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.