TencentDB for MySQL

Set up, operate, and scale a relational database in the cloud within minutes

Overview

TencentDB for MySQL makes it simple to deploy and use MySQL database in the cloud. It allows you to deploy a scalable MySQL database instance in minutes at lower costs and adjust your hardware capacity without any shutdown. TencentDB for MySQL streamlines database operations with features like backup, rollback, monitoring, fast scaling, and data transfer, allowing you to focus more on business development.

Benefits
Managed Deployment

Launch and connect to a production-ready MySQL database in minutes with a few clicks in the console. It offers preset parameters and settings customized to your server, which you can adjust via database parameter groups to get started quickly.

Custom Kernels

Offer industry-leading I/O throughput capability with custom MySQL kernels, which outperforms open-source MySQL databases and sustains more concurrent requests with fewer databases. It also optimizes backend architecture to make overall operations easier.

Reliable Backup and Recovery

Provide 99.9996% data reliability and 99.95% service availability with comprehensive automatic data backup and lossless recovery mechanism. It allows you to store data in the cloud without having to invest additional IT resources and efforts in your operations workloads to ensure data reliability.

Strong Sync Replication

Support both semi-sync and strong sync data replication, with the latter's performance improved through kernel optimization. TencentDB for MySQL v5.6 improved data consistency by fixing the phantom reading issue caused by source/replica switchover and the critical transactions generated during CVM failure recovery.

Comprehensive Daily Monitoring

Monitor the status of your database by offering over 70 metrics such as connection access, database load, query cache, and storage engine. It allows you to identify abnormal databases quickly by setting customized views to compare running instance loads in multiple instances over the same period and same instances over different periods.

Custom Alarms

Support custom alarms for resource thresholds to detect issues during database running and automatically report those issues to the Ops team to ensure a quick response.

Full-Process Ops Services

Manage all Ops activities from service setup, deployment, updates to troubleshooting, with source/replica switchover and data migration transparent to users. It allows you to retain the same IP addresses and ports throughout these activities with no IP drift in your applications, greatly reducing your Ops costs.

Easy Data Migration

Migrate data from other MySQL database sources to the cloud seamlessly by using DTS, requiring no manual migration and simplifying the cloudification process.

Secure Disaster Recovery Solution

Sync data in real time between on-premises MySQL database and TencentDB for MySQL through DTS. When database service is interrupted in the local IDC due to power or network failure, the backup MySQL instances will take over for disaster recovery. It also supports intra-region and cross-region disaster recovery to ensure high availability.

Features

Ultra-High Performance

Enterprise-Grade High Availability

Enterprise-Grade Security

Enterprise-Grade Monitoring

Scalability

Ease of Use

Data Migration

Ultra-High Performance


Premium Hardware

The IOPS configuration is based on the PCIe SSD at least three times the performance of SATA, with powerful IO capability ensuring uninterrupted database access. The storage devices use the NVMe protocol that is specially designed for PCIs SSD for better storage capability. A high IO instance can support up to 245,509 QPS, 488 GB memory and 6 TB storage.

Kernel Optimization

The multithreading source/replica sync is optimized to eliminate the need to worry about sync latency. The locks of MySQL transaction threads and dump threads are improved for better database performance.

Enterprise-Grade High Availability


Cross-AZ Disaster Recovery

Cross-AZ deployment is supported for disaster recovery. The source (local) and the replica (remote) are located at different AZs in the same city, with data replicated in real time via Tencent Direct Connect. The local source instance will get the request for data access first. If it is down or inaccessible, the request will go to the remote replica instance. The source/replica switchover is transparent to the user and removes the operational concerns associated with single-IDC deployment, with IDC downtime completely transparent to the business.

Cross-Region Disaster Recovery

Cross-region disaster recovery instances are supported to help you perform remote data sync for disaster recovery over the private network. When the source instances fail or become unavailable for other reasons, the remote disaster recovery instances allow you to quickly recover data access by setting up a business system and redirecting access traffic remotely. When data is synced from the source instances to the disaster recovery instances, data write performance will be limited. You can promote the disaster recovery instances to source instances in the web-based console and disconnect them from the data sync to resume their full performance. The promotion process takes only a few seconds, minimizing the impact of business interruption in the disaster.

