ApsaraDB RDS for MySQL performance in-depth evaluation and comparison (2024)
This paper focuses on in-depth testing and comparison of ARM, x86 architecture, HUAWEI CLOUD, Alibaba Cloud, AWS and other cloud environments based on databases, and gives test and analysis conclusions.
differentQuotientSameSpecs (e.g. 4vcpu16gb), do they have the same performance? arm-based instances are alwaysDeclaredThere is a better price, is that really the case? The performance of different storage options varies significantly.
ESSD PL0 1 2 3: Designed for high-performance workloads with ultra-low latency and high throughput.
GP2 GP3: Ideal for general workloads, it provides balanced performance and price/performance.
IO1: For applications that require high IOPS, it provides the best performance and high reliability.
Choosing the right storage option can significantly improve the performance and stability of your database. RDS are all providedDifferent storage optionse.g. essd pl0 1 2 3, gp2 gp3 io1, do they differ in performance? Performance", "Reliable" parameter templatesDo they differ in performance? What did we give away from the different options? "Pass", exclusive".Specs, do they differ in performance? What did we give away from the different options? The Dedicated Log Disk feature solves the problem of poor performance or insufficient disk capacity of some disks. Its advantages are: it can be quickly written and read to meet the log requirements in high-concurrency scenarios; Large capacity, can easily handle a large number of logs; High reliability ensures that log data is not lost.
However, the cost of proprietary log disks is relatively high compared with that of ordinary cloud disks, so you need to weigh the pros and cons based on the actual project situation and consider the cost-effectiveness and reliability requirements. Shang provided"Proprietary Chronicles".Features, is it worth choosing, and what do we gain at an additional cost? HUAWEI CLOUD: x86 is the same as that of Kunpeng instances**, and the performance gap is acceptable.
On HUAWEI CLOUD, x86 and Kunpeng instances are the same. The Kunpeng version has a performance gap of about 15 to 45% with x86, but considering the status of Kunpeng chips in China's independent controllable chips, as well as the large number of scenarios where x86 cannot be used in China, this performance degradation is generally acceptable. , x86 and Kunpeng architecture instances** are the same. The Kunpeng version has a performance gap of about 15 to 45% compared to the x86, and considering the position of the Kunpeng core in China's main controllable core, this performance degradation is usually acceptable in the domestic X86 scenario.
Performance comparison: Advantages of ARM Edition.
Economy (ARM):
tps：2185
*：1.61 yuan hour.
Cost per 1,000 TPS: 074 yuan.
Standard Edition (x86):
tps：2324
*：2.52 yuan hour.
Cost per 1,000 TPS: 108 yuan.
Cost-effective comparison: The economy version is more cost-effective.
The economy version of the cost performance improvement: 315%
Conclusion: Alibaba Cloud Economy Edition (ARM) is more cost-effective than Standard Edition (x86).
Lower cost per 1,000 tps, more economics. On the cloud, the price of the Economy Edition (ARM) and the Standard Edition (x86) is requiredSpecifically, select 16 concurrent devices, with 2185 TPS for ARM and 2324 for x86 TPS. **, the ARM version** is 1At 61 yuan, the x86 version** is 252 yuan, then the corresponding ** per 1000 tps are: 074 yuan with 108 yuan. From the point of view of price, the economic version has increased by 315%。
On AWS, gr**iton 3 instance performance has improved across the board.
gr**iton 3 instances have significant performance improvements compared to gr**iton 2. Especially when the concurrency is high, the cost-effective advantage is obvious.
Specific data: Taking 128 concurrency as an example, M7G vs M6i, gr**iton 3 has a 27% cost performance improvement compared with x86.
Advantages of gr**iton 3 instances:
Excellent performance: gr**iton 3 instances have a significant performance advantage over x86 at high concurrency.
Cost-effective: gr**iton 3 instances have a significant price-performance advantage, especially when the concurrency is high.
Strong compatibility: gr**iton 3 instances are compatible with x86 instances, making it easy to migrate existing applications.
Conclusion: gr**iton 3 instances are ideal for high-concurrency applications, with significant performance and price/performance improvements. On AWS, gr**iton 2 instances have little advantage over x86, which is contrary to the claimed 52% price increase. The performance of gr**iton 3 instances is often improvedThe performance of the gr**iton 3 instance is concurrent, compared with x86 has a more obvious price advantage, take 128 concurrency as an example, m7g vs m6i,gr**iton 3 phase gr**iton 2There is often a significant performance advantage, which is in contrast to the claimed 27% price increase.
Performance consistency:
Amazon Web Services (AWS) sets an example in terms of performance consistency, clearly identifying CPU generations and architectures by instance model, such as M5XLARGE, M6i, M6G, M7G, etc., show a high degree of productization advantages.
There are obvious differences between Alibaba Cloud and Tencent Cloud in terms of performance consistency, and some vendors may give away more CPU cores to improve short-term performance, but this is not the best solution in the long run.
Performance comparison between x86 and arm:
On the AWS platform, x86 instances have better performance at low concurrency, while M7G performs well at high concurrency.
Alibaba Cloud RDS is cost-effective and 32% more economical.
Durability vs. performance trade-offs:
AWS, Azure, and GCP are biased towards "durability" and use synchronous storage architectures to ensure durability.
Huawei, Alibaba, Tencent, and Cloud are biased towards "performance" and use semi-sync as a synchronous architecture to balance performance and durability.
ApsaraDB RDS for MySQL Performance In-Depth Evaluation and Comparison (2024) report:
Performance consistency: AWS is a model, but there are differences between Alibaba Cloud and Tencent Cloud.
Comparison of X86 and ARM performance: AWS is excellent for low concurrency X86 and strong for high concurrency M7G; Alibaba Cloud Economy (ARM) has a high price.
Durability and performance trade-offs: AWS Azure GCP is more durable, while Huawei, Alibaba, and Tencent Cloud are more performance-oriented.
Report Conclusion: AWS has set an example in terms of ApsaraDB RDS MySQL performance with its consistent performance and productization advantages.
There are differences between Alibaba Cloud and Tencent Cloud in terms of performance consistency, but some vendors give away more CPU cores to improve short-term performance.
The performance of x86 vs. ARM varies by platform, with x86 instances having an advantage at low concurrency on AWS and M7G outperforming at high concurrency.
Alibaba Cloud RDS is cost-effective and 32% more economical.
AWS, Azure, and GCP are biased towards "durability" and use synchronous storage architectures to ensure durability.
Huawei, Alibaba, Tencent, and Cloud are biased towards "performance" and use semi-sync as a synchronous architecture to balance performance and durability. In terms of "specificity", AWS is a model, with frequent productized CPU generational management AWS through instance models, such as M5Xlarge, M6i, M6G, M7G, etc., clearly identify the CPU generation and architecture. Due to the difference in CPU generation, Ayun and Tencent Cloud have obvious performance failures. Part of the Chamber of Commerce by giving away more CPU Cores for better performance,It may not be a long-term solution, but in the short term, developers and businesses will still benefit. Overall, x86 vs arm will have different performance on different platformsIn AWS, M6i vs M7G, M5 vs M6G, and x86 instances have better performance at low concurrency; The performance advantage of concurrent M7G is also obvious. The economic (ARM) value of ARV's RDS is 32%. Previously, the advantage of the Kunpeng architecture was not in performanceTheoretically, AWS Azure GCP is more inclined to "persistence", while Huawei and Tencent Cloud are more inclined to performanceAWS Azure GCP has chosen a "synchronous storage architecture" to ensure durability; Huawei, Tencent Cloud, and Tencent Cloud have all chosen semi-sync as the synchronization architecture to ensure durability. The following is from ".ApsaraDB RDS for MySQL performance in-depth evaluation and comparison (2024)
- What are your thoughts on this? -
- Welcome to leave a message** and share in the comment area. -