I-TiDB 4.0 isasaze ukukhutshwa kwe-DBMS

Iyafumaneka kusasazwa ukukhutshwa kweDBMS I-TiDB 4.0iphuhliswe phantsi kweempembelelo zetekhnoloji zikaGoogle Spanner и F1. I-TiDB yeyodidi lwe-HTAP exutyiweyo (iHybrid Transactional/Analytical Processing) iinkqubo ezikwaziyo ukubonelela ngeentengiselwano zexesha langempela (OLTP) kunye nemibuzo yohlalutyo. Iprojekthi ibhalwe kwiGo kunye isasazwa ngu ilayisenisi phantsi kweApache 2.0.

Iimpawu zeTiDB:

• Inkxaso ye-SQL kunye nokubonelela nge-interface yomxhasi ehambelana ne-MySQL protocol, eyenza kube lula ukulungelelanisa izicelo ezikhoyo ezibhaliweyo kwi-MySQL kwi-TiDB, kwaye ikuvumela ukuba usebenzise amathala eencwadi abaxhasi abaqhelekileyo. Ukongeza kwiprotocol ye-MySQL, ungasebenzisa i-API esekwe kwi-JSON kunye nekhonkco ye-Spark ukufikelela kwi-DBMS.
• Kweempawu zeSQL, izalathiso, imisebenzi edityanisiweyo, IQELA NGOKU, UKUYALELA NGOKU, UKUZENZA OKUHLUKENEYO, ukudibanisa (UKU JOYINA NGENXELE / ELUNGELO JOIN / UMNQAPHISO JOIN), iimboniselo, imisebenzi yewindow kunye ne-subqueries zixhaswa. Amathuba anikezelweyo anele ukucwangcisa umsebenzi kunye ne-TiDB yezicelo zewebhu ezifana nePhpMyAdmin, IiGogs kunye neWordPress;
• Ukulinganisa kunye nokuqina: Ugcino kunye namandla okusebenza anokunyuswa ngokulula ngokongeza iindawo ezintsha. Idatha isasazwa kuzo zonke iindawo kunye nokuphindaphinda ukuvumela imisebenzi ukuba iqhubeke ukuba iindawo zomntu ngamnye ziyasilela. Iintsilelo zisingathwa ngokuzenzekelayo.
• Inkqubo iqinisekisa ukuhambelana kwaye ibukeka njenge-DBMS enye enkulu kwi-software yomxhasi, nangona ukuba, eqinisweni, idatha evela kwiinode ezininzi ibandakanyeka ukugqiba ukuthengiselana.
• Ii-backends ezahlukeneyo zingasetyenziselwa ukugcinwa kwedatha ebonakalayo kwiindawo, umzekelo, i-GoLevelDB kunye ne-BoltDB iinjini zokugcina zendawo okanye iinjini zokugcina ezisasazwayo zendalo. I-TiKV kunye neTiFlash. I-TiKV igcina idatha kwifomati yomgca-ngomgca kwifomathi yesitshixo/yexabiso kwaye ilunge ngakumbi kwimisebenzi yokwenziwa kwentengiselwano (OLTP). I-TiFlash igcina idatha ngendlela esekelwe kwikholamu kwaye ikuvumela ukuba ufezekise ukusebenza okuphezulu xa usombulula iingxaki zohlalutyo (OLAP).
• Ikhono lokutshintsha i-asynchronously isikimu sokugcina, ukuvumela ukuba ungeze iikholamu kunye nezalathisi kwi-fly ngaphandle kokuyeka ukuqhutyelwa kwemisebenzi eqhubekayo.

Kukhupho olutsha:

• Ngokungagqibekanga, umqokeleli wenkunkuma osasazwayo iGreen GC inikwe amandla, enokunyusa kakhulu isantya sokuqokelela inkunkuma kumaqela amakhulu kunye nokuphucula ukuzinza;
• Inkxaso eyongeziweyo yeentengiselwano ezinkulu, ubungakanani bayo buthintelwe phantse ngobukhulu bememori yomzimba. Umda wokuthengiselana omnye unyuswe ukusuka kwi-100 MB ukuya kwi-10 GB;
• Inkxaso eyongeziweyo ye-IBACKUP kunye ne-RESTORE imiyalelo yogcino;
• Ukongeza ukukwazi ukuseta isitshixo kwiitafile;
• Ukongezwa kwe-MySQL-compatible transaction mechanism kwizinga lokufunda (FUNDA UZINIKELE);
• Inkxaso ka-LIKE kunye NAPHO amabinzana afakwe kwi "ADMIN SHOW DDL JOBS" umyalelo;
• Yongeza iparameter ye-oom-use-tmp-storage, evumela ukusebenzisa iifayile zesikhashana kwi-caching iziphumo eziphakathi kwiimeko ze-RAM engonelanga;
• Yongezwe igama elingundoqo elingena-Random ukunika amaxabiso angaqhelekanga kwiempawu;
• Umyalelo we LOAD DATA ngoku unokwazi ukusebenzisa ihexadecimal kunye neentetho zokubini;
• Yongeza iiparamitha ezili-15 ukulawula ukuziphatha kakuhle;
• Izixhobo ezongeziweyo zokuxilonga ukusebenza kwemibuzo yeSQL. Yongeza umbuzo ocothayo welog ekhoyo ngenkqubo yetafile SLOW_QUERY / CLUSTER_SLOW_QUERY;
• Inkxaso eyongeziweyo kwimisebenzi yokusebenza ngokulandelelana;
• Ukongezwa amandla okutshintsha ngokuguquguqukayo iiparamitha zoqwalaselo ezifundwe kwiPD (Indawo yoMqhubi, iseva yolawulo lweqela). Kongezwe ukukwazi ukusebenzisa i-"SET CONFIG" ingxelo ukutshintsha useto lwe-PD/TiKV nodes.
• Isethingi eyongeziweyo ye-max-server-connections ukunciphisa inani eliphezulu loqhagamshelwano ngaxeshanye kumncedisi (4096 ngokungagqibekanga);
• Ukusebenza okuphuculweyo kwiimeko apho iikholamu eziceliweyo zigutyungelwe ngokupheleleyo zizalathisi;
• Ukongezwa kwemibuzo eyongeziweyo esekwe kukudibanisa izalathisi;
• Ukusebenza okuphuculweyo kwemisebenzi enoluhlu lwamaxabiso;
• Ukunciphisa umthwalo we-CPU ngokugcina iziphumo zokufikelela kwizalathisi kunye nokucoca ukuphinda kabini;
• Inkxaso eyongeziweyo yefomathi entsha yokugcina umtya evumela ukuba ukwandise ukusebenza kweetafile kunye nenani elikhulu leekholomu;
• I GROUP_CONCAT umsebenzi ngoku uxhasa "ORDER BY" intetho;
• Ukongeza ukukwazi ukukhupha idatha kwi-log ye-TiFlash nge-SQL;
• Umyalelo othi "RECOVER TABLE" usebenzisa inkxaso yokubuyisela iitafile ezicushiweyo;
• Itheyibhile eyongeziweyo yenkqubo ye-DDLJobs yokubuza iinkcukacha malunga nokwenziwa komsebenzi we-DDL;
• Yongeza ukukwazi ukusebenzisa umyalelo BONISA UQINISEKISO ukubonisa izicwangciso zePD kunye neTiKV;
• Ivuliwe i-cache ye-coprocessor engagqibekanga;
• Inani lee-goroutines kwisigaba sokuphinda uzame kwakhona ngoku lingalawulwa kusetyenziswa i-committer-concurrency setting;
• Yongeza ukukwazi ukubonisa imimandla yesahlulelo setafile;
• Yongeza ukukwazi ukunciphisa ubungakanani bokugcinwa okwethutyana kwi-tidb-server;
• Inkxaso eyongeziweyo ye-"insert into tbl_name partition(partition_name_list)" kunye ne-"place into tbl_name partition(partition_name_list)" imisebenzi;
• Kwi-hash esetyenziselwa ukwahlula (i-partitioning), inkxaso yongeziweyo yokucoca ngesiseko esithi "is null";
• Kwiitheyibhile ezahluliweyo, inkxaso yokukhangela, ukucoca, nokubuyisela izalathisi zongeziwe.

umthombo: opennet.ru