TiDB 4.0 ya rarraba sakin DBMS

Akwai rarraba DBMS saki TiDB 4.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.
• Ana iya amfani da maɓalli daban-daban don ajiyar bayanan jiki akan nodes, misali, GoLevelDB da injunan ajiya na gida na BoltDB ko injunan ajiya da aka rarraba na asali. TiKV da TiFlash. TiKV yana adana bayanai a tsarin layi-bi-layi a tsarin maɓalli/ƙimar kuma ya fi dacewa don ayyukan sarrafa ma'amala (OLTP). TiFlash yana adana bayanai ta hanyar tushen ginshiƙi kuma yana ba ku damar cimma babban aiki yayin magance matsalolin nazari (OLAP).
• 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.

A cikin sabon saki:

• Ta hanyar tsoho, ana kunna mai tattara datti da aka rarraba Green GC, wanda zai iya haɓaka saurin tattara datti a cikin manyan gungu kuma inganta kwanciyar hankali;
• Ƙara goyon baya ga manyan ma'amaloli, wanda girmansa ya iyakance kusan girman ƙwaƙwalwar jiki. Ƙimar ma'amala guda ɗaya ta ƙaru daga 100 MB zuwa 10 GB;
• Ƙara goyon baya don BACKUP da umarnin RESTORE don madadin;
• Ƙara ikon saita kulle akan tebur;
• Ƙara tsarin keɓewar ma'amala mai jituwa ta MySQL a matakin karantawa (KARANTA COMMITTED);
• Taimako don LIKE da INA an ƙara maganganu zuwa umarnin "ADMIN SHOW DDL JOBS";
• Ƙara ma'auni na oom-use-tmp-storage, wanda ke ba da damar yin amfani da fayilolin wucin gadi don ɓoye sakamakon matsakaici a cikin yanayin rashin isasshen RAM;
• Ƙara keyword Random don sanya ƙimar bazuwar zuwa halaye;
• Umurnin LOAD DATA yanzu yana da ikon yin amfani da hexadecimal da maganganun binary;
• Ƙara sigogi 15 don sarrafa halayen ingantawa;
• Ƙara kayan aikin don gano aikin tambayoyin SQL. Ƙara bayanan binciken jinkirin da ake samu ta tsarin tebur SLOW_QUERY / CLUSTER_SLOW_QUERY;
• Ƙara goyon baya don ayyuka don aiki tare da jeri;
• An ƙara ikon canza sigogin sanyi da aka karanta daga PD (Direba Wuri, uwar garken sarrafa tari). Ƙara ikon yin amfani da bayanin "SET CONFIG" don canza saitunan nodes na PD/TiKV.
• Ƙara saitin max-uwar garken-haɗin don iyakance iyakar adadin haɗin lokaci guda zuwa uwar garken (4096 ta tsohuwa);
• Ingantaccen aiki a cikin yanayi inda ginshiƙan da aka buƙata ke rufe gabaɗaya ta fihirisa;
• Ƙara inganta haɓakar tambaya dangane da haɗin kai;
• Inganta aikin ayyuka tare da jeri na ƙima;
• Rage nauyin CPU ta hanyar caching sakamakon samun maƙasudi da tace kwafi;
• Ƙara goyon baya don sabon tsarin ajiya na kirtani wanda ke ba ka damar ƙara yawan aikin tebur tare da adadi mai yawa na ginshiƙai;
• Aikin GROUP_CONCAT yanzu yana goyan bayan kalmar "ORDER BY";
• Ƙara ikon cire bayanai daga log ɗin TiFlash ta hanyar SQL;
• Umurnin "RECOVER TABLE" yana aiwatar da goyan baya don dawo da teburin da aka yanke;
• Ƙara teburin tsarin DDLJobs zuwa cikakkun bayanai game da aiwatar da aikin DDL;
• Ƙara ikon yin amfani da umarnin SHOW CONFIG don nuna saitunan PD da TiKV;
• An kunna tsoho coprocessor cache;
• Ana iya sarrafa adadin goroutines a cikin lokacin sake gwadawa yanzu ta amfani da saitin haɗin kai;
• Ƙara ikon nuna yankuna na ɓangaren tebur;
• Ƙara ikon iyakance girman ma'ajiyar wucin gadi zuwa uwar garken tidb;
• Ƙara goyon baya don "saka cikin tbl_name partition(partition_name_list)" da "maye gurbin zuwa tbl_name partition(partition_name_list)" ayyuka;
• A cikin zanta da aka yi amfani da shi don rarrabawa (rarrabuwa), an ƙara tallafi don tacewa a kan “Babu”;
• Don teburin da aka raba, an ƙara tallafi don dubawa, tsaftacewa, da maido da fihirisa.

source: budenet.ru