Is there any way to run Signoz without ClickHouse ...
# support
d
Is there any way to run Signoz without ClickHouse in cluster mode with Zookeeper?
p
do you want to add. your own clickhouse @Dave Lahn?
d
We have set up a standalone ClickHouse.
p
d
We aren't used K8s. We are setting this up in ECS/Fargate, so we are bringing up all of the individual elements.
It seems the SigNoz otel-collector must have a cluster called "cluster" in ClickHouse. Is this right? But then does this make Zookeeper absolutely required?
It doesn't seem like ClickHouse explicitly requires ZK.. so I don't want to add any unnecessary dependencies.
s
It seems the SigNoz otel-collector must have a cluster called “cluster” in ClickHouse
Yes
It doesn’t seem like ClickHouse explicitly requires ZK.. so I don’t want to add any unnecessary dependencies.
If you want to use external clickhouse you should be able to do it. Let me share the docs for it.
p
d
@Pranay This isn't the correct doc. This is just how to connect to ClickHouse.
p
Ok, will let Srikanth get back
d
In your docker-compose example, you have something like this:
Copy code
<?xml version="1.0"?>
<clickhouse>
    <remote_servers>
        <cluster>
            <shard>
                <replica>
                    <host>localhost</host>
                    <port>9000</port>
                </replica>
            </shard>
        </cluster>
    </remote_servers>
</clickhouse>
This makes "cluster" in ClickHouse... but then, I believe ZK is required?
s
ZK that comes with SigNoz installation is not required if you want to use external ClickHouse. It’s main purpose is to provide coordination system for distributed ClickHouse. But if you want to use SigNoz there should be cluster called
cluster
so you may already have zk or clickhouse keeper on your ClickHouse server.
d
So I must have ZK or Keeper to back my ClickHouse.
s
Yes, the distributed ClickHouse setup requires zookeeper or clickhouse-keeper.
d
Ok. And since you require "cluster", I have to have a distributed ClickHouse, even though I only have 1 ClickHouse.
s
Let me share the docs for it.
Unfortunately, there is no written documentation around this. You can disable the ClickHouse and setup the appropriate values for externalClickHouse. And use the override-values to apply the custom config.
d
The easy solution for this was to enable the ClickHouse Keeper configuration within ClickHouse.
It starts it as a part of the service, and then I don't need an external ZK
p
Nice, were you able to make this work for your setup? @Dave Lahn