Financial Solution for Three IDCs in Two Regions

TencentDB for MySQL offers deployment architectures for two IDCs in the same city and three IDCs in two different regions. When a failure occurs, you can restore normal database operations in minutes. This solution can be achieved with just a few clicks on the configuration page: select MySQL cross-AZ deployment and strong sync data replication to achieve the solution for two IDCs in the same city with strong data consistency; add a remote disaster recovery node to the cluster to achieve the architecture for three IDCs in two different regions.

Completed Hot Backup and Cold Backup

Physical machines with the same architecture are used to provide real-time hot backup. Based on cold backup and binlog files, data within 3 days can be recovered losslessly and cold backup data within 5 days can be dumped, making data recovery more secure.

Automatic Disaster Recovery

Automatic downtime detection and failover are supported. During source/replica switch, VIP is used to make the switch processes transparent to you, so you don't need to worry about the issues caused by failure and downtime of physical machines. You can finish the hot backup switch with no changes to the application layer, which is imperceptive to the business.

Enterprise-Grade Security


Compatible with International Standards

As a flagshiop product of TencentDB databases, TencentDB for MySQL has been certified with multiple international standards, including but not limited to PCI-DSS, CSA STAR, ISO22301, ISO27001, ISO20000, and ISO9001.

VPC Support

You can run your TencentDB for MySQL instances in Virtual Private Cloud (VPC). This enables you to isolate database instances and connect them to your current IDCs via industry-standard encrypted IPsec VPN or direct connect.

Multi-Layer Security Protection

TencentDB for MySQL provides multiple layers of security protection for each database by default. It can defense against the incoming traffic from DDoS attacks to ensure business continuity. It can also defense against common database attacks such as SQL injections and brute force attacks to minimize the business interruption and loss.

Granular Permission Control

Super admin accounts are disabled to avoid security risks. Permission controls are avaliable on the object level such as table, function, and storage process, allowing your assigned accounts to access authorized resources only and keep the risks under control.

High Storage Reliability

Two duplicates of online source/replica data storage are offered to ensure online data security. Data is automatically backed up daily and can be rolled back to any time point in the past 3 days based on the backup files. The cold backup is saved into multiple copies daily to allow data recovery in case of disaster. You can store your data in TencentDB for MySQL without fear of data loss.

Enterprise-Grade Monitoring


Comprehensive Daily Monitoring

TencentDB for MySQL offers more than 70 common database performance metrics that can be monitored at the minute level in real time. It allows you to identify abnormal databases quickly by setting customized views to compare running instance loads in multiple instances over the same period and same instances over different periods.

Finer Granularity Monitoring

TencentDB for MySQL provides 15 core database performance metrics that can be monitored at the second level in real time, helping you keep track of the health of your instances and quickly locate performance issues.

Custom Alarms

TencentDB for MySQL supports custom alarms for these metrics and sends notifications to Ops personnel upon alarm triggering, allowing them to quickly respond to the problems.

Database Logs

TencentDB for MySQL provides reports on slow query analysis and SQL running for download, enabling you to identify factors affecting database performance.

Scalability


Read-Only Instance

TencentDB for MySQL provides read-only instance to achieve an architecture with one source and multiple replicas as well as read/write separation, so that you can better cope with mass business requests. You can mount up to 5 read-only instances to a source instance and distribute read requests among them via Cloud Load Balancer (CLB).

Performance and Capacity Expansion

Except the instances with the highest specs, TencentDB for MySQL can be upgraded seamlessly. When there is a bottleneck for performance, you can upgrade instances to higher specs for greater performance and capacity with a few clicks in the console. The upgrade process has no impact on your business continuity.

Ease of Use


Database Management

You can manage TencentDB for MySQL by using command line or on the web-based console. Since database management, permission allocation and SQL batch import are supported, managing database instances no longer requires a lot of workloads but simply a few clicks.

Session Management

You can manage instance sessions and terminate abnormal sessions to reduce downtime caused by unusual access.


Network Access Options

