{"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\/pt\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0","title":{"rendered":"Lan\u00e7amento do banco de dados distribu\u00eddo 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\/\">Dispon\u00edvel<\/a><\/noindex> lan\u00e7amento do SGBD distribu\u00eddo <noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/index\">TiDB 3.0<\/a><\/noindex>, desenvolvido sob a influ\u00eancia das tecnologias do Google <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/archive\/spanner.html\">Spanner<\/a><\/noindex> e <noindex><a rel=\"nofollow\" href=\"http:\/\/research.google.com\/pubs\/pub38125.html\">F1<\/a><\/noindex>. TiDB \u00e9 classificada como um sistema h\u00edbrido HTAP (Hybrid Transactional\/Analytical Processing), capaz de realizar transa\u00e7\u00f5es em tempo real (OLTP) e processar consultas anal\u00edticas. O projeto \u00e9 escrito na linguagem Go e <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\">\u00e9 distribu\u00eddo<\/a><\/noindex> est\u00e3o sob a licen\u00e7a Apache 2.0.<\/p>\n<p>Recursos do TiDB:\n<\/p>\n<ul>\n<li class=\"l\"> Suporte a SQL e fornecimento de uma interface de cliente compat\u00edvel com o protocolo MySQL, facilitando a adapta\u00e7\u00e3o de aplica\u00e7\u00f5es existentes para TiDB que foram escritas para MySQL, al\u00e9m de permitir o uso de bibliotecas de cliente populares. Al\u00e9m do protocolo MySQL, \u00e9 poss\u00edvel acessar o SGBD atrav\u00e9s de uma API baseada em JSON e conector para Spark.\n<\/li>\n<li class=\"l\"> Entre os recursos suportados pelo SQL est\u00e3o \u00edndices, fun\u00e7\u00f5es agregadas, express\u00f5es GROUP BY, ORDER BY, DISTINCT, jun\u00e7\u00f5es (LEFT JOIN \/ RIGHT JOIN \/ CROSS JOIN), vis\u00f5es, fun\u00e7\u00f5es de janela e subconsultas. As capacidades fornecidas s\u00e3o suficientes para operar com TiDB em web-aplica\u00e7\u00f5es como PhpMyAdmin, <noindex><a rel=\"nofollow\" href=\"https:\/\/gogs.io\/\">Gogs<\/a><\/noindex> e WordPress;\n<\/li>\n<li class=\"l\"> Capacidade de escalonamento horizontal e garantia de alta disponibilidade: o tamanho do armazenamento e a pot\u00eancia computacional podem ser aumentados simplesmente conectando novos n\u00f3s. Os dados s\u00e3o distribu\u00eddos entre os n\u00f3s com redund\u00e2ncia, permitindo a continuidade do funcionamento em caso de falhas de n\u00f3s individuais. Falhas s\u00e3o tratadas automaticamente.\n<\/li>\n<li class=\"l\"> O sistema garante consist\u00eancia e para o software cliente parece um \u00fanico grande SGBD, apesar de que, para executar uma transa\u00e7\u00e3o, s\u00e3o utilizados dados de v\u00e1rios n\u00f3s.\n<\/li>\n<li class=\"l\"> Para o armazenamento f\u00edsico de dados em n\u00f3s, podem ser utilizados diferentes backends, como os motores de armazenamento locais GoLevelDB e BoltDB ou o pr\u00f3prio motor de armazenamento distribu\u00eddo <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tikv\">TiKV<\/a><\/noindex>.\n<\/li>\n<li class=\"l\"> Capacidade de altera\u00e7\u00e3o ass\u00edncrona do esquema de armazenamento, permitindo a adi\u00e7\u00e3o de colunas e \u00edndices em tempo real sem interromper a execu\u00e7\u00e3o de opera\u00e7\u00f5es atuais.\n<\/ul>\n<p>Principais <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pingcap\/tidb\/releases\/tag\/v3.0.0\">novidades<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Foi realizado um trabalho para aumentar o desempenho. No teste Sysbench vers\u00e3o 3.0, supera a vers\u00e3o 2.1 em 1,5 vezes na execu\u00e7\u00e3o de opera\u00e7\u00f5es de select e update, e no teste TPC-C em 4,5 vezes. As otimiza\u00e7\u00f5es afetaram v\u00e1rios tipos de consultas, incluindo subconsultas 'IN', 'DO' e 'NOT EXISTS', opera\u00e7\u00f5es de jun\u00e7\u00e3o de tabelas (JOIN), uso de \u00edndices e muito mais;<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=\"Lan\u00e7amento do banco de dados distribu\u00eddo 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=\"Lan\u00e7amento do banco de dados distribu\u00eddo 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\"> Adicionado um novo mecanismo de armazenamento TiFlash, que proporciona um desempenho superior na execu\u00e7\u00e3o de tarefas anal\u00edticas (OLAP) devido ao armazenamento em formato de colunas. O TiFlash complementa o armazenamento anteriormente oferecido, TiKV, que armazena dados em formato de linha chave\/valor e \u00e9 mais otimizado para tarefas de processamento de transa\u00e7\u00f5es (OLTP). O TiFlash opera em conjunto com o TiKV, e os dados continuam a ser replicados no TiKV utilizando o protocolo Raft para determinar o consenso, mas para cada grupo de r\u00e9plicas Raft, uma r\u00e9plica adicional \u00e9 criada para ser usada no TiFlash. Essa abordagem permite uma melhor divis\u00e3o de recursos entre tarefas OLTP e OLAP, al\u00e9m de tornar os dados das transa\u00e7\u00f5es imediatamente dispon\u00edveis para consultas anal\u00edticas;\n<p><center><noindex><a rel=\"nofollow\" href=\"https:\/\/pingcap.com\/images\/blog\/tidb-htap-architecture-1.png\"><img decoding=\"async\" alt=\"Lan\u00e7amento do banco de dados distribu\u00eddo 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\"> Implementado um coletor de lixo distribu\u00eddo que aumenta significativamente a velocidade de coleta de lixo em grandes clusters e melhora a estabilidade operacional;\n<li class=\"l\"> Adicionada uma implementa\u00e7\u00e3o experimental do sistema de controle de acesso baseado em fun\u00e7\u00f5es (RBAC). Tamb\u00e9m foi garantida a possibilidade de definir permiss\u00f5es de acesso para opera\u00e7\u00f5es ANALYZE, USE, SET GLOBAL e SHOW PROCESSLIST;\n<li class=\"l\"> Adicionada a capacidade de usar express\u00f5es SQL para sele\u00e7\u00e3o de registros do log de consultas lentas;\n<li class=\"l\"> Implementado um mecanismo r\u00e1pido de recupera\u00e7\u00e3o de tabelas deletadas, que permite restaurar dados acidentalmente exclu\u00eddos;\n<li class=\"l\"> Formatos de logs gravados unificados;\n<li class=\"l\"> Adicionado suporte ao modo de bloqueio pessimista, que torna o tratamento de transa\u00e7\u00f5es mais semelhante ao MySQL;\n<li class=\"l\"> Foi adicionada a compatibilidade com fun\u00e7\u00f5es de janela (fun\u00e7\u00f5es de janela ou fun\u00e7\u00f5es anal\u00edticas), compat\u00edveis com MySQL 8.0. As fun\u00e7\u00f5es de janela permitem que c\u00e1lculos sejam realizados para cada linha da consulta, utilizando outras linhas. Ao contr\u00e1rio das fun\u00e7\u00f5es agregadas, que condensam um conjunto de linhas agrupadas em uma \u00fanica linha, as fun\u00e7\u00f5es de janela agregam com base no conte\u00fado da 'janela', que inclui uma ou mais linhas do conjunto de resultados. Entre as fun\u00e7\u00f5es de janela implementadas:<br \/>\nNTILE, LEAD, LAG, PERCENT_RANK, NTH_VALUE, CUME_DIST, FIRST_VALUE, LAST_VALUE, RANK, DENSE_RANK e ROW_NUMBER;<\/p>\n<li class=\"l\"> Adicionada suporte experimental para vis\u00f5es (VIEW);\n<li class=\"l\"> Aprimorado o sistema de particionamento, permitindo a distribui\u00e7\u00e3o de dados em se\u00e7\u00f5es com base em intervalos de valores ou hashes;\n<li class=\"l\"> Adicionado um framework para desenvolvimento de plugins, como plugins j\u00e1 preparados para usar uma lista de IPs permitidos ou para manter um log de auditoria;\n<li class=\"l\"> Foi garantido o suporte experimental para a fun\u00e7\u00e3o 'EXPLAIN ANALYZE' para a constru\u00e7\u00e3o do plano de execu\u00e7\u00e3o da consulta SQL (Gest\u00e3o de Planos SQL);\n<li class=\"l\">  Adicionada a comando next_row_id para obter o identificador da pr\u00f3xima linha;\n<li class=\"l\"> Novas fun\u00e7\u00f5es embutidas JSON_QUOTE, JSON_ARRAY_APPEND, JSON_MERGE_PRESERVE, BENCHMARK, COALESCE e NAME_CONST foram adicionadas.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Fonte: <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.3 - 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\/pt\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_PT\" \/>\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\/pt\/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\udd47Lan\u00e7amento do banco de dados distribu\u00eddo TiDB 3.0 | ProHoster","description":"Dispon\u00edvel a vers\u00e3o do banco de dados distribu\u00eddo TiDB 3.0.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/vypusk-raspredelyonnoj-subd-tidb-3-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","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\/pt\/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\/pt\/wp-json\/wp\/v2\/posts\/36120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=36120"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/36120\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media\/27011"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=36120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=36120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=36120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}