ProHoster > Блог > ozi ịntanetị > MariaDB 10.10 kwụsiri ike

MariaDB 10.10 kwụsiri ike

Ntọhapụ izizi nke ngalaba ọhụrụ nke DBMS MariaDB 10.10 (10.10.2) ka ebipụtala, n'ime nke a na-emepụta alaka MySQL nke na-ejigide ndakọrịta azụ ma bụrụ nke dị iche site na ntinye nke igwe nchekwa ọzọ na ike dị elu. MariaDB Foundation nọọrọ onwe ya na-ahụ maka mmepe MariaDB, na-agbaso usoro mmepe mepere emepe nke na-anọghị na ndị na-ere ahịa n'otu n'otu. A na-enye MariaDB ka ọ bụrụ nnọchi MySQL n'ọtụtụ nkesa Linux (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) ma etinyere ya na nnukwu ọrụ dị ka Wikipedia, Google Cloud SQL na Nimbuzz.

Nkwalite isi na MariaDB 10.10:

  • Agbakwunyere ọrụ RANDOM_BYTES iji nweta usoro n'usoro nke bytes nke nha enyere.
  • Ụdị data INET4 agbakwunyere iji chekwaa adreesị IPv4 na nnọchite 4-byte.
  • Agbanweela ihe ndabara nke okwu "CHANGE MASTER TO", nke na-eji ụdị ngbanwe dabere na GTID (ID Transaction Global), ma ọ bụrụ na ihe nkesa na-akwado ụdị njirimara a. Akwụsịla ntọala "MASTER_USE_GTID=Current_Pos" wee were nhọrọ "MASTER_DEMOTE_TO_SLAVE" dochie ya.
  • Nkwalite nkwalite maka ijikọ arụmọrụ yana ọnụ ọgụgụ tebụl buru ibu, gụnyere ikike iji "eq_ref" iji jikọta tebụl n'usoro ọ bụla.
  • UCA etinyere n'ọrụ (Unicode Collation Algoritm) algọridim, akọwapụtara na nkọwapụta Unicode 14 wee chọpụta nhazi na iwu dakọtara na-eburu n'uche ihe mkpụrụedemede pụtara (dịka ọmụmaatụ, mgbe ị na-ahazi ụkpụrụ dijitalụ, ọnụnọ nke mwepu na ntụpọ n'ihu. A na-eburu n'uche ọnụọgụ na ụdị dị iche iche nke mkpoputa, ma mgbe atụnyere ya anaghị anabata, buru n'uche ihe odide na ọnụnọ nke akara ụda). Arụmọrụ UCA emelitere na ọrụ utf8mb3 na utf8mb4.
  • Ikike itinye adreesị IP na ndepụta Galera Cluster nodes nke ekwenyere ime arịrịọ SST/IST ka emejuputala.
  • Site na ndabara, a na-arụ ọrụ "explicit_defaults_for_timestamp" mode iji weta omume nso na MySQL (mgbe ị na-eme "SHOW CREATE TABLE" ọdịnaya nke DEFAULT blocks maka ụdị timestamp anaghị egosi).
  • Na interface ahịrị ahịrị, a na-eme nhọrọ "--ssl" site na ndabara (ịmepụta njikọ TLS-ezoro ezo na-enyere aka).
  • A rụgharịala nhazi nke okwu nkwalite na Hichapụ ọkwa dị elu.
  • Akwụsịla ọrụ DES_ENCRYPT na DES_DECRYPT yana mgbanwe mgbanwe innodb_prefix_index_cluster_optimization.

isi: opennet.ru

Tinye a comment