{"id":36120,"date":"2019-10-31T22:09:43","date_gmt":"2019-10-31T19:09:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/vypusk-raspredelyonnoj-subd-tidb-3-0\/"},"modified":"2019-10-31T22:09:43","modified_gmt":"2019-10-31T19:09:43","slug":"vypusk-raspredelyonnoj-subd-tidb-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0","title":{"rendered":"Objava distribuirane DBMS TiDB 3.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/blog\/tidb-3.0-announcement\/\">Dostupno<\/a><\/noindex> izdanje distribuirane DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/index\">TiDB 3.0<\/a><\/noindex>, razvijen pod utjecajem tehnologija Google <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/archive\/spanner.html\">Spanner<\/a><\/noindex> i <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/pubs\/pub38125.html\">F1<\/a><\/noindex>. TiDB pripada kategoriji hibridnih HTAP sustava (Hibridno Transakcijsko\/Analiti\u010dko Procesiranje) koji su sposobni kako za izvr\u0161avanje transakcija u stvarnom vremenu (OLTP), tako i za analiti\u010dka upitna obra\u010dunavanja. Projekt je napisan na jeziku Go i <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\">distribuira se<\/a><\/noindex> pod licencom Apache 2.0.<\/p>\n<p>Zna\u010dajke TiDB-a:\n<\/p>\n<ul>\n<li class=\"l\"> Podr\u0161ka za SQL i pru\u017eanje korisni\u010dkog su\u010delja kompatibilnog s MySQL protokolom, \u0161to olak\u0161ava prilagodbu postoje\u0107ih aplikacija napisanim za MySQL za TiDB, kao i omogu\u0107uje kori\u0161tenje popularnih klijentskih biblioteka. Osim MySQL protokola, za pristup DBMS-u mo\u017ee se koristiti API temeljen na JSON-u i konektor za Spark.\n<\/li>\n<li class=\"l\"> Iz SQL mogu\u0107nosti podr\u017eavaju se indeksi, agregatne funkcije, izrazi GROUP BY, ORDER BY, DISTINCT, spojevi (LEFT JOIN \/ RIGHT JOIN \/ CROSS JOIN), prikazi, prozor funkcije i podupiti. Pru\u017eene mogu\u0107nosti su dovoljne za rad s TiDB u web-aplikacijama kao \u0161to su PhpMyAdmin, <noindex><a rel=\"nofollow\" href=\"https:\/\/gogs.io\/\">Gogs<\/a><\/noindex> i WordPress;\n<\/li>\n<li class=\"l\"> Mogu\u0107nost horizontalnog skaliranja i osiguranje otpornosti: kapacitet pohrane i ra\u010dunalnu snagu mogu\u0107e je pove\u0107ati jednostavnim dodavanjem novih \u010dvorova. Podaci se distribuiraju po \u010dvorovima s redundancijom koja omogu\u0107ava nastavak rada u slu\u010daju kvara pojedinih \u010dvorova. Kvarovi se automatski obra\u0111uju.\n<\/li>\n<li class=\"l\"> Sustav jam\u010di dosljednost i za klijentski softver izgleda kao jedna velika DBMS, iako se za izvr\u0161enje transakcija zapravo koriste podaci s vi\u0161e \u010dvorova.\n<\/li>\n<li class=\"l\"> Razli\u010diti backendovi mogu se koristiti za fizi\u010dko pohranjivanje podataka na \u010dvorovima, poput lokalnih storage engine-a GoLevelDB i BoltDB ili vlastitog engine-a distribuiranog skladi\u0161ta. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tikv\">TiKV<\/a><\/noindex>.\n<\/li>\n<li class=\"l\"> Mogu\u0107nost asinkrone promjene sheme pohrane, koja omogu\u0107ava dodavanje stupaca i indeksa u hodu bez prekida obrade trenutnih operacija.\n<\/ul>\n<p>Glavne <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\/releases\/tag\/v3.0.0\">novosti<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Izvr\u0161en je rad na pove\u0107anju performansi. U Sysbench testu verzija 3.0 prema\u0161uje granu 2.1 za 1.5 puta prilikom izvr\u0161avanja operacija select i update, a u TPC-C testu za 4.5 puta. Optimizacije su obuhvatile razne vrste upita, uklju\u010duju\u0107i podupite &#171;IN&#187;, &#171;DO&#187; i &#171;NOT EXISTS&#187;, operacije spajanja tabela (JOIN), kori\u0161\u0107enje indeksa i jo\u0161 mnogo toga;<br \/>\n<center><noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/images\/blog\/oltp-point-select-in-sysbench-and-tidb-2.1.png\"><img decoding=\"async\" alt=\"Objava distribuirane DBMS TiDB 3.0 \" src=\"\/wp-content\/uploads\/2019\/07\/f4c63d50663f95fb877fa111810439f3.png\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/images\/blog\/tpc-c-results-for-tidb-3.0-and-tidb-2.1.png\"><img decoding=\"async\" alt=\"Objava distribuirane DBMS TiDB 3.0 \" src=\"\/wp-content\/uploads\/2019\/07\/89768360adce73a07b9248cf286053bd.png\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/center><\/p>\n<li class=\"l\"> Dodana je nova TiFlash engine za skladi\u0161tenje, koja omogu\u0107ava postizanje vi\u0161ih performansi u analiti\u010dkim zadacima (OLAP) zahvaljuju\u0107i skladi\u0161tenju vezanom za stupce. TiFlash dopunjuje prethodno ponu\u0111eno skladi\u0161te TiKV, koje pohranjuje podatke po redovima u klju\u010d\/vrijednost formatu i optimalnije je za obradu transakcija (OLTP). TiFlash radi zajedno s TiKV, a podaci se i dalje repliciraju u TiKV koriste\u0107i Raft protokol za odre\u0111ivanje konsenzusa, ali za svaku grupu Raft replika stvara se dodatna replika koja se koristi u TiFlash-u. Takav pristup omogu\u0107ava bolje razdvajanje resursa izme\u0111u OLTP i OLAP zadataka, kao i trenutnu dostupnost podataka transakcija za analiti\u010dke upite.\n<p><center><noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/images\/blog\/tidb-htap-architecture-1.png\"><img decoding=\"async\" alt=\"Objava distribuirane DBMS TiDB 3.0 \" src=\"\/wp-content\/uploads\/2019\/07\/ba4a4e5e9c9390c7db6fcdb4e88e7e40.png\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><\/center><\/p>\n<li class=\"l\"> Implementiran je distribuirani sakuplja\u010d sme\u0107a, koji zna\u010dajno pove\u0107ava brzinu sakupljanja sme\u0107a u velikim klasterima i pobolj\u0161ava stabilnost rada.\n<li class=\"l\"> Dodana je eksperimentalna implementacija sustava za upravljanje pristupom na temelju uloga (RBAC). Tako\u0111er, omogu\u0107eno je postavljanje prava pristupa za operacije ANALYZE, USE, SET GLOBAL i SHOW PROCESSLIST.\n<li class=\"l\"> Dodana je mogu\u0107nost kori\u0161tenja SQL izraza za selekciju iz loga sporih upita.\n<li class=\"l\"> Implementiran je mehanizam brzog vra\u0107anja obrisanih tablica, koji omogu\u0107ava povrat slu\u010dajno izbrisanih podataka.\n<li class=\"l\"> Standardiziran je format zapisivanja logova.\n<li class=\"l\"> Dodana je podr\u0161ka za pesimisti\u010dki na\u010din blokiranja, koji \u010dini obradu transakcija bli\u017eom MySQL-u.\n<li class=\"l\"> Dodana je podr\u0161ka za prozorske funkcije (window funkcije ili analiti\u010dke funkcije) kompatibilne sa MySQL 8.0. Prozorske funkcije omogu\u0107avaju da se za svaki red upita izvr\u0161e prora\u010duni koriste\u0107i druge redove. Za razliku od agregatnih funkcija, koje sakupljaju grupisani skup redova u jedan red, prozorske funkcije vr\u0161e agregiranje na osnovu sadr\u017eaja &#171;prozora&#187;, koji uklju\u010duje jedan ili vi\u0161e redova iz rezultantnog skupa. Me\u0111u implementiranim prozorskim funkcijama su:<br \/>\nNTILE, LEAD, LAG, PERCENT_RANK, NTH_VALUE, CUME_DIST, FIRST_VALUE, LAST_VALUE, RANK, DENSE_RANK i ROW_NUMBER;<\/p>\n<li class=\"l\"> Dodana je eksperimentalna podr\u0161ka za prikaze (VIEW);\n<li class=\"l\"> Pobolj\u0161an je sustav particioniranja, dodana je mogu\u0107nost raspodjele podataka po sekcijama na temelju raspona vrijednosti ili he\u0161ova;\n<li class=\"l\"> Dodana je struktura za razvoj dodataka, na primjer, ve\u0107 su pripremljeni dodaci za kori\u0161tenje bijele liste IP-a ili vo\u0111enje audit loga;\n<li class=\"l\"> Odobrena je eksperimentalna podr\u0161ka za funkciju &#171;EXPLAIN ANALYZE&#187; za izradu plana izvr\u0161enja SQL upita (SQL Plan Management);\n<li class=\"l\">  Dodana je naredba next_row_id za dobivanje identifikatora sljede\u0107eg retka;\n<li class=\"l\"> Dodane su nove ugra\u0111ene funkcije JSON_QUOTE, JSON_ARRAY_APPEND, JSON_MERGE_PRESERVE, BENCHMARK, COALESCE i NAME_CONST.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Izvor: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51060\">opennet.ru<\/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 3.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":27011,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-36120","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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 3.0.\" \/>\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\/hr\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"hr_HR\" \/>\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 3.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 3.0.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-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=\"2019-10-31T19:09:43+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:09:43+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\udd47Izlaz distribuirane DBMS TiDB 3.0 | ProHoster","description":"Dostupan je izlaz distribuirane DBMS TiDB 3.0.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","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 3.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 3.0.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-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":"2019-10-31T19:09:43+00:00","article:modified_time":"2019-10-31T19:09:43+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36120","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":"2026-01-22 02:06:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:50:23","updated":"2026-01-22 02:06:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/36120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=36120"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/36120\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media\/27011"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=36120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=36120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=36120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}