I've noticed that with Flyway Database ClickHouse, it is possible for a single migration to be applied multiple times (I have clickhouse connection in multiple services)
I'm aware that ClickHouse does not support transactions. Does this require external locking to apply migrations?