Simple replication with clickhouse

201 views
Skip to first unread message

Pramod Jadhav

unread,
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.

Thanks,
Pramod 

Alexey Milovidov

unread,
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 clickhouse+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/1077e43d-7221-4d83-9177-2e0cba42512bn%40googlegroups.com.

adi...@mux.com

unread,
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

unread,
Jun 22, 2023, 8:15:52 PM6/22/23
to adi...@mux.com, 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
Forward
0 new messages