Tencent Cloud

Recent Pages

Operation Overview

Last updated: 2024-12-30 17:41:32

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.
﻿
Assigning instances to projects
Assign instances to different projects for management. For more information, see Assigning Instances to Projects.
﻿
Adjusting database instance specifications
Quickly adjust instance specifications through the console for flexible scaling.
For more information on single-node, two-node, and three-node instances, see Adjusting Database Instance Specifications.
For more information on Cluster Edition instances, see Adjusting Instance Configuration.
﻿
Modifying the port number
Support modification of the port number for the instance's private network address.
For more information on single-node, two-node, and three-node instances, see Modifying the Port Number.
For more information on Cluster Edition instances, see Read-Write Address Management and Read-Only Address Management.
﻿
Migrate to New AZ
Migrate TencentDB for MySQL instances to another availability zone in the same region. For more information, see Migrating Availability Zones.
﻿
Source/Replica Switch
Switch the primary and secondary databases of instances.
For more information on two-node and three-node instances, see Primary/Replica Switch.
For more information on Cluster Edition instances, see Primary/Replica Switch.
﻿
CPU elastic scale-out
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.
For more information on Cluster Edition instances, see Read-Write Address Management and Read-Only Address Management.
﻿
Enabling public network connection address
For more information, see Enabling Public Network Connection Address.
Instance Monitoring
﻿
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.
﻿Set instance parameters.
﻿Apply parameter templates.
﻿Compare different template parameters.
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.
﻿Create accounts.
﻿Set password complexity.
﻿Reset passwords.
﻿Modify account permissions.
﻿Modify host addresses with access permissions.
﻿Delete accounts.
Security Group
﻿
You can configure security groups for your databases. For more information, see TencentDB Security Group Management.
Backup and Restoration
Back up a database
You can automatically or manually back up the database. For more information, see Back up a Database.
﻿
Configuring transition-to-cold storage
Support transition-to-cold storage for backup files to reduce backup storage costs.
For more information on two-node and three-node instances, see Configuring Transition-to-Cold Storage.
Single-node and Cluster Edition instances currently do not support configuring transition-to-cold storage.
﻿
Cross-Region Backup
Support storing backup files in another region.
For more information on two-node, three-node, and Cluster Edition instances, see Cross-Region Backup.
Single-node instances currently do not support cross-region backup.
﻿
Backup Encryption
Support encryption of physical backups and log backups (binlog).
For more information on two-node and three-node instances, see Backup Encryption.
Single-node and Cluster Edition instances currently do not support backup encryption.
﻿
Setting backup download rules
Set restrictions for backup download.
For more information on two-node and three-node instances, see Setting Backup Download Rules.
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.
For more information on two-node and three-node instances, see Creating a Read-Only Instances.
For Cluster Edition instances, 1-5 read-only nodes can be created. For more information, see Adding a Node for an Instance.
For Cluster Edition instances, 1-15 independent read-only instances can also be created. For more information, see Creating a Read-Only Instance.
﻿
Managing the RO group of read-only instance
Two-node and three-node instances support managing the RO group of read-only instance. For more information, see Managing RO Group of Read-Only Instance.
﻿
Managing delayed replication of read-only instance
Two-node and three-node instances support managing delayed replication of read-only instances. For more information, see Managing Delayed Replication of Read-Only Instance.
Database Proxy
﻿
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.
Data Security
Enabling Transparent Data Encryption (TDE)
Two-node and three-node instances support enabling TDE. For more information, see Enabling Transparent Data Encryption.
﻿
Setting SSL encryption
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.

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support

tencent cloud

Recent Pages

Operation Overview

Instance list page

Instance management page

Was this page helpful?

Was this page helpful?

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.

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.
		Assigning instances to projects	Assign instances to different projects for management. For more information, see Assigning Instances to Projects.
		Adjusting database instance specifications	Quickly adjust instance specifications through the console for flexible scaling. For more information on single-node, two-node, and three-node instances, see Adjusting Database Instance Specifications. For more information on Cluster Edition instances, see Adjusting Instance Configuration.
		Modifying the port number	Support modification of the port number for the instance's private network address. For more information on single-node, two-node, and three-node instances, see Modifying the Port Number. For more information on Cluster Edition instances, see Read-Write Address Management and Read-Only Address Management.
		Migrate to New AZ	Migrate TencentDB for MySQL instances to another availability zone in the same region. For more information, see Migrating Availability Zones.
		Source/Replica Switch	Switch the primary and secondary databases of instances. For more information on two-node and three-node instances, see Primary/Replica Switch. For more information on Cluster Edition instances, see Primary/Replica Switch.
		CPU elastic scale-out	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. For more information on Cluster Edition instances, see Read-Write Address Management and Read-Only Address Management.
		Enabling public network connection address	For more information, see Enabling Public Network Connection Address.
Instance Monitoring			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. Set instance parameters. Apply parameter templates. Compare different template parameters. 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. Create accounts. Set password complexity. Reset passwords. Modify account permissions. Modify host addresses with access permissions. Delete accounts.
Security Group			You can configure security groups for your databases. For more information, see TencentDB Security Group Management.
Backup and Restoration	Back up a database	You can automatically or manually back up the database. For more information, see Back up a Database.
		Configuring transition-to-cold storage	Support transition-to-cold storage for backup files to reduce backup storage costs. For more information on two-node and three-node instances, see Configuring Transition-to-Cold Storage. Single-node and Cluster Edition instances currently do not support configuring transition-to-cold storage.
		Cross-Region Backup	Support storing backup files in another region. For more information on two-node, three-node, and Cluster Edition instances, see Cross-Region Backup. Single-node instances currently do not support cross-region backup.
		Backup Encryption	Support encryption of physical backups and log backups (binlog). For more information on two-node and three-node instances, see Backup Encryption. Single-node and Cluster Edition instances currently do not support backup encryption.
		Setting backup download rules	Set restrictions for backup download. For more information on two-node and three-node instances, see Setting Backup Download Rules. 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. For more information on two-node and three-node instances, see Creating a Read-Only Instances. For Cluster Edition instances, 1-5 read-only nodes can be created. For more information, see Adding a Node for an Instance. For Cluster Edition instances, 1-15 independent read-only instances can also be created. For more information, see Creating a Read-Only Instance.
		Managing the RO group of read-only instance	Two-node and three-node instances support managing the RO group of read-only instance. For more information, see Managing RO Group of Read-Only Instance.
		Managing delayed replication of read-only instance	Two-node and three-node instances support managing delayed replication of read-only instances. For more information, see Managing Delayed Replication of Read-Only Instance.
Database Proxy			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.
Data Security	Enabling Transparent Data Encryption (TDE)	Two-node and three-node instances support enabling TDE. For more information, see Enabling Transparent Data Encryption.
Data Security		Setting SSL encryption	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.

tencent cloud

Sign Up

Log in

Recent Pages

Operation Overview

Instance list page

Instance management page

Was this page helpful?

Was this page helpful?