Oracle ya kafa sabon reshe na MySQL 8.2 DBMS kuma ya buga sabuntawar gyara zuwa MySQL 8.0.35 da 5.7.44. MySQL Community Server 8.2.0 yana gina ginin don duk manyan Linux, FreeBSD, macOS da rarrabawar Windows.
MySQL 8.2.0 shine sakin na biyu da aka kafa a ƙarƙashin sabon ƙirar sakin, wanda ke ba da kasancewar rassan MySQL iri biyu - “Innovation” da “LTS”. An ba da shawarar rassan Innovation, waɗanda suka haɗa da MySQL 8.1 da 8.2, ga waɗanda ke son samun damar yin amfani da sabbin ayyuka a baya. Ana buga waɗannan rassan kowane watanni 3 kuma ana tallafawa kawai har sai an buga babban saki na gaba (misali, bayan bayyanar reshe na 8.2, an daina goyan bayan reshen 8.1). An ba da shawarar rassan LTS don aiwatarwa waɗanda ke buƙatar tsinkaya da tsayin daka na halayen da ba su canzawa. Za a fitar da rassan LTS duk bayan shekara biyu kuma za a tallafa musu kullum har tsawon shekaru 5, ban da haka za ku iya samun ƙarin shekaru 3 na ƙarin tallafi. Ana sa ran sakin LTS na MySQL 2024 a cikin bazara na 8.4, bayan haka za a kafa sabon reshen Innovation 9.0.
Babban canje-canje a cikin MySQL 8.2:
- Ƙara goyon baya don tsarin tabbatarwa dangane da ƙayyadaddun Webauthn (FIDO2), yana ba ku damar amfani da ingantattun abubuwa masu yawa da kuma tabbatar da haɗi zuwa uwar garken MySQL ba tare da kalmomin shiga ta amfani da alamun kayan aiki na FIDO2 ba ko kuma tabbatarwa na biometric. A halin yanzu plugin ɗin Webauthn yana samuwa kawai don Kasuwancin MySQL.
- plugin ɗin mysql_native_password uwar garken, wanda ke ba da tabbaci ta amfani da kalmomin shiga, an ƙaura zuwa nau'in zaɓi kuma ana iya kashe shi. Maimakon mysql_native_password, ana ba da shawarar canzawa zuwa caching_sha2_password plugin, wanda ke amfani da SHA2 algorithm maimakon SHA1 don hashing. Don canza masu amfani zuwa caching_sha2_password plugin kuma musanya kalmar sirri tare da bazuwar ɗaya, zaku iya amfani da umarnin: ALTER USER 'username'@'localhost' GANO TARE DA caching_sha2_password BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD.
- An inganta tebur ɗin Hash don hanzarta aiwatar da ayyukan EXCEPT da INTERSECT.
- An faɗaɗa damar gyara kuskure. SELECT, INSERT, MUSA, UPDATE da DELETE ayyuka yanzu suna goyan bayan furcin "EXPLAIN FORMAT=JSON" don samar da fitarwar bincike a tsarin JSON (misali, "EXPLAIN FORMAT=JSON INTO @var select_stmt;").
- Ƙara kalmar "BAYYANA DON SCHEMA" don nuna alamun bincike mai alaƙa da takamaiman tsarin bayanai kawai.
- An ƙara zaɓin "--output-as-version" zuwa mai amfani na mysqldump don ƙirƙirar juji masu dacewa da takamaiman tsohuwar sigar MySQL (misali, zaku iya saka BEFORE_8_2_0 ko BEFORE_8_0_23 don dawo da kalmar master/bayi da ba daidai ba a siyasance da aka yanke a cikin sakin 8.2.0. 8.0.23 da XNUMX).
- Ikon yin amfani da halayen suna cikin tambayoyin da aka tsara (maganganun da aka shirya), aiwatar da su ta amfani da sabon aikin mysql_stmt_bind_named_param(), wanda ya maye gurbin aikin mysql_stmt_bind_param (), an ƙara zuwa ɗakin karatu na abokin ciniki C.
- Sauƙaƙan rarraba zirga-zirgar SQL a cikin gungun sabar MySQL. Ana ba da dama don tsara haɗin kai zuwa sabar na biyu ko na farko waɗanda ke bayyane ga aikace-aikace.
- An ƙara sabon gata SET_ANY_DEFINER, wanda ke ba da damar ƙirƙirar abubuwa tare da DEFINER, da kuma damar ALLOW_NONEXISTENT_DEFINER don kare abubuwa tare da mai shi ba ya nan.
- Deprecated: tsofaffi da sababbin masu canji, "%" da "_" masks a cikin ayyuka don ba da damar shiga bayanan bayanai, zaɓin "-character-set-client-handshake" zaɓi, binlog_transaction_dependency_tracking m da SET_USER_ID gata.
- A wani bangare na gyara kalmomin da ba daidai ba a siyasance da ke da alaka da maimaitawa, an soke kalaman “SAKIWA MASTER”, “NUNA MATSAYIN MASTER STATUS”, “SHOW MASTER LOGS” da “PURGE MASTER LOGS”, sannan kuma ya kamata a yi amfani da kalmomin “SAKI DAYA DA GTIDS”. a yi amfani da shi maimakon.NUNA MATSAYIN LOGCIN BINARY, NUNA BINARY LOGS, da kuma “SALLAR BINARY LOGS”.
- An cire abubuwan da aka yanke a baya: aikin WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), madaidaicin kwanakin_logs_logs, zaɓin "--abort-slave-event-count" da "--disconnect-slave-event-count".
- 26 vulnerabilities gyarawa. Lalacewar biyu masu alaƙa da amfani da kunshin Curl da ɗakin karatu na OpenSSL ana iya amfani da su daga nesa.
source: budenet.ru