I am really really thankful for your help.
1. I am using three nodes (2 Cpu , 4 GB RAM for each node)
2. I was able to set up zookeeper and it is up and running (3 nodes). Could you please what is wrong with below query?
CREATE DATABASE FIRST_DB [ON CLUSTER demo-01] ENGINE = ReplicatedMergeTree();
error: DB::Exception: Syntax error: failed at position 27 ('['): [ON CLUSTER demo-01] ENGINE = ReplicatedMergeTree(). Expected one of: storage definition, ENGINE, end of query, UUID, INTO OUTFILE, SETTINGS, ON, FORMAT (version 22.214.171.124.altinitystable (altinity build))
3. How do I know that the clickhouse pods/nodes are linked to zookeeper and how to test if the replication is happening and where/how to see the replicas?
4. As of now, we have 3.5 billion records in some on premises Ubuntu system. Once the setup is done, I need to migrate it. What would be your suggestion on this "What would be best number of zookeeper nodes, replicas and shards for my cluster?"
Kindly help me with the above questions.