ProHoster > Blog > internet nhau > MariaDB 10.4 yakagadzikana kuburitswa

MariaDB 10.4 yakagadzikana kuburitswa

Mushure megore rekuvandudza uye matanhatu pre-kuburitswa gadzirira yekutanga yakagadzikana kuburitswa kwebazi idzva reDBMS MariaDB 10.4, mukati meiyo bazi reMySQL riri kugadzirwa rinochengetedza kumashure kuenderana uye zvakasiyana kubatanidzwa kwemamwe mainjini ekuchengetedza uye kugona kwepamusoro. Bazi idzva richatsigirwa kwemakore mashanu, kusvika muna June 5.

Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira MariaDB Foundation, ichitevera yakavhurika uye yakajeka yekuvandudza maitiro ayo akazvimirira kune ega vatengesi. MariaDB inopihwa pachinzvimbo cheMySQL mune dzakawanda Linux kugovera (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru akadai se. Wikipedia, Google Cloud SQL ΠΈ Nimbuzz.

Key kuvandudzika MariaDB 10.4:

  • Inosanganisira synchronous multi-master replication tekinoroji Galera 4, iyo inobvumira inoshingaira-inoshanda yakawanda-tenzi topology inogona kuverengwa uye kunyorwa chero node. Iine synchronous replication, node dzese dzinogara dziine data yazvino, i.e. hapana kutengeserana kwakarasika kunovimbiswa sezvo kutengeserana kunoitwa chete mushure mekunge data yaparidzirwa kune node dzese. Kudzokorora kunoitwa nenzira yakafanana, padanho remutsara, kuendesa chete ruzivo nezve shanduko;
  • PaUnix-senge masisitimu, iyo yekusimbisa plugin inogoneswa nekusarudzika unix_socket, iyo inokubvumira kushandisa maakaunti aripo muhurongwa kuti ubatanidze kuDBMS uchishandisa unix socket yemunharaunda;
  • Added mukana kugovera hupenyu hwese password yemushandisi, mushure meizvozvo iyo password inomakwa seyakapera. Kuseta zuva rekupera kwepassword mu "CREATE USER" uye "ALTER USER" mashandiro, izwi rekuti "PASSWORD EXPIRE INTERVAL N DAY" rawedzerwa;
  • Yakawedzerwa rutsigiro ichivharira Vashandisi veDBMS kuburikidza nekutaura kwe "ACCOUNT LOCK" mu "CREATE USER" uye "ALTER USER" mashandiro;
  • Kuitwa kweropafadzo kunotarisa mukugadzirisa nehuwandu hwevashandisi kana mitemo yekuwana yakakurumidza kukurumidza;
  • discontinued uchishandisa mysql.user uye mysql.host matafura. Iyo mysql.global_priv table yava kushandiswa kuchengeta maakaunti neropafadzo dzepasi rose;
  • Π’ plugins authentication akawedzera rutsigiro rwekuti "SET PASSWORD" kutaura;
  • Added kugona kushandisa anopfuura imwechete yekusimbisa plugin yeakaundi yega yega, iyo inogona kubatsira kune zvishoma nezvishoma kutamira vashandisi kune plugin. ed25519. Paunenge uchigadzira iyo mudzi @ localhost mushandisi ine mysql_install_db script, maviri echokwadi plugins ave kugoneswa nekusarudzika - unix_socket uye mysql_native_password;
  • Iyo InnoDB yekuchengetedza inoshandisa kushanda kwekudzima makoramu ipapo (ALTER TABLE ... DROP COLUMN ... ALGORITHM=INSTANT) uye kushandura kurongeka kwemakoramu. Saizi yerogi yekutanga yekudzosera mashandiro (redo log) yakaderedzwa. Yakawedzera kiyi yekutenderera rutsigiro innodb_encrypt_log. Yakaitwa algorithm yekutarisa checksums
    innodb_checksum_algorithm=full_crc32. Inopa kuwedzera nekukurumidza kwerudzi rweVARCHAR uye kushandura encoding yemavara kune asina-indexed column;

  • Yakavandudzwa optimizer. Yakawedzera kugona kuteedzera iyo optimizer, inogoneswa kuburikidza neinosiyana system optimizer-trace. Default zvinosanganisira kuchengetedza zviverengero zvakazvimirira zvezvinjini zvekuchengetedza.
    Pane maviri matsva use_stat_tables modhi - COMPLEMENTARY_FOR_QUERIES uye PREFERABLY_FOR_QUERIES. optimize_join_buffer_size mode inogoneswa. Zvitsva zvakawedzerwa mireza rowid_filter uye condition_pushdown_from_having;

  • Tsigiro yematafura eshanduro yesystem, ayo asingangochengete chete yazvino data chidimbu, asi zvakare chengetedza ruzivo nezve zvese zvakamboitwa shanduko, yakawedzerwa. mabasa nezvikamu zvenguva;
  • Yakawedzera mutsva "FLUSH SSL" murairo wekurodha zvakare SSL zvitupa pasina kutangazve server;
  • Yakawedzerwa rutsigiro rwekuti "KANA ASIPO" uye "KANA IRIPO" mu "INSTALL PLUGIN", "UNINSTALL PLUGIN" uye "UNINSTALL SONAME" mashandiro;
  • Crash-resistant system matafura anokurudzirwa, kuitira kuchengetedza iyo injini inoshandiswa Aria;
  • Shanduko yekushandiswa kweiyo C ++11 chiyero chakaitwa (atomic mashandiro anobatanidzwa);
  • Kuita kweCollation locale zvivakwa zve Unicode kwakagadziridzwa zvakanyanya, zvichikubvumidza kuti utaure mitemo yekuronga uye nzira dzekufananidza zvichienderana nezvinoreva mavara;
  • Added plugin yekutsanangura mhando dzemunda wako;
  • Yakawedzera rutsigiro rwewindow UDF inoshanda (Mushandisi-Akatsanangurwa Mabasa);
  • Mukushanda kwe "FLUSH TABLES". itwa "BACKUP LOCK" modhi, iyo inogona kushandiswa paunenge uchitsigira dhatabhesi mafaira;
  • Added tsigiro yemirairo yeseva kutanga ne mariadb, dzimwe nzira dzemirairo kutanga ne "mysql" (semuenzaniso, mariadump pachinzvimbo che mysqldump).

Source: opennet.ru

Voeg