Updated on 2023-12-27 GMT+08:00

Managing Databases and Agents

After adding a database successfully, you can view, disable or delete the database. After adding an agent to the database, you can view, disable or delete the agent.

Prerequisites

  • You have applied for a database audit instance and the Status is Running.
  • You have added a database successfully.
  • Before disabling a database, ensure that Audit Status of the database is Enabled.

Viewing the Database Information

  1. Log in to the management console.
  2. Select a region, click , and choose Security > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Databases.
  4. In the Instance drop-down list, select the instance whose database you want to view.
  5. View the database information. For details about related parameters, see Table 1.

    Figure 1 Viewing the database and agent information

    Select an audit status from the All audit statuses drop-down list in the upper right corner of the list, or enter a key word of a database to search for it.

    Table 1 Parameters

    Parameter

    Description

    Example Value

    Database Information

    Name, type, and version of a database

    -

    Character Set

    Encoding character set of the database

    UTF8

    IP Address/Port

    IP address of the database

    192.168.0.104

    3306

    Instance

    Database instance name

    -

    OS

    Operating system of the database

    LINUX64

    Audit Status

    Audit status of the database. The options are as follows:

    • Enabled
    • Disabled

    Enabled

    Agent

    Click Add to add an agent for the database.

    Add an agent.

    You can perform the following operations on a database you added:

    • Disable
      • Locate the row that contains the database to be disabled, click Disable in the Operation column, and click OK in the displayed dialog box. The Audit Status of the database will change to Disabled.
      • When a database is disabled, database audit is disabled for the database.
    • Delete
      • Locate the row that contains the database to be deleted, click Delete in the Operation column, and click OK in the displayed dialog box.
      • You need to add the database again if a database is deleted and you want to audit the database.

Viewing an Agent

  1. Log in to the management console.
  2. Select a region, click , and choose Security > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Databases.
  4. In the Instance drop-down list, select the instance whose agent you want to view.
  5. Click on the left of the database to expand the agent details, as shown in Figure 2. For details about related parameters, see Table 2.

    Figure 2 Viewing the database and agent information
    Table 2 Parameters of an agent

    Parameter

    Description

    Agent ID

    Agent ID, which is automatically generated

    Installing Node Type

    Type of the installing node. The options are Database and Application.

    Installing Node IP Address

    IP address of the node where an agent is installed

    OS

    Agent OS

    Audited NIC Name

    NIC name of an installing node

    CPU Threshold (%)

    CPU threshold of the installing node. The default value is 80.

    NOTE:

    The agent on a node will stop working if the CPU usage of the node exceeds this threshold. You can scale up CPU resources to avoid this problem.

    Memory Threshold (%)

    Memory threshold of the installing node. The default value is 80.

    NOTE:

    The agent on a node will stop working if the memory usage of the node exceeds this threshold. You can scale up memory resources to avoid this problem.

    General

    Whether an agent is a general-purpose agent.

    Status

    Running status of the installing node

    You can perform the following operations on an agent you added:

    • Disable
      • Locate the row that contains the agent to be disabled, click Disable in the Operation column, and click OK in the displayed dialog box. The status of the agent will change to Disabled.
      • When an agent is disabled, database audit is disabled for the associated database.
    • Delete
      • Locate the row that contains the agent to be deleted, click Delete in the Operation column, and click OK in the displayed dialog box.
      • After an agent is deleted, add another agent again if you want to audit the database.