TencentDB for MySQL makes it easy for you to deploy and use MySQL database, one of the world's most popular open source relational database, in the cloud. TencentDB for MySQL is cost-efficient and flexible; it only takes minutes to deploy a scalable MySQL database instance and you can resize your hardware capacity without shutting down your machines. It comes with a full set of streamlined database OPS solutions, including backups, rollbacks, monitoring, fast scaling and data transfer, freeing you up to focus your energies on developing your business.
Benefits
Managed Deployment
You can launch and connect to a production-ready MySQL database in minutes with just a few clicks in the TencentDB for MySQL console. TencentDB for MySQL comes with preset parameters and settings tailored for your server, and you can further refine and customize your MySQL database settings via the database parameter group.
Custom Kernels
TencentDB for MySQL instances outperforms the open-source MySQL databases by offering industry-leading I/O throughput capability with Tencent's custom MySQL kernels. Tencent DB for MySQL's high performance allows you to support more concurrent requests with fewer databases and optimized backend architecture, making the overall IT architecture easier to manage and operate.
Reliable Backup and Recovery
TencentDB for MySQL provides 99.9996% data reliability and 99.95% service availability with comprehensive automatic data backup and lossless recovery system. TencentDB for MySQL's high reliability enables you to store your data in the cloud with a peace of mind. You also no longer need to worry about investing IT resources and efforts in heavy OPS workloads to protect your data reliability.
Strong Sync Replication
TencentDB for MySQL supports both strong synchronous and semi-synchronous data replication. TencentDB for MySQL kernel boosts strong synchronous data replication performance through optimization. Also, TencentDB for MySQL v5.6 improved data consistency by fixing the phantom reading issue caused when users switch between source and replica as well as the critical transactions generated during CVM failure recovery.
Comprehensive Daily Monitoring
You can view over 70 indicators in the TencentDB for MySQL console, including connection access, database load, query cache, and storage engine, to take full control and monitor your database status. You can also 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
Custom alarms for resource thresholds can detect issues during the TencentDB for MySQL operation and automatically report those issues to the Tencent OPS team to ensure a timely response.
Full-Process OPS Services
The Tencent Cloud team will take care of all TencentDB for MySQL OPS processes, from service set-up, deployment, updates to troubleshooting. We also help minimize your OPS cost by being fully transparent on the source/replica switch process and data migration. You will keep IP addresses and Ports throughout the process and do not need to worry about IP drift for your applications.
Easy Data Migration
Tencent Cloud's Data Transfer Service (DTS) makes automatic database migrations easy for you. You can automatically and seamlessly transfer on-premise MySQL databases and MySQL databases in other cloud providers or databases in IDCs with public IPs to Tencent's MySQL database instances. Transferring your databases to the cloud is now a much smoother experience.
Secure Disaster Recovery Solution
Real-time data synchronization can be performed between the MySQL database in the local IDC and the TencentDB for MySQL through DTS. When database service interruption happens due to power or network failure in the local IDC, the backup MySQL instances will take over to avoid data loss and perform disaster recovery. Also, TencentDB for MySQL supports multi-availability zone in one city and cross-city disaster recovery to minimize data risk.
Features
Ultra-high Performance
Enterprise-Level High Availability
Enterprise-Level Security
Enterprise-Level Monitoring
Scalability
Ease of Use
Data Migration
Ultra-high Performance
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.
Enterprise-Level High Availability
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.
Enterprise-Level Security
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.
Enterprise-Level Monitoring
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.
Scalability
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.
Ease of Use
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.
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.
Features
Ultra-high Performance
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.
Enterprise-Level High Availability
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.
Enterprise-Level Security
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.
Enterprise-Level Monitoring
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.
Scalability
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.
Ease of Use
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.
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.
Scenarios
Gaming
Internet and Mobile Apps
Finance
Ecommerce
Business Types
Tencent DB for MySQL is ideal for gaming and other business cases where elastic scaling and fast rollback are needed.
TencentDB for MySQL features compute resources elastic scaling, so you can increase productivity and deploy game servers in multiple regions in minutes. It can roll back to any point in time and perform batch operations so you can recover and rollback games quickly.
TencentDB for MySQL can act as the server data storage medium for Internet 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, and offers auditing, cross-regional disaster recovery, and strongly consistent database services, to ensure the security and reliability of your financial data.
Its high-performance and fast Redis reads and writes can easily handle spikes and high concurrent traffic during sales.
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 this option suitable for business with fluctuating demands.
For more information, see Product Pricing.