MariaDB 10.4 tokollo e tsitsitseng

Ka mor'a selemo sa ntshetsopele le tse tšeletseng pele ho lokolloa itokisitse tokollo ea pele e tsitsitseng ea lekala le lecha la DBMS MariaDB 10.4, moo ho ntseng ho ntlafatsoa lekala la MySQL le bolokang tšebelisano ea morao-rao le fapaneng kopanyo ea lienjineri tse eketsehileng tsa polokelo le bokhoni bo tsoetseng pele. Ho tla fanoa ka tšehetso bakeng sa lekala le lecha ka lilemo tse 5, ho fihlela ka June 2024.

Nts'etsopele ea MariaDB e tsamaisoa ke Mokhatlo o ikemetseng oa MariaDB, ho latela ts'ebetso ea nts'etsopele e bulehileng ka ho felletseng e ikemetseng ho barekisi ka bomong. MariaDB e fanoe sebakeng sa MySQL ho li-distributions 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 и nimbuzz.

Senotlolo ntlafatso MariaDB 10.4:

• E kenyelletsa tekhenoloji ea ho ikatisa ea masters e mengata e lumellanang Khaolo ea 4, e lumellang topology e sebetsang e sebetsang ka bongata e ka baloang le ho ngoloa ke node efe kapa efe. Ka ho pheta-pheta ka mokhoa o lumellanang, li-node tsohle li lula li na le data ea morao-rao, ke hore. ha ho na litšebelisano tse lahlehileng tse tiisitsoeng, kaha ts'ebetso e etsoa feela ka mor'a hore data e phatlalatsoe ho li-node tsohle. Ho pheta-pheta ho etsoa ka mokhoa o ts'oanang, boemong ba mela, ho fetisa boitsebiso feela ka liphetoho;
• Litsamaisong tse kang Unix, plugin ea netefatso e nolofalloa ka ho sa feleng unix_socket, e leng se u lumellang hore u sebelise litlaleho tse teng tsamaisong ea ho hokahanya le DBMS ho sebelisa sokete ea unix ea sebakeng seo;
• E kentsoe monyetla ho abela phasewete ea mosebelisi bophelo bohle, ka mor'a moo phasewete e tšoauoa e felile. Ho beha letsatsi la ho felloa ke nako ha password ts'ebetsong ea "CREATE USER" le "ALTER USER", poleloana "PASSWORD EXPIRE INTERVAL N DAY" e kentsoe;
• Tšehetso e ekelitsoeng thibela Basebelisi ba DBMS ka polelo ea "ACCOUNT LOCK" ts'ebetsong ea "CREATE USER" le "ALTER USER";
• Ts'ebetso ea ho hlahloba litokelo ka litlhophiso tse nang le palo e kholo ea basebelisi kapa melao ea ho fihlella e potlakisitsoe haholo;
• khaotsoe ho sebelisa litafole tsa mysql.user le mysql.host. Tafole ea mysql.global_priv e se e sebelisoa ho boloka li-account le litokelo tsa lefats'e;
• В li-plugins netefatso eketsoe tšehetso bakeng sa polelo ea "SET PASSWORD";
• E kentsoe bokhoni ba ho sebelisa plugin ea netefatso e fetang e le 'ngoe bakeng sa ak'haonte e' ngoe le e 'ngoe, e ka ba molemo bakeng sa ho fallisetsa basebelisi butle-butle ho plugin. ed25519. Ha u theha mosebelisi oa "root@localhost" ka mongolo oa mysql_install_db, li-plugins tse peli tsa netefatso li se li nolofalitsoe ka mokhoa o ikhethileng - unix_socket le mysql_native_password;
• Polokelo ea InnoDB e sebelisa ts'ebetso ea ho hlakola litšiea hang-hang (ALTER TABLE ... DROP COLUMN ... ALGORITHM=INSTANT) le ho fetola tatellano ea likholomo. Boholo ba logi ea pele bakeng sa ts'ebetso ea rollback (redo log) e fokotsehile. E kenyellelitse ts'ehetso ea bohlokoa ea ho potoloha bakeng sa innodb_encrypt_log. E kentse algorithm ea ho lekola li-checksums
  innodb_checksum_algorithm=full_crc32. E fana ka katoloso ea hang-hang ea mofuta oa VARCHAR le ho fetola khouto ea mongolo bakeng sa likholomo tse sa ngolisoeng;

• optimizer e ntlafalitsoeng. E kentse bokhoni ba ho ts'oara optimizer, e nolofalitsoeng ka mokhoa o fapaneng oa sistimi optimizer-trace. Ea kamehla kenyelelitsoe ho boloka lipalo-palo ntle le lienjineri tsa polokelo.
  Ho na le mefuta e 'meli e mecha ea use_stat_tables - COMPLEMENTARY_FOR_QUERIES le PREFERABLY_FOR_QUERIES. optimize_join_buffer_size mode e lumelletsoe. Tse ncha li kentsoe lifolakha rowid_filter le condition_pushdown_from_having;

• Ts'ehetso ea litafole tsa mofuta oa sistimi, e sa bolokeng selae sa data sa hajoale, empa hape le ho boloka tlhahisoleseling mabapi le liphetoho tsohle tse entsoeng pele, e atolositsoe. ts'ebetso ka mekhahlelo ea nako;
• E kentse taelo e ncha ea "FLUSH SSL" ho kenya litifikeiti tsa SSL hape ntle le ho qala seva hape;
• Ts'ebetsong ea "INSTALL PLUGIN", "UNINSALL PLUGIN" le "UNINSTALL SONAME" li ekelitse tšehetso bakeng sa lipoleloana "HAE TSE TENG" le "HAEBA E LE TENG";
• Litafole tsa sistimi e thibelang ho senyeha hoa sisinngoa, bakeng sa ho boloka enjene e sebelisoang Aria;
• Phetoho ea tšebeliso ea maemo a C ++ 11 e entsoe (ts'ebetso ea athomo e ameha);
• Ts'ebetso ea thepa ea sebaka sa Collation bakeng sa Unicode e ntlafalitsoe haholo, e u lumella ho hlakisa melao ea ho hlopha le mekhoa e bapisang ho latela moelelo oa litlhaku;
• E kentsoe plugin bakeng sa ho hlalosa mefuta ea hau ea masimo;
• Tšehetso e ekelitsoeng bakeng sa lifensetere Mesebetsi ea UDF (Mesebetsi e Hlalositsoeng ke Mosebelisi);
• Ka ts'ebetso ea "FLUSH TABLES". kenngwa tshebetsong Mokhoa oa "BACKUP LOCK", o ka sebelisoang ha o boloka lifaele tsa database;
• E kentsoe tšehetso bakeng sa litaelo tsa seva ho qala ka mariadb, mekhoa e meng ea litaelo tse qalang ka "mysql" (mohlala, mariadump sebakeng sa mysqldump).

Source: opennet.ru