All Products
Search

This Product

    Data Management:Customize and block system databases in DMS

    Document Center

    Data Management:Customize and block system databases in DMS

    Last Updated:Mar 30, 2026

    After you register instances with Data Management Service (DMS), DMS automatically collects metadata from all databases in those instances. To prevent system databases — such as MySQL's information_schema — or sensitive business databases from being indexed and visible in the DMS console, configure a security rule that excludes them from metadata collection. Blocked databases are hidden from instance lists and search results across the console.

    Note

    For PostgreSQL instances, blocking an instance blocks its schemas.

    Prerequisites

    Before you begin, ensure that you have:

    • A database instance managed in Security Collaboration mode

    Usage notes

    The Whether to Filter System Databases toggle controls whether filtering is active:

    • On: DMS blocks the system databases defined in the Filter System Database Configurations security rule.

    • Off: DMS does not block any system databases.

    Block system databases

    1. Log on to the DMS console V5.0.

    2. Move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All Features > Security and disaster recovery (DBS) > Security Rules.

      Note

      If you use the DMS console in normal mode, choose Security and disaster recovery (DBS) > Security Rules in the top navigation bar.

    3. Move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All functions > Security and Specifications > Security Rules.

      Note

      In normal mode, choose Security and Specifications > Security Rules in the top navigation bar.

    4. Find the rule set to edit and click Edit in the Actions column.

    5. In the left-side pane, choose Others > Metadata Synchronization.

    6. Find the Filter System Database Configurations rule and click Edit in the Actions column.

    7. In the Change Configuration Item dialog box, turn on Whether to Filter System Databases.

    8. Specify the databases to block. You can use either method or both at the same time.

      • Filter Databases: Click the field and enter the database names to block.

      • Filter Database Regex Match: Enter a regular expression. For example, test_\w+ blocks all databases whose names start with test_.

      Method Field When to use
      Exact name Filter Databases Block a small, fixed list of databases by exact name
      Regular expression Filter Database Regex Match Block multiple databases that match a naming pattern

    9. Click Submit.

    10. Apply the rule to the target database instances. To make the change take effect immediately, trigger a manual synchronization. Otherwise, DMS automatically synchronizes metadata at 18:00 every day.

      Method Steps When to use
      Manual Go to the Home page of the DMS console. In the left-side navigation pane, click Database instances, right-click the instance name, and click Refresh / Sync dictionary. You need the change to take effect immediately
      Automatic No action needed. You can wait for the next scheduled sync

    Related topics