TiDB ndeye yakavhurwa sosi NewSQL dhatabhesi iyo inotsigira Hybrid Transactional uye Analytical Kugadziriswa kwekuwanda kwemabasa (htap) chii inogona kuita real-time transaction (OLTP) uye kugadzirisa zvikumbiro zvekuongorora.
Inoenderana neMySQL uye inogona kupa yakatwasuka scalability, kugadzikana kwakasimba uye kuwanikwa kwakanyanya. Yakagadziriswa pasi pechinyorwa cheGoogle Spanner uye F1 matekinoroji. Iyo purojekiti yakanyorwa muGo uye inoparadzirwa pasi peiyo Apache 2.0 rezinesi.
Nezve TiDB
TiDB ine SQL rutsigiro uye kupihwa kwevatengi interface inoenderana neiyo MySQL protocol, iyo inorerutsa kuchinjika kwezviripo zviripo zvakanyorerwa MySQL kuTiDB uye zvakare zvinokutendera iwe kuti ushandise zvakajairika muteresi maraibhurari. Pamusoro peiyo MySQL protocol, unogona kushandisa iyo JSON-yakavakirwa API uye Spark chinongedzo kuti uwane iyo DBMS.
SQL Zvimiro tsigiro indekisi, mabasa akaunganidzwa, GROUP GROUP mataurirwo, ORDER BY, DISTINCT, majoini, maonero, windows mabasa, uye subqueries. Iyo mikana yakapihwa yakakwana kuronga basa neTiDB yewebhu kunyorera senge PhpMyAdmin, Gogs uye WordPress.
Iko mukana wekukwirisa kuyera uye kukanganisa kushivirira: Saizi yekuchengetedza uye simba remakomputa zvinogona kuwedzerwa zvakapfava nekubatanidza node nyowani. Dhata inogoverwa kune maodhi ane redundancy, ichikubvumidza iwe kuti urambe uchishanda muchiitiko chekukanganisa kwemunhu node. Tsaona dzinobatwa otomatiki.
Iyo sisitimu inosimbisa kusagadzikana uye inoita senge DBMS hombe kune software yemutengi, kunyangwe hazvo chokwadi chekuti data kubva kunhamba dzakawanda rinoshandiswa kuita mutengano.
Dzakasiyana kumashure dzinogona kushandiswa kune epanyama data kuchengetedza mune nodeSemuenzaniso, iyo GoLevelDB neBoltDB yemuno injini dzekuchengetedza kana yako wega TiKV yakagovera injini yekuchengetera.
Iko kugona asynchronously kushandura iyo yekuchengetera schema, ichikubvumidza iwe kuti uwedzere makoramu uye maindekisi pane iyo nhunzi usinga mise kugadziriswa kwemazvino mashandiro.
TiDB 3.0 Main Zvitsva Zvimiro
Sezvatareva, TiDB 3.0 inowanikwa uye nayo kunouya kuvandudzwa kutsva kushanda uye kuwedzera kugadzirwa.
Muedzo weSysbench, vhezheni 3.0 iri pamberi pebazi 2.1 1.5 nguva kana uchiita sarudza nekuvandudza mashandiro uye mune TPC-C bvunzo 4.5 nguva. Iyo optimizations yakabata mhando dzakasiyana dzemibvunzo, kusanganisira "IN", "DO", uye "HASI ANOGONA" subqueries, JOIN mashandiro, kushandiswa kweindekisi, uye nezvimwe.
Mune iyi vhezheni nyowani vanogadzira vanosimbisa kuwedzera kweiyo nyowani TiFlash yekuchengetedza injini, iyo inogonesa kuita kuri nani mukugadzirisa mabasa eanoongorora (OLAP), nekuda kwekolamu-based chengetedzo.
TiFlash inopedzisa iyo yakambofungidzirwa TiKV yekuchengetedza, ichichengeta dhata mune mamiriro etambo mune kiyi / kukosha fomati uye yakanyanya kuita yekutengesa kugadzirisa (OLTP) mabasa.
TiFlash inoshanda yakabatana neTiKV uye iyo data iri kuenderera ichidzokororwa sepakutanga neTiKV ichishandisa iyo Raft protocol kuona kubvumirana, asi kuboka rega rega reRaft replicas chinowedzerwa chakagadzirwa, icho chinoshandiswa muTiFlash.
Maitiro aya anotendera iwe kuti ugone kupatsanura zvirinani zviwanikwa pakati peOLTP uye OLAP mabasa, uye zvakare inoita kuti data rekutengesa riwanikwe ipapo kune yekuongorora mibvunzo;
Uye zvakare, akagovera marara mutori akaitwa, iyo inobvumidza kuwedzera zvakanyanya kumhanya kwekutakura marara mumapoka makuru uye kuwedzera kugadzikana.
Wakawedzera rutsigiro rwemabasa ewindo (windows mabasa kana ekuongorora mabasa) inowirirana neMySQL 8.0. Mabasa ari muhwindo anotendera tambo yega yega yemubvunzo kuti iite kuverenga uchishandisa mimwe mitsara.
Kusiyana nemabasa akaunganidzwa anodonhedza seti yemitsetse pamutsetse mumwe, windows mashandiro akaunganidzwa zvinoenderana nezviri mukati me "hwindo" iro rinosanganisira imwe kana yakawanda mitsara kubva pane yakatarwa mhedzisiro. Pakati pekuitwa kwehwindo mabasa: NTILE, LEAD, LAG, PERCENT_RANK, NTH_VALUE, CUME_DIST, FIRST_VALUE, LAST_VALUE, RANK, DENSE_RANK uye ROW_NUMBER.
Kana iwe uchida kuziva zvakawanda nezve kuvhurwa uku, unogona kutarisa chinyorwa chekuchinja, uye kurodha pasi, unogona kuwana zvinongedzo muiyi link imwechete.