Add Database Monitoring

SuperMap iManager supports to add Database monitoring, please follow the steps below:

  1. Log in SuperMap iManager, click Database Monitoring on the left navigation bar.
  2. Click Add Database Monitoring on the top left connor of the page.
  3. Fill in the following information according to the different types of database:

  • MySQL

    addMySQLMonitoring

    • Name(Required): Customize the name of database monitoring.
    • Database Type(Required): MySQL.
    • Address(Required): The address of MySQL, the format is {ip}:{port}, for example, 192.168.11.120:3306.
    • Database: The name of database in MySQL.
    • Username(Required): The username of accessible account.
    • Password(Required): The password of accessible account.

    Notes:
    If you are not using administrator account of MySQL database, please execute the following command in the database: sh grant replication client,process on *.* to "supermap"; grant select on performance_schema.* to "supermap"; flush privileges;

  • Oracle

    addOracleMonitoring

    • Name(Required): Customize the name of database monitoring.
    • Database Type(Required): Oracle.
    • Address(Required): The address of Oracle, the format is {ip}:{port}, for example, 192.168.11.120:30620.
    • Instance: The name of instance in Oracle. A database instance is a set of memory structures that manage database files.
    • Username(Required): The username of accessible account.
    • Password(Required): The password of accessible account.

  • PostgreSQL

    addPostgreSQLMonitoring

    • Name(Required): Customize the name of database monitoring.
    • Database Type(Required): PostgreSQL.
    • Address(Required): The address of PostgreSQL, the format is {ip}:{port}, for example, 192.168.11.120:30976.
    • Database: The name of database in PostgreSQL.
    • Username(Required): The username of accessible account.
    • Password(Required): The password of accessible account.

  • MongoDB

    addMongoDBMonitoring

    • Name(Required): Customize the name of database monitoring.
    • Database Type(Required): MongoDB.
    • Address(Required): The address of MongoDB, the format is {ip}:{port}, for example, 192.168.11.120:30163.
    • Database: The name of database in PostgreSQL.
    • Username: The username of accessible account.
    • Password: The password of accessible account.

  • KingbaseES

    addKingbaseMonitoring

    • Name(Required)：Customize the name of database monitoring.
    • Database Type(Required)：KingbaseES.
    • Address(Required)：The address of KingbaseES, the format is {ip}:{port}, for example, 172.16.112.145:32209.
    • Database(Required)：The name of database in KingbaseES.
    • Username(Required)：The username of accessible account.
    • Password(Required)：The password of accessible account.

  • HighGo DB

    addHighgoMonitoring

    • Name(Required): ustomize the name of database monitoring.
    • Database Type(Required)：HighGo.
    • Address(Required)：The address of HighGo DB, the format is {ip}:{port}, for example, 172.16.120.128:5866。
    • Database(Required)：The name of database.
    • Username(Required)：The username of accessible account.
    • Password(Required)：The password of accessible account.
  1. Click on OK to finish adding the URL Monitoring.

Related