{"id":103994,"date":"2022-05-10T09:36:51","date_gmt":"2022-05-10T07:36:51","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite"},"modified":"2022-05-10T09:36:51","modified_gmt":"2022-05-10T07:36:51","slug":"predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","status":"publish","type":"post","link":"https:\/\/prohoster.info\/fr\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","title":{"rendered":"Litestream a \u00e9t\u00e9 pr\u00e9sent\u00e9 avec une impl\u00e9mentation du syst\u00e8me de r\u00e9plication pour SQLite.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Ben Johnson, l'auteur du stockage NoSQL BoltDB, a pr\u00e9sent\u00e9 le projet Litestream, qui offre une surcouche pour organiser la r\u00e9plication des donn\u00e9es dans SQLite. Litestream ne n\u00e9cessite aucune modification de SQLite et peut fonctionner avec toutes les applications utilisant cette biblioth\u00e8que. La r\u00e9plication est g\u00e9r\u00e9e par un processus en arri\u00e8re-plan distinct qui suit les modifications apport\u00e9es aux fichiers de la base de donn\u00e9es et les transf\u00e8re dans un autre fichier ou vers un stockage externe. Le code du projet est \u00e9crit en Go et est distribu\u00e9 sous la licence Apache 2.0. <\/p>\n

Tout l'interaction avec la base de donn\u00e9es est r\u00e9alis\u00e9e via l'API SQLite standard, c'est-\u00e0-dire que Litestream n'interf\u00e8re pas directement avec le fonctionnement, n'affecte pas les performances et ne peut pas endommager le contenu de la base de donn\u00e9es, ce qui distingue avantageusement Litestream de solutions telles que Rqlite et Dqlite. Les modifications sont suivies en activant le journal WAL (\u00ab Write-Ahead Log \u00bb) dans SQLite. Pour \u00e9conomiser de l'espace de stockage, le syst\u00e8me agr\u00e8ge p\u00e9riodiquement le flux de changements en instantan\u00e9s (snapshots) de la base de donn\u00e9es, au-dessus desquels d'autres modifications commencent \u00e0 s'accumuler. Le moment de cr\u00e9ation des instantan\u00e9s est sp\u00e9cifi\u00e9 dans les param\u00e8tres, par exemple, il est possible de cr\u00e9er des instantan\u00e9s une fois par jour ou une fois par heure. <\/p>\n

Les principales applications de Litestream incluent l'organisation de sauvegardes s\u00e9curis\u00e9es et la r\u00e9partition de la charge de lecture sur plusieurs serveurs<\/a>. Le transfert du flux de modifications vers des stockages tels qu'Amazon S3, Azure Blob Storage, Backblaze B2, DigitalOcean Spaces, Scaleway Object Storage, Google Cloud Storage, Linode Object Storage ou sur tout h\u00f4te externe prenant en charge le protocole SFTP est pris en charge. En cas de corruption du contenu de la base de donn\u00e9es principale, une sauvegarde peut \u00eatre restaur\u00e9e \u00e0 partir d'un \u00e9tat correspondant \u00e0 un moment donn\u00e9, \u00e0 une modification sp\u00e9cifique, \u00e0 la derni\u00e8re modification ou \u00e0 un instantan\u00e9 donn\u00e9.
\n
Source : opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0411\u0435\u043d \u0414\u0436\u043e\u043d\u0441\u043e\u043d (Ben Johnson), \u0430\u0432\u0442\u043e\u0440 NoSQL-\u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 BoltDB, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u043b \u043f\u0440\u043e\u0435\u043a\u0442 Litestream, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0439 \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0443 \u0434\u043b\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 SQLite. Litestream \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0432\u043d\u0435\u0441\u0435\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 SQLite \u0438 \u043c\u043e\u0436\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u043b\u044e\u0431\u044b\u043c\u0438 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u043c\u0438, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0449\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u0443\u044e \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0443. \u0420\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c\u044b\u0439 \u0444\u043e\u043d\u043e\u0432\u044b\u0439 \u043f\u0440\u043e\u0446\u0435\u0441\u0441, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u0442\u0441\u043b\u0435\u0436\u0438\u0432\u0430\u0435\u0442 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0432 \u0444\u0430\u0439\u043b\u0430\u0445 \u0441 \u0411\u0414 \u0438 \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u0442 \u0438\u0445 \u0432 \u0434\u0440\u0443\u0433\u043e\u0439 \u0444\u0430\u0439\u043b \u0438\u043b\u0438 \u0432\u043e […]<\/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-103994","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Litestream a \u00e9t\u00e9 pr\u00e9sent\u00e9 avec la mise en \u0153uvre d'un syst\u00e8me de r\u00e9plication pour SQLite | ProHoster","description":"Ben Johnson, l'auteur du stockage NoSQL BoltDB, a pr\u00e9sent\u00e9 le projet Litestream, qui offre une surcouche pour organiser la r\u00e9plication des donn\u00e9es dans SQLite.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","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\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d Litestream \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0434\u043b\u044f SQLite | ProHoster","og:description":"\u0411\u0435\u043d \u0414\u0436\u043e\u043d\u0441\u043e\u043d (Ben Johnson), \u0430\u0432\u0442\u043e\u0440 NoSQL-\u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430 BoltDB, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u043b \u043f\u0440\u043e\u0435\u043a\u0442 Litestream, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0439 \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0443 \u0434\u043b\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 SQLite.","og:url":"https:\/\/prohoster.info\/fr\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","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":"2022-05-10T07:36:51+00:00","article:modified_time":"2022-05-10T07:36:51+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"103994","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":"default","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-02-09 18:13:21","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2022-05-10 07:37:42","updated":"2026-02-09 18:13:21","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\/103994","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=103994"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/103994\/revisions"}],"predecessor-version":[{"id":158887,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/103994\/revisions\/158887"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=103994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=103994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=103994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}