Simple replication with clickhouse

Skip to first unread message

Pramod Jadhav

Jun 22, 2023, 1:27:33 AM6/22/23
to ClickHouse
Is there any simple replication option with clickhouse? Just wanted to replicate in master / slave configuration.

One clickhouse instance will be master, used for writing only & second, as slave for reading only.
We have already large volume of data in one instance (will be a master) so we are bit skeptical about using distributed tables & updating existing queries to use distributed tables instead of local tables.


Alexey Milovidov

Jun 22, 2023, 6:20:07 PM6/22/23
to Pramod Jadhav, ClickHouse
Hi! You don't have to create distributed tables. On a single-shard scenario with a few replicas, you create Replicated tables and query directly.

You received this message because you are subscribed to the Google Groups "ClickHouse" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit

Jun 22, 2023, 7:52:54 PM6/22/23
to ClickHouse
Is this completely accurate as a solution?  Is there a concept of a read only replica within Clickhouse's replication or is that something that would need to be enforced via user account permissions and the use of a different user on the "read only" replica?

Alexey Milovidov

Jun 22, 2023, 8:15:52 PM6/22/23
to, ClickHouse
There is no notion of a read-only replica. You can make a replica invisible to your load balancer and applications, or allow only read-only queries in the configuration.

Reply all
Reply to author
0 new messages