ProHoster > Blog > internet nhau > MySQL 8.3.0 DBMS iripo

MySQL 8.3.0 DBMS iripo

Oracle yakagadzira bazi idzva reMySQL 8.3 DBMS uye yakaburitsa gadziriso yekuvandudza kuMySQL 8.0.36. MySQL Community Server 8.3.0 inovaka inogadzirirwa ese makuru Linux, FreeBSD, macOS uye Windows kugovera.

MySQL 8.3.0 ndiyo yechitatu kuburitswa kwakaumbwa pasi peiyo nyowani yekuburitsa modhi, iyo inopa kuvepo kwemarudzi maviri emapazi eMySQL - "Innovation" uye "LTS". Iwo Mapazi eInnovation, anosanganisira MySQL 8.1, 8.2 uye 8.3, anokurudzirwa kune avo vanoda kuwana mukana wekushanda kutsva kare. Aya mapazi anobudiswa mwedzi mitatu yega yega uye anotsigirwa chete kusvikira kusunungurwa kukuru kunotevera kwabudiswa (somuenzaniso, mushure mekuonekwa kwebazi re3, kutsigirwa kwebazi re8.3 kwakamiswa). Mapazi eLTS anokurudzirwa kuita izvo zvinoda kufanotaura uye kuchengetedza kwenguva refu kwemaitiro asina kushanduka. Mapazi eLTS anoburitswa makore maviri ega ega uye anotsigirwa zvakajairwa kwemakore mashanu, mukuwedzera kwaunogona kuwana mamwe makore matatu erutsigiro rwakawedzerwa. Kuburitswa kweLTS kweMySQL 8.2 inotarisirwa muchirimo cha5, mushure mezvo bazi idzva reInnovation 3 richaumbwa.

Shanduko huru muMySQL 8.3:

  • 25 kusasimba kwakagadziriswa, iyo imwe (CVE-2023-5363, inobata OpenSSL) inogona kushandiswa kure. Nyaya yakanyanya kuoma ine chekuita nekushandiswa kweKerberos protocol inopihwa hutsinye hwe8.8. Kusanyanya kusimba nekuomarara nhanho 6.5 kunokanganisa optimizer, UDF, DDL, DML, kudzokorora, rombo system, uye encryption maturusi.
  • Papuratifomu yeLinux, tsigiro ye mold linker yawedzerwa. Kuigonesa, sarudzo "-DWITH_LD=mold|lld" inopihwa.
  • Zvinodiwa zveiyo C ++ chiyero chinotsigirwa nemubatanidzwa zvakasimudzwa kubva paC++17 kuenda kuC++20.
  • Tsigiro yekuvaka nemaraibhurari ekunze eBoost C++ yakamiswa - chete maraibhurari akavakirwa-mukati eBoost ndiwo ave kushandiswa pakugadzira MySQL. CMake yakabvisa WITH_BOOST, DOWNLOAD_BOOST uye DOWNLOAD_BOOST_TIMEOUT sarudzo dzekuvaka.
  • Kuvaka rutsigiro rweVisual Studio 2022 kwakamiswa. Iyo shoma inotsigirwa shanduro yeClang toolkit yakasimudzwa kubva kuClang 10 kuenda kuClang 12.
  • MySQL Enterprise Edition yakawedzera tsigiro yekuunganidza telemetry nemametrics nezve server server muOpenTelemetry fomati uye kuendesa data kune network processor inotsigira iyi fomati.
  • Iyo GTID (global transaction identifier) ​​fomati, inoshandiswa panguva yekudzokorora kuona mapoka ekutengeserana, yakawedzerwa. New GTID fomati - "UUID: :NUMBER" (pachinzvimbo pe "UUID:NUMBER"), apo TAG iri tambo yekupopota iyo inokutendera kuti upe mazita akasiyana kune rimwe boka rematanho kuti riite nyore kugadzirisa uye kupatsanura.
  • Takawedzera zvinhu zviviri zvitsva "Deprecated_use_i_s_processlist_count" uye "Deprecated_use_i_s_processlist_last_timestamp" kutsvaga kushandiswa kwetafura yeINFORMATION_SCHEMA.PROCESSLIST.
  • Kuseta iyo AUTHENTICATION_PAM_LOG kusiyanisa kwezvakatipoteredza hakuchakonzeri mapassword kuti aratidzwe mumameseji ekuongorora (ukoshi PAM_LOG_WITH_SECRET_INFO hunodiwa kuti utaure password).
  • Yakawedzera tp_connections tafura ine ruzivo nezve imwe neimwe yekubatanidza mune yeshinda dziva.
  • Yakawedzerwa sisitimu yakasiyana "explain_json_format_version" kuti usarudze iyo JSON format version inoshandiswa mu "EXPLAIN FORMAT=JSON" statements.
  • Mukuchengetedza kweInnoDB, "--innodb" uye "--skip-innodb" sarudzo, idzo dzakadzimwa mukuburitswa kweMySQL 5.6, dzabviswa. Iyo memcached plugin yeInnoDB, iyo yakabviswa muMySQL 8.0.22, yabviswa.
  • Yakabvisa mamwe marongero ane chekuita nekudzokorora uye sarudzo dzemutsara wemirairo dzakadzikiswa mukuburitswa kwakapfuura: "--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". Kugona kushandisa IGNORE_SERVER_IDS sarudzo ine GTID replication mode (gtid_mode=ON) kwabviswa.
  • Tsigiro yemabasa eC API yakamiswa: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), mysql_ssl_set().
  • Izwi rekuti "FLUSH HOSTS", iro rakadzimwa muMySQL 8.0.23, ramiswa.

Source: opennet.ru

Voeg