Load data to specified replica

[xichenAiguang]

Is it possible to load data to specified replica over http request? I have a Clickhouse cluster, which has 3 partitions, and each partition has 3 replicas. I would like always write / read data to replica0 for each partition, wondering is it possible for this scenario by using Clickhouse.Client?

[MikeAmputer]

I might be wrong, but isn't it enough to just specify the replica0 host address in the connection string?

Here’s an example of writing and reading data from specific hosts for distributed tables (but not replicated):
Example.Distributed - this contains a test cluster setup with docker-compose file and table creation migrations.

If you need to segregate write and read logic across specific hosts, the ClickHouse.Facades package might be a good fit. Let me know if you need any help - I’d be happy to assist! Also, if you’d like me to test your specific case with an additional example, just let me know.