Tokollo ea pele e tsitsitseng ea lekala le lecha la DBMS MariaDB 10.10 (10.10.2) e hatisitsoe, moo lekala la MySQL le ntseng le ntlafatsoa le bolokang ho lumellana ka morao 'me le khetholloa ka ho kopanngoa ha lisebelisoa tse eketsehileng tsa polokelo le bokhoni bo tsoetseng pele. Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso e bulehileng le e hlakileng ea nts'etsopele e ikemetseng ho barekisi ka bomong. MariaDB e fanoa e le sebaka sa MySQL libakeng tse ngata tsa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) 'me e kentsoe tšebetsong mererong e meholo joalo ka Wikipedia, Google Cloud SQL le Nimbuzz.
Lintlafatso tsa bohlokoa ho MariaDB 10.10:
- E kentse tšebetso ea RANDOM_BYTES ho fumana tatellano e sa reroang ea li-byte tsa boholo bo fanoeng.
- E kentse mofuta oa data oa INET4 ho boloka liaterese tsa IPv4 ka boemeli ba 4-byte.
- Mekhahlelo ea kamehla ea poleloana ea "CHANGE MASTER TO" e fetotsoe, eo hona joale e sebelisang mokhoa oa ho pheta-pheta o thehiloeng ho GTID (Global Transaction ID), haeba seva se seholo se tšehetsa mofuta ona oa sekhetho. Litlhophiso tsa "MASTER_USE_GTID=Current_Pos" ha li sa sebetsa, 'me li lokela ho nkeloa sebaka ke khetho ea "MASTER_DEMOTE_TO_SLAVE".
- Lintlafatso tse ntlafalitsoeng bakeng sa ho kopanya lits'ebetso le litafole tse ngata, ho kenyelletsa le bokhoni ba ho sebelisa "eq_ref" ho kopanya litafole ka tatellano efe kapa efe.
- Li-algorithms tsa UCA (Unicode Collation Algoritm) tse kentsoeng, tse hlalositsoeng ho Unicode 14 mme li sebelisetsoa ho khetholla melao ea ho hlopha le ho bapisa ho nahanoa ka moelelo oa litlhaku (mohlala, ha ho hlophisoa boleng ba dijithale, boteng ba ho tlosa le letheba ka pel'a palo le mefuta e fapaneng ea mopeleto e hlokomeloa, 'me ha e bapisoa ha e amoheloe ho nahanoa ka taba ea litlhaku le boteng ba letšoao la molumo). Ts'ebetso e ntlafalitsoeng ea ts'ebetso ea UCA mesebetsing ea utf8mb3 le utf8mb4.
- Bokhoni ba ho kenya liaterese tsa IP lethathamong la li-Galera Cluster node tse lumelletsoeng ho etsa likopo tsa SST/IST bo kentsoe tšebetsong.
- Ka kamehla, mokhoa oa "explicit_defaults_for_timestamp" o kentsoe tšebetsong ho atametsa boitšoaro haufi le MySQL (ha o etsa "SHOW CREATE TABLE" likahare tsa li-block tsa DEFAULT tsa mofuta oa setempe sa nako ha li bontšoe).
- Sehokelong sa mola oa taelo, khetho ea "--ssl" e nolofalloa ka ho sa feleng (ho theha likhokahano tse encrypted tsa TLS ho nolofalitsoe).
- Ts'ebetso ea litlhaloso tsa boemo bo holimo tsa UPDATE le DELETE e se e entsoe bocha.
- DES_ENCRYPT le DES_DECRYPT le mefuta e fapaneng ya innodb_prefix_index_cluster_optimization e tlositswe.
Source: opennet.ru