Pulogalamu ya ProHoster > Blog > nkhani zapaintaneti > MySQL 8.3.0 DBMS ilipo

MySQL 8.3.0 DBMS ilipo

Oracle yapanga nthambi yatsopano ya MySQL 8.3 DBMS ndipo yafalitsa zosintha zosintha ku MySQL 8.0.36. Zomangamanga za MySQL Community Server 8.3.0 zakonzedwa kugawa zonse zazikulu za Linux, FreeBSD, macOS ndi Windows.

MySQL 8.3.0 ndi kumasulidwa kwachitatu kopangidwa pansi pa chitsanzo chatsopano chomasulidwa, chomwe chimapereka kupezeka kwa mitundu iwiri ya nthambi za MySQL - "Innovation" ndi "LTS". Nthambi za Innovation, zomwe zikuphatikiza MySQL 8.1, 8.2 ndi 8.3, zimalimbikitsidwa kwa iwo omwe akufuna kupeza magwiridwe antchito kale. Nthambizi zimasindikizidwa miyezi yonse ya 3 ndipo zimathandizidwa mpaka kutulutsidwa kwakukulu kotsatira kudzasindikizidwa (mwachitsanzo, pambuyo pa kuonekera kwa nthambi ya 8.3, chithandizo cha nthambi ya 8.2 chinathetsedwa). Nthambi za LTS zimalimbikitsidwa kuti zigwiritsidwe ntchito zomwe zimafuna kulosera komanso kusunga nthawi yayitali machitidwe osasinthika. Nthambi za LTS zimatulutsidwa zaka ziwiri zilizonse ndipo zimathandizidwa nthawi zonse kwa zaka 5, kuphatikiza pomwe mutha kupeza zaka zina za 3 zothandizira. Kutulutsidwa kwa LTS kwa MySQL 2024 kukuyembekezeka kumapeto kwa 8.4, pambuyo pake nthambi yatsopano ya Innovation 9.0 idzapangidwa.

Zosintha zazikulu mu MySQL 8.3:

  • Zowopsa za 25 zakhazikitsidwa, zomwe (CVE-2023-5363, zomwe zikukhudza OpenSSL) zitha kugwiritsidwa ntchito kutali. Nkhani yovuta kwambiri yokhudzana ndi kugwiritsa ntchito protocol ya Kerberos imapatsidwa mlingo wa 8.8. Kusatetezeka kocheperako kokhala ndi mulingo wowopsa 6.5 kumakhudza chowonjezera, UDF, DDL, DML, kubwereza, njira yamwayi, ndi zida zolembera.
  • Pa nsanja ya Linux, chithandizo cha cholumikizira nkhungu chawonjezedwa. Kuti muyitse, kusankha "-DWITH_LD=mold|lld" kwaperekedwa.
  • Zofunikira pamtundu wa C ++ wothandizidwa ndi wopanga zidakwezedwa kuchokera ku C++17 mpaka C++20.
  • Thandizo lomanga ndi malaibulale akunja a Boost C ++ lathetsedwa - malaibulale omangidwa a Boost okha ndi omwe amagwiritsidwa ntchito popanga MySQL. CMake yachotsa zosankha za WITH_BOOST, DOWNLOAD_BOOST ndi DOWNLOAD_BOOST_TIMEOUT.
  • Mangani chithandizo cha Visual Studio 2022 chathetsedwa. Mtundu wocheperako wothandizidwa wa zida za Clang wakwezedwa kuchokera ku Clang 10 kupita ku Clang 12.
  • MySQL Enterprise Edition yawonjezera chithandizo chosonkhanitsira ma telemetry ndi ma metrics okhudza magwiridwe antchito a seva mu mtundu wa OpenTelemetry ndikusamutsa deta ku purosesa ya netiweki yomwe imathandizira mtundu uwu.
  • Mawonekedwe a GTID (global transaction identifier) ​​​​, omwe amagwiritsidwa ntchito pobwereza kuti azindikire magulu ochita malonda, awonjezedwa. Mtundu watsopano wa GTID - "UUID: :NUMBER" (m'malo mwa "UUID:NUMBER"), pomwe TAG ndi chingwe chosasintha chomwe chimakulolani kuti mupereke mayina apadera ku gulu linalake la zochitika kuti muzitha kukonza ndi kugawa mosavuta.
  • Awonjeza zosintha ziwiri zatsopano "Deprecated_use_i_s_processlist_count" ndi "Deprecated_use_i_s_processlist_last_timestamp" kuti mulondolere kagwiritsidwe ntchito ka tebulo lotsitsidwa la INFORMATION_SCHEMA.PROCESSLIST.
  • Kukhazikitsa AUTHENTICATION_PAM_LOG kusintha kwa chilengedwe sikuchititsanso kuti mawu achinsinsi awonetsedwe mu mauthenga ozindikira matenda (mtengo wake PAM_LOG_WITH_SECRET_INFO ukufunika kuti mutchule mawu achinsinsi).
  • Tawonjezedwa tp_connections tebulo ndi zambiri zokhudzana ndi kulumikizana kulikonse mu dziwe la ulusi.
  • Mawonekedwe amtundu wowonjezera "explain_json_format_version" kuti musankhe mtundu wa JSON womwe ukugwiritsidwa ntchito mu "EXPLAIN FORMAT=JSON".
  • Posungira InnoDB, zosankha za "--innodb" ndi "--skip-innodb", zomwe zidatsitsidwa pakutulutsidwa kwa MySQL 5.6, zachotsedwa. Pulogalamu yowonjezera ya memcached ya InnoDB, yomwe idachotsedwa mu MySQL 8.0.22, yachotsedwa.
  • Yachotsa zosintha zina zokhudzana ndi kubwereza ndi zosankha za mzere wamalamulo zomwe zidasiyidwa m'mawu am'mbuyomu: "--slave-rows-search-algorithms", "--relay-log-info-file", "-relay-log-info-repository" ", "-master-info-file", "-master-info-repository", "log_bin_use_v1_events", "transaction_write_set_extraction", "group_replication_ip_whitelist", "group_replication_primary_member". Kutha kugwiritsa ntchito njira ya IGNORE_SERVER_IDS yokhala ndi GTID yobwerezabwereza (gtid_mode=ON) kwachotsedwa.
  • Thandizo la ntchito za C API lathetsedwa: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • Mawu akuti "FLUSH HOSTS", omwe adatsitsidwa mu MySQL 8.0.23, adathetsedwa.

Source: opennet.ru

Kuwonjezera ndemanga