Configuration for ClickHouse on SaaS
Summary
We're working on several PoCs related to the ClickHouse database (https://gitlab.com/gitlab-com/www-gitlab-com/-/issues/34299) and to move forward from local development to production-like environments we'd like to configure the config/click_house.yml
file on the application nodes (web, sidekiq).
For now, this would only mean SaaS however, sometime later we might need to provide the same configuration capability on self-managed instances.
Configuration used
Here is the example YML file in the gitlab
repository: https://gitlab.com/gitlab-org/gitlab/-/blob/master/config/click_house.yml.example?ref_type=heads
The configuration supports multiple databases similarly to the standard database.yml
file. For now, we'll only support one database called main
which has 4 configuration options:
production:
main:
database: gitlab_clickhouse_test
url: 'http://localhost:8123'
username: clickhouse
password: clickhouse
The environment-specific will be provided by @sgoldstein.
Expected outcome
The config/click_house.yml
file is available on staging (staging.gitlab.com) and production (gitlab.com).