search

aws-quickstart / quickstart-clickhouse-cluster

AWS Quick Start Team
Apache License 2.0
14 stars 16 forks source link

Testing connection from client #56

Open thespamer opened 1 year ago

thespamer commented 1 year ago

Hello all!

I just did everything from quickstart tutorial, all cloudformatio nare up and running, and now I'm able to ssh on clickhouseAdminClient EC2.

What are next steps to connect this clusters? from this ec2 client I just can:

1- connect into all clickhouse nodes with success: clickhouse-client --host 10.0.0.109 --password mypassword

2- second node: clickhouse-client --host 10.0.0.110 --password mypassword

But when I created a database on one of them, the database are not listing in the another host.

my question is... which address should I send to developers to user this cluster properly?

qiaow02 commented 1 year ago

Thanks for the feedback. The solution follows some best practices of ClickHouse. It is recommended to write data directly to the shards of each computing node, and queries are performed across nodes through distributed tables. The solution will create a sample table and import the sample data when set the Demonstration data size to small in the CloudFormation parameter, you can refer to it or the ClickHouse’s official website. https://github.com/aws-quickstart/quickstart-clickhouse-cluster/blob/main/scripts/create-table-demo.sql