{"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\/fr\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","title":{"rendered":"Dqlite 1.0 est disponible, une version distribu\u00e9e de SQLite de l'entreprise Canonical","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Soci\u00e9t\u00e9 Canonical <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\/releases\/tag\/v1.0.0\">a publi\u00e9<\/a><\/noindex> sortie significative du projet <noindex><a rel=\"nofollow\" href=\"https:\/\/dqlite.io\/\">Dqlite 1.0<\/a><\/noindex> (SQLite distribu\u00e9), un moteur SQL embarqu\u00e9 compatible avec SQLite, supportant la r\u00e9plication des donn\u00e9es, la r\u00e9cup\u00e9ration automatique apr\u00e8s d\u00e9faillance et la r\u00e9silience via la distribution des gestionnaires sur plusieurs n\u0153uds. La base de donn\u00e9es est impl\u00e9ment\u00e9e sous forme de biblioth\u00e8que C int\u00e9gr\u00e9e aux applications et <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/dqlite\">est distribu\u00e9<\/a><\/noindex> sous licence Apache 2.0 (SQLite original est fourni dans le domaine public). Des liaisons sont disponibles pour le langage <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/go-dqlite\">Go<\/a><\/noindex>.<\/p>\n<p>La biblioth\u00e8que est une surcouche \u00e0 la base de code SQLite existante, ajoutant le support d'un protocole r\u00e9seau pour connecter plusieurs instances d'application ex\u00e9cut\u00e9es sur diff\u00e9rents h\u00f4tes. L'application construite avec Dqlite peut fonctionner comme un cluster autonome r\u00e9silient, sans d\u00e9pendance \u00e0 des bases de donn\u00e9es externes. En pratique, Dqlite est utilis\u00e9 par Canonical dans le syst\u00e8me de gestion des conteneurs <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=44228\">LXD<\/a><\/noindex>. Parmi les domaines d'application de la biblioth\u00e8que, on mentionne \u00e9galement la cr\u00e9ation de dispositifs IoT r\u00e9silients et de gestionnaires dans des syst\u00e8mes<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\">-de calcul<\/a><\/noindex>. <\/p>\n<p>Pour assurer la coh\u00e9rence lors de la r\u00e9plication des donn\u00e9es, une m\u00e9thode de consensus bas\u00e9e sur l'algorithme  <noindex><a rel=\"nofollow\" href=\"https:\/\/raft.github.io\/\">Raft<\/a><\/noindex>, utilis\u00e9 dans des projets tels que etcd, RethinkDB, CockroachDB et OpenDaylight. Dans Dqlite, une impl\u00e9mentation asynchrone propre est appliqu\u00e9e <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/raft\">C-raft<\/a><\/noindex>, \u00e9crite en C. Pour le multiplexage des connexions et l'organisation du lancement des coroutines, des biblioth\u00e8ques pr\u00eates \u00e0 l'emploi sont utilis\u00e9es <noindex><a rel=\"nofollow\" href=\"https:\/\/libuv.org\/\">libuv<\/a><\/noindex> et <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/canonical\/libco\">libco<\/a><\/noindex>.<\/p>\n<p>Compar\u00e9 \u00e0 un projet similaire  <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/rqlite\/rqlite\">rqlite<\/a><\/noindex>, Dqlite offre un support complet des transactions, peut se connecter \u00e0 tous les projets en C, permet d'utiliser la fonction time() et applique la r\u00e9plication bas\u00e9e sur les images plut\u00f4t que sur la traduction d'expressions SQL.<\/p>\n<p>Caract\u00e9ristiques de Dqlite :<\/p>\n<ul>\n<li class=\"l\"> Ex\u00e9cution de toutes les op\u00e9rations disque et r\u00e9seau en mode asynchrone ;\n<li class=\"l\"> Pr\u00e9sence d'un jeu de tests pour valider l'int\u00e9grit\u00e9 des donn\u00e9es ;\n<li class=\"l\"> Faible consommation de m\u00e9moire et \u00e9change efficace de donn\u00e9es sur le r\u00e9seau ;\n<li class=\"l\"> Stockage permanent sur disque de la base de donn\u00e9es et du journal des transactions (avec possibilit\u00e9 de mise en cache en m\u00e9moire) ;\n<li class=\"l\"> R\u00e9cup\u00e9ration rapide apr\u00e8s d\u00e9faillance ;\n<li class=\"l\"> Client CLI stable en Go, pouvant \u00eatre utilis\u00e9 pour initialiser la base de donn\u00e9es, configurer la r\u00e9plication et connecter\/d\u00e9connecter des n\u0153uds ;\n<li class=\"l\"> Support des architectures ARM, X86, POWER et IBM Z ;\n<li class=\"l\"> L'impl\u00e9mentation de l'algorithme Raft est optimis\u00e9e pour minimiser les latences lors de la validation des transactions.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Source : <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.2.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\/fr\/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.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\/fr\/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\udd47Dqlite 1.0, variante distribu\u00e9e de SQLite par Canonical, est disponible | ProHoster","description":"La soci\u00e9t\u00e9 Canonical a publi\u00e9 une version importante du projet.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/dostupen-dqlite-1-0-raspredelyonnyj-variant-sqlite-ot-kompanii-canonical","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","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\/fr\/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\/fr\/wp-json\/wp\/v2\/posts\/37709","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=37709"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/37709\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=37709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=37709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=37709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}