TiDB 3.0 ya rarraba sakin DBMS

Akwai rarraba DBMS saki TiDB 3.0an haɓaka ƙarƙashin tasirin fasahar Google Spanner и F1. TiDB na cikin nau'in tsarin HTAP (Hybrid Transactional/Analytical Processing) wanda ke da ikon samar da ma'amaloli na lokaci-lokaci (OLTP) da sarrafa tambayoyin nazari. An rubuta aikin a cikin Go da rarraba ta lasisi a ƙarƙashin Apache 2.0.

Siffofin TiDB:

• Taimakawa ga SQL da samar da haɗin gwiwar abokin ciniki wanda ya dace da ka'idar MySQL, wanda ke sauƙaƙa daidaita aikace-aikacen da aka rubuta don MySQL zuwa TiDB, kuma yana ba ku damar amfani da ɗakunan karatu na abokin ciniki gama gari. Baya ga ka'idar MySQL, zaku iya amfani da API na tushen JSON da mai haɗawa don Spark don samun damar DBMS.
• Daga cikin fasalulluka na SQL, fihirisa, tara ayyuka, GROUP BY, oda BY, BAYANIN maganganu, haɗe-haɗe (haguwar HAGU / DAMA JOIN / CROSS JOIN), ra'ayoyi, ayyukan taga da subqueries ana goyan bayan. Dama da aka bayar sun isa don tsara aiki tare da TiDB na irin waɗannan aikace-aikacen yanar gizo kamar PhpMyAdmin, Gog da WordPress;
• Sikeli-fita da juriya: Ma'ajiya da ikon sarrafawa ana iya haɓakawa ta hanyar ƙara sabbin nodes. Ana rarraba bayanai a ko'ina tare da sakewa don ba da damar ayyuka su ci gaba idan nodes ɗin ɗaya ya gaza. Ana sarrafa gazawar ta atomatik.
• Tsarin yana ba da tabbacin daidaito kuma yana kama da babban DBMS guda ɗaya zuwa software na abokin ciniki, duk da cewa ana amfani da bayanai daga nodes da yawa don kammala ma'amala.
• Don adana bayanai ta jiki akan nodes, ana iya amfani da maɓalli daban-daban, misali, injunan ajiya na gida GoLevelDB da BoltDB ko injin ɗinmu da aka rarraba. TiKV.
• Ikon canza tsarin ajiya asynchronously, yana ba ku damar ƙara ginshiƙai da fihirisa akan tashi ba tare da dakatar da sarrafa ayyukan da ke gudana ba.

Main sababbin abubuwa:

• An gudanar da aikin don ƙara yawan aiki. A cikin gwajin Sysbench, sakin 3.0 shine sau 2.1 cikin sauri fiye da reshe na 1.5 yayin aiwatar da zaɓi da sabuntawa, kuma a cikin gwajin TPC-C ta ​​sau 4.5. Ingantawa ya shafi nau'ikan tambayoyi daban-daban, gami da IN, DO da BA EXISTS subqueries, ayyukan haɗin tebur (JOIN), amfani da fihirisa da ƙari mai yawa;
  

• An ƙara sabon injin ajiyar TiFlash wanda ke ba da damar yin aiki mafi girma a cikin magance matsalolin nazari (OLAP) godiya ga ajiyar shafi. TiFlash yana haɓaka ma'ajiyar TiKV da aka bayar a baya, wanda ke adana bayanai masu hikima a cikin maɓalli/ƙimar ƙima kuma ya fi dacewa don ayyukan sarrafa ma'amala (OLTP). TiFlash yana aiki kafada da kafada tare da TiKV kuma ana ci gaba da yin kwafin bayanai zuwa TiKV kamar yadda kafin amfani da ka'idar Raft don tantance yarjejeniya, amma ga kowane rukunin Raft ana ƙirƙira ƙarin kwafi wanda ake amfani da shi a cikin TiFlash. Wannan tsarin yana ba da damar ingantacciyar hanyar raba albarkatu tsakanin ayyukan OLTP da OLAP, kuma yana ba da bayanan ma'amala nan take don tambayoyin nazari;
  

• An aiwatar da aikin tattara shara da aka rarraba, wanda zai iya haɓaka saurin tattara datti a cikin manyan gungu kuma inganta kwanciyar hankali;
• An ƙara aiwatar da aikin gwaji na Role-Based Access Control (RBAC). Hakanan yana yiwuwa a saita haƙƙin samun dama ga ANALYZE, AMFANI, SET GLOBAL da NUNA ayyukan PROCESSLIST;
• Ƙara ikon yin amfani da maganganun SQL don cire ƙananan tambayoyin daga log ɗin;
• An aiwatar da hanyar maido da tebur da aka goge cikin sauri, ba ku damar dawo da bayanan da aka goge ba da gangan ba;
• An haɗa tsarin rajistan ayyukan da aka yi rikodi;
• Ƙara goyon baya don yanayin kulle mara kyau, wanda ke sa sarrafa ma'amala ya fi kama da MySQL;
• Ƙara tallafi don ayyukan taga (ayyukan taga ko ayyukan nazari) masu dacewa da MySQL 8.0. Ayyukan taga suna ba ku damar yin lissafin kowane jere na tambaya ta amfani da wasu layuka. Ba kamar ayyukan tarawa ba, waɗanda ke rugujewar jeri-rukuni na jeri ɗaya, ayyukan taga suna haɗawa bisa abubuwan da ke cikin “taga,” wanda ya haɗa da layuka ɗaya ko fiye daga saitin sakamako. Daga cikin ayyukan taga da aka aiwatar:
  NTILE, LEAD, LAG, PERCENT_RANK, NTH_VALUE, CUME_DIST, FIRST_VALUE, LAST_VALUE, RANK, DENSE_RANK da ROW_NUMBER;

• Ƙara goyon bayan gwaji don ra'ayoyi (VIEW);
• An inganta tsarin rarrabawa, an ƙara ikon rarraba bayanai zuwa sassa dangane da ƙimar ƙima ko hashes;
• An ƙara wani tsari don haɓaka plugins, alal misali, an riga an shirya plugins don yin amfani da jerin gwanon IP ko kiyaye bayanan dubawa;
• An ba da goyan bayan gwaji don aikin "EXPLAIN ANALYZE" don gina tsarin aiwatarwa don tambayar SQL (SQL Plan Management);
• Ƙara umarnin next_row_id don samun ID na jere na gaba;
• An ƙara sabbin ayyukan ginannen JSON_QUOTE, JSON_ARRAY_APPEND, JSON_MERGE_PRESERVE, BENCHMARK , COALESCE da NAME_CONST.

source: budenet.ru