I-Oracle idale igatsha elisha lesistimu yokuphathwa kwedatha ye-MySQL 8.2 futhi yashicilela izibuyekezo zokulungisa ze-MySQL 8.0.35 kanye ne-5.7.44. Izakhiwo ze-MySQL Community Server 8.2.0 zilungiselelwe zonke izabelo ezinkulu. Linux, I-FreeBSD, macOS и Windows.
I-MySQL 8.2.0 iwukukhululwa kwesibili ngaphansi kwemodeli entsha yokukhishwa kwe-MySQL, ehlanganisa izinhlobo ezimbili zamagatsha: Ukuqamba kanye ne-LTS. Amagatsha okusungula, ahlanganisa i-MySQL 8.1 ne-8.2, ayanconywa kulabo abafuna ukufinyelela kusenesikhathi ekusebenzeni okusha. Lawa magatsha ashicilelwa njalo ezinyangeni ezintathu futhi asekelwa kuphela kuze kube ukukhululwa okukhulu okulandelayo (isibonelo, ngemva kokukhululwa kwe-8.2, ukusekelwa kwe-8.1 kuphelile). Amagatsha e-LTS anconyelwe ukuthunyelwa okudinga ukubikezelwa nokuzinza kwesikhathi eside. Amagatsha e-LTS azokhishwa njalo eminyakeni emibili futhi azosekelwa iminyaka emihlanu, kuphinde kutholakale iminyaka emithathu yokwesekwa okwengeziwe. I-MySQL 8.4 kulindeleke ukuthi ikhishwe entwasahlobo ka-2024, ilandelwe yigatsha elisha le-Innovation, i-9.0.
Izinguquko ezinkulu ku-MySQL 8.2:
- Ukwesekwa okwengeziwe kwendlela yokuqinisekisa ngokusekelwe ku-Webauthn (FIDO2) specification, evumela ukuqinisekiswa kwezinto eziningi kanye nokuqinisekiswa kokuxhumeka ku- iseva I-MySQL ayinaphasiwedi, isebenzisa amathokheni ehadiwe anikwe amandla yi-FIDO2 noma ukuqinisekiswa kwe-biometric. I-plugin enokusekelwa kwe-Webauthn okwamanje itholakala kuphela kwi-MySQL Enterprise.
- I-plugin yeseva ye-mysql_native_password, ehlinzeka ngokufakazela ubuqiniso bephasiwedi, ihanjiswe esigabeni ongasikhetha futhi ingacishwa. Kutuswa ukuthi ushintshele ku-caching_sha2_password plugin esikhundleni se-mysql_native_password, esebenzisa i-algorithm ye-SHA2 ye-hashing esikhundleni se-SHA1. Ukuze ushintshele abasebenzisi ku-plugin ye-caching_sha2_password bese ushintsha igama-mfihlo ufaka elingahleliwe, sebenzisa umyalo: ALTER USER 'username'@'localhost' UKHONJWE NGECACHING_sha2_password NGEPHASWEDI ENGAJWAYELEKILE IPHELELE IFAILED_LOGIN_IMIZAMO 3 PASSWORD_2;
- Amathebula e-Hash alungiselelwe ukusheshisa ukwenziwa kwemisebenzi ye-EXCEPT kanye ne-INTERSECT.
- Amandla okususa iphutha anwetshiwe. Usekelo lwenkulumo ethi "CHAZA IFOMU=JSON" yengezwe kokuthi KHETHA, FAKA, REPLACE, BUYEKEZA, kanye nokuthi SUSA imisebenzi ukuze ukhiqize okukhiphayo kokuxilonga ngefomethi ye-JSON (isb., "CHAZA IFOMU=JSON INTO @var select_stmt;").
- Kwengezwe isitatimende esithi "CHAZA NGE-SCHEMA" ukuze kuboniswe ukuxilonga okuhlobene kuphela ne-schema yedatha ethile.
- Insiza ye-mysqldump manje inenketho "--output-as-version" yokudala ukulahlwa okuhambisana nenguqulo ethile endala ye-MySQL (isibonelo, ungacacisa BEFORE_8_2_0 noma BEFORE_8_0_23 ukuze ubuyele kugama elingalungile ngokwepolitiki eliyinhloko/isigqila elahoxiswa ku-8.2.0 no-8.0.23 nokukhishwayo).
- Umtapo wezincwadi weklayenti C manje usekela ukusebenzisa izibaluli eziqanjiwe emibuzweni enepharamitha (izitatimende ezilungiselelwe) ezisetshenziswa kusetshenziswa umsebenzi omusha we-mysql_stmt_bind_named_param(), othatha indawo yomsebenzisi we-mysql_stmt_bind_param().
- Ukusatshalaliswa kwethrafikhi ye-SQL kuqoqo leseva ye-MySQL kwenziwe kwaba lula. Ukuxhumana okungenamfihlo kuhlelo lokusebenza kumaseva esibili noma ayinhloko manje sekungenzeka.
- Kwengezwe ilungelo elisha SET_ANY_DEFINER lokunikeza ilungelo lokudala izinto ezinomusho we-DEFINER, kanye nelungelo elithi ALLOW_NONEXISTENT_DEFINER lokuvikela izinto ezingenamnikazi.
- Kwehlisiwe: izinto eziguquguqukayo ezindala nezintsha, amamaski "%" kanye "_" emisebenzini yesibonelelo sokufinyelela kusizindalwazi, inketho "--character-set-client-handshake", i-binlog_transaction_dependency_tracking variable, kanye nelungelo le-SET_USER_ID.
- Njengengxenye yokulungiswa kwamatemu angalungile ngokwepolitiki ahlobene nokuphindaphinda, amazwi athi "SETHA KABUSHA INKOSI", "BONISA ISIMO ESINKOSI", "SHOW MASTER LOGS", kanye "PURGE MASTER LOGS" ahoxisiwe futhi esikhundleni sawo kwafakwa amazwi athi "SETHA KABUSHA IZINGODO ZINAKABUKHOSI KANYE NE-GTIDS", "SHOW BINARY LOGS STATUS", "SHOW BINARY BINARY".
- Izici ebezihoxisiwe ngaphambilini zisusiwe: umsebenzi WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), i-expire_logs_days variable, kanye "--abort-slave-event-event-count" kanye "--disconnect-slave-event-event-count" izinketho.
- Ubungozi obungamashumi amabili nesithupha bulungisiwe. Ukulimala okubili okuhlobene nephakheji ye-Curl kanye nelabhulali ye-OpenSSL kungaxhashazwa ukude.
Source: opennet.ru
