Oracle ya ƙirƙiri sabon reshe na tsarin sarrafa bayanai na MySQL 8.2 kuma ya buga sabuntawa na gyara don MySQL 8.0.35 da 5.7.44. An shirya gina MySQL Community Server 8.2.0 don duk manyan rarrabawa. Linux, FreeBSD, macOS и 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:
- An ƙara tallafi don tsarin tabbatarwa bisa ga ƙayyadaddun Webauthn (FIDO2), wanda ke ba da damar tabbatar da abubuwa da yawa da tabbatar da haɗin kai zuwa uwar garken MySQL ba tare da kalmar sirri ba, ta amfani da alamun kayan aiki masu aiki da FIDO2 ko kuma tabbatar da yanayin halitta. A halin yanzu akwai plugin tare da tallafin Webauthn kawai ga MySQL Enterprise.
- 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
