TencentDB for MySQL

Premium Hardware
The IOPS configuration is based on the PCI-E SSD at least three times the performance of SATA. The powerful IO capability ensures uninterrupted database access; The storage devices use the NVMe protocol and specially designed for PCI-E SSD for better storage capability; One single high IO instance supports up to 245,509 QPS (queries per second), 488 GB memory and 6 TB storage.

Kernel Optimization
Multithreading master/slave sync optimization breaks through the bottleneck of database sync, so you don't need to worry about latency in master/slave sync.The locks of MySQL transactional threads and dump threads are optimized for better database performance.

Multi-availability Zone Disaster Recovery
Cross-availability zone deployment is supported with the master machine and slave machine located at different availability zones in one city where real-time data replication is performed via Tencent's direct connect. The master machine is in local availability zones and the slave machine is in remote ones. When the data are accessed externally, local instances are accessed first. If they are down or inaccessible, remote slave machines will be accessed. The cross-availability zone deployment provides MySQL with multi-availability zone disaster recovery. The switching process between the master machine and slave machine is transparent to the user. This eliminates the operational risks of single IDC deployment, and the IDC downtime is completely transparent to the services.

Remote Disaster Recovery Instances
Cross-region remote disaster recovery instances are supported to help you set up remote data synchronization for disaster recovery via the private network. In the event that the IDC where the master MySQL instances reside is down or unavailable due to other reasons, the remote disaster recovery instances enable you to quickly recover data access, allowing you to fast set up a business system remotely and redirect access traffic to remote instances. In this way, you can recover business operation, reduce business losses due to downtime and ensure high database availability in case of disasters. During the data synchronization from master instances to the disaster recovery instances, data write performance will be limited. However, you can upgrade the disaster recovery instances to master instances in the Web console and disconnect them from the data synchronization to resume full performance. The switching process takes only a few seconds, minimizing the impact of business interruption in the disaster.

Financial Solution for Three IDCs in Two Regions
MySQL offers deployment architectures for two IDCs in one city and three IDCs in two regions. When a failure occurs, you can restore the normal operation of your databases in minutes. The solution for three IDCs in two regions can be achieved with just a few clicks on the configuration page: Select MySQL cross-availability zone deployment and strong sync data replication to achieve the solution for two IDCs in one city with strong data consistency; Add a remote disaster recovery node to the cluster to achieve the architecture for three IDCs in two regions.

Completed Hot Backup and Cold Backup
Physical machines of identical architectures are used to provide real-time hot backup. Upon master failure, the slave will be switched to in seconds, improving database availability and ensuring business continuity. Based on cold backup and binlog files, lossless recovery within 3 days and cold backup data dump within 5 days are provided, making secure data recovery available.

Automatic Disaster Recovery
Automatic downtime detection and failover are supported. During master/slave switch, VIP blocking switch process is used, so the switch and failover processes are totally transparent to you. You don't need to worry about the issues caused by failure and downtime of physical machines where the data resides, and you can finish the hot backup switch process without changing the application layer. The disaster recovery switch process is imperceptive to the business.

Compatible with International Standards
As a representative product of Tencent Cloud, MySQL has been certified with multiple international standards, including but not limited to: PCI-DSS; CSA STAR; ISO22301; ISO27001; ISO20000; ISO9001.

VPC Support
With MySQL, you can run your database 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
MySQL provides multiple layers of security protection for each database by default. When a database instance that can be accessed from a public network is under DDoS attacks, the attacking traffic can be protected against to ensure normal business operation. Database attacks such as SQL injections and brute force attacks can be defended from to minimize the business interruption and loss caused by those attacks.

Granular Permission Control
Super administrator accounts are blocked to eliminate security risks. Various permission controls on the object level such as table, function and storage process are offered, making your allocated accounts access only authorized resources and keep the risks under control.

High Storage Reliability
Two duplicates of online master/slave data storage are offered to ensure online data security. Data is automatically backed up daily, and MySQL can roll 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 rest assured to store your data in MySQL and worry nothing about data loss.

Comprehensive Daily Monitoring
You can view over 70 indicators with a 60-second granularity, including connection access, database load, query cache and storage engine, to comprehensively monitor your database health. 15 core database performance indicators support second-level real-time monitoring to help you gain full control of instance health and locate performance issues fast. Custom alarms for resource thresholds can help you detect issues in DB operation which will be reported to and solved by the Tencent OPS team promptly. Slow query analysis reports and complete SQL operation reports can be downloaded to help understand the factors that affect the database performance.

Second-level Granular Monitoring
15 core database performance indicators support second-level real-time monitoring to help you gain full control of instance health and locate performance issues fast.

Custom Alarms
Custom alarms for resource thresholds can help you detect issues in DB operation which will be reported to and solved by the Tencent OPS team promptly.

Database Logs
Slow query analysis reports and complete SQL operation reports can be downloaded to help understand the factors that affect the database performance.

Read-only Instance
Read-only instance can help you achieve an architecture with one master and multiple salves and read/write splitting to cope with mass business requests. Up to 5 read-only instances can be mounted to MySQL. It supports Cloud Load Balance to simplify the process of pressure distribution among slaves.

Performance and Capacity Expansion
Except the instances with the highest specs, MySQL can be upgraded seamlessly. When there is a bottleneck for performance, you can upgrade to instance specs with higher performance and capacity by clicking on the page. The upgrade process is imperceptive.

Easy Management of Mass Databases
You can manage MySQL using command line or Web. Database management, permission allocation and SQL import in batch are supported. The heavy OPS for mass database instances is simplified into just a few clicks.

Session Management
Instance session management is supported to fast terminate abnormal sessions and help you minimize the possibility of database downtime caused by unusual access.

Multiple Network Access Ways
VPC and basic networks are supported. Access from public networks to the databases can be configured. Through those ways, you can access the MySQL from Tencent Cloud, IDC, private cloud or clouds provided by other vendors to meet diverse needs for database access in different environments.

Parameter Template
Parameter configuration templates are provided. You can save frequently used database configurations into templates and apply to new instances, so you don't need to initialize the new databases. This simplifies the parameter optimization.

API Support
MySQL provides a comprehensive API system which can be used to integrate MySQL with your internal monitoring and operational systems, completing a fully automated business OPS ecosystem that is close to business needs.

Data Migration
With MySQL's Data Transfer Service (DTS), automatic database migration in different scenarios can be made possible, such as from self-built MySQL databases on CVM to MySQL database instances, or from MySQL with public IP in IDCs/clouds provided by other vendors to 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.
Minute-level response is achieved based on the business load: With this feature, CVM instances will be automatically added during periods of peak demand to ensure application availability, and some instances will be automatically reduced when the demand falls to save costs.
Your clusters are closely monitored, so faulty instances will be immediately replaced to ensure business continuity. For business with regular load peaks and valleys, Auto Scaling can be used to set the number of instances for peaks and valleys respectively for automatic scale-up and scale-down. You can use the Auto Scaling service for free.
Learn more about Auto Scaling >