Clickhouse - basic migrations support
Currently, we manage the Clickhouse database schema entirely by hand.
This has a few disadvantages:
- only a few people have access to do that
- it's error-prone
- it requires a lot of internal knowledge, so it will be very hard for self-managed users to adopt Clickhouse
We want to introduce a special rake task, that will run the migrations.
For the inspiration we can use:
- https://github.com/PNixx/clickhouse-activerecord/tree/master
- https://github.com/PNixx/clickhouse-activerecord/blob/master/lib/clickhouse-activerecord/migration.rb
-
Update the documentation in https://docs.gitlab.com/ee/development/database/clickhouse/clickhouse_within_gitlab.html
This will not address:
- Rollbacks
- Automatically running the migrations during GitLab upgrades
Those things will be be addressed on the next stage: ClickHouse adoption - Stage 3 - self-managed op... (&11721)
Edited by Vladimir Shushlin