MySQL is the most popular open-source relational database in the world, and Cloud Database MySQL(TencentDB for MySQL) enables you to deploy and use MySQL database in the cloud with ease. With TencentDB for MySQL, it only takes minutes to deploy a scalable MySQL database instance. Besides high cost efficiency, you can enjoy flexibly scalable hardware specs without business interruption. MySQL offers a complete set of database OPS solutions including backup rollback, monitoring, fast scaling and data transfer, simplifying your IT OPS and enabling you to focus on business development.
With a few clicks in the Tencent MySQL console, you can launch and connect to a production-ready MySQL database within a few minutes. MySQL is pre-configured with various parameters and settings for your selected server types. With the database parameter group, you can control and finetune the MySQL database.
MySQL instances provide industry-leading IO throughput capability with highly customized MySQL kernels that outperform self-built open-source MySQL-based databases. The performance advantages of MySQL allow you to use fewer databases to support more concurrent requests and simplify backend architecture, streamlining the overall IT architecture for easier management and OPS.
Tencent Cloud provides 99.9996% data reliability and 99.95% service availability with completed automatic data backup and lossless recovery mechanism. With the high reliability of MySQL, you can rest assured to put your data in the cloud with no worry about data loss. Meanwhile, the extra work and additional IT investment required by traditional OPS activities to ensure high data reliability can be eliminated.
MySQL kernel in many aspects, improving the performance of strong sync data replication. Meanwhile, it improves the phantom reading phenomena caused by the master/slave switching and the critical transactions caused by the recovery of CVM failure, improving data consistency in MySQL v5.6.
You can view over 70 indicators in the MySQL console, including connection access, database load, query cache and storage engine, to comprehensively monitor your database health. You can also create custom monitoring views to compare the running instance loads in multiple dimensions for multiple instances over the same period or for different periods on the same instances. Abnormal databases can be detected fast in this way.
Custom alarms for resource thresholds can help you detect issues in MySQL operation which will be reported to and solved by the Tencent OPS team promptly.
You don't need to care about the installation, deployment, update and troubleshooting of MySQL. Tencent MySQL team will have free you from worries. Switching between master and slave, troubleshooting and data migration are fully transparent to you. IP addresses and ports remain unchanged. IP drift is no longer a consideration for your applications. All those advantages help minimize your OPS costs.
With Data Transfer Service (DTS), automatic database migration can be achieved easily from self-built MySQL databases on CVMs to MySQL database instances as well as from MySQL databases in IDCs with public IPs/in other vendors' cloud to MySQL database instances, simplifying your database cloudization without manual migration and enabling seamless business transition to the cloud.
Real-time data synchronization can be performed between the MySQL database in the local IDC and the Cloud Database through the data migration service. In case of database service interruption caused by power or network failure in the local IDC, backup MySQL instances can be rapidly switched to for disaster recovery; meanwhile, MySQL supports multi-availability zone in one city/cross-city disaster recovery to ensure high availability.
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.
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.
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 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.
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.
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 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.
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.
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.
MySQL is charged in a postpaid way. When you create a MySQL instance, one hour's hardware fee will be frozen in your cloud account. The usage will be charged hourly (Beijing time) with a second-level billing granularity. In this billing mode, you only pay for what you use in MySQL. No advance payment is required. You can go to our buying page to view detailed prices of MySQL. View more.