Operation Overview

Last updated: 2021-03-26 10:22:41

    This document describes operations on the instance list and management pages in the TencentDB for MySQL console.

    Instance List Page

    You can log in to the TencentDB for MySQL console and enter the instance list page to view instance information and manage your instances.

    Feature Description
    Configuration adjustment In the instance list, you can adjust the configuration (i.e., scaling) of your database instance. Both instance upgrade and downgrade are supported. For more information, please see Adjusting Database Instance Specification.
    Rollback In the instance list, select the instance to be rolled back and click More > Rollback at the top to roll it back to a specified time point based on cold backup and binlog. For more information, please see Database Rollback.
    Restart In the instance list, select an instance and click Restart at the top to restart it. You can also select multiple instances for batch restart.
  • During the restart, the instance will be inaccessible, and existing connections to it will be closed.
  • During the restart, if the number of business writes is high and there are too many dirty pages, the restart will fail. In this case, the instance will go back to the state before the restart and become accessible.
  • Please restart instances during off-peak hours to ensure the restart success rate and reduce the impact on your business.
  • Instance Management Page

    Log in to the TencentDB for MySQL console. After an instance is initialized, click its ID/name in the instance list or click Manage in the Operation column to enter the instance management page, where you can view its details, monitor it, and manage databases.

    Feature Description
    Instance details On the Instance Details tab, you can view and manipulate various information of the database. Click to modify the basic information of the instance, where the public network address is disabled by default. If needed, click Enable after Public Network Address to enable it.
    Instance monitoring On the Instance Monitoring tab, you can view the monitoring data of various core metrics of the current database in various dimensions such as access, load, query cache, table, InnoDB, and MyISAM. For more information, please see Monitoring Feature and Alarm Policies (Cloud Monitor).
    Database management
  • Database List
    On this tab, you can import SQL files into a specified database. For more information, please see Importing SQL File.
  • Parameter Settings
    On this tab, you can set and view the history of customizable database parameters. Click in the Current Value column to modify the parameter value. For more information, please see Managing Parameter Templates.
  • Manage Account
    On this tab, you can manage the system's default root account, such as modifying permissions and resetting password. You can also create and delete account. For more information, please see Account Management.
  • Security group On the Security Group tab, you can configure security groups for your databases. For more information, please see TencentDB Security Group Management.
    Backup and restoration On the Backup and Restore tab, you can download binlogs and perform cold backup. For more information, please see Backing up Databases.
    Operation log On the Operation Log tab, you can view and download slow query logs, error log, and rollback logs. For more information, please see Operation Logs.
    Read-only replicas On the Read-only Replica tab, you can create one or more read-only (RO) replicas, which can be applied to read/write separation and one-source-multiple-replica application scenarios to boost the read load capacity of your databases. For more information, see Creating Read-only Replicas.
    Connection Check On the Connection Check tab, you can check for potential connectivity and access problems and address them using the solutions provided so as to ensure that your databases can be accessed normally. For more information, please see One-Click Connectivity Checker.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help