An buga barga na farko na sabon MariaDB 10.10 (10.10.2) reshe na DBMS, wanda a cikinsa ake haɓaka reshe daga MySQL wanda ke kula da daidaituwar baya kuma an bambanta ta hanyar haɗin ƙarin injunan ajiya da fasali na ci gaba. Gidauniyar MariaDB mai zaman kanta ce ke kula da ci gaban MariaDB, bin tsarin ci gaban buɗaɗɗe da fayyace mai zaman kanta na kowane dillalai. Ana jigilar MariaDB a madadin MySQL akan yawancin rarrabawar Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) kuma manyan ayyuka kamar Wikipedia, Google Cloud SQL, da Nimbuzz sun karɓa.
Maɓallin haɓakawa a cikin MariaDB 10.10:
- Ƙara aikin RANDOM_BYTES don samun jerin bazuwar bytes na girman da aka bayar.
- An ƙara nau'in bayanan INET4 don adana adiresoshin IPv4 a cikin wakilcin 4-byte.
- An canza ma'auni na kalmar "CHANGE MASTER ZUWA", wanda yanzu yana amfani da yanayin kwafi bisa GTID (ID na Kasuwancin Duniya), idan babban uwar garken yana goyan bayan wannan nau'in ganowa. An soke saitin "MASTER_USE_GTID=Current_Pos" kuma yakamata a maye gurbinsa da zabin "MASTER_DEMOTE_TO_SLAVE".
- Ingantattun ingantawa don haɗa ayyukan tare da adadi mai yawa na teburi, gami da ikon yin amfani da "eq_ref" don haɗa tebur a kowane tsari.
- Aiwatar da UCA (Unicode Collation Algoritm) Algorithms, wanda aka ayyana a cikin ƙayyadaddun Unicode 14 kuma ana amfani da su don tantance rarrabuwa da ƙa'idodin daidaitawa da la'akari da ma'anar haruffa (misali, lokacin da ake rarraba ƙimar dijital, kasancewar ragi da dige a gaban. ana la'akari da lamba da nau'ikan haruffa daban-daban, kuma idan aka kwatanta shi ba a yarda da shi ba a yi la'akari da yanayin haruffa da kasancewar alamar lafazin). Ingantattun ayyukan UCA a cikin ayyukan utf8mb3 da utf8mb4.
- An aiwatar da ikon ƙara adiresoshin IP zuwa jerin Galera Cluster nodes waɗanda aka ba su izinin yin buƙatun SST/IST.
- Ta hanyar tsoho, ana kunna yanayin "bayyanar_defaults_for_timestamp" don kawo dabi'ar kusa da MySQL (lokacin aiwatar da "NUNA CREATE TABLE" abubuwan da ke cikin DEFAULT tubalan na nau'in tambarin lokaci ba a nuna ba).
- A cikin layin umarni, zaɓin "--ssl" yana kunna ta tsohuwa (kafa haɗin haɗin TLS an kunna).
- An sake yin aiki na babban matakin UPDATE da DELETE maganganu.
- Ayyukan DES_ENCRYPT da DES_DECRYPT da innodb_prefix_index_cluster_optimization an soke su.
source: budenet.ru