Help Center > > User Guide> Enterprise Change Approval> System Management> Instance Management

Instance Management

Updated at: Jun 09, 2021 GMT+08:00

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 drop 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.

    Supported DB instance types include RDS, GaussDB(for MySQL), ECS, and DDM.

  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
      Figure 1 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.

      Figure 2 Viewing collection logs

  6. On the Instance Management page, click Configure to edit the instance basic information.

    Figure 3 Editing instance basic information

  7. To disable or remove an instance, choose More > Disable or More > Remove.

    Figure 4 Disabling or removing an instance

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel