ProHoster > Blog > internet nhau > MySQL 8.2.0 DBMS iripo

MySQL 8.2.0 DBMS iripo

Oracle yakagadzira bazi idzva reMySQL 8.2 DBMS uye yakaburitsa zvigadziriso zveMySQL 8.0.35 uye 5.7.44. MySQL Community Server 8.2.0 inovaka inogadzirirwa ese makuru Linux, FreeBSD, macOS uye Windows kugovera.

MySQL 8.2.0 ndiyo yechipiri kuburitswa yakaumbwa pasi peiyo nyowani yekuburitsa modhi, iyo inopa kuvepo kwemhando mbiri dzemapazi eMySQL - "Innovation" uye "LTS". Iwo matavi eInnovation, ayo anosanganisira MySQL 8.1 uye 8.2, anokurudzirwa kune avo vanoda kuwana mukana wekushanda kutsva kare. Aya matavi anoburitswa mwedzi mitatu yega yega uye anotsigirwa chete kusvikira kuburitswa kukuru kunotevera kwaburitswa (semuenzaniso, mushure mekuonekwa kwebazi re3, kutsigirwa kwebazi re8.2 kwakamiswa). Mapazi eLTS anokurudzirwa kuita izvo zvinoda kufanotaura uye kuenderera kwenguva refu kwemaitiro asina kushanduka. Mapazi eLTS anoburitswa makore maviri ega ega uye anotsigirwa zvakajairwa kwemakore mashanu, mukuwedzera kwaunogona kuwana mamwe makore matatu ekutsigirwa kwakawedzerwa. Kuburitswa kweLTS kweMySQL 8.1 inotarisirwa muchirimo cha5, mushure mezvo bazi idzva reInnovation 3 richaumbwa.

Shanduko huru muMySQL 8.2:

  • Rutsigiro rwakawedzerwa rwenzira yekuvimbisa yakavakirwa pane zvakatsanangurwa zveWebauthn (FIDO2), izvo zvinobvumira kusimbiswa kwezvinhu zvakawanda uye kusimbiswa kwekubatana ku sevha MySQL haina password, uchishandisa ma hardware tokens eFIDO2-enabled kana biometric authentication. Plugin ine rutsigiro rweWebauthn parizvino inowanikwa chete kuMySQL Enterprise.
  • Iyo mysql_native_password server plugin, iyo inopa huchokwadi uchishandisa mapassword, yakaendeswa kune inosarudzwa chikamu uye inogona kuremara. Panzvimbo pe mysql_native_password, zvinokurudzirwa kuti uchinje kune caching_sha2_password plugin, iyo inoshandisa iyo SHA2 algorithm panzvimbo yeSHA1 yehashing. Kuti uchinje vashandisi kune caching_sha2_password plugin uye kutsiva pasiwedhi neisina kurongeka, unogona kushandisa rairo: ALTER USER 'username'@'localhost' AKAZIVA NECaching_sha2_password NERAndom PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD_2 PASSWORD_XNUMX;
  • Matafura eHash akagadziridzwa kuti akurumidze kuitwa EXCEPT uye INTERSECT mashandiro.
  • Debugging kugona kwakawedzerwa. SARUDZA, INSERT, REPLACE, UPDATE uye DELETE mashandiro ava kutsigira kutaura kwekuti "TSANANGURA FORMAT=JSON" kuti ubudise diagnostic kubuda mufomati yeJSON (semuenzaniso, " TSANANGURA FORMAT=JSON INTO @var select_stmt;").
  • Yakawedzerwa "TSANANGURA YESCHEMA" kutaura kuratidza diagnostics inongoenderana neiyo chaiyo data schema.
  • Yakawedzerwa "-output-as-version" sarudzo kune mysqldump utility yekugadzira marasira anoenderana neyakare vhezheni yeMySQL (semuenzaniso, unogona kutsanangura BEFORE_8_2_0 kana BEFORE_8_0_23 kudzosa tenzi / muranda izwi risiri iro rezvematongerwo enyika rakadzikiswa mukuburitswa 8.2.0. 8.0.23 uye XNUMX).
  • Iko kugona kushandisa hunhu hwemazita mumibvunzo yakamisikidzwa (yakagadzirirwa zvirevo), inoshandiswa uchishandisa iyo nyowani mysql_stmt_bind_named_param () basa, iro rakatsiva mysql_stmt_bind_param () basa, rakawedzerwa kune mutengi C raibhurari.
  • Kugoverwa kweSQL traffic musumbu reMySQL maseva kwakave nyore. Mikana inopihwa yekuronga kubatanidza kune yechipiri kana yekutanga maseva ayo ari pachena kune maapplication.
  • Mukana mutsva weSET_ANY_DEFINER wawedzerwa, izvo zvinopa kodzero yekugadzira zvinhu zvine DEFINER matauriro, pamwe neiyo ALLOW_NONEXISTENT_DEFINER rombo rekuchengetedza zvinhu nemuridzi asipo.
  • Yakaregwa: ekare uye matsva akasiyana, "%" uye "_" masks ari mukushanda kuti ape mukana kune dhatabhesi, "-character-set-client-handshake" sarudzo, binlog_transaction_dependency_tracking musiyano uye SET_USER_ID mukana.
  • Sechikamu chekugadzirisa chirevo chezvematongerwo enyika chisiri icho chine chekuita nekudzokorodza, mazwi ekuti "RESET MASTER", "SHOW MASTER STATUS", "SHOW MASTER LOGS" uye "PURGE MASTER LOGS" akaregwa, uye mazwi ekuti "RESET BINARY LOGS AND GTIDS" anofanira. RATIDZA BINARY LOG STATUS ", "RATIDZA BINARY LOGS" uye "PURGE BINARY LOGS".
  • Zvinhu zvakamborambwa zvakabviswa: WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() basa, expire_logs_days variable, "--abort-slave-event-count" uye "--disconnect-slave-event-count" sarudzo.
  • 26 kusasimba kwakagadziriswa. Kusagadzikana kuviri kwakabatana nekushandiswa kweiyo Curl package uye OpenSSL raibhurari inogona kushandiswa kure.

Source: opennet.ru

Voeg