{"repo":"yandex/ch-backup","free":true,"listed":false,"github":"https://github.com/yandex/ch-backup","clone":"git clone https://github.com/yandex/ch-backup.git","description":"Backup tool for ClickHouse DBMS","language":"Python","stars":49,"topics":["clickhouse"],"license":"MIT","category":"data-pipelines","readme_excerpt":"ch-backup Backup tool for ClickHouse DBMS. It allows to perform backups to S3 compatible storage and restore from backup data in the case of original data corruption. Backup is performed for tables of MergeTree engine family only as these are the only tables that support consistent data snapshots without server shutdown. The tool also supports deduplication at part-level granularity. It's set up through configuration file and enabled by default. Installation In order to get an up-to-date version of ch-backup, run make build . It will produce a Python wheel (.whl) package that can be installed using pip install or uv tool install . Example Usage Testing Regression The regression test suite contains run of static code analysis tools (isort, black, codespell, ruff, pylint, mypy), unit tests and integration tests. The tests can be run by issuing the command: Manual The following steps describe how to set up testing infrastructure on top of ClickHouse and Minio (open source S3-compatible storage server) docker containers. 1. Create and run docker containers. 2. Log in to ClickHouse docker container and you are all set to issue ch-backup commands. Note: There are no prepopulated data in ClickHouse. So you need to insert some data yourself in order to make non-zero backup. Testing new versions Unit tests Unit tests are implemented based on pytest testing framework. The tests can be run as a part of regression test suite with make all or separately with make test-unit . Additionally,","default_branch":null,"files":null,"tree":[],"storefront":"/r/yandex","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/yandex/ch-backup/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}