{"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\/et\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","title":{"rendered":"Litestream on esitatud SQLite'i replikatsioonis\u00fcsteemi rakendusega.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Ben Johnson, BoltDB NoSQL-andmete salvestustehnoloogia autor, tutvustas projekti Litestream, mis pakub lisakihti andmete replikatsiooni korraldamiseks SQLite'is. Litestream ei n\u00f5ua SQLite'is muudatusi ja saab t\u00f6\u00f6tada igasuguste rakendustega, mis seda teeki kasutavad. Replikatsioon toimub eraldi t\u00f6\u00f6tava taustaprotsessi kaudu, mis j\u00e4lgib andmebaasifailides toimuvaid muudatusi ja edastab need teise faili v\u00f5i v\u00e4lisse salvestusse. Projekti kood on kirjutatud keeles Go ja levitatakse Apache 2.0 litsentsi alusel. <\/p>\n

Kogu suhtlus andmebaasiga toimub standardse SQLite API kaudu, st Litestream ei sega otseselt t\u00f6\u00f6d, ei m\u00f5juta j\u00f5udlust ega saa andmebaasi sisu kahjustada, mis eristab Litestream'i sellistest lahendustest nagu Rqlite ja Dqlite. Muudatusi j\u00e4lgitakse WAL-logi (\"Write-Ahead Log\") aktiveerimise kaudu SQLite's. Ruumi kokkuhoiu eesm\u00e4rgil koondab s\u00fcsteem perioodiliselt muudatuste vooge andmebaasi l\u00f5igudesse (snapshot'id), millele hakkavad kogunema uued muudatused. L\u00f5ikude loomise aeg m\u00e4\u00e4ratakse seadetes, n\u00e4iteks saab l\u00f5ike luua kord p\u00e4evas v\u00f5i kord tunnis. <\/p>\n

Litestreami peamised rakendusalad h\u00f5lmavad turvalise varundamise korraldamist ja lugemise koormuse jagamist mitme vahel. serverite<\/a>Toetatakse muutuste voogude edastamist Amazon S3, Azure Blob Storage, Backblaze B2, DigitalOcean Spaces, Scaleway Object Storage, Google Cloud Storage, Linode Object Storage v\u00f5i igale v\u00e4lisele hostile, mis toetab SFTP protokolli. Andmebaasi sisu kahjustumise korral saab varukoopia taastada m\u00e4\u00e4ratud ajahetke, kindla muudatuse, viimase muudatuse v\u00f5i m\u00e4\u00e4ratud l\u00f5ike seisundisse.
\n
Allikas: 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\udd47Tutvustatud Litestream SQLite replikatsioonis\u00fcsteemiga | ProHoster","description":"Ben Johnson, BoltDB NoSQL-panga autori, esitles projekti Litestream, mis pakub laiendust andmete replikatsiooni korraldamiseks SQLite's.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","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\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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/103994","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=103994"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/103994\/revisions"}],"predecessor-version":[{"id":158887,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/103994\/revisions\/158887"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=103994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=103994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=103994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}