Kutulutsidwa koyamba kokhazikika kwa nthambi yatsopano ya DBMS MariaDB 10.10 (10.10.2) kwasindikizidwa, momwe nthambi ya MySQL ikupangidwira yomwe imasunga kuyanjana kwa m'mbuyo ndipo imasiyanitsidwa ndi kuphatikiza kwa injini zosungirako zowonjezera ndi luso lapamwamba. Kukula kwa MariaDB kumayang'aniridwa ndi MariaDB Foundation yodziyimira payokha, kutsatira njira yotseguka komanso yowonekera yomwe ili yodziyimira pawokha kwa ogulitsa. MariaDB imaperekedwa m'malo mwa MySQL m'magawo ambiri a Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ndipo yakhala ikugwiritsidwa ntchito m'mapulojekiti akuluakulu monga Wikipedia, Google Cloud SQL ndi Nimbuzz.
Zosintha zazikulu mu MariaDB 10.10:
- Onjezani ntchito ya RANDOM_BYTES kuti mupeze mndandanda wama byte wamulingo womwe waperekedwa.
- Onjezani mtundu wa data wa INET4 kuti musunge ma adilesi a IPv4 mu chiwonetsero cha 4-byte.
- Zosintha zosasinthika za mawu oti "CHANGE MASTER TO" zasinthidwa, zomwe tsopano zimagwiritsa ntchito mawonekedwe obwereza potengera GTID (ID ya Global Transaction ID), ngati seva yayikulu imathandizira chozindikiritsa chamtunduwu. Zokonda za "MASTER_USE_GTID=Current_Pos" zatsitsidwa ndipo zikuyenera kusinthidwa ndi "MASTER_DEMOTE_TO_SLAVE".
- Kukhathamiritsa kwabwino kwa kuphatikiza magwiridwe antchito ndi matebulo ambiri, kuphatikiza kuthekera kogwiritsa ntchito "eq_ref" kuphatikiza matebulo mwanjira iliyonse.
- Kukhazikitsidwa kwa UCA (Unicode Collation Algoritm) ma aligorivimu, otanthauziridwa mu Unicode 14 ndipo amagwiritsidwa ntchito kudziwa malamulo osankha ndi kufananitsa poganizira tanthauzo la zilembo (mwachitsanzo, posankha ma digito, kupezeka kwa minus ndi kadontho patsogolo pa chiwerengero ndi mitundu yosiyanasiyana ya kalembedwe zimaganiziridwa, ndipo poziyerekeza sizikuvomerezedwa, ganizirani za otchulidwa ndi kukhalapo kwa chizindikiro cha mawu). Kuchita bwino kwa ntchito za UCA mu ntchito za utf8mb3 ndi utf8mb4.
- Kutha kuwonjezera ma adilesi a IP pamndandanda wamagawo a Galera Cluster omwe amaloledwa kuchita zopempha za SST/IST kwakhazikitsidwa.
- Mwachisawawa, mawonekedwe a "explicit_defaults_for_timestamp" amayatsidwa kuti ayandikitse khalidweli ku MySQL (pamene mukuchita "SHOW CREATE TABLE" zomwe zili mu DEFAULT midadada ya mtundu wa nthawi sizikuwonetsedwa).
- M'mawonekedwe a mzere wolamula, "--ssl" njira imayatsidwa mwachisawawa (kukhazikitsa ma TLS-encrypted kugwirizana ndikoyatsidwa).
- Kukonza kwa mawu apamwamba a UPDATE ndi DELETE kwakonzedwanso.
- Ntchito za DES_ENCRYPT ndi DES_DECRYPT komanso zosintha za innodb_prefix_index_cluster_optimization zatsitsidwa.
Source: opennet.ru