Oracle e thehile lekala le lecha la MySQL 8.3 DBMS mme e phatlalalitse ntlafatso ea tokiso ho MySQL 8.0.36. Mehaho ea MySQL Community Server 8.3.0 e lokiselitsoe lisebelisoa tsohle tse kholo tsa Linux, FreeBSD, macOS le Windows.
MySQL 8.3.0 ke tokollo ea boraro e entsoeng tlasa mofuta o mocha oa tokollo, e fanang ka boteng ba mefuta e 'meli ea makala a MySQL - "Innovation" le "LTS". Makala a Innovation, a kenyelletsang MySQL 8.1, 8.2 le 8.3, a khothaletsoa ho ba batlang ho fumana ts'ebetso e ncha pejana. Makala ana a hatisoa likhoeling tse ling le tse ling tsa 3 'me a tšehetsoa feela ho fihlela tokollo e latelang e kholo e hatisoa (mohlala, ka mor'a ponahalo ea lekala la 8.3, tšehetso ea lekala la 8.2 e ile ea khaotsa). Makala a LTS a khothaletsoa bakeng sa ts'ebetsong e hlokang ho tseba esale pele le ho phehella ha nako e telele boitšoarong bo sa fetoheng. Makala a LTS a tla lokolloa lilemo tse ling le tse ling tse peli 'me a tla tšehetsoa ka mokhoa o tloaelehileng bakeng sa lilemo tse 5, ho phaella moo o ka fumanang lilemo tse ling tsa 3 tsa tšehetso e atolositsoeng. Ho lebeletsoe ho lokolloa ha LTS ho MySQL 2024 nakong ea selemo sa 8.4, ka mor'a moo ho tla thehoa lekala le lecha la Innovation 9.0.
Liphetoho tse kholo ho MySQL 8.3:
- Bofokoli ba 25 bo lokisitsoe, boo e 'ngoe ea tsona (CVE-2023-5363, e amang OpenSSL) e ka sebelisoang hampe hole. Taba e matla ka ho fetisisa e amanang le tšebeliso ea protocol ea Kerberos e abeloa boemo bo boima ba 8.8. Bofokoli bo fokolang bo boholo ba boemo ba 6.5 bo ama optimizer, UDF, DDL, DML, replication, privilege system, le lisebelisoa tsa encryption.
- Sethaleng sa Linux, tšehetso bakeng sa sehokelo sa hlobo e kentsoe. Ho e nolofalletsa, khetho "-DWITH_LD=mold|lld" e fanoe.
- Litlhoko tsa maemo a C++ a tšehetsoeng ke moqapi a phahamisitsoe ho tloha ho C++17 ho ea ho C++20.
- Ts'ehetso ea ho aha ka lilaebrari tsa Boost C++ tsa kantle e khaotsoe - ke lilaebrari tsa Boost tse hahelletsoeng feela tse sebelisoang ha ho etsoa MySQL. CMake e tlositse likhetho tsa WITH_BOOST, DOWNLOAD_BOOST le DOWNLOAD_BOOST_TIMEOUT.
- Tšehetso ea ho aha bakeng sa Visual Studio 2022 e khaotsoe. Bonyane mofuta o tšehetsoeng oa Clang toolkit o phahamisitsoe ho tloha ho Clang 10 ho ea ho Clang 12.
- Khatiso ea MySQL Enterprise e ekelitse tšehetso bakeng sa ho bokella telemetry ka metrics mabapi le ts'ebetso ea seva ka sebopeho sa OpenTelemetry le ho fetisetsa data ho processor ea marang-rang e tšehetsang sebopeho sena.
- Sebopeho sa GTID (global transaction identifier) se sebelisoang nakong ea ho pheta-pheta ho khetholla lihlopha tsa thekiso, se ekelitsoe. Sebopeho se secha sa GTID ke "UUID: :NUMBER" (ho e-na le "UUID:NUMBER"), moo TAG e leng khoele e sa reroang e u lumellang hore u fane ka mabitso a ikhethileng ho sehlopha se itseng sa transactions bakeng sa ho sebetsa le ho arola habonolo.
- E kentse mefuta e 'meli e mecha "Deprecated_use_i_s_processlist_count" le "Deprecated_use_i_s_processlist_last_timestamp" ho latela tšebeliso ea tafole e tlositsoeng ea INFORMATION_SCHEMA.PROCESSLIST.
- Ho beha mofuta oa AUTHENTICATION_PAM_LOG tikoloho ha ho sa etsa hore li-password li hlahisoe melaetsa ea tlhahlobo (boleng bo hlokehang PAM_LOG_WITH_SECRET_INFO ho bolela phasewete).
- E kentse tafole ea tp_connections e nang le tlhaiso-leseling mabapi le khokahano e 'ngoe le e' ngoe ka har'a letamo la likhoele.
- Ho kentsoe phapano ea sistimi "explain_json_format_version" ho khetha mofuta oa mofuta oa JSON o sebelisoang ho "EXPLAIN FORMAT=JSON".
- Ka polokelong ea InnoDB, likhetho tsa "--innodb" le "--skip-innodb", tse neng li tlositsoe tokollong ea MySQL 5.6, li tlositsoe. Plugin ea memcached ea InnoDB, e neng e tlositsoe ho MySQL 8.0.22, e tlositsoe.
- E tlositse litlhophiso tse ling tse amanang le phetisetso le likhetho tsa mela ea litaelo tse tlositsoeng litokollong tse fetileng: "--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". Bokhoni ba ho sebelisa khetho ea IGNORE_SERVER_IDS ka mokhoa oa ho pheta-pheta oa GTID (gtid_mode=ON) bo tlositsoe.
- Tšehetso ea mesebetsi ea C API e khaotsoe: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
- Polelo ea "FLUSH HOSTS", e neng e tlositsoe ho MySQL 8.0.23, e khaotsoe.
Source: opennet.ru