Dataphin:Create and manage ADB PG clusters

Permissions

• All system roles except for tag business specialists and business members, and custom global roles with the Cluster - View permission, can view the details of each cluster.

• Super administrators, system administrators, and custom global roles with the Cluster - Manage permission can create and manage ADB PG clusters. These users can also specify which users can reference the cluster when creating an ADB PG compute source and assign cluster administrators to the cluster.

• Cluster administrators can manage the clusters for which they are responsible.

Create an ADB PG cluster

1. In the top menu bar of the Dataphin home page, choose Planning > Compute Source.

2. On the Compute Source page, click Manage ADB PG Cluster.

3. In the Manage ADB PG Cluster dialog box, click + New ADB PG Cluster.

4. On the New ADB PG Cluster page, configure the following parameters.

   • Basic information

     Parameter	Description
     Cluster Name	The cluster name. It can contain Chinese characters, letters, digits, underscores (_), and hyphens (-), up to 128 characters.
     Cluster Administrator	Select one or more tenant members as cluster administrators. Cluster administrators can download files, edit the cluster, view historical versions, and delete the cluster.
     Description (Optional)	A brief description of the cluster, up to 128 characters.

   • Cluster security control

     Usable by: Controls which users can reference this cluster when creating a compute source. Select Roles With "Create Compute Source" Permission or Specified Users.

     • Roles With "Create Compute Source" Permission: Selected by default.

     • Specified Users: You can select one or more personal accounts and user groups.

   • Cluster configuration

     Parameter	Description
     Version	Select 7.x or 6.x. Default: 7.x.
     JDBC URL	The JDBC URL in the format jdbc:postgresql://{host}:{port}/.
     Default Execution User, Password	The username and password for authentication. Ensure the user has the required database permissions so that compute nodes run correctly.

5. Click Test Connection. After the connection test is successful, click Save to create the ADB PG cluster.

Manage ADB PG clusters

1. In the top menu bar of the Dataphin home page, choose Planning > Compute Source.

2. On the Compute Source page, click Manage ADB PG Cluster.

3. In the Manage ADB PG Cluster dialog box, view the cluster list. The list shows the cluster name, cluster administrator, associated compute sources, creation information, and modification information.

   • Associated Compute Sources: Shows the total number of associated compute sources. Click the icon to view the list, and click a compute source name to go to its details page.

   • Creation Information: Shows the creator and creation time.

   • Modification Information: Shows who last edited the cluster and when.

   Note

   A compute node can run in only one cluster. Data from different ADB PG clusters cannot be joined.

4. (Optional) In the search box, enter a cluster name to perform a fuzzy search.

5. In the Actions column, perform the following operations on a cluster.

   Operation	Description
   View	In the Actions column of the target cluster, click the icon to view the details of the current version of the cluster.
   Edit	In the Actions column of the target cluster, click the icon to open the page for editing the ADB PG cluster. On this page, you can modify the existing configurations. After you finish, click Save. In the dialog box that appears, enter a Change Description and click OK.
   Clone	In the Actions column of the target cluster, click the icon. All data of the current cluster is cloned and the New ADB PG Cluster page opens. You can modify the configurations based on the cloned settings.
   History	In the Actions column of the target cluster, click the icon and select History. The dialog box shows version information, including the version name, modifier, and change description. You can View and Compare historical versions. View: In the Actions column of the target version, click the icon to go to the View ADB PG Cluster page and view the details of that version. Compare: In the Actions column of the target version, click the icon to go to the version comparison page. From the drop-down list on the comparison page, select a different version to compare. By default, the current version of the ADB PG cluster is compared with the target version.
   Delete	Note You can delete a cluster only if it has no associated compute sources. A deleted cluster cannot be restored. In the Actions column of the target cluster, click the icon and select Delete. In the dialog box that appears, click OK.