https://signoz.io logo
#support
Title
# support
a

Alexei Zenin

08/03/2022, 10:55 PM
Just noticed in my custom clickhouse cluster that the SigNoz tables are not created on every node, what is the recommended approach to get all the tables to align across all the Clickhouse nodes? I’m trying to get HA but have noticed most of the push is to run 1 instance of clickhouse atm. Does that scale well, is a cluster overkill?
never worked with Clickhouse but surprised they don’t replicate DDL: https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/replication/
a

Ankit Nayan

08/04/2022, 4:21 AM
hey @Alexei Zenin we have not enabled replicated mergetree till now. Though it is planned in soon.
how many spans/s do you expect to write to clickhouse? We tested with 500K spans/s ingestion into single clickhouse instance which consumed around 10-15 CPUs
ReplicatedMergeTree is recommended even for that load to enable data redundancy and reduce single point of failure.
Let us know if you must move to ReplicatedMergeTree very soon, we might help with that too else it will come as planned within 2 months
a

Alexei Zenin

08/04/2022, 1:03 PM
I see, it should be fine I think. Wasn't aware of the hard limitation that SigNoz can only use 1 clickhouse instance at the moment. Thanks for clarifying
Only concern is HA of our setup and if the node goes down. Concerning that all of our observabilty could disappear due to 1 machine. For PROD readiness I would definitely expect an HA setup.
3 Views