I-Oracle yakhe igatsha elisha le-MySQL 8.2 DBMS futhi yashicilela izibuyekezo zokulungisa ku-MySQL 8.0.35 kanye no-5.7.44. Ukwakhiwa kwe-MySQL Community Server 8.2.0 kulungiselelwe zonke i-Linux, i-FreeBSD, i-macOS ne-Windows ukusatshalaliswa okukhulu.
I-MySQL 8.2.0 iwukukhululwa kwesibili okwakhiwa ngaphansi kwemodeli entsha yokukhishwa, ehlinzeka ngokuba khona kwezinhlobo ezimbili zamagatsha e-MySQL - “I-Innovation” kanye ne-“LTS”. Amagatsha e-Innovation, ahlanganisa i-MySQL 8.1 ne-8.2, ayanconywa kulabo abafuna ukufinyelela ekusebenzeni okusha kusenesikhathi. Lawa magatsha ashicilelwa njalo ezinyangeni ezi-3 futhi asekelwa kuphela kuze kube yilapho ukukhululwa okukhulu okulandelayo kushicilelwe (isibonelo, ngemva kokuvela kwegatsha le-8.2, ukusekelwa kwegatsha le-8.1 kwanqanyulwa). Amagatsha e-LTS anconyelwe ukusetshenziswa okudinga ukubikezelwa kanye nokuphikelela kwesikhathi eside kokuziphatha okungashintshiwe. Amagatsha e-LTS azokhishwa njalo eminyakeni emibili futhi azosekelwa ngokujwayelekile iminyaka emi-5, ngaphezu kwalokho ongathola eminye iminyaka emi-3 yokusekelwa okunwetshiwe. Ukukhishwa kwe-LTS kwe-MySQL 2024 kulindeleke entwasahlobo ka-8.4, ngemva kwalokho kuzokwakhiwa igatsha elisha le-Innovation 9.0.
Izinguquko ezinkulu ku-MySQL 8.2:
- Ukwesekwa okwengeziwe kwendlela yokuqinisekisa esekelwe esicacisweni se-Webauthn (FIDO2), okukuvumela ukuthi usebenzise ukuqinisekiswa kwezinto eziningi futhi uqinisekise uxhumano kuseva ye-MySQL ngaphandle kwamaphasiwedi usebenzisa amathokheni ehadiwe anikwe amandla i-FIDO2 noma ukuqinisekiswa kwebhayomethrikhi. I-plugin ye-Webauthn okwamanje itholakala kuphela ku-MySQL Enterprise.
- I-plugin yeseva ye-mysql_native_password, enikeza ukuqinisekiswa kusetshenziswa amagama ayimfihlo, ihanjiswe esigabeni ongasikhetha futhi ingacishwa. Esikhundleni se-mysql_native_password, kuyanconywa ukuthi ushintshele ku-caching_sha2_password plugin, esebenzisa i-algorithm ye-SHA2 esikhundleni se-SHA1 ye-hashing. Ukuze ushintshele abasebenzisi ku-caching_sha2_password plugin bese ushintsha igama-mfihlo ufaka elingahleliwe, ungasebenzisa umyalo: ALTER USER 'username'@'localhost' UKHONJWE NGECACHING_sha2_password NGEPHASWEDI ENGAJWAYELEKILE IPHELELE IFAILED_LOGIN_ATTEMPTS 3 PASSWORD_2 PASSWORD_XNUMX;
- Amathebula e-Hash alungiselelwe ukusheshisa ukwenziwa kwemisebenzi ye-EXCEPT kanye ne-INTERSECT.
- Amandla okususa iphutha anwetshiwe. KHETHA, FAKA, BUYISE, BUYEKEZA futhi USUSA imisebenzi manje isekela inkulumo ethi "CHAZA IFOMU=JSON" ukuze ukhiqize okukhiphayo kokuxilonga ngefomethi ye-JSON (ngokwesibonelo, "CHAZA IFOMU=JSON INTO @var select_stmt;").
- Kwengezwe isisho esithi "CHAZA NGE-SCHEMA" ukuze kuboniswe ukuxilonga okuhlotshaniswa kuphela ne-schema yedatha ethile.
- Kwengezwe inketho ethi "-output-as-version" kusisetshenziswa se-mysqldump ukuze udale ukulahlwa okuhambisana nenguqulo ethile endala ye-MySQL (isibonelo, ungacacisa BEFORE_8_2_0 noma BEFORE_8_0_23 ukuze ubuyisele igama elingalungile ngokwepolitiki eliyinhloko/isigqila elihoxisiwe ekukhishweni okungu-8.2.0. 8.0.23 kanye no-XNUMX).
- Amandla okusebenzisa izibaluli eziqanjwe igama emibuzweni enepharamitha (izitatimende ezilungisiwe), asetshenziswa kusetshenziswa umsebenzi omusha we-mysql_stmt_bind_named_param(), othathe indawo yomsebenzi we-mysql_stmt_bind_param(), lengezwe kulabhulali yeklayenti C.
- Ukusabalalisa okwenziwe lula kwethrafikhi ye-SQL kuqoqo lamaseva e-MySQL. Amathuba anikeziwe wokuhlela ukuxhumeka kumaseva esibili noma ayinhloko asobala ezinhlelweni zokusebenza.
- Ilungelo elisha le-SET_ANY_DEFINER lengeziwe, elinikeza ilungelo lokudala izinto ezinomusho we-DEFINER, kanye nelungelo elithi ALLOW_NONEXISTENT_DEFINER lokuvikela izinto ezinomnikazi ongekho.
- Kwehlisiwe: izinto eziguquguqukayo ezindala nezintsha, imaski ethi "%" kanye "_" ekusebenzeni ukuze kunikezwe ukufinyelela kusizindalwazi, inketho ethi "-character-set-client-handshake", i-binlog_transaction_dependency_tracking variable kanye nelungelo le-SET_USER_ID.
- Njengengxenye yokulungisa amagama angalungile ngokwepolitiki ahlotshaniswa nokuphindaphinda, amagama athi "SETHA KABUSHA AMASTER", "SHOW MASTER STATUS", "SHOW MASTER LOGS" kanye "PURGE MASTER LOGS" ahoxisiwe, kanye nenkulumo ethi "SETHA KABUSHA AMALOGU ANAMBANAMILI KANYE NE-GTIDS" kufanele. BONISA ISIMO SOLOGU UNAMBAMBILI", "BONISA IZINGODO ZINAKAMBALAKATHI" kanye "HLANGANISA IZINGODO ZINAKAMBANAMBANA".
- Izici ebezihoxisiwe ngaphambilini zikhishiwe: umsebenzi WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), i-expire_logs_days variables, "--abort-slave-event-event-count" ongakhetha "--disconnect-slave-event-event".
- Ubuthakathaka obungu-26 bulungisiwe. Ubungozi obubili obuhlobene nokusetshenziswa kwephakheji ye-Curl kanye nelabhulali ye-OpenSSL kungaxhashazwa ukude.
Source: opennet.ru