Oracle wuxuu sameeyay laan cusub oo MySQL 8.2 DBMS ah wuxuuna daabacay cusbooneysiinta sixitaanka MySQL 8.0.35 iyo 5.7.44. MySQL Community Server 8.2.0 dhismooyin ayaa loo diyaariyey dhammaan Linux waaweyn, FreeBSD, macOS iyo qaybinta Windows.
MySQL 8.2.0 waa sii dayntii labaad ee lagu sameeyay qaabka cusub ee sii deynta, kaas oo bixiya joogitaanka laba nooc oo laamood MySQL ah - "Innovation" iyo "LTS". Laamaha hal-abuurka, oo ay ku jiraan MySQL 8.1 iyo 8.2, ayaa lagula talinayaa kuwa doonaya inay hore u helaan hawl cusub. Laamahaan waxaa la daabacaa 3-dii biloodba mar waxaana la taageeraa oo kaliya ilaa laga soo saaro sii deynta weyn ee soo socota (tusaale ahaan, ka dib muuqaalka laanta 8.2, taageerada laanta 8.1 waa la joojiyay). Laamaha LTS waxa lagula taliyaa fulinta u baahan saadaalinta iyo ku adkaysiga muddada dheer ee dhaqanka aan isbeddelin. Laamaha LTS ayaa la sii deyn doonaa labadii sanaba mar waxaana si caadi ah loo taageeri doonaa 5 sano, taas oo ay kuu dheer tahay inaad heli karto 3 sano oo kale oo taageero ah. Siidaynta LTS ee MySQL 2024 ayaa la filayaa guga 8.4, markaas ka dib laan cusub oo cusub oo 9.0 ah ayaa la samayn doonaa.
Isbeddellada waaweyn ee MySQL 8.2:
- Taageerada lagu daray ee habka aqoonsiga ee ku salaysan qeexida Webauthn (FIDO2), taas oo kuu ogolaanaysa inaad isticmaasho xaqiijinta arrimo badan oo aad xaqiijiso xidhiidhka server-ka MySQL iyada oo aan lahayn furaha sirta ah iyadoo la adeegsanayo FIDO2-karti qalab qalab ama xaqiijinta biometric. Furaha Webauthn ayaa hadda diyaar u ah MySQL Enterprise.
- Plugin server-ka mysql_native_password, kaas oo bixiya xaqiijinta iyadoo la isticmaalayo ereyada sirta ah, ayaa loo raray qaybta ikhtiyaarka ah waana la joojin karaa. Halkii mysql_native_password, waxaa lagu talinayaa in loo beddelo caching_sha2_password plugin, kaas oo isticmaala SHA2 algorithm halkii SHA1 ee xashiishada. Si aad isticmaalayaasha ugu beddesho caching_sha2_password plugin oo aad ugu beddelato erayga sirta ah mid random ah, waxaad isticmaali kartaa amarka: BEDEL USER 'username'@'localhost' AQOONSIGA AH caching_sha2_password BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD
- Miisaska xashiishka ayaa la hagaajiyay si loo dedejiyo fulinta hawlgallada EXCEPT iyo INTERSECT.
- Awoodaha wax-ka-hortagga waa la ballaariyay. DOORASHADA, GELI, BEDEL, CUSBOONAYSIINTA iyo hawl galada tirtirka hadda waxay taageeraan odhaahda "QOOMKA SHARAXI=JSON" si loo dhaliyo wax soo saarka ogaanshaha ee qaabka JSON (tusaale, "SHArax QAABKA=JSON INTO @var select_stmt;").
- Lagu darey "SHAraxa SHEMA" si loo muujiyo ogaanshaha ogaanshaha ee la xidhiidha kaliya qorshe xog gaar ah.
- Waxaa lagu daray "-output-as-version" utility mysqldump si loo abuuro qashin qub ah oo la jaan qaadaya nooc duug ah oo MySQL ah (tusaale, waxaad cayimi kartaa BEFORE_8_2_0 ama BEFORE_8_0_23 si aad u soo celiso ereybixinta sayid/addoon ee siyaasad ahaan khaldanayd ee la sii daayay 8.2.0. 8.0.23 iyo XNUMX).
- Kartida loo isticmaalo sifada magacaaban ee su'aalaha la jaan-qaadaya (odhaah la diyaariyay), oo la hirgaliyay iyada oo la adeegsanayo mysql_stmt_bind_named_param () ee cusub, kaas oo bedelay shaqada mysql_stmt_bind_param (), ayaa lagu daray macmiilka C maktabadda.
- Qaybinta taraafikada SQL ee la fududeeyay ee kutlada server-yada MySQL. Fursadaha ayaa la bixiyaa abaabulka isku xirka server-yada sare ama kuwa aasaasiga ah ee daah-furan codsiyada.
- Mudnaan cusub oo SET_ANY_DEFINER ah ayaa lagu daray, kaas oo siinaya xaqa lagu abuurayo shay leh tibaax DEFINER, iyo sidoo kale ALLOW_NONEXISTENT_DEFINER mudnaanta si loo ilaaliyo walxaha mulkiilaha maqan.
- Go'ay: doorsoomayaasha hore iyo kuwa cusub, "%" iyo "_" waji-xidhaha hawlgallada si loogu oggolaado gelitaanka xogta, ikhtiyaarka "- character-set-client-handshake", doorsoomaha binlog_transaction_dependency_tracking iyo mudnaanta SET_USER_ID.
- Iyada oo qayb ka ah sixitaanka erey-bixinta siyaasadeed ee khaldan ee la xidhiidha ku-noqoshada, tibaaxaha "RESET MASTER", "SHOW MASTER STATUS", "SHOW MASTER LOGS" iyo "PURGE MASTER LOGS" ayaa meesha laga saaray, iyo tibaaxaha "RESET BINARY LOGS AND GTIDS" waa in TUSI XAALADDA LOGGA LABADA AH, "TUS LIISKA BILAASHKA AH" iyo "Nadiifi Logs-Binary".
- Astaamaha hore loo joojiyay waa laga saaray: shaqada WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), doorsoomayaasha_logs_days doorsoomayaasha, "--abort-slave-event-count" iyo "--disconnect-slave-event-count" fursadaha.
- 26 dayacan oo go'an. Laba dayacan oo la xidhiidha isticmaalka xirmada Curl iyo maktabadda OpenSSL ayaa laga faa'iidaysan karaa meel fog.
Source: opennet.ru