Manage tenant parameter templates

A tenant parameter template contains predefined tenant parameters. You can use a parameter template to create a series of tenants that have similar configurations without repeatedly configuring tenant parameters.

Prerequisites

The logged-on user in the OceanBase Cloud Platform (OCP) console has the permission to create a tenant .

Procedure

1. Log on to the OCP console. The Tenants page automatically appears.

2. In the left-side navigation pane, select Tenants. The Tenants tab automatically appears.

3. Click the Parameter Template tab to view the tenant parameter template list. If no tenant is available in the current cluster, click Tenant Parameter Template Management to create a tenant parameter template.

   

   Note

   If you do not have the permission to create a tenant, the button Tenant Parameter Template Management is not displayed.

4. On the Tenant Parameter Template Management page, you can query a parameter template, create a parameter template, edit a parameter template, copy a parameter template and delete a parameter template.

Create a parameter template

1. On the Tenant Parameter Template Management page, click Create Parameter Template .

2. On the Create the tenant parameter template page, name the template and set parameters in it.

   You can click Add Parameter to add parameters and set parameter values.

   

3. Click Submit .

   Note

   Some parameters are applicable only to tenants in Oracle mode, and cannot be used by tenants in MySQL mode.

Edit a parameter template

1. On the Tenant Parameter Template Management page, click Edit .

2. On the Edit the tenant parameter template page, modify the template name and parameters as needed.

3. Click Submit .

Copy a parameter template

You can copy a complex template named A, and rename the template to B. In this way, you do not need to repeatedly set parameters in template B, and need to make only required modification.

1. On the Tenant Parameter Template Management page, find the target template in the Tenant Parameter Templates list, and click Copy in the Actions column.

2. On the Copy the Tenant Parameter Template page, rename the template and modify parameters in the template as needed.

3. Click Submit .

Delete a parameter template

1. On the Tenant Parameter Template Management page, find the target template in the Tenant Parameter Templates list.

2. Click Delete in the Actions column.

3. Click OK in the dialog box that appears.

Query a parameter template

1. On the Tenant Parameter Template Management page, specify the template name in the search box above the Tenant Parameter Templates list.

2. Click . The query results appear in the Tenant Parameter Templates list.