Simple replication with clickhouse

[Pramod Jadhav]

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]

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]

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]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/1128b780-6f53-46f4-a277-2c1c0d4e17e7n%40googlegroups.com.