Add support to replicated clickhouse cluster
Author: jderusseCreated Dec 11, 2024Updated Sep 4, 2026
Labelsclickhouseup next
When running goose on a clickhouse cluster, it fails to get the list of "previous" migrations (sometime querying a node a get a partial list of migrations)
Possible fix:
- change the engine
- ENGINE = MergeTree()
+ ENGINE = ReplicatedMergeTree('/clickhouse/{cluster}/tables/{shard}/{database}/{table}', '{replica}')Not sure how this can be defined in goose via the CreateTable function (or should it be a new driver ? :thinking: )
Source: pressly/goose