ProHoster > Блог > wararka internetka > MariaDB 10.4 siideynta xasilloon

MariaDB 10.4 siideynta xasilloon

Ka dib hal sano oo horumarineed iyo lix horudhac ah diyaariyay Siideynta ugu horreysa ee xasilloon ee laanta cusub ee DBMS MariaDB 10.4, kaas oo laan ka mid ah MySQL lagu samaynayo taas oo ilaalinaysa waafaqid danbe iyo kala duwan isku dhafka matoorada kaydinta dheeraadka ah iyo awoodaha horumarsan. Taageerada laanta cusub waxaa la bixin doonaa 5 sano, ilaa Juun 2024.

Horumarinta MariaDB waxaa kormeera MariaDB Foundation oo madax-banaan, ka dib habsocod horumarineed oo dhammaystiran oo furan oo ka madaxbannaan iibiyeyaasha gaarka ah. MariaDB waxaa la bixiyaa halkii MySQL laga heli lahaa qaybo badan oo Linux ah (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) waxaana lagu fuliyay mashaariic waaweyn sida Wikipedia, Google Cloud SQL и nimbuzz.

Furaha horumar MariaDB 10.4:

  • Waxa ku jira tignoolajiyada ku celcelinta sayidyada badan ee isku xidhan Galera 4, kaas oo u ogolaanaya topology multi-master-firfircoon oo firfircoon oo la akhriyi karo laguna qori karo noode kasta. Ku celcelinta isku midka ah, dhammaan qanjidhada ayaa had iyo jeer ka kooban xog cusub, i.e. ma jiro wax kala beddelasho lumay oo dammaanad qaadaya, tan iyo markii macaamilku dhaco kaliya ka dib marka xogta lagu faafiyo dhammaan qanjidhada. Ku celcelinta waxaa lagu sameeyaa qaab isku mid ah, heerka safka, wareejinta macluumaadka kaliya ee ku saabsan isbeddelada;
  • Nidaamyada Unix-ka u eg, plugin-ka xaqiijinta ayaa si toos ah u shaqeeya unix_socket, kaas oo kuu ogolaanaya inaad isticmaasho xisaabaadka ku jira nidaamka si aad ugu xirto DBMS adoo isticmaalaya godad unix ah;
  • Lagu daray fursad u qoondaynta inta uu nool yahay erayga sirta ah ee isticmaalaha, ka dib erayga sirta ah waxaa lagu calaamadiyaa inuu dhacay. Si loo dejiyo taariikhda uu dhacayo erayga sirta ah ee hawlgallada “CREATE USER” iyo “BALTER USER”, odhaahda “PASSWORD EXPIRE INTERVAL N DAY” ayaa lagu daray;
  • Taageero lagu daray xannibid Isticmaalayaasha DBMS iyada oo loo marayo odhaahda "XISAABTA LOCK" ee "CREATE USER" iyo "BEDEL USER" hawlgallada;
  • Fulinta hubinta mudnaanta ee isku xidhka tiro badan oo isticmaalayaasha ah ama xeerarka gelitaanka ayaa si weyn loo dardargeliyey;
  • la joojiyay isticmaalaya mysql.user iyo mysql.host miisaska. Shaxda mysql.global_priv waxaa hadda loo isticmaalaa in lagu kaydiyo xisaabaadka iyo mudnaanta caalamiga ah;
  • В plugins xaqiijin ayaa lagu daray taageerada ereyga "SET PASSWORD";
  • Lagu daray awoodda loo isticmaalo in ka badan hal plugin sugida akoon kasta, taas oo faa'iido u yeelan karta isticmaalayaasha si tartiib tartiib ah ugu guuraya plugin ed25519. Markaad abuureyso isticmaale root @ localhost oo leh qoraalka mysql_install_db, laba sugitaan oo xaqiijin ah ayaa hadda karti u leh sida caadiga ah - unix_socket iyo mysql_native_password;
  • Kaydinta InnoDB waxay fulisaa hawlgalka tiirarka isla markaaba loo tirtiro (BEDDELKA SHAXDA ... DEJI COLUMN ... ALGORITHM=DHAQAN) oo beddela nidaamka tiirarka. Baaxadda diiwaanka bilowga ah ee hawlgallada dib-u-celinta (log redo) waa la dhimay. Taageerada wareejinta furaha ee lagu daray innodb_encrypt_log. Hirgaliyay algorithm ee hubinta jeegaga
    innodb_checksum_algorithm=full_crc32. Waxay bixisaa balaadhin degdeg ah nooca VARCHAR oo beddela qoraalka codaynta ee tiirarka aan tusinneen;

  • Hagaajinta hagaajinta Waxaa lagu daray awoodda lagu raadinayo hagaajinta, oo lagu kartiyeeyay doorsoomiyaha nidaamka optimizer-raad. Asal ahaan waxaa ka mid ahaa ilaalinta tirakoobka ka madax banaan matoorada kaydinta.
    Waxa jira laba nooc oo cusub oo loo isticmaalo_stat_tables - COMPLEMENTARY_FOR_QUERIES iyo PREFERABLY_FOR_QUERIES. qaabaynta_join_buffer_size waa la dajiyay. Ku cusub oo lagu daray calanka shaandhaynta_rovid iyo xaalad_ riixid_ka-soo-noqoshada;

  • Taageerada miisaska nidaamka qaabaysan, kuwaas oo aan kaydin oo keliya jeex xogta hadda jirta, laakiin sidoo kale kaydisa macluumaadka ku saabsan dhammaan isbeddellada hore loo sameeyay, ayaa la ballaariyay. hawlgallada oo leh waqtiyo kala duwan;
  • Lagu daray amar cusub oo "FLUSH SSL" si dib loogu raro shahaadooyinka SSL iyada oo aan dib loo bilaabin serfarka;
  • Hawlgalladii "INSTALL PLUGIN", "UNINSTALL PLUGIN" iyo "UNINSTALL SONAME" waxay ku biiriyeen taageerada tibaaxaha " HADDII AAN JIRAAN" iyo " HADDII AY JIRTO ";
  • Miisaska nidaamka u adkaysiga shilalka ayaa la soo jeediyay, si loo kaydiyo matoorka loo isticmaalo Aria;
  • U gudubka isticmaalka heerka C++11 ayaa la sameeyay (hawlaha atomiga ayaa ku lug leh);
  • Waxqabadka guryaha isku xidhka ee Unicode si weyn ayaa loo hagaajiyay, taas oo kuu ogolaanaysa inaad qeexdo xeerarka kala-soocidda iyo hababka isku midka ah ee ku salaysan macnaha jilayaasha;
  • Lagu daray plugin si aad u qeexdo noocyada beertaada;
  • Taageero lagu daray daaqadaha Hawlaha UDF (Shaqooyinka Isticmaalaha-Qeexay);
  • Hawlgalka "TABKA FLUSH". la fuliyay Habka "KABAYNTA LOCK", kaas oo la isticmaali karo marka la kaydinayo faylasha xogta;
  • Lagu daray Taageerada amarrada server-ka ee ka bilaabma mariadb, beddelka amarada ka bilaabma "mysql" (tusaale, mariadump halkii mysqldump).

Source: opennet.ru

Add a comment