Oracle ya kafa sabon reshe na MySQL 8.3 DBMS kuma ya buga sabuntawa mai gyara zuwa MySQL 8.0.36. MySQL Community Server 8.3.0 yana gina ginin don duk manyan Linux, FreeBSD, macOS da rarrabawar Windows.
MySQL 8.3.0 shine saki na uku da aka kafa a ƙarƙashin sabon tsarin 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, 8.2 da 8.3, 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.3, an daina goyan bayan reshen 8.2). 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.3:
- An gyara lahani guda 25, wanda ɗayan (CVE-2023-5363, yana shafar OpenSSL) za'a iya amfani da su daga nesa. Batun mafi tsananin da ke da alaƙa da amfani da ka'idar Kerberos an sanya shi matakin tsanani na 8.8. Ƙananan lahani mai tsanani tare da matsananciyar matakin 6.5 yana rinjayar ingantawa, UDF, DDL, DML, kwafi, tsarin gata, da kayan aikin ɓoyewa.
- A kan dandali na Linux, an ƙara goyan baya ga mahaɗin mold. Don kunna shi, an bayar da zaɓin "-DWITH_LD=mold|ld"
- Abubuwan buƙatun ma'aunin C++ wanda mai tarawa ke goyan bayan an ɗaga su daga C++17 zuwa C++20.
- An dakatar da goyan bayan gini tare da ɗakunan karatu na Boost C++ na waje - ginannen ɗakunan karatu na Boost ne kawai ake amfani da su lokacin tattara MySQL. CMake ya cire zaɓuɓɓukan ginin WITH_BOOST, DOWNLOAD_BOOST da DOWNLOAD_BOOST_TIMEOUT.
- Gina goyan bayan Kayayyakin Kayayyakin Kayayyakin 2022 an daina. An ɗaga mafi ƙarancin tallafin kayan aikin Clang daga Clang 10 zuwa Clang 12.
- Ɗabi'ar Kasuwancin MySQL ta ƙara tallafi don tattara na'urorin sadarwa tare da awo game da aikin uwar garken a cikin tsarin OpenTelemetry da canja wurin bayanai zuwa na'ura mai sarrafa cibiyar sadarwa wanda ke goyan bayan wannan tsari.
- An faɗaɗa tsarin GTID (mai gano ma'amala ta duniya), wanda aka yi amfani da shi yayin kwafi don gano ƙungiyoyin ma'amala. Sabon tsarin GTID shine “UUID: : NUMBER" (maimakon "UUID: NUMBER"), inda TAG wata igiya ce ta sabani wacce ke ba ka damar sanya sunaye na musamman ga takamaiman rukunin ma'amaloli don sauƙin sarrafawa da tantancewa.
- An ƙara sabbin masu canji biyu "Deprecated_use_i_s_processlist_count" da "Deprecated_use_i_s_processlist_last_timestamp" don bin diddigin amfani da tebur INFORMATION_SCHEMA.PROCESSLIST.
- Saita canjin yanayi na AUTHENTICATION_PAM_LOG baya haifar da bayyanar da kalmomin shiga cikin saƙon bincike (ana buƙatar ƙimar PAM_LOG_WITH_SECRET_INFO don ambaci kalmar sirri).
- Ƙara tp_connections tebur tare da bayani game da kowace haɗi a cikin tafkin zaren.
- Ƙara canjin tsarin "explain_json_format_version" don zaɓar sigar JSON da aka yi amfani da ita a cikin maganganun "EXPLAIN FORMAT=JSON".
- A cikin ajiyar InnoDB, an cire zaɓuɓɓukan "--innodb" da "--skip-innodb", waɗanda aka yanke a cikin sakin MySQL 5.6. An cire kayan aikin memcached na InnoDB, wanda aka soke a cikin MySQL 8.0.22.
- An cire wasu saitunan masu alaƙa da kwafi da zaɓuɓɓukan layin umarni waɗanda aka soke a cikin abubuwan da suka gabata: "--slave-rows-search-algorithms", "-relay-log-info-file", "-relay-log-info-repository" ", "-master-info-file", "-master-info-repository", "log_bin_use_v1_events", "transaction_write_set_extraction", "group_replication_ip_whitelist", "group_replication_primary_member". An cire ikon yin amfani da zaɓi na IGNORE_SERVER_IDS tare da yanayin maimaita GTID (gtid_mode=ON).
- An daina goyan bayan ayyukan API na C: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh (), mysql_reload (), mysql_shutdown (), mysql_ssl_set().
- Kalmomin "FLUSH HOSTS", wanda aka soke a cikin MySQL 8.0.23, an daina.
source: budenet.ru