Questions tagged [clickhouse-backup]

6 questions
2
votes
1 answer

Authentication for clickhouse-backup commands

I have a clickhouse instance running wherein I have installed clickhouse-backup. I've connected to it and have no issues running clickhouse-client with a custom user like this: clickhouse-client -u fred --password 12345 but when I do a…
user15071072
1
vote
1 answer

How to correctly set a path to default config for clickhouse backup?

I'm setting up clickhouse-backup utility locally. I go through the installation steps and now I'm stuck on the step with changing settings for '.config.yml' file. I ran sudo ./clickhouse-backup create from the folder where I decompressed the utility…
vitaliis
  • 4,082
  • 5
  • 18
  • 40
0
votes
0 answers

Clickhouse database - backup - replica has part different from part on another replica - inconsistencies between the shards

While taking backup of clickhouse, it throws exception about inconsistencies between parts in different shards in different replica. BACKUP DATABASE default ON CLUSTER 'cluster-name' TO S3( …
Sairam Krish
  • 10,158
  • 3
  • 55
  • 67
0
votes
2 answers

Steps to migrate my clickhouse data from single node to replicated cluster

I am trying to find a way to move my data from single node standalone clickhouse to new replicated cluster. But there are no solid documents available to perform that. I tried to take backup from single node clickhouse and then tired to restore it…
0
votes
2 answers

Clickhouse-backup restore empty databases

Trying to setup clickhouse-backup according to this manual https://github.com/AlexAkulov/clickhouse-backup/blob/master/Examples.md#how-to-use-clickhouse-backup-in-kubernetes All look good to me but when I decided to wipe & restore to test - restore…
0
votes
2 answers

Clickhouse 2 Nodes Cluster (Keeper Replication)

Is a 2 nodes Clickhouse setup possible? If yes would it be bad or unreasonable? Most tutorials require a 3 node setup. For example the official documentation: https://clickhouse.com/docs/en/guides/sre/keeper/clickhouse-keeper I found this example…
MichaelRazum
  • 789
  • 1
  • 10
  • 26