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
Log In
Click Log In in the Operation column to log in to the database using the next-generation database tool. For more information, see DMC Overview.
Manage
Click Manage in the Operation column to enter the instance management page.
Upgrade Version
Two-node and three-node instances: Click More > Upgrade Version in the Operation column to upgrade the database version. For more information, see Upgrading Database Engine Versions.
Single-node and Cluster Edition instances: Upgrading the database engine version is not yet supported.
Purchase Same Configuration
After the target instance is selected, click More > Purchase Same Configuration in the Operation column to quickly create a new instance with the same configuration as the selected one on the purchase page.
Adjust Configurations
Click More > Adjust Configurations in the Operation column to adjust the configuration of the database instance (scaling). Both instance upgrade and downgrade are supported. For more information, see Adjusting Database Instance Specifications. For Cluster Edition instances, you can also quickly add and delete read-only nodes by adjusting the configuration. For more information, see Adjusting Instance Configuration.
Pay-as-You-go to Monthly Subscription
Click More > Pay-as-You-Go to Monthly Subscription in the Operation column to change the billing mode of pay-as-you-go instances. For more information, see Pay-as-You-Go to Monthly Subscription.
Edit Tag
Click More > Edit Tag in the Operation column to edit and manage the tags of instance resources. For more information, see Tag Editing.
Terminate/Return
Click More > Terminate/Return in the Operation column to return the instance by yourself. For more information, see Terminating an Instance.
Security Group
Click More > Security Group in the Operation column to configure or modify the security group of the instance. For more information, see Cloud Database Security Group Management.
Create
Click Create above the instance list to go to the purchase page and create an instance. For more information, see Creating a MySQL Instance.
Renew
After the target instance is selected, click Renew above the instance list to manually renew the instance. For more information, see Renewal Instructions.
Restart
After the target instance is selected, click Restart above the instance list to restart the instance. Batch restart is supported (selecting multiple instances).
During the restart, the instances will not be accessible normally and existing connections will be disconnected. Please be prepared to avoid any impact.
Restart will fail if there are a large number of writes and dirty pages during the restart. In this case, the instance will roll back to the status before the restart and can still be accessed.
Be sure to restart the instance during off-hours so as to ensure success and reduce the impact on your business.
Roll Back
After the target instance is selected, click More > Roll Back above the instance list to roll back a database to a specified time based on backups. For more information, see Rolling Back a Database.
Parameter Settings
After the target instance is selected, click More > Parameter Settings above the instance list to modify the parameter values of the instance. Batch settings are supported (selecting multiple instances). For more information, see Setting Instance Parameters.
Enable Auto-Renewal
After the target instance is selected, click More > Enable Auto-Renewal above the instance list to make the non-auto-renewal instance automatically renew monthly after expiration. Batch enablements are supported (selecting multiple instances). For more information, see Renewal Instructions.
Disable Auto-Renewal
After the target instance is selected, click More > Disable Auto-Renewal above the instance list to cancel auto-renewal for instances that are already set to auto-renew. Batch cancellations are supported (selecting multiple instances).
Quick Migration
After the required target instance is selected, click Quick Migration above the instance list to migrate TencentDB for MySQL two-node/three-node instances to TDSQL-C for MySQL. For more information, see Perform Quick Migration.
Quick Check
Click Quick Check above the instance list to go to the TencentDB for DBbrain Console, where you can view the health status of instances under your account and perform performance optimization on instances. For more details, see MySQL Performance Optimization.
Comparative Monitoring
After 2 to 6 target instances are selected, click Comparative Monitoring above the instance list to view and compare the monitoring situation of multiple instances in the pop-up window on the right side of the console.
Instance management page
Log in to the TencentDB for MySQL console, click the target instance ID in the instance list, or click Manage in the Operation column to enter the instance management page, where you can switch to view Instance Details, Instance Monitoring, Database Management, Security Group, Backup and Restoration, Operation Log, Read-Only Instance, Database Proxy, Data Security, and Connection Check.
Feature Page
Feature Item
Description
Instance Details
Viewing instance health status
Help users find the abnormal situation of the instance in time and optimize system performance and security configurations. For more information, see Viewing Instance Health Status.
Setting instance maintenance time
The system will aperiodically perform maintenance on instances during the maintenance time. For more information, see Setting Instance Maintenance Time.
Automatically or manually expand the CPU upper limit of the current instance. For more information, see CPU Elastic Scale-out. Cluster Edition instances do not support this feature.
Managing disaster recovery instances
Two-node and three-node instances support the creation of disaster recovery instances. For more information, see Managing Disaster Recovery Instances. Single-node and Cluster Edition instances do not support the creation of disaster recovery instances.
Network switch
Modify the private network of instances.
For more information on single-node, two-node, and three-node instances, see Network Switch.
You can view the monitoring of many core metrics of the current database in dimensions such as access, load, query cache, Ttable, InnoDB, and MyISAM. For details, see Monitoring Features and Alarm Feature. Cluster Edition instances support switching nodes on the instance monitoring page to view the monitoring situation. For more information, see View Instance Monitoring.
Database Management
Database List
The DMC console allows you to create databases and tables, manage databases, import/export data, and supports SQL window. For more information, see DMC Management.
Parameter Settings
View and modify some parameters through the console, and query parameter modification records in the console.
For more information on single-node, two-node, and three-node instances with 4 cores and above, see Intelligent Parameter Tuning. Cluster Edition instances currently do not support intelligent parameter tuning.
Account Management
You can manage the default root account of the system or create and manage new accounts.
Single-node and Cluster Edition instances currently do not support setting backup download rules.
Viewing backup space
View the instance backup space and free quota. For more information, see Viewing Backup Space.
Setting local Binlog retention
Set the binlog retention period for the instance. For more information, see Setting Local Binlog Retention. Single-node instances do not support setting local binlog retention.
Restoring a database using physical backup
Two-node and three-node instances support the use of XtraBackup tool to restore MySQL physical backup files to a self-built database on another host. For more information, see Restoring a Database Using Physical Backup.
Restoring a database using logical backup
Two-node and three-node instances support using logical backup files for manual data restoration. For more information, see Restoring a Database Using Logical Backup.
Downloading a backup
Logical and physical backups of two-node and three-node instances can be downloaded. For more information, see Downloading a Backup. Snapshot backups of single-node and Cluster Edition instances cannot be downloaded.
Rolling back a database
Data corrupted can be recovered through rollback in a self-service manner. For more information, see Rolling back a Database.
Deleting a backup
Only manual backup files of two-node and three-node instances can be deleted. For more information, see Delete a Backup.
Cloning an instance
Help users quickly roll back an instance to a newly purchased MySQL instance. For more information, see Cloning an Instance.
Operation Log
For Cluster Edition, two-node, and three-node instances, slow logs, error logs, and rollback logs can be viewed, and logs can be shipped. For more information, see Operation Logs and Log Shipping.
For single-node instances, slow logs and error logs can be viewed. For more information, see Operation Logs.
Read-Only Instance
Creating a read-only instance
Create one or more read-only instances to support users' read-write separation and one-primary-multiple-secondary application scenarios.
It is used to proxy requests when the application server accesses the database. It provides advanced features such as automatic read/write separation, connection pool, and connection retention. Single-node and Cluster Edition instances do not support database proxy. For more information on two-node and three-node instances, see Database Proxy Overview.
Two-node and three-node instances support setting SSL encryption. For more information, see Setting SSL Encryption.
Connection Check
You can detect potential connection access issues with your TencentDB and address them using the provided solutions to ensure that your TencentDB can be accessed normally. For more information, see One-Click Connectivity Checker.
