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	Enter a name for the cluster. The name can contain Chinese characters, letters, digits, underscores (_), and hyphens (-). The name can be up to 128 characters long.
     Cluster Administrator	Select one or more members from the current tenant to be cluster administrators. Cluster administrators can manage the cluster. They can download files, edit the cluster, view historical versions, and delete the cluster.
     Description (Optional)	Enter a brief description of the cluster. The description can be up to 128 characters long.

   • Cluster security control

     Usable by: Specifies which users can reference the cluster configuration when creating a new compute source. You can 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. The default value is 7.x.
     JDBC URL	Enter the JDBC URL. The format is jdbc:postgresql://{host}:{port}/.
     Default Execution User, Password	Enter the username and password for authentication. To ensure that nodes run correctly, make sure the user has the required database permissions.

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 list of ADB PG clusters. The list displays information such as Cluster name, Cluster administrator, Associated compute sources, Creation information, and Modification information.

   • Associated Compute Sources: Displays the total number of associated compute sources. Click the icon to view the list of associated compute sources. Click a compute source name to go to the compute source page.

   • Creation Information: Displays the user who created the cluster and the creation time.

   • Modification Information: Displays the username of the user who last edited the cluster and the modification time.

   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 of the ADB PG cluster list, you can perform management operations on the target cluster. The supported operations are as follows.

   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. The system automatically clones all data of the current cluster and opens the New ADB PG Cluster page. 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. A dialog box appears and displays the version information of the cluster, 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.