Network and DB clusters in Yandex MPP Analytics for PostgreSQL

When creating a cluster, you can:

• Set network and subnet for the cluster.
• Enable public access to connect to the cluster from outside Yandex Cloud.

You can only connect to Greenplum® clusters via master hosts. You cannot connect to segment hosts directly.

Segment hosts are combined into a virtual network, where each of them is a cloud resource. Data is replicated and rebalanced across the segments within this network.

By default, master hosts are available for connection from the VMs located in the same cloud network. For more information about networking, see the Yandex Virtual Private Cloud documentation.

Host name and FQDNHost name and FQDN

When you create a cluster, Yandex MPP Analytics for PostgreSQL automatically assigns its hosts both short and full (FQDN) names. These cannot be changed.

To learn how to get a host FQDN, see this guide.

You can use FQDNs to access master hosts from both inside and outside Yandex Cloud.

Public access to clustersPublic access to clusters

To enable public access to master hosts from outside Yandex Cloud, enable Public access when creating or updating your cluster. To connect to a cluster, use the FQDNs of its master hosts.

Security groupsSecurity groups

Specifics of working with security groups:

• To connect to a cluster, you need rules that allow traffic between the cluster and the connecting host, even if they are in the same security group.

• Security group settings affect the ability to connect to the cluster, its performance, and the network connectivity between its hosts.

For more information, see this Virtual Private Cloud guide.

Use casesUse cases

• Creating an external table from a Yandex Object Storage bucket table using a configuration file

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.