Getting started with Managed Service for ClickHouse

    To use the service, create a cluster and connect to a DBMS:

    1. All you need to create a database cluster is a folder in Yandex.Cloud that you are allowed to access. If you already have a folder in Yandex.Cloud, open the page of that folder in the management console. If there is no folder yet, create one:

      1. Click Create folder in the Home page of the management console.

      2. Enter the folder name.

        The name must be unique within the folder. The name may contain lowercase Latin letters, numbers, and hyphens. The first character must be a letter. The last character can't be a hyphen. The maximum length of the name is 63 characters.

      3. Select Create a default network. A network is created with subnets in each availability zone.

      4. Click Create folder.

    2. You can connect to DB clusters from both inside and outside of the Cloud:

      1. To connect to a DB cluster from inside the Cloud, create a VM in the same network as the DB cluster (based on Linux or Windows)

      2. To enable connection to a cluster over the internet, request external IP addresses for hosts when creating the cluster.

    3. In the management console, select the folder where you want to create a DB cluster.

    4. Click Create resource and select ClusterClickHouse.

    5. Set the cluster parameters and click Create cluster. This process is described in detail in Creating ClickHouse clusters.

    6. When the cluster is ready, its status on the Managed Service for ClickHouse dashboard will change to RUNNING.

    7. To connect to the DB server, you need an SSL certificate. Download it:

      $ wget "https://storage.yandexcloud.net/cloud-certs/CA.pem"
      
    8. Send a request specifying the path to the received SSL certificate, database attributes, and the request text in urlencoded format:

      $ curl --cacert <path to the SSL certificate> \
           -H "X-ClickHouse-User: <DB username>" \
           -H "X-ClickHouse-Key: <DB user password>" \
           'https://<host address>:8443/?database=<DB name>&query=SELECT%20now ()'