Bayan shekara guda na ci gaba da juzu'i shida na farko, an riga an sake sabon sabon fasalin sabon reshe na DBMS MariaDB 10.4., a cikin abin da aka haɓaka reshe na MySQL, wanda ke riƙe daidaituwa tare da sifofin da ya gabata kuma yana ba da haɗin haɗakar ƙarin injunan ajiya da ayyuka na ci gaba.
Ci gaban MariaDB yana karkashin kulawar Gidauniyar MariaDB mai zaman kanta bisa tsarin ci gaba gaba ɗaya wanda ya buɗe kuma mai gaskiya, mai zaman kansa ga masu siyar da kansa.
MariaDB ta zo a madadin MySQL a yawancin rarraba Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma ana aiwatar da su a cikin mahimman ayyuka kamar su Wikipedia, Google Cloud SQL da Nimbuzz.
Babban sabon fasalin MariaDB 10.4
Ofaya daga cikin manyan siffofin wannan sigar ta MariaDB shine contara tare da tallafi na shekaru 5, don haka za'a tallafawa wannan sigar har zuwa Yuni 2024.
Canza zuwa amfani da daidaitattun C + + 11 (Ayyukan Atomic suna da hannu) kuma aiwatar da kaddarorin yanki na "Tattara" na Unicode ya karu sosai, yana ba ku damar saita dokokin rarrabuwa da hanyoyin kwatantawa, la'akari da ma'anar haruffa.
Tsarin ya hada da Galera 4 tare da fasaha mai kere-kere da yawa, wanda ke ba da izinin amfani da topology mai yawan aiki mai aiki, ba da damar karantawa da rubutu zuwa kowane kumburi.
A cikin aiki tare, dukkan node koyaushe suna ƙunshe da ainihin bayanai, ma'ana, ta tabbatar da rashin ma'amala da suka ɓace, tunda ana yin rijistar ma'amala ne kawai bayan an rarraba bayanan ga duk nodes.
Ana yin kwafi a cikin layi daya, a matakin jere, tare da kawai bayanai game da canje-canjen da aka watsa.
A kan tsarin kwatankwacin Unix, ana kunna unix_socket ingantaccen plugin ta tsohuwa, ba ka damar amfani da asusun a kan tsarin don haɗawa zuwa DBMS ta amfani da soket ɗin Unix na gida.
Hakanan zamu iya samun hakan abilityara ikon sanya kalmar sirrin mai amfani tsawon rai, bayan haka kalmar wucewa ta yi alama cewa ta kare.
Don ƙayyade lokacin ingancin kalmar sirri a cikin ayyukan "HALITTA MAI AMFANI" da "KASHE MAI AMFANI" a kanta dole ne mu ƙara kalmar "PASSWORD EXPIRE INTERVAL N DAY".
A gefe guda za a sami tallafi don toshe mai amfanis daga DBMS ta amfani da kalmar "ACCOUNT LOCK" a cikin ayyukan "KIRAN MAI AMFANI" da "KASHE USER".
Bugu da ƙari aiwatar da binciken gata da sauri a cikin daidaitawa tare da adadi mai yawa na masu amfani ko ka'idojin samun dama.
An daina amfani da teburin mysql.user da mysql.host. Ana amfani da teburin mysql.global_priv don adana asusun masu amfani da gatan duniya.
Taimako don tsarin tebur na tsari, a cikin wanda ba kawai ɓangaren bayanan yanzu ake adana ba, amma ana samun bayanai game da duk canje-canje da aka yi a baya, sAn fadada shi ta ayyukan ɓataccen lokaci.
Ara sabon umarni "FLUSH SSL" don sake shigar da takaddun shaidar SSL ba tare da sake farawa uwar garke ba;
A cikin ayyukan "INSTALL PLUGIN", "UNINSTALL PLUGIN" da "UNINSTALL SONAME" sun ƙara goyan baya ga maganganun "IDAN BASU KASANCE" da "IDAN KASAN".
An gabatar da allon tsarin tsayayye don ajiyar abin da ake amfani da injin Aria.
A ƙarshe za mu iya haskakawa cewa an ƙara ikon amfani da fulogi na tabbatarwa sama da ɗaya don kowane asusu.
Sauran canje-canjen da za'a iya samu a cikin wannan sigar sune:
- Fayil ɗin tantancewa ya ƙara kalmar tallafi "SET PASSWORD"
- Pluginara plugin don ayyana nau'ikan filinku
- Supportara tallafi don ayyukan taga UDF (Ayyuka Masu Ayyuka na Mai Amfani)
- Aikin "FLUSH TABLES" yana aiwatar da yanayin "BACKUP LOCK", wanda za'a iya amfani dashi yayin adana fayilolin bayanai
- Ara tallafi don umarnin uwar garke wanda ya fara da sunan mariadb, madadin umarni farawa da "mysql" (misali, mariadump maimakon mysqldump).