During the use of TencentDB for MySQL, you may encounter problems related to instance access, instance maintenance, database and table creation as well as data backup and rollback. This document describes common operations in TencentDB for MySQL instances and relevant products.

Instance

A TencentDB for MySQL instance can contain multiple user-created databases and can be accessed using the same tools and applications as those for a standalone database instance. Below are common operations in TencentDB for MySQL instances, databases, and tables.

Common operations

• Accessing MySQL Instance

• Maintaining an instance

  • Setting Instance Maintenance Period
  • Specifying Project for Instance

• Modifying an instance

  • Upgrading Database Engine
  • Adjusting Database Instance Specification

• Scaling an instance

  • Read-Only Instance
  • RO Group of Read-only Instance
  • Disaster Recovery Instance

• Terminating Instance

Database management

• Creating a database and table
• Manipulating instances in batches
• Dropping a database and table

Parameter Template

A parameter template is used to manage how the parameters of a database engine are configured. A database parameter set is just like a container of engine configuration values which can be applied to one or more database instances. Below are common operations currently supported by a TencentDB instance parameter template.

Common operations

• Creating a Parameter Template
• Copying a Parameter Template
• Modifying a Parameter Template
• Importing Parameters

Data

Common data operations in TencentDB for MySQL are as follows:

Backup and rollback

• Restoring Database from Physical Backup
• Restoring Database from Physical Backup File
• Database Rollback

Data import and export

• Data Import
• Migrating data offline

Security Group

A TencentDB security group is a stateful virtual firewall capable of filtering. As an important means for network security isolation provided by Tencent Cloud, it can be used to set network access controls for one or more TencentDB databases.