Operation Overview

Last updated: 2020-08-27 17:57:55

    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 select More > Rollback to roll it back to a specified time point based on cold backup and binlog. For more information, please see Data Rollback.
    Restart In the instance list, select an instance and click Restart 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. Please be prepared for the restart to avoid business interruption.
  • 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 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 Alarming Feature.
    Database management
  • Database List
    On the "Database List" tab, you can import SQL files into a specified database. For more information, please see Importing SQL File.
  • Parameter Settings
    On the "Parameter Settings" tab, you can set and view the history of various customizable database parameters. Click next to Current Value to modify the parameter value.
  • Manage Account
    On the "Manage Account" 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 Security Group.
    Backup and restoration On the "Backup and Restore" tab, you can download binlogs and perform cold backup. For more information, please see Backing up Database.
    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 Log.
    Read-only instance On the "Read-only Instance" tab, you can create one or more read-only (RO) instances, 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, please see Read-only Instance.
    Connection check On the "Connection Check" tab, you can check for potential connectivity and access problems and address them by 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