Instance Management

Prerequisites

You have the DBA or system administrator role.

Procedure

1. On the top menu bar, choose System Management > Instance Management to go to the instance management page.
2. Click Add Instance in the upper left corner.
3. On the displayed page, set instance information.

   Table 1 Basic information

   Parameter	Description
   Region	Select the region where all instances of your account are located.
   Select Instance	List the instances that can be added by the current account.

   Table 2 Instance properties

   Parameter	Description
   Environment Type	Select Test or Production.
   Instance DBA	Select the DBA of the current instance.
   Service Owner	Select the service owner of the current instance.
   Remarks	Enter the instance description.

   Table 3 Security control items

   Parameter	Description
   Query Timeout Duration (s)	Set it based on your service requirements.
   Maximum Number of Rows Returned in a Query	Set it based on your service requirements.
   Allow DML Execution in SQL Window	Data manipulation language (DML) is a SQL language used to operate data in the database. INSERT, DELETE, UPDATE, and SELECT are sample DML statements. Determine whether to enable Allow DML Execution in SQL Console based on your service requirements.
   Allow DDL Execution in SQL Window	Data definition language (DDL) is a SQL language used to manage certain database objects, such as databases and tables. CREATE, ALTER, and DROP are sample DDL statements. Determine whether to enable Allow DDL Execution in SQL Console based on your service requirements.

   Table 4 Approval process management

   Parameter	Description
   Enable Instance Approval Process Management	After enabled, permission applications related to this instance will be processed based on defined approval processes.
   During Database Permission Application	Approval process for database permission application.
   During Data Modification	Approval process for data modification. DML statements are mainly involved.
   During Structure Modification	Approval process for structure modification. DDL statements are mainly involved.
   During O&M	Approval process for O&M. DCL statements, including querying sessions, kill sessions, and create users, are mainly involved.
   During Data Export	Approval process for data export.
   During High-Risk Operation	Approval process for high-risk operations. High-risk operations mainly involve dropping databases, truncating tables, and dropping users.

   

   Process approval management items of an instance are set to default settings when databases are synchronized. Approval process settings on the database are used.

4. After settings are complete, click OK.
5. On the Instance Management page, view information about existing instances, such as the environment type, instance name, and DB engine. You can also perform the following operations.
   • Edit

     Click Edit in the Operation column. In the displayed dialog box, view the basic information about the current instance and edit the parameters listed in Table 5. After settings are complete, click OK.

     Table 5 Editable instance information

     Parameter	Description
     Username	Database name.
     Password	Password for logging in to the database.
     Environment Type	Test environment or production environment
     Instance DBA	Instance O&M personnel
     Service Owner	Service operator of the instance

   • Synchronize Dictionary

     Generally, metadata is automatically collected once a day. Click Synchronize Dictionary in the Operation column or in the upper left corner of the page to collect the data of databases, tables, and columns in the instance to DAS.

     Click the Metadata Collection tab under Database Management. On the displayed page, click View Details in the Operation column.

6. On the Instance Management page, click Configure to edit the instance basic information.
7. To disable or remove an instance, choose More > Disable or More > Remove.