Kusunungurwa kwekutanga kwakagadzikana kwebazi idzva reDBMS MariaDB 10.10 (10.10.2) rakadhindwa, mukati umo bazi reMySQL riri kugadzirwa rinochengetedza kuwirirana kwemashure uye rinosiyaniswa nekubatanidzwa kweimwe injini yekuchengetedza uye unyanzvi hwepamusoro. Kubudirira kweMariaDB kunotariswa neiyo yakazvimirira yeMariaDB Foundation, ichitevera yakavhurika uye iri pachena nzira yekuvandudza iyo yakazvimirira kune yega vatengesi. MariaDB inopihwa sechinzvimbo cheMySQL mune dzakawanda Linux kugoverwa (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) uye yakaitwa mumapurojekiti makuru seWikipedia, Google Cloud SQL uye Nimbuzz.
Kuvandudza kwakakosha muMariaDB 10.10:
- Wakawedzera RANDOM_BYTES basa kuti uwane kutevedzana kusina kurongeka kwemabhaiti ehukuru hwakapihwa.
- Yakawedzera INET4 data rudzi kuchengetedza IPv4 kero mune 4-byte inomiririra.
- Maparamita akasarudzika ekutaura kwe "CHANGE MASTER TO" akachinjwa, ayo ave kushandisa nzira yekudzokorodza yakavakirwa paGTID (Global Transaction ID), kana master server ichitsigira rudzi urwu rwechiratidzo. Iyo "MASTER_USE_GTID=Current_Pos" setting yarambwa uye inofanira kutsiviwa ne"MASTER_DEMOTE_TO_SLAVE".
- Yakavandudzwa optimizations yekubatanidza mashandiro nehuwandu hukuru hwematafura, kusanganisira kugona kushandisa "eq_ref" kubatanidza matafura mune chero kurongeka.
- Yakatemerwa UCA (Unicode Collation Algoritm) algorithms, inotsanangurwa muiyo Unicode 14 kutsanangurwa uye inoshandiswa kuona yekuronga nekufananidza mitemo ichifunga nezvezvinoreva mavara (semuenzaniso, pakuronga dhijitari, kuvapo kweminus uye doti pamberi pe. nhamba nemhando dzakasiyana dzezviperengo zvinotariswa, uye kana uchienzanisa hazvigamuchirwi funga nezvenyaya yevatambi uye kuvapo kwechiratidzo chekutaura). Kuvandudzwa kwekuita kweUCA mashandiro mune utf8mb3 uye utf8mb4 mabasa.
- Kugona kuwedzera IP kero kune rondedzero yeGalera Cluster node inotenderwa kuita SST/IST zvikumbiro kwaitwa.
- Nekumisikidza, iyo "explicit_defaults_for_timestamp" modhi inobatiswa kuunza maitiro padhuze neMySQL (kana uchiita "SHOW CREATE TABLE" zviri mukati me DEFAULT blocks yerudzi rwechitambi chenguva hazviratidzwe).
- Mune yekuraira mutsara interface, iyo "--ssl" sarudzo inogoneswa nekusarudzika (kumisikidza TLS-encrypted kubatana kunogoneswa).
- Kugadziriswa kwepamusoro-level UPDATE uye DELETE mataurirwo aitwazve.
- Iyo DES_ENCRYPT uye DES_DECRYPT mashandiro uye innodb_prefix_index_cluster_optimization musiyano warambwa.
Source: opennet.ru