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

MySQL 8.2.0 DBMS ilipo

Oracle yapanga nthambi yatsopano ya MySQL 8.2 DBMS ndikusindikiza zosintha zosintha ku MySQL 8.0.35 ndi 5.7.44. Zomangamanga za MySQL Community Server 8.2.0 zakonzedwa kugawa zonse zazikulu za Linux, FreeBSD, macOS ndi Windows.

MySQL 8.2.0 ndi kumasulidwa kwachiwiri kupangidwa 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 ndi 8.2, zimalimbikitsidwa kwa iwo omwe akufuna kupeza magwiridwe antchito kale. Nthambizi zimasindikizidwa miyezi yonse ya 3 ndipo zimathandizidwa pokhapokha mpaka kutulutsidwa kwakukulu kotsatira kudzasindikizidwa (mwachitsanzo, pambuyo powonekera kwa nthambi ya 8.2, chithandizo cha nthambi ya 8.1 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.2:

  • Thandizo lowonjezera pamakina otsimikizira kutengera mafotokozedwe a Webauthn (FIDO2), kukulolani kuti mugwiritse ntchito kutsimikizika kwazinthu zambiri ndikutsimikizira kulumikizana ndi seva ya MySQL popanda mawu achinsinsi pogwiritsa ntchito zizindikiro za Hardware zothandizidwa ndi FIDO2 kapena kutsimikizika kwa biometric. Pulogalamu yowonjezera ya Webauthn ikupezeka pa MySQL Enterprise yokha.
  • Mysql_native_password seva plugin, yomwe imapereka chitsimikiziro pogwiritsa ntchito mawu achinsinsi, yasunthidwa kugawo losankha ndipo ikhoza kuyimitsidwa. M'malo mwa mysql_native_password, tikulimbikitsidwa kuti musinthe ku caching_sha2_password plugin, yomwe imagwiritsa ntchito SHA2 algorithm m'malo mwa SHA1 ya hashing. Kuti musinthe ogwiritsa ntchito ku caching_sha2_password plugin ndikusintha mawu achinsinsi ndi amodzi mwachisawawa, mutha kugwiritsa ntchito lamulo: ALTER USER 'username'@'localhost' WODZIΕ΄IKA NDI caching_sha2_password NDI ZOCHITA PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD 2 PASSWORD XNUMX;
  • Matebulo a Hash adakonzedwa kuti afulumizitse ntchito EXCEPT ndi INTERSECT.
  • Kuthekera kochotsa zolakwika kwakulitsidwa. SINANI, INSERT, REPLACE, UPDATE ndi DELETE operations tsopano zikugwirizana ndi mawu oti "EXPLAIN FORMAT=JSON" kuti mupange diagnostic output mu JSON format (mwachitsanzo, "EXPLAIN FORMAT=JSON INTO @var select_stmt;").
  • Adawonjezedwa mawu akuti "EXPLAIN FOR SCHEMA" kuti awonetse zowunikira zomwe zimangogwirizana ndi schema inayake ya data.
  • Chowonjezera "-output-as-version" ku mysqldump utility kuti mupange zinyalala zomwe zimagwirizana ndi mtundu wakale wa MySQL (mwachitsanzo, mutha kutchula BEFORE_8_2_0 kapena BEFORE_8_0_23 kuti mubweze mawu olakwika a master/akapolo omwe adachotsedwa pazandale 8.2.0. 8.0.23 ndi XNUMX).
  • Kuthekera kogwiritsa ntchito zotchulidwa m'mafunso otsatiridwa (ziganizo zokonzedwa), zogwiritsidwa ntchito pogwiritsa ntchito mysql_stmt_bind_named_param() ntchito yatsopano, yomwe idalowa m'malo mwa mysql_stmt_bind_param() ntchito, yawonjezedwa ku laibulale ya kasitomala C.
  • Kugawa kosavuta kwa magalimoto a SQL mumagulu a maseva a MySQL. Kuthekera kumaperekedwa pakukonza zolumikizira ku maseva achiwiri kapena oyambira omwe amawonekera pamapulogalamu.
  • Mwayi watsopano wa SET_ANY_DEFINER wawonjezedwa, womwe umapereka ufulu wopanga zinthu ndi mawu a DEFINER, komanso mwayi wa ALLOW_NONEXISTENT_DEFINER kuteteza zinthu ndi eni ake omwe palibe.
  • Zachotsedwa: zosintha zakale ndi zatsopano, masks a "%" ndi "_" omwe akugwira ntchito kuti apatse mwayi wofikira ku database, njira ya "-character-set-client-handshake", njira ya binlog_transaction_dependency_tracking ndi mwayi wa SET_USER_ID.
  • Monga gawo lokonza mawu olakwika andale okhudzana ndi kubwerezabwereza, mawu oti "RESET MASTER", "SHOW MASTER STATUS", "SHOW MASTER LOGS" ndi "PURGE MASTER LOGS" asiyidwanso, ndipo mawu oti "RESET BINARY LOGS AND GTIDS" akuyenera M'malo mwake, ONERANI ZOKHUDZA ZOKHUDZA ZOKHUDZA ZOCHITIKA", "ONETSANI ZIPINGO ZONSE" ndi "PURGE LOGIG BINARY".
  • Zina zomwe zidasiyidwa kale zachotsedwa: ntchito ya WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), kusintha kwa expire_logs_days, "--abort-slave-event-count-count" ndi "--disconnect-slave-event-count".
  • Zofooka za 26 zakonzedwa. Zofooka ziwiri zokhudzana ndi kugwiritsa ntchito phukusi la Curl ndi laibulale ya OpenSSL zitha kugwiritsidwa ntchito kutali.

Source: opennet.ru

Kuwonjezera ndemanga