{"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\/hu\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","title":{"rendered":"Megjelent a Litestream, amely az SQLite adatb\u00e1zis replik\u00e1ci\u00f3s rendszer\u00e9t val\u00f3s\u00edtja meg","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Ben Johnson, a szerz\u0151je a BoltDB NoSQL t\u00e1rol\u00f3nak bemutatta a Litestream projektet, amely kieg\u00e9sz\u00edt\u00e9st ny\u00fajt az SQLite adatainak replik\u00e1l\u00e1s\u00e1hoz. A Litestream nem ig\u00e9nyel m\u00f3dos\u00edt\u00e1st az SQLite-ban, \u00e9s b\u00e1rmilyen alkalmaz\u00e1ssal kompatibilis, amely ezt a k\u00f6nyvt\u00e1rat haszn\u00e1lja. A replik\u00e1l\u00e1st egy k\u00fcl\u00f6n fut\u00f3 h\u00e1tt\u00e9rfolyamat v\u00e9gzi, amely nyomon k\u00f6veti az adatb\u00e1zis f\u00e1jljaiban v\u00e9gbemen\u0151 v\u00e1ltoz\u00e1sokat, \u00e9s azokat egy m\u00e1sik f\u00e1jlba vagy k\u00fcls\u0151 t\u00e1rol\u00f3ba \u00e1thelyezi. A projekt k\u00f3dja Go nyelven k\u00e9sz\u00fclt, \u00e9s Apache 2.0 licenc alatt \u00e1ll. <\/p>\n

Minden adatb\u00e1zissal val\u00f3 interakci\u00f3 a standard SQLite API-n kereszt\u00fcl t\u00f6rt\u00e9nik, azaz a Litestream k\u00f6zvetlen\u00fcl nem avatkozik be a m\u0171k\u00f6d\u00e9sbe, nem befoly\u00e1solja a teljes\u00edtm\u00e9nyt \u00e9s nem k\u00e1ros\u00edthatja az adatb\u00e1zis tartalm\u00e1t, ami a Litestreamt el\u0151ny\u00f6sen megk\u00fcl\u00f6nb\u00f6zteti az olyan megold\u00e1sokt\u00f3l, mint az Rqlite \u00e9s a Dqlite. A v\u00e1ltoz\u00e1sok a WAL-napl\u00f3 (\"Write-Ahead Log\") bekapcsol\u00e1s\u00e1val k\u00f6vethet\u0151k nyomon az SQLite-ban. A t\u00e1rhely hely\u00e9nek meg\u0151rz\u00e9se \u00e9rdek\u00e9ben a rendszer id\u0151szakosan aggreg\u00e1lja a v\u00e1ltoz\u00e1sfolyamot az adatb\u00e1zis szeleteibe (snapshotokba), amelyek f\u00f6l\u00e9 \u00fajabb v\u00e1ltoz\u00e1sok halmoz\u00f3dnak. A szeletek l\u00e9trehoz\u00e1s\u00e1nak idej\u00e9t a be\u00e1ll\u00edt\u00e1sokban lehet megadni, p\u00e9ld\u00e1ul szeleteket lehet k\u00e9sz\u00edteni naponta egyszer vagy \u00f3r\u00e1nk\u00e9nt. <\/p>\n

A Litestream f\u0151 alkalmaz\u00e1si ter\u00fcletei k\u00f6z\u00e9 tartozik a biztons\u00e1gos biztons\u00e1gi m\u00e1solatok k\u00e9sz\u00edt\u00e9se \u00e9s a terhel\u00e9s megoszt\u00e1sa az olvas\u00e1s sor\u00e1n. szerverek<\/a>. T\u00e1mogatott a v\u00e1ltoz\u00e1sok \u00e1tvitele az Amazon S3, Azure Blob Storage, Backblaze B2, DigitalOcean Spaces, Scaleway Object Storage, Google Cloud Storage, Linode Object Storage vagy b\u00e1rmely k\u00fcls\u0151 hosztra, amely t\u00e1mogatja az SFTP protokollt. Ha az alapadatb\u00e1zis tartalma megs\u00e9r\u00fcl, a biztons\u00e1gi m\u00e1solat vissza\u00e1ll\u00edthat\u00f3 egy megadott id\u0151pont \u00e1llapot\u00e1ra, egy adott v\u00e1ltoz\u00e1sra, az utols\u00f3 v\u00e1ltoz\u00e1sra vagy egy megadott pillanatfelv\u00e9telre.
\n
Forr\u00e1s: 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\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\udd47Bemutatva a Litestream az SQLite replik\u00e1ci\u00f3s rendszer megval\u00f3s\u00edt\u00e1s\u00e1val | ProHoster","description":"Ben Johnson, a szerz\u0151je a BoltDB NoSQL t\u00e1rol\u00f3nak bemutatta a Litestream projektet, amely kieg\u00e9sz\u00edt\u00e9st ny\u00fajt az SQLite adatainak replik\u00e1l\u00e1s\u00e1hoz.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/predstavlen-litestream-s-realizacziej-sistemy-replikaczii-dlya-sqlite","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/103994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=103994"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/103994\/revisions"}],"predecessor-version":[{"id":158887,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/103994\/revisions\/158887"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=103994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=103994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=103994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}