Run ClickHouse locally, then take it to production.
Recent revisions are kept. Restoring one creates a new revision.