{"id":37709,"date":"2019-10-31T22:19:14","date_gmt":"2019-10-31T19:19:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical\/"},"modified":"2019-10-31T22:19:14","modified_gmt":"2019-10-31T19:19:14","slug":"dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","status":"publish","type":"post","link":"https:\/\/prohoster.info\/pt\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","title":{"rendered":"Est\u00e1 dispon\u00edvel o Dqlite 1.0, uma variante distribu\u00edda do SQLite da Canonical","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>A Canonical <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\/releases\/tag\/v1.0.0\">publicou<\/a><\/noindex> lan\u00e7amento significativo do projeto <noindex><a rel=\"nofollow\" href=\"https:\/\/dqlite.io\/\">Dqlite 1.0<\/a><\/noindex> (SQLite Distribu\u00eddo), desenvolvendo um mecanismo SQL incorporado compat\u00edvel com SQLite, que suporta replica\u00e7\u00e3o de dados, recupera\u00e7\u00e3o autom\u00e1tica de falhas e garantia de alta disponibilidade atrav\u00e9s da distribui\u00e7\u00e3o de processadores em v\u00e1rios n\u00f3s. O SGBD \u00e9 implementado na forma de uma biblioteca em C vinculada a aplicativos e <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\">\u00e9 distribu\u00eddo<\/a><\/noindex> sob a licen\u00e7a Apache 2.0 (o SQLite original \u00e9 disponibilizado como dom\u00ednio p\u00fablico). H\u00e1 bindings dispon\u00edveis para a linguagem <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/go-dqlite\">Go<\/a><\/noindex>.<\/p>\n<p>A biblioteca \u00e9 uma extens\u00e3o da base de c\u00f3digo existente do SQLite, que adiciona suporte ao protocolo de rede para interligar v\u00e1rias inst\u00e2ncias de aplicativos executadas em diferentes hosts. Um aplicativo compilado com Dqlite pode funcionar como um cluster auto-suficiente e tolerante a falhas, sem depender de SGBDs externos. Na pr\u00e1tica, a Dqlite \u00e9 usada pela empresa Canonical no sistema de gerenciamento de cont\u00eaineres <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=44228\">LXD<\/a><\/noindex>. \u00c1reas de aplica\u00e7\u00e3o da biblioteca tamb\u00e9m incluem a cria\u00e7\u00e3o de dispositivos de internet das coisas tolerantes a falhas e processadores em sistemas<br \/>\n<noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=48372\">Edge<\/a><\/noindex><noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51077\">-computa\u00e7\u00e3o<\/a><\/noindex>. <\/p>\n<p>Para garantir a consist\u00eancia durante a replica\u00e7\u00e3o de dados, utiliza-se um m\u00e9todo de alcance de consenso baseado no algoritmo  <noindex><a rel=\"nofollow\" href=\"https:\/\/raft.github.io\/\">Raft<\/a><\/noindex>, que \u00e9 usado em projetos como etcd, RethinkDB, CockroachDB e OpenDaylight. Na Dqlite, uma implementa\u00e7\u00e3o ass\u00edncrona pr\u00f3pria do <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/raft\">C-raft<\/a><\/noindex>, escrita em C, \u00e9 aplicada. Para multiplexa\u00e7\u00e3o do tratamento de conex\u00f5es e organiza\u00e7\u00e3o do lan\u00e7amento de corrotinas, s\u00e3o utilizadas bibliotecas prontas <noindex><a rel=\"nofollow\" href=\"https:\/\/libuv.org\/\">libuv<\/a><\/noindex> e <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/libco\">libco<\/a><\/noindex>.<\/p>\n<p>Comparado com um projeto semelhante  <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rqlite\/rqlite\">rqlite<\/a><\/noindex>, a Dqlite oferece suporte total a transa\u00e7\u00f5es, pode se conectar a qualquer projeto escrito em C, permite o uso da fun\u00e7\u00e3o time() e aplica replica\u00e7\u00e3o baseada em quadros em vez de replica\u00e7\u00e3o baseada na retransmiss\u00e3o de express\u00f5es SQL.<\/p>\n<p>Caracter\u00edsticas da Dqlite:<\/p>\n<ul>\n<li class=\"l\"> Execu\u00e7\u00e3o de todas as opera\u00e7\u00f5es de disco e rede de forma ass\u00edncrona;\n<li class=\"l\"> Disponibilidade de um conjunto de testes para confirmar a corre\u00e7\u00e3o dos dados;\n<li class=\"l\"> Baixo consumo de mem\u00f3ria e troca de dados eficaz pela rede;\n<li class=\"l\"> Armazenamento persistente no disco do banco de dados e do log de transa\u00e7\u00f5es (com possibilidade de cache na mem\u00f3ria);\n<li class=\"l\"> R\u00e1pida recupera\u00e7\u00e3o ap\u00f3s falhas;\n<li class=\"l\"> Cliente CLI est\u00e1vel escrito em Go, que pode ser usado para inicializar o banco de dados, configurar replica\u00e7\u00e3o e conectar\/desconectar n\u00f3s;\n<li class=\"l\"> Suporte para arquiteturas ARM, X86, POWER e IBM Z;\n<li class=\"l\"> A implementa\u00e7\u00e3o do algoritmo Raft \u00e9 otimizada para minimizar lat\u00eancias na confirma\u00e7\u00e3o de transa\u00e7\u00f5es.\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=51402\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Canonical \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 Dqlite 1.0 (Distributed SQLite), \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u044b\u0439 \u0441 SQLite \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u044b\u0439 SQL-\u0434\u0432\u0438\u0436\u043e\u043a, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0439 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u044e \u0434\u0430\u043d\u043d\u044b\u0445, \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043e\u0441\u043b\u0435 \u0441\u0431\u043e\u0435\u0432 \u0438 \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u0435 \u043e\u0442\u043a\u0430\u0437\u043e\u0443\u0441\u0442\u043e\u0439\u0447\u0438\u0432\u043e\u0441\u0442\u0438 \u0447\u0435\u0440\u0435\u0437 \u0440\u0430\u0437\u043d\u0435\u0441\u0435\u043d\u0438\u0435 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 \u043d\u0430 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0443\u0437\u043b\u043e\u0432. \u0421\u0423\u0411\u0414 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u0430 \u0432 \u0444\u043e\u0440\u043c\u0435 \u043f\u0440\u0438\u043a\u0440\u0435\u043f\u043b\u044f\u0435\u043c\u043e\u0439 \u043a \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u043c \u0421\u0438-\u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \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 (\u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b\u044c\u043d\u044b\u0439 SQLite \u043f\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0435 \u0434\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435). \u0414\u043e\u0441\u0442\u0443\u043f\u043d\u044b \u0431\u0438\u043d\u0434\u0438\u043d\u0433\u0438 \u0434\u043b\u044f [&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-37709","post","type-post","status-publish","format-standard","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=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Canonical \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430\" \/>\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\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical\" \/>\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\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d Dqlite 1.0, \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 SQLite \u043e\u0442 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 Canonical | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Canonical \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/pt\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical\" \/>\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:19:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:19:14+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\udd47 Dqlite 1.0, variante distribu\u00edda do SQLite da Canonical, est\u00e1 dispon\u00edvel | ProHoster","description":"A Canonical lan\u00e7ou uma vers\u00e3o significativa do projeto","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","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\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d Dqlite 1.0, \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 SQLite \u043e\u0442 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 Canonical | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Canonical \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430","og:url":"https:\/\/prohoster.info\/pt\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","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:19:14+00:00","article:modified_time":"2019-10-31T19:19:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"37709","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-23 19:00:09","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:22:28","updated":"2026-01-23 19:00:09","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\/37709","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=37709"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/37709\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=37709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=37709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=37709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}