Managing Database

Last updated: 2020-05-15 16:37:17

PDF

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 of your database instance (i.e., scale-up or scale-down). 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 creates. 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 Backup Mode.
    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-master-multiple-slave 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 using the solutions provided so as to ensure that your databases can be accessed normally. For more information, please see One-Click Connectivity Checker.