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.
SDK
Overview
Login
In the instance list, click Log In in the Operation column to log in to the database by using the new-gen database tool. For more information, see DMC Overview.
management
In the instance list, click Manage in the Operation column to enter the instance management page.
Upgrading the version
In the instance list, click More > Upgrade Version in the Operation column to upgrade the database version. For detailed conditions and instructions, see Upgrading Database Engine.
Adjust configuration
In the instance list, click More* > Adjust Configurations in the Operation column to adjust the configuration (i.e., scaling) of your database instance. Both instance upgrade and downgrade are supported. For more information, see Adjusting Database Instance Specification.
Pay-as-you-go to monthly subscription
In the instance list, click More > Switch from Pay-as-You-Go to Monthly Subscription in the operation column to modify the billing mode of pay-as-you-go instances. For detailed instructions, see Switch from Pay-as-You-Go to Monthly Subscription.
Editing Tag
In the instance list, click More > Edit Tag in the Operation column to edit and manage the tags of the instance. For more information, see Editing Tags.
Terminate/Return
In the instance list, click More > Terminate/Return in the Operation column to return the instance. For more information, see Terminating Instance.
Security Group
In the instance list, click More > Security Group in the Operation column to configure or modify the security group of the instance. For more information, see TencentDB Security Group Management.
About Renewal
Select the target instance and click Renew at the top of the instance list to set manual renewal for the instance. For more information, please refer to Renewal Instructions.
Restart the service
After selecting the target instance(s), click Restart at the top of the instance list to restart the instance(s). This operation supports batch restarts by selecting multiple instances.
During the restart, the instance will become inaccessible, and the existing connection will be disconnected. Back up data timely.
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.
Restart the instance during off-peak hours to ensure success and minimize the impact on your business.
Rollback
Select the target instance and click More > Rollback above the instance list to roll it back to a specified time point based on cold backup and binlog. For more information, see Rolling back Databases.
Setting parameters
Select one or more target instances and click More > Parameter Settings above the instance list to modify their parameter values. For more information, see Setting Instance Parameters.
Auto-renewal configuration
Select one or more target instances and click More > Enable Auto-Renewal above the instance list to set monthly auto-renewal for them. For more information, see Renewal.
Instance management page
Log in to the TencentDB for MySQL console(https://console.cloud.tencent.com/cdb), 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 view its details, monitor it, and manage databases.
SDK
Overview
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, see Monitoring and Alarm Policies (TCOP).
Database management
Database List
On this tab, you can import SQL files to the specified database. For more information, see Importing SQL Files.
Parameter settings
On the Database Management > Parameter Settings tab, you can set modifiable parameters for databases and view the modification history, or click
On the Account Management page, you can manage the default root account, such as modifying permissions and resetting passwords. You can also create and delete accounts, as well as enable password complexity features to enhance database access security. For more information, please refer to Account Management and Setting Password Complexity.
Security Group
On the Security Group tab, you can configure security groups for your databases. For more information, see TencentDB Security Group Management.
Backup and restoration
On the Backup and Restoration tab, you can download binlogs, perform cold backup, set automatic, manual, and cross-region backups, and enable backup encryption. For more information, see Backing up Databases, Cross-Region Backup, and Backup Encryption.
Operations log
On the Operation Logtab, you can view and download slow query logs, error log, and rollback logs. For more information, see Operation Logs.
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, see Creating Read-Only Instance.
Database Proxy Overview
It is used to proxy requests when the application service accesses the database. It provides advanced features such as automatic read/write separation, connection pool, and connection persistence and boasts high availability, high performance, Ops support, and ease of use. For more information, see Database Proxy
Data Security
On the Data Security tab, you can enable TDE for the instance, but then the instance cannot be restored from a physical backup to a self-created database on another server. You can also enable SSL encryption to transfer data in an encrypted manner and prevent it from being intercepted, tampered with, or eavesdropped. For more information, see Enabling Transparent Data Encryption and Setting SSL Encryption
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, see One-Click Connection Check.
