Process up to 1.48x the MySQL Database Transactions with Intel® Xeon® Processor-backed Alibaba G7 Instances vs. Alibaba G6a Instances

MySQL

  • Complete 1.48x the MySQL database transactions per minute on G7 instances with 3rd Gen Intel® Xeon® Scalable processors vs. G6a instances

  • Get better value with G7 instances featuring 3rd Gen Intel® Xeon® Scalable processors vs. G6a instances

author-image

By

Get More for Your Money with Alibaba G7 Instances Featuring 3rd Gen Intel® Xeon® Scalable Processors

When you’re shopping for cloud instances to host your MySQL databases, it’s important to choose an instance that can provide the performance you need. While storage contributes significantly to OLTP database performance, the CPU also plays a large role, and choosing just any compute-intensive instance may not be enough. For OLTP databases, Alibaba G7 instances enabled by 3rd Gen Intel® Xeon® Scalable processors can offer greater performance—and greater value— than G6a instances with AMD EPYC processors.

HammerDB benchmark tests used an OLTP workload to compare four sizes of MySQL databases on Alibaba instances (see Figure 1).

Table 1. Names of the tested Alibaba instances with their vCPU configurations.

Not only did the G7 instances featuring 3rd Gen Intel® Xeon® Scalable processors provide up to 1.48x the transactions per minute of G6a instances, but they also delivered better value than G6a instances, providing a larger performance increase than cost increase. With each instance doing more work, you could consolidate your database instances, reducing your cloud costs without affecting performance.

Figure 1. Relative results comparing the MySQL database transactions per minute of G7 instances vs. G6a instances at four different vCPU instance sizes.

G7 Instances Delivered Better Performance

As Figure 2 on the previous page shows, G7 instances enabled by 3rd Gen Intel® Xeon® Scalable processors outperformed G6a instances at all four vCPU counts tested, with improvements ranging from 1.36x to 1.48x as many MySQL database transactions per minute.

G7 Instances Provided Better Value

Performance is an important criterion for those selecting cloud instances, and cost is, too. While Alibaba lists the G7 instances featuring 3rd Gen Intel® Xeon® Scalable processors at a slightly higher price point than the G6a instances, the performance improvement outweighs the cost increase. The G7 instances cost at most 1.31x as much as the G6a instances, but they deliver up to 1.48x the performance. This means that you get more performance for your dollar with the G7 instances.

Based on these comparisons, companies that host MySQL databases in the cloud could meet goals for both performance and cost by choosing compute-intensive Alibaba G7 instances enabled by 3rd Gen Intel® Xeon® Scalable processors rather than Alibaba G6a instances with AMD EPYC processors.

Learn More

To begin running your MySQL workloads on Alibaba G7 instances with 3rd Gen Intel® Xeon® Scalable processors, visit www.thailand.intel.com/alibaba.