FQDNs of ClickHouse® hosts
To connect to a host, you need its fully qualified domain name (FQDN). You can use the FQDN of a particular host in the cluster or a special FQDN always pointing to the available host.
Host FQDN example:
rc1a-goh2a9tr********.mdb.yandexcloud.net
Getting host FQDN
You can obtain the ClickHouse® host FQDN by doing one of the following:
-
Look up the FQDN in the management console:
- Go to the cluster page.
- Go to Hosts.
- Copy the Host FQDN column value.
-
In the management console, copy the command for connecting to the cluster. This command contains the host FQDN. To get the command, go to the cluster page and click Connect.
-
Request a list of cluster hosts using the CLI or API.
Selecting an available host automatically
To avoid connecting to another host manually if the current one becomes unavailable, use a special FQDN. It can be in one of the following formats:
-
c-<cluster_ID>.rw.mdb.yandexcloud.net: To connect to an available cluster host. -
<shard_name>.c-<cluster_ID>.rw.mdb.yandexcloud.net: To connect to an available shard host.
If the host an FQDN points to becomes unavailable, there may be a slight delay before the FQDN starts pointing to another available host.
Warning
If, during cluster maintenance, a special FQDN points to a host without public access, the cluster will not be available for connection from the internet. To avoid this, enable public access for all cluster hosts.
ClickHouse® is a registered trademark of ClickHouse, Inc.