{"id":83153,"date":"2020-05-29T01:42:10","date_gmt":"2020-05-28T23:42:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-raspredelyonnoj-subd-tidb-4-0"},"modified":"2020-05-29T01:42:10","modified_gmt":"2020-05-28T23:42:10","slug":"vypusk-raspredelyonnoj-subd-tidb-4-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-4-0","title":{"rendered":"Lansarea bazei de date distribuite TiDB 4.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\/releases\/tag\/v4.0.0\">Disponibil<\/a><\/noindex> lansarea unei baze de date distribuite <noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/index\">TiDB 4.0<\/a><\/noindex>, dezvoltat\u0103 sub influen\u021ba tehnologiilor Google <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/archive\/spanner.html\">Spanner<\/a><\/noindex> \u0219i <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/pubs\/pub38125.html\">F1<\/a><\/noindex>. TiDB face parte din categoria sistemelor hibride HTAP (Hybrid Transactional\/Analytical Processing), capabile s\u0103 execute at\u00e2t tranzac\u021bii \u00een timp real (OLTP), c\u00e2t \u0219i s\u0103 proceseze interog\u0103ri analitice. Proiectul este scris \u00een limbajul Go \u0219i <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\">se r\u0103sp\u00e2nde\u0219te<\/a><\/noindex> sub licen\u021ba Apache 2.0.<\/p>\n<p>Caracteristici ale TiDB:\n<\/p>\n<ul>\n<li class=\"l\"> Suport pentru SQL \u0219i furnizarea unei interfe\u021be client compatibile cu protocolul MySQL, ceea ce faciliteaz\u0103 adaptarea aplica\u021biilor existente pentru TiDB, scrise pentru MySQL, \u0219i permite utilizarea bibliotecilor client comune. Pe l\u00e2ng\u0103 protocolul MySQL, se poate folosi un API bazat pe JSON \u0219i un conector pentru Spark pentru a accesa baza de date.\n<\/li>\n<li class=\"l\"> Printre caracteristicile SQL se num\u0103r\u0103 indec\u0219ii, func\u021biile agregate, expresiile GROUP BY, ORDER BY, DISTINCT, \u00eembin\u0103rile (LEFT JOIN \/ RIGHT JOIN \/ CROSS JOIN), vizualiz\u0103rile, func\u021biile de fereastr\u0103 \u0219i subinterog\u0103rile. Func\u021bionalit\u0103\u021bile oferite sunt suficiente pentru a organiza lucrul cu TiDB pentru aplica\u021bii web precum PhpMyAdmin, <noindex><a rel=\"nofollow\" href=\"https:\/\/gogs.io\/\">Gogs<\/a><\/noindex> \u0219i WordPress;\n<\/li>\n<li class=\"l\"> Posibilitatea scal\u0103rii orizontale \u0219i asigurarea redundan\u021bei: dimensiunea stoc\u0103rii \u0219i puterea de calcul pot fi extinse prin simpla conectare a unor noi noduri. Datele sunt distribuite \u00eentre noduri cu redundan\u021b\u0103, permi\u021b\u00e2nd continuarea func\u021bion\u0103rii \u00een caz de eroare a unor noduri. Defec\u021biunile sunt gestionate automat.\n<\/li>\n<li class=\"l\"> Sistemul garanteaz\u0103 consisten\u021ba \u0219i pentru software-ul client apare ca o singur\u0103 baz\u0103 de date mare, cu toate c\u0103, de fapt, pentru executarea tranzac\u021biilor sunt implicate date de pe mai multe noduri.\n<\/li>\n<li class=\"l\"> Pentru stocarea fizic\u0103 a datelor pe noduri pot fi utilizate diferite backend-uri, cum ar fi motoarele de stocare locale GoLevelDB \u0219i BoltDB sau motoarele proprii de stocare distribuit\u0103. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tikv\">TiKV<\/a><\/noindex> \u0219i TiFlash. TiKV stocheaz\u0103 datele pe linii \u00een format cheie\/valoare \u0219i este mai optimizat pentru sarcini de procesare a tranzac\u021biilor (OLTP). TiFlash stocheaz\u0103 datele \u00een func\u021bie de coloane \u0219i permite ob\u021binerea unei performan\u021be mai ridicate \u00een cadrul sarcinilor analitice (OLAP).\n<\/li>\n<li class=\"l\"> Posibilitatea de a modifica schema de stocare \u00een mod asincron, permi\u021b\u00e2nd ad\u0103ugarea de coloane \u0219i indec\u0219i \u00een timpul desf\u0103\u0219ur\u0103rii opera\u021biunilor curente.\n<\/li>\n<\/ul>\n<p>\u00cen noua versiune:<\/p>\n<ul>\n<li class=\"l\"> Implicit, este activat colectorul de gunoi distribuit Green GC, care permite cre\u0219terea semnificativ\u0103 a vitezei de colectare a gunoaiului \u00een clustere mari \u0219i cre\u0219terea stabilit\u0103\u021bii func\u021bion\u0103rii acesteia;\n<li class=\"l\">A fost ad\u0103ugat\u0103 suportul pentru tranzac\u021bii mari, a c\u0103ror dimensiune este practic limitat\u0103 de dimensiunea memoriei fizice. Limitarea dimensiunii unei tranzac\u021bii a fost crescut\u0103 de la 100 MB la 10GB;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 suportul pentru comenzile BACKUP \u0219i RESTORE pentru realizarea copiilor de rezerv\u0103;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 posibilitatea de a instala blocaje pe tabele;\n<li class=\"l\"> A fost ad\u0103ugat un mecanism de izolare a tranzac\u021biilor compatibil cu MySQL, la nivel de citire (READ COMMITTED);\n<li class=\"l\"> Comanda &#171;ADMIN SHOW DDL JOBS&#187; a fost ad\u0103ugat\u0103 suport pentru expresiile LIKE \u0219i WHERE;\n<li class=\"l\"> A fost ad\u0103ugat parametru oom-use-tmp-storage, care permite utilizarea fi\u0219ierelor temporare pentru a cache-a rezultatele intermediare \u00een condi\u021bii de lips\u0103 de memorie RAM;\n<li class=\"l\"> A fost ad\u0103ugat cuv\u00e2ntul cheie Random pentru a atribui atributelor valori \u00eent\u00e2mpl\u0103toare;\n<li class=\"l\"> \u00cen comanda LOAD DATA a fost ad\u0103ugat\u0103 posibilitatea de a utiliza expresii hexazecimale \u0219i binare;\n<li class=\"l\"> Au fost ad\u0103ugate 15 parametri pentru controlul comportamentului optimizatorului;\n<li class=\"l\"> Au fost ad\u0103ugate instrumente pentru diagnosticarea performan\u021bei interog\u0103rilor SQL. A fost ad\u0103ugat un log pentru interog\u0103rile lente, disponibil prin intermediul tabelei sistemului SLOW_QUERY \/ CLUSTER_SLOW_QUERY;\n<li class=\"l\"> A fost ad\u0103ugat suportul pentru func\u021bii pentru lucrul cu secven\u021bele;\n<li class=\"l\"> S-a ad\u0103ugat posibilitatea de a schimba dinamic parametrii de configurare, citi\u021bi din PD (Placement Driver, server de control al clusterului). S-a ad\u0103ugat posibilitatea de a utiliza expresia &#171;SET CONFIG&#187; pentru a modifica set\u0103rile nodurilor PD\/TiKV.\n<li class=\"l\"> A fost ad\u0103ugat\u0103 configura\u021bia max-server-connections pentru a limita num\u0103rul maxim de conexiuni simultane la server (implicit 4096);\n<li class=\"l\"> A fost crescut\u0103 performan\u021ba \u00een situa\u021biile \u00een care coloanele solicitate sunt complet acoperite de indec\u0219i;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 optimizarea interog\u0103rilor pe baza fuziunii indec\u0219ilor.\n<li class=\"l\"> Performan\u021ba opera\u021biunilor cu intervale de valori a fost \u00eembun\u0103t\u0103\u021bit\u0103;\n<li class=\"l\"> Sarcina pe CPU a fost redus\u0103 datorit\u0103 memoriz\u0103rii rezultatelor apelurilor la indec\u0219i \u0219i filtr\u0103rii duplicatelor;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 suport pentru un nou format de stocare a \u0219irurilor, permi\u021b\u00e2nd \u00eembun\u0103t\u0103\u021birea performan\u021bei tabelelor cu un num\u0103r mare de coloane;\n<li class=\"l\"> Func\u021bia GROUP_CONCAT a ob\u021binut suport pentru expresia &#171;ORDER BY&#187;;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 posibilitatea de a extrage date din jurnalul TiFlash prin SQL;\n<li class=\"l\"> Comanda &#171;RECOVER TABLE&#187; a implementat suport pentru recuperarea tabelelor trunchiate;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 o tabel\u0103 sistem DDLJobs pentru interogarea detaliilor despre execu\u021bia lucr\u0103rilor DDL;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 posibilitatea de a utiliza comanda SHOW CONFIG pentru a ar\u0103ta set\u0103rile PD \u0219i TiKV;\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\/pull\/16710\">Activat<\/a><\/noindex>  memoria cache a coprocessorului implicit;\n<li class=\"l\"> Num\u0103rul de coroutine \u00een faza de retrial poate fi acum controlat prin configura\u021bia committer-concurrency;\n<li class=\"l\"> A fost ad\u0103ugat\u0103 posibilitatea de a afi\u0219a regiunile sec\u021biunii tabelelor (table partition);\n<li class=\"l\"> \u00cen tidb-server a fost ad\u0103ugat\u0103 op\u021biunea de a limita dimensiunea stoc\u0103rii temporare;\n<li class=\"l\"> S-a ad\u0103ugat suport pentru opera\u021biile &#171;insert into tbl_name partition(partition_name_list)&#187; \u0219i &#171;replace into tbl_name partition(partition_name_list)&#187;;\n<li class=\"l\"> \u00cen hash-ul utilizat pentru parti\u021bionare s-a ad\u0103ugat suport pentru filtrarea dup\u0103 criteriul &#171;is null&#187;;\n<li class=\"l\"> Pentru tabelele sec\u021bionate, a fost ad\u0103ugat\u0103 suport pentru opera\u021biunile de verificare, cur\u0103\u021bare \u0219i recuperare a indicilor.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Sursa: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53045\">opennet.ro<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB 4.0, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u043c\u043e\u0439 \u043f\u043e\u0434 \u0432\u043f\u0435\u0447\u0430\u0442\u043b\u0435\u043d\u0438\u0435\u043c \u043e\u0442 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 Google Spanner \u0438 F1. TiDB \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0441\u044f \u043a \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438 \u0433\u0438\u0431\u0440\u0438\u0434\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c HTAP (Hybrid Transactional\/Analytical Processing), \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0445 \u043a\u0430\u043a \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438 (OLTP), \u0442\u0430\u043a \u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Go \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0. \u041e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 TiDB: \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 SQL [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-83153","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-4-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB 4.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-4-0\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-05-28T23:42:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-05-28T23:42:10+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Lansare baz\u0103 de date distribuit\u0103 TiDB 4.0 | ProHoster","description":"Este disponibil\u0103 lansarea bazei de date distribuite TiDB.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-4-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412\u044b\u043f\u0443\u0441\u043a \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB 4.0 | ProHoster","og:description":"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u0440\u0435\u043b\u0438\u0437 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414 TiDB.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-4-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-05-28T23:42:10+00:00","article:modified_time":"2020-05-28T23:42:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"83153","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 15:24:25","updated":"2022-09-28 02:50:21","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/83153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=83153"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/83153\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=83153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=83153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=83153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}