{"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\/et\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","title":{"rendered":"Seal on saadaval Dqlite 1.0, Canonicali jaotatud versioon SQLite'ist.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Canonical ettev\u00f5te <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\/releases\/tag\/v1.0.0\">avalikustas<\/a><\/noindex> t\u00e4htis projekti v\u00e4ljalase <noindex><a rel=\"nofollow\" href=\"https:\/\/dqlite.io\/\">Dqlite 1.0<\/a><\/noindex> (jaotatud SQLite), arendades SQLite'iga \u00fchilduvat sisseehitatud SQL-mootorit, mis toetab andmete replikatsiooni, autonoomset t\u00f5rke taastamist ja t\u00f5rketaluvust, jagades t\u00f6\u00f6tlejad mitme s\u00f5lme peale. DBMS on rakendatav C teegi vormis ja <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\">levitatakse<\/a><\/noindex> Apache 2.0 litsentsi all (algne SQLite on saadaval avaliku domeenina). Saadaval on keele <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/go-dqlite\">Go<\/a><\/noindex>.<\/p>\n<p>Teegil on olemasoleva SQLite koodi alusele kiht, mis lisab v\u00f5rguprotokolli toe mitme rakenduse eksemplari vahel, mis t\u00f6\u00f6tavad erinevates hostides. Dqlite'iga \u00fcles ehitatud rakendus v\u00f5ib toimida iseseisva t\u00f5rketaluvana klastrina, s\u00f5ltumata v\u00e4listest DBMS-idest. Praktikas kasutab Dqlite'd ettev\u00f5te Canonical konteinerite haldamise s\u00fcsteemis <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=44228\">LXD<\/a><\/noindex>. Teegi valdkondade hulka kuulub ka t\u00f5rketaluvate Interneti-asjade seadmete ja t\u00f6\u00f6tlejate loomine<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\">-arvutus<\/a><\/noindex>. <\/p>\n<p>Andmete replikatsiooni j\u00e4rjepidevuse tagamiseks rakendatakse konsensuse saavutamise meetodit, mis p\u00f5hineb  <noindex><a rel=\"nofollow\" href=\"https:\/\/raft.github.io\/\">Rafti<\/a><\/noindex>, mida kasutatakse sellistes projektides nagu etcd, RethinkDB, CockroachDB ja OpenDaylight. Dqlite'is kasutatakse oma as\u00fcnkroonset rakendust <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/raft\">C-raft<\/a><\/noindex>, mis on kirjutatud C keeles. \u00dchenduste t\u00f6\u00f6tlemise ja kahekordsete k\u00e4igukastide k\u00e4ivitamise korraldamiseks kasutatakse valmis teeke <noindex><a rel=\"nofollow\" href=\"https:\/\/libuv.org\/\">libuv<\/a><\/noindex> ja <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/libco\">libco<\/a><\/noindex>.<\/p>\n<p>V\u00f5rreldes sarnase projektiga  <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rqlite\/rqlite\">rqlite<\/a><\/noindex>, Dqlite pakub t\u00e4ielikku tehingute tuge, v\u00f5ib \u00fchendada k\u00f5ikv\u00f5imalike C keeltes projektidega, v\u00f5imaldab kasutada time() funktsiooni ning rakendab kaadrite p\u00f5hjal replikatsiooni, mitte SQL-lausete edastamise p\u00f5hjal replikatsiooni.<\/p>\n<p>Dqlite omadused:<\/p>\n<ul>\n<li class=\"l\"> K\u00f5ik kettaga ja v\u00f5rgu toimingud toimuvad as\u00fcnkroonselt;\n<li class=\"l\"> Andmete \u00f5igsuse kinnitamiseks on olemas testimise komplekt;\n<li class=\"l\"> Madala m\u00e4lutarbimise ja t\u00f5husa andmevahetusega v\u00f5rgu kaudu;\n<li class=\"l\"> Andmebaasi ja tehingute logi pidev s\u00e4ilitamine kettal (v\u00f5imalusega vahem\u00e4lus hoida);\n<li class=\"l\"> Kiire t\u00f5rke taastamine;\n<li class=\"l\"> Stabiilne CLI-klient Go keeles, mida saab kasutada andmebaasi initsialiseerimiseks, replikatsiooni seadistamiseks ning s\u00f5lmede \u00fchendamiseks\/eraldamiseks;\n<li class=\"l\"> Toetab ARM, X86, POWER ja IBM Z arhitektuuride kasutamist;\n<li class=\"l\"> Rafti algoritmi rakendamine on optimeeritud tehingute kinnitamise viivituste v\u00e4hendamiseks.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Allikas: <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.1.1 - 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\/et\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\/et\/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\udd47Saadaval on Dqlite 1.0, Canonicali loodud jaotatud versioon SQLite'ist | ProHoster","description":"Ettev\u00f5te Canonical avaldas olulise v\u00e4ljaande projektist","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/37709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=37709"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/37709\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=37709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=37709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=37709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}