I-Oracle yakhe igatsha elisha le-MySQL 8.3 DBMS futhi yashicilela isibuyekezo sokulungisa ku-MySQL 8.0.36. Ukwakhiwa kwe-MySQL Community Server 8.3.0 kulungiselelwe zonke i-Linux, i-FreeBSD, i-macOS ne-Windows ukusatshalaliswa okukhulu.
I-MySQL 8.3.0 iwukukhululwa kwesithathu okwakhiwa ngaphansi kwemodeli entsha yokukhishwa, ehlinzeka ngokuba khona kwezinhlobo ezimbili zamagatsha e-MySQL - “I-Innovation” kanye ne-“LTS”. Amagatsha e-Innovation, ahlanganisa i-MySQL 8.1, 8.2 kanye ne-8.3, ayanconywa kulabo abafuna ukufinyelela ekusebenzeni okusha kusenesikhathi. Lawa magatsha ashicilelwa njalo ezinyangeni ezi-3 futhi asekelwa kuphela kuze kushicilelwe ukukhululwa okukhulu okulandelayo (isibonelo, ngemva kokuvela kwegatsha le-8.3, ukusekelwa kwegatsha le-8.2 kwanqanyulwa). Amagatsha e-LTS anconyelwe ukusetshenziswa okudinga ukubikezelwa kanye nokulondolozwa kwesikhathi eside kokuziphatha okungashintshiwe. Amagatsha e-LTS azokhishwa njalo eminyakeni emibili futhi azosekelwa ngokujwayelekile iminyaka emi-5, ngaphezu kwalokho ongathola eminye iminyaka emi-3 yokusekelwa okunwetshiwe. Ukukhishwa kwe-LTS kwe-MySQL 2024 kulindeleke entwasahlobo ka-8.4, ngemva kwalokho kuzokwakhiwa igatsha elisha le-Innovation 9.0.
Izinguquko ezinkulu ku-MySQL 8.3:
- Ubungozi obungu-25 bulungisiwe, obunye (CVE-2023-5363, obuthinta i-OpenSSL) obungaxhashazwa ukude. Inkinga enzima kakhulu ehlobene nokusetshenziswa kwephrothokholi ye-Kerberos inikezwe ileveli yokuqina engu-8.8. Ubungozi obuncane kakhulu obuneleveli yobukhulu 6.5 buthinta isilungiseleli, i-UDF, i-DDL, i-DML, ukuphindaphinda, isistimu yelungelo, namathuluzi wokubethela.
- Kuplathifomu ye-Linux, usekelo lwesixhumanisi sesikhunta sengeziwe. Ukuze uyivule, inketho ethi “-DWITH_LD=mold|lld” inikeziwe.
- Izidingo zezinga le-C++ elisekelwa umdidiyeli zinyusiwe zisuka ku-C++17 zaya ku-C++20.
- Ukusekela ukwakha ngemitapo yolwazi ye-Boost C++ yangaphandle kunqanyuliwe - imitapo yolwazi ye-Boost eyakhelwe ngaphakathi kuphela esetshenziswayo lapho kuhlanganiswa i-MySQL. I-CMake isuse izinketho zokwakha okuthi WITH_BOOST, DOWNLOAD_BOOST kanye ne-DOWNLOAD_BOOST_TIMEOUT.
- Usekelo lokwakha lwe-Visual Studio 2022 lunqanyuliwe. Inguqulo encane esekelwayo yekhithi yamathuluzi ye-Clang iphakanyiswe isuka ku-Clang 10 yaya ku-Clang 12.
- I-MySQL Enterprise Edition yengeze usekelo lokuqoqa i-telemetry ngamamethrikhi mayelana nokusebenza kweseva ngefomethi ye-OpenTelemetry nokudlulisa idatha kumcubunguli wenethiwekhi esekela le fomethi.
- Ifomethi ye-GTID (isikhombi sokwenziwe emhlabeni wonke), esetshenziswa ngesikhathi sokuphindaphinda ukuhlonza amaqembu okwenziwayo, inwetshiwe. Ifomethi entsha ye-GTID - "UUID: :NUMBER" (esikhundleni sokuthi "UUID:NUMBER"), lapho i-TAG iyiyunithi yezinhlamvu engafanele ekuvumela ukuthi unikeze amagama ahlukile eqenjini elithile lemisebenzi ukuze kube lula ukucutshungulwa nokuhlukaniswa.
- Kwengezwe okuhlukile okusha okubili "Deprecated_use_i_s_processlist_count" kanye "Deprecated_use_i_s_processlist_last_timestamp" ukuze kulandelelwe ukusetshenziswa kwethebula elihoxisiwe elithi INFORMATION_SCHEMA.PROCESSLIST.
- Ukusetha okuguquguqukayo kwemvelo kwe-AUTHENTICATION_PAM_LOG akusabangeli iphasiwedi ukuthi iboniswe emilayezweni yokuxilonga (inani elingu-PAM_LOG_WITH_SECRET_INFO liyadingeka ukuze kukhulunywe iphasiwedi).
- Kwengezwe ithebula le-tp_connections elinolwazi mayelana nokuxhumana ngakunye ku-pool pool.
- Kwengezwe okuguquguqukayo kwesistimu "explain_json_format_version" ukuze ukhethe inguqulo yefomethi ye-JSON esetshenziswe kuzitatimende ze-"CHAZA FORMAT=JSON".
- Esilondolozini se-InnoDB, izinketho ze-"--innodb" kanye "--skip-innodb", ezehlisiwe ekukhishweni kwe-MySQL 5.6, zisusiwe. I-plugin ye-memcached ye-InnoDB, eye yahoxiswa ku-MySQL 8.0.22, ikhishiwe.
- Kususwe ezinye izilungiselelo ezihlobene nokuphindaphinda kanye nezinketho zomugqa womyalo ezehlisiwe ekukhishweni kwangaphambilini: "--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". Amandla okusebenzisa inketho ye-IGNORE_SERVER_IDS enemodi yokuphindaphinda ye-GTID (gtid_mode=ON) asusiwe.
- Ukusekelwa kwemisebenzi ye-C API kunqanyuliwe: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
- Isisho esithi "FLUSH HOSTS", esahoxiswa ku-MySQL 8.0.23, sinqanyuliwe.
Source: opennet.ru