To help you fully understand the performance potential of TDSQL-C for MySQL, TDSQL-C for MySQL introduces the high-performance configuration capability, also known as the high-performance template. This capability uses a built-in deep-tuning parameter template to enable database clusters to achieve significantly improved read/write performance and throughput immediately after deployment. You can flexibly select the template type for your cluster based on your business scenarios. This selection meets the high standards required for performance benchmarking and is also suitable for scenarios with high-performance demands. You can configure the high-performance template for both newly purchased clusters and existing cluster upgrades. This document describes the high-performance template and provides related instructions and operations.
Feature Application Scenarios
Performance Benchmarking Scenario: Before migrating your business to TDSQL-C for MySQL, you are expected to conduct thorough performance stress testing to evaluate whether the cloud database meets your business performance requirements.
Performance Configuration Description
The performance configuration of TDSQL-C for MySQL supports two template types, as shown below:
High-Stability Template: This template uses general settings to provide high stability while ensuring relatively high performance.
High-Performance Template: This template uses high-performance settings to effectively improve database performance. However, its stability is moderate, so it is recommended for use in scenarios such as stress testing.
Description of Three Template Types Under the High-Performance Template
Under the high-performance configuration, three configuration types are supported. You can select a minimum of one type or a maximum of all three. Descriptions of the different configuration types are as follows:
|
Compiler-Optimized Edition | The compilation-optimized edition can enhance the performance of the database kernel in common business scenarios while reducing its power consumption, all without compromising existing compatibility. For details, see compilation-optimized high-performance version. |
High-Performance Parameter Template | TDSQL-C for MySQL performs deep learning and references tens of thousands of database cases to provide parameter templates featuring higher performance. These templates improve database performance while ensuring high stability. |
binlog Disabled | Under this template, binlog can be disabled for the cluster to reduce database overhead and effectively improve database performance. |
Feature Adaptation Description
After the high-performance template is configured, the following describes feature compatibility:
After the compilation-optimized edition is enabled for an existing cluster, all instances under the cluster are upgraded to the compilation-optimized edition.
When you purchase a new read-only instance under a cluster, the template type of the read-only instance is the same as that of the read-write instance.
If you have enabled Multi-AZ deployment, binlog cannot be disabled. If your cluster is deployed in a single AZ, you can disable binlog. However, note that after binlog is disabled, you cannot enable Multi-AZ deployment. This poses a risk in some disaster recovery scenarios, so disable binlog with caution.
Operation Steps
Selecting a High-Performance Template When Purchasing a New Cluster
Note:
On the Performance Configuration > Template Type page, after you choose the high-stability template, the parameter template options are restricted to the high-stability parameter template only. Similarly, after you choose the high-performance template, the parameter template options are restricted to the high-performance parameter template only.
You can follow the steps below to quickly configure the high-performance template. If you need to understand all configuration item descriptions for cluster purchase, you can refer to Create Cluster. 1. Log in to the Purchase Page, complete the Database Configuration, Instance Selection, and Storage settings, and then click Next. 2. Complete the Basic Info settings. Under the Performance Configuration settings, select High-Performance Template as the template type.
3. Under the high-performance template, select the configuration types you need. You can select a minimum of one type or a maximum of three.
4. Complete the Advanced Configuration settings, select the purchase duration and quantity (only the quantity is required when the billing mode is pay-as-you-go), confirm the fees, and then click Buy Now.
Upgrading a High-Stability Template to a High-Performance Template for an Existing Cluster
Note:
In the high-performance template, after you enable the compilation-optimized edition, you cannot roll back to the mainline edition.
Updating the configuration type of the high-performance template involves a restart. Please select an execution time.
1. Log in to the TDSQL-C for MySQL console and click the target cluster in the cluster list on the left to go to the Cluster Management page. 2. Click High-Performance Template in the upper-right corner.
3. In the pop-up window, enable the target configuration type as needed, select an execution time, and then click OK.
Execute Immediately: This means the upgrade task is executed immediately, which involves a restart.
Within Maintenance Time: This means the upgrade is performed during the cluster's maintenance time, which involves a restart. To modify the maintenance time, see Modify Instance Maintenance Time.