VPC and classic networks are both supported. You can configure your database to be accessed over the public network, allowing access from Tencent Cloud, IDC, private clouds, or third-party clouds.


Parameter Template

Parameter configuration templates are provided. You can save frequently used database configurations as templates and apply them to new instances to get started quickly next time.


API Support

TencentDB for MySQL offers a complete set of APIs that can be integrated with your own monitoring and operational systems to develop a fully automated business Ops ecosystem to meet your needs.


View API documentation

Data Migration


With Data Transmission Service (DTS), automatic database migration can be made possible in different scenarios, such as from CVM-based self-built MySQL databases to TencentDB for MySQL instances, or from MySQL with public IP in IDCs/clouds provided by other vendors to TencentDB for MySQL instances, simplifying your database cloudization. With seamless transition to the cloud, you don't need to migrate your databases manually. DTS is fully manageable over the web. Just a few clicks in the console can enable unattended automatic data migration.

Features


Premium Hardware

The IOPS configuration is based on the PCIe SSD at least three times the performance of SATA, with powerful IO capability ensuring uninterrupted database access. The storage devices use the NVMe protocol that is specially designed for PCIs SSD for better storage capability. A high IO instance can support up to 245,509 QPS, 488 GB memory and 6 TB storage.

Kernel Optimization

The multithreading source/replica sync is optimized to eliminate the need to worry about sync latency. The locks of MySQL transaction threads and dump threads are improved for better database performance.


Cross-AZ Disaster Recovery

Cross-AZ deployment is supported for disaster recovery. The source (local) and the replica (remote) are located at different AZs in the same city, with data replicated in real time via Tencent Direct Connect. The local source instance will get the request for data access first. If it is down or inaccessible, the request will go to the remote replica instance. The source/replica switchover is transparent to the user and removes the operational concerns associated with single-IDC deployment, with IDC downtime completely transparent to the business.

Cross-Region Disaster Recovery

Cross-region disaster recovery instances are supported to help you perform remote data sync for disaster recovery over the private network. When the source instances fail or become unavailable for other reasons, the remote disaster recovery instances allow you to quickly recover data access by setting up a business system and redirecting access traffic remotely. When data is synced from the source instances to the disaster recovery instances, data write performance will be limited. You can promote the disaster recovery instances to source instances in the web-based console and disconnect them from the data sync to resume their full performance. The promotion process takes only a few seconds, minimizing the impact of business interruption in the disaster.

Financial Solution for Three IDCs in Two Regions

TencentDB for MySQL offers deployment architectures for two IDCs in the same city and three IDCs in two different regions. When a failure occurs, you can restore normal database operations in minutes. This solution can be achieved with just a few clicks on the configuration page: select MySQL cross-AZ deployment and strong sync data replication to achieve the solution for two IDCs in the same city with strong data consistency; add a remote disaster recovery node to the cluster to achieve the architecture for three IDCs in two different regions.

Completed Hot Backup and Cold Backup

Physical machines with the same architecture are used to provide real-time hot backup. Based on cold backup and binlog files, data within 3 days can be recovered losslessly and cold backup data within 5 days can be dumped, making data recovery more secure.

Automatic Disaster Recovery

Automatic downtime detection and failover are supported. During source/replica switch, VIP is used to make the switch processes transparent to you, so you don't need to worry about the issues caused by failure and downtime of physical machines. You can finish the hot backup switch with no changes to the application layer, which is imperceptive to the business.


Compatible with International Standards

As a flagshiop product of TencentDB databases, TencentDB for MySQL has been certified with multiple international standards, including but not limited to PCI-DSS, CSA STAR, ISO22301, ISO27001, ISO20000, and ISO9001.

VPC Support

You can run your TencentDB for MySQL instances in Virtual Private Cloud (VPC). This enables you to isolate database instances and connect them to your current IDCs via industry-standard encrypted IPsec VPN or direct connect.

Multi-Layer Security Protection

TencentDB for MySQL provides multiple layers of security protection for each database by default. It can defense against the incoming traffic from DDoS attacks to ensure business continuity. It can also defense against common database attacks such as SQL injections and brute force attacks to minimize the business interruption and loss.

Granular Permission Control

Super admin accounts are disabled to avoid security risks. Permission controls are avaliable on the object level such as table, function, and storage process, allowing your assigned accounts to access authorized resources only and keep the risks under control.

High Storage Reliability

Two duplicates of online source/replica data storage are offered to ensure online data security. Data is automatically backed up daily and can be rolled back to any time point in the past 3 days based on the backup files. The cold backup is saved into multiple copies daily to allow data recovery in case of disaster. You can store your data in TencentDB for MySQL without fear of data loss.


Comprehensive Daily Monitoring

TencentDB for MySQL offers more than 70 common database performance metrics that can be monitored at the minute level in real time. It allows you to identify abnormal databases quickly by setting customized views to compare running instance loads in multiple instances over the same period and same instances over different periods.

Finer Granularity Monitoring

TencentDB for MySQL provides 15 core database performance metrics that can be monitored at the second level in real time, helping you keep track of the health of your instances and quickly locate performance issues.

Custom Alarms

TencentDB for MySQL supports custom alarms for these metrics and sends notifications to Ops personnel upon alarm triggering, allowing them to quickly respond to the problems.

Database Logs

TencentDB for MySQL provides reports on slow query analysis and SQL running for download, enabling you to identify factors affecting database performance.


Read-Only Instance

TencentDB for MySQL provides read-only instance to achieve an architecture with one source and multiple replicas as well as read/write separation, so that you can better cope with mass business requests. You can mount up to 5 read-only instances to a source instance and distribute read requests among them via Cloud Load Balancer (CLB).

Performance and Capacity Expansion

Except the instances with the highest specs, TencentDB for MySQL can be upgraded seamlessly. When there is a bottleneck for performance, you can upgrade instances to higher specs for greater performance and capacity with a few clicks in the console. The upgrade process has no impact on your business continuity.


Database Management

You can manage TencentDB for MySQL by using command line or on the web-based console. Since database management, permission allocation and SQL batch import are supported, managing database instances no longer requires a lot of workloads but simply a few clicks.

Session Management

You can manage instance sessions and terminate abnormal sessions to reduce downtime caused by unusual access.


Network Access Options

VPC and classic networks are both supported. You can configure your database to be accessed over the public network, allowing access from Tencent Cloud, IDC, private clouds, or third-party clouds.


Parameter Template

Parameter configuration templates are provided. You can save frequently used database configurations as templates and apply them to new instances to get started quickly next time.


API Support

TencentDB for MySQL offers a complete set of APIs that can be integrated with your own monitoring and operational systems to develop a fully automated business Ops ecosystem to meet your needs.


View API documentation


With Data Transmission Service (DTS), automatic database migration can be made possible in different scenarios, such as from CVM-based self-built MySQL databases to TencentDB for MySQL instances, or from MySQL with public IP in IDCs/clouds provided by other vendors to TencentDB for MySQL instances, simplifying your database cloudization. With seamless transition to the cloud, you don't need to migrate your databases manually. DTS is fully manageable over the web. Just a few clicks in the console can enable unattended automatic data migration.

Scenarios

Tencent DB for MySQL is ideal for gaming and other business applications that require elastic scaling and fast rollback. It enables you to boost productivity and deploy gaming servers in multiple regions within minutes. It offers rollback to any point in time as well as batch operations, allowing you to easily recover and rollback games.

TencentDB for MySQL can act as the server data storage medium for web and mobile apps. For cases where reads outnumber writes, read-only instances can be increased to boost read performance.

TencentDB for MySQL stores and processes financial transaction and account data. It offers auditing, cross-region disaster recovery, and strong data consistency to ensure the security and reliability of your financial data.

TencentDB for MySQL offers high performance and fast Redis reads and writes, allowing you to handle high-concurrency access traffic and business peaks during sales and marketing campaigns with ease.

Pricing

TencentDB for MySQL provides monthly subscription and pay-as-you-go options to suit your needs and help you save on database investments. Monthly subscription users prepay for a fixed period of usage ranging from a month to a few years, depending on the business needs. The pay-as-you-go option lets users pay for what they use with no upfront payment required, making it suitable for business with fluctuating demands. For more information, see Product Pricing.