Mushure megore rekuvandudza uye nhanhatu dzekutanga shanduro, iyo nyowani vhezheni vhezheni yebazi idzva reDBMS MariaDB 10.4 rakatoburitswa., mukati mayo bazi reMySQL rakagadziridzwa, iro rinochengetedza kuenderana neshanduro dzakapfuura uye rinopa kusangana kweanowedzera enjini dzekuchengetedza uye epamberi mabasa.
MariaDB budiriro inotarisirwa neyakaimiririra MariaDB Foundation zvinoenderana neyakavhurika uye yakajeka nzira yekuvandudza, yakazvimirira kune vamwe vatengesi.
MariaDB inouya panzvimbo yeMySQL mune akawanda maLinux anogovera (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye inoitwa muzvirongwa zvakakosha seWikipedia, Google Cloud SQL neNimbuzz.
Main nyowani maficha eMariaDB 10.4
Chimwe chezvinhu zvikuru zveiyi vhezheni yaMariaDB ndeyekuti contara nerutsigiro rwemakore mashanu, saka iyi vhezheni ichatsigirwa kusvika muna Chikumi 5.
Shanduko kushandisa C ++ 11 yakajairwa (Atomic mashandiro anobatanidzwa) uye mashandiro eiyo "Collation" nzvimbo dzenzvimbo ye Unicode yakawedzera zvakanyanya, zvichikubvumidza iwe kumisikidza mitemo yekumisikidza uye nzira dzekuenzanisa, uchifunga zvinorehwa nevanyori.
Chimiro inosanganisira Galera 4 inoenderana yakawanda tenzi kudzokorora tekinoroji, iyo inogonesa inoshanda-inoshanda yakawanda tenzi topology kuti ishandiswe, ichibvumira kuverenga nekunyora kune chero node.
Mukubvumirana kunoenderana, maodhi ese anogara aine data chairo, ndiko kuti, zvakavimbisa kusavapo kwekutengeserana kwakarasika, nekuti kutengeserana kunonyorwa chete mushure mekunge dhata ragoverwa kunzvimbo dzese.
Kudzokorora kunoitwa nenzira yakafanana, padanho remutsara, iine ruzivo chete nezve shanduko dzakapfuudzwa.
Pane Unix-senge masystem, iyo unix_socket yekusimbisa plugin inogoneswa nekutadza, ichikubvumidza iwe kushandisa maakaunzi pane system kuti ubatanidze kune DBMS uchishandisa sosi yeUnix yemuno.
Tinogona zvakare kuwana izvo akawedzera kugona kugovera mushandisi password password, mushure meizvozvo password inoratidzwa seyakapera.
Kuisa izwi rechokwadi repassword mune mashandiro «GADZIRA USER» uye «ALTER USER» kwariri tinofanirwa kuwedzera izwi rekuti «PASSWORD EXPIRE INTERVAL N ZUVA».
Kune rumwe rutivi Tsigiro ichawanikwa ichivharira mushandisis kubva kuDBMS vachishandisa chirevo "ACCOUNT LOCK" mune "Gadzira USER" uye "ALTER USER" mashandiro.
Mukuwedzera kuitwa kwekuremekedzwa cheki kwakakurumidza kumhanyisa mukugadzirisa nenhamba yakakura yevashandisi kana mitemo yekuwana.
Kurega kushandiswa kwemysql.user uye mysql.host matafura. Iyo mysql.global_priv tafura ikozvino yashandiswa kuchengeta mushandisi maakaunzi uye neropafadzo dzepasirese.
Tsigiro yematafura akagadziridzwa, mune iyo kwete chete iyo yazvino dhata yedhata yakachengetwa, asi ruzivo nezve shanduko dzese dzakaitwa kare dzinochengetwa, sInowedzerwa nekushanda kwenguva.
Wakawedzera murairo mutsva "FLUSH SSL" kutorazve zvitupa zveSSL pasina kutangazve server;
Mune mashandiro "INSTALL PLUGIN", "UNINSTALL PLUGIN" uye "UNINSTALL SONAME" akawedzera rutsigiro rwemazwi ekuti "KANA ASI ANO" uye "KANA ACHIKO".
Shock resistant system system inorongedzerwa kuchengetedza iyo iyo Injini yeAria inoshandiswa.
Chekupedzisira isu tinogona zvakare kuratidza kuti kugona kwekushandisa inopfuura imwechete yekusimbisa plugin kune yega account yakawedzerwa.
Dzimwe shanduko dzinogona kuwanikwa mune iyi vhezheni ndeidzi:
- Yekusimbisa plugin yakawedzera rutsigiro kutaura "SET PASSWORD"
- Wakawedzera plugin kutsanangura yako wega munda mhando
- Wakawedzera rutsigiro rweUDF windows mabasa (Mushandisi Anotsanangurwa Mabasa)
- Basa re "FLUSH TABLES" rinoshandisa iyo "BACKUP LOCK" maitiro, ayo anogona kushandiswa pakutsigira mafaira e database
- Wakawedzera rutsigiro rwemaseva mirairo kutanga nezita mariadb, imwe nzira kumirairo kutanga na "mysql" (semuenzaniso, mariadump panzvimbo ye mysqldump)