Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Setup replication on production clickhouse instance #111

Closed
hellais opened this issue Oct 24, 2024 · 2 comments
Closed

Setup replication on production clickhouse instance #111

hellais opened this issue Oct 24, 2024 · 2 comments
Assignees
Labels
funder/drl2022-2024 priority/high Important issue that needs attention soon

Comments

@hellais
Copy link
Member

hellais commented Oct 24, 2024

There is a scheduled downtime for backend-fsn set for:

Start:	2024-12-05, 03:30 AM UTC
Estimated end:	2024-12-05, 05:30 AM UTC

We should use this as an opportunity and motivation to setup replication between backend-fsn and backend-hel so that we can be fault tolerant to these kinds of downtimes.

Relevant bits of documentation are:

We also need to run a dedicated clickhouse-zookeeper instance in addition to one on the two replicas. It's probably good to set that up on the monitoring host since the memory requirements are relatively light compared to clickhouse.

@hellais hellais added the priority/high Important issue that needs attention soon label Oct 24, 2024
@hellais
Copy link
Member Author

hellais commented Nov 15, 2024

This is being setup inside of #112 as part of the work to get Pipeline v5 into production. Once it's finished we should move the fastpath clickhouse database over and set it up as a replicated table.

I wrote some notes on this can be done here: https://github.com/ooni/devops/blob/prod-pipeline-v5/docs/merge-tree-replication.md

@hellais
Copy link
Member Author

hellais commented Jan 6, 2025

While we didn't manage to get everything ready for the expected downtime, we did end up deploying a clickhouse cluster which should eventually be used to provide better availability to the backend-fsn host.

This is closed by: #112

@hellais hellais closed this as completed Jan 6, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
funder/drl2022-2024 priority/high Important issue that needs attention soon
Projects
None yet
Development

No branches or pull requests

3 participants