Oracle etolitela alaka ọhụrụ nke MySQL 8.2 DBMS wee bipụta mmelite mmezi na MySQL 8.0.35 na 5.7.44. A na-akwado MySQL Community Server 8.2.0 maka nkesa Linux, FreeBSD, macOS na Windows.
MySQL 8.2.0 bụ ntọhapụ nke abụọ hibere n'okpuru ụdị ntọhapụ ọhụrụ, nke na-enye maka ọnụnọ nke ngalaba MySQL abụọ - “Innovation” na “LTS”. Alaka Innovation, nke gụnyere MySQL 8.1 na 8.2, ka akwadoro maka ndị chọrọ ịnweta ọrụ ọhụrụ na mbụ. A na-ebipụta alaka ndị a kwa ọnwa 3 ma na-akwado naanị ruo mgbe ewepụtara isi mmalite ọzọ (dịka ọmụmaatụ, mgbe mpụtachara alaka nke 8.2, nkwado maka ngalaba 8.1 kwụsịrị). A na-atụ aro alaka LTS maka mmejuputa iwu chọrọ amụma amụma na ogologo oge nke omume agbanweghị agbanwe. A ga-ahapụ alaka LTS kwa afọ abụọ ma a ga-akwado ya maka afọ 5, na mgbakwunye na nke ị nwere ike nweta afọ 3 ọzọ nke nkwado ogologo oge. A na-atụ anya mwepụta LTS nke MySQL 2024 n'oge opupu ihe ubi nke 8.4, emesia a ga-emepụta alaka ọhụrụ 9.0 Innovation.
Nnukwu mgbanwe na MySQL 8.2:
- Nkwado agbakwunyere maka usoro nyocha dabere na nkọwapụta Webauthn (FIDO2), na-enye gị ohere iji nyocha ọtụtụ ihe wee kwado njikọ na sava MySQL na-enweghị okwuntughe site na iji akara ngwaike nwere FIDO2 ma ọ bụ nyocha biometric. Ngwa mgbakwunye Webauthn dị ugbu a naanị maka ụlọ ọrụ MySQL.
- Ihe mgbakwunye ihe nkesa mysql_native_password, nke na-enye nyocha site na iji okwuntughe, ebugharịla na ngalaba nhọrọ ma nwee ike nwee nkwarụ. Kama mysql_native_password, a na-atụ aro ka ịgbanwee gaa na caching_sha2_password plugin, nke na-eji SHA2 algọridim kama SHA1 maka hashing. Ka ịgbanwee ndị ọrụ na caching_sha2_password ngwa mgbakwunye wee dochie paswọọdụ site na enweghị usoro, ị nwere ike iji iwu a: ALTER USER 'username'@'localhost' IDENTIFIED WITH caching_sha2_password BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMP_3 2 PASSWORD.
- Edozila tebụl hash iji mee ka arụ ọrụ EXCEPT na INTERSECT dị ngwa ngwa.
- A gbasaala ike nzipu. Họrọ, INSERT, Dochie, Mmelite na Hichapụ arụmọrụ ugbu a na-akwado okwu a "EXPLAIN FORMAT=JSON" iji mepụta nchọpụta nchọpụta n'ụdị JSON (dịka ọmụmaatụ, "EXPLAIN FORMAT=JSON INTO @var select_stmt;").
- Agbakwunyere okwu "KWUOWA SCHEMA" iji gosipụta nchọpụta nchọpụta metụtara naanị otu atụmatụ data.
- Agbakwunyere nhọrọ "--output-as-version" na ngwa mysqldump iji mepụta mkpofu dakọtara na ụdị MySQL ochie (dịka ọmụmaatụ, ị nwere ike ezipụta BEFORE_8_2_0 ma ọ bụ BEFORE_8_0_23 iji weghachi okwu nna ukwu/ohu na-ezighi ezi na ndọrọ ndọrọ ọchịchị kwụsịrị na mwepụta 8.2.0. 8.0.23 na XNUMX).
- Ikike iji njiri mara aha na ajụjụ parameterized (okwu akwadoro), etinyere ya site na iji ọrụ mysql_stmt_bind_named_param () ọhụrụ, nke dochie ọrụ mysql_stmt_bind_param (), agbakwunyere na ọbá akwụkwọ C nke onye ahịa.
- Emeela nkesa okporo ụzọ SQL na ụyọkọ nke sava MySQL dị mfe. A na-enye ohere maka ịhazi njikọ na nke abụọ ma ọ bụ nke mbụ nke na-apụta ìhè na ngwa.
- agbakwunyere ihe ùgwù SET_ANY_DEFINER ọhụrụ, nke na-enye ikike imepụta ihe nwere okwu DEFINER, yana ohere ALLOW_NONEXISTENT_DEFINER ichekwa ihe n'enweghị onye nwe ya.
- Akwụsịla: mgbanwe ochie na nke ọhụrụ, ihe mkpuchi "%" na "_" na arụ ọrụ iji nye ohere ịnweta nchekwa data, nhọrọ "-character-set-client-handshake", ọnụọgụ binlog_transaction_dependency_tracking na ikike SET_USER_ID.
- Dị ka akụkụ nke idozi okwu ndọrọ ndọrọ ọchịchị ezighi ezi jikọtara ya na ntugharị, okwu ndị a bụ "RESET MASTER", "SHOW MASTER STATUS", "SHOW MASTER LOGS" na "PURGE MASTER LOGS" ka ebibiela, na okwu ndị a bụ "ReSET BINARY LOGS AND GTIDS" kwesịrị ekwesị. ga-eji kama. Gosi ọnụọgụ abụọ LOG STATUS", "Gosi ọnụọgụ abụọ" na "Kwụsị akwụkwọ ndekọ aha ọnụọgụ abụọ".
- Ewepụla atụmatụ ndị ewepụrụ na mbụ: ọrụ WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), ọnụọgụgụ_logs_days agbanwe, nhọrọ "--abort-slave-event-count" na "-disconnect-slave-event-count".
- 26 adịghị ike edozi. Enwere ike iji adịghị ike abụọ metụtara iji ngwugwu Curl na ọbá akwụkwọ OpenSSL mee ihe ozugbo.
isi: opennet.ru