aws-ia / cfn-ps-clickhouse-cluster Goto Github PK

Getting "Parameter AlarmEmail failed to satisfy constraint: Incorrect email address" error, when trying to deploy into a new VPC. But there weren't any option to specify AlarmEmail parameter beforehand

Suppose I have gone through everything from step1 to step6:

https://aws-ia.github.io/cfn-ps-clickhouse-cluster/

when I got to the final step step6 try to start clickhouse-client it received the following error:

[ec2-user@ip-xx-x-xx-xxx ~]$ clickhouse-client
ClickHouse client version 23.3.8.21 (official build).
Connecting to localhost:9000 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9000). (NETWORK_ERROR)

When I tried to check the server status I received the following:

[ec2-user@ip-xx-x-xx-xxx ~]$ service clickhouse-server status
Redirecting to /bin/systemctl status clickhouse-server.service
Unit clickhouse-server.service could not be found.

I can't even ping my bastion host using its public IP. It seems perhaps the security group is wrong? Couldn't also connect from the console with ec2 connect.

I know we can deploy clickhouse using this solution on aws console. But my whole infrastructure is managed using terraform.
Is there an terraform module for this solution?

I am unclear about how I (or one of my apps) is supposed to connect to the database.

Hi

The repo is great, I wanted to know some questions about the cluster.

Whats the default password of clickhouse?

Can i use only 1 or 2 zookeeper nodes, 3 seems high for 2 clickhouse nodes? Can i reduce down zookeeper nodes to small like t2.small?

I see only one clickhouse node is attached to load balancer. for eg if i have to connect to kafka which node do i connect to inside a vpc to able to connect to cluster?

Also does ClickHouseAdminClient need to be same size as clickhouse node

Thanks again for the help?