CloudDB for MySQL
Set up, operate, and scale a relational database in the cloud within minutes
Overview
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 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 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
CloudDB 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 flagship product of CloudDB databases, CloudDB 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 CloudDB 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
CloudDB for MySQL provides multiple layers of security protection for each database by default. It can defend against the incoming traffic from DDoS attacks to ensure business continuity. It can also defend against common database attacks such as SQL injections and brute force attacks to minimize business interruption and loss.
Granular Permission Control
Super admin accounts are disabled to avoid security risks. Permission controls are available 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 CloudDB DB for MySQL without fear of data loss.
Comprehensive Daily Monitoring
CloudDB 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 the same instances over different periods.
Finer Granularity Monitoring
CloudDB 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
CloudDB 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
CloudDB for MySQL provides reports on slow query analysis and SQL running for download, enabling you to identify factors affecting database performance.
Read-Only Instance
CloudDB for MySQL provides read-only instances 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 a Cloud Load Balancer (CLB).
Performance and Capacity Expansion
Except for the instances with the highest specs, CloudDB 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 CloudDB for MySQL by using the 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 workload 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 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
CloudDB 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.
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 CloudDB for MySQL instances, or from MySQL with public IP in IDCs/clouds provided by other vendors to CloudDB for MySQL instances, simplifying your database cloudization. With a 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
CloudDB 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 roll back games.
CloudDB 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.
CloudDB for MySQL stores and processes financial transactions and account data. It offers auditing, cross-region disaster recovery, and strong data consistency to ensure the security and reliability of your financial data.
CloudDB 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.