Modernize Enterprise Open-Source Databases with New Processors for Improved VM Density and Greater Performance

Modernizing open-source database infrastructure with servers powered by Intel® Xeon® 6 processors can deliver substantial throughput, scaling, and consolidation benefits compared with older Intel Xeon platforms. In the Prowess Consulting technical brief, “Modernize Enterprise Open-Source Databases with New Processors for Improved VM Density and Greater Performance,” commissioned by Intel, our testing evaluated MySQL® and PostgreSQL® workloads on Red Hat® OpenShift® using HammerDB online transaction processing (OLTP) benchmarks across prior-generation Intel Xeon Scalable processors and newer HPE® systems with Intel Xeon 6 processors. The results show up to 3.5x higher MySQL throughput and up to 3.6x higher PostgreSQL throughput, which can help enterprises address rising transaction volumes, concurrency, and infrastructure constraints. The paper also connects these gains to AI-readiness, showing how higher sustained compute capacity, memory efficiency, Compute Express Link® (CXL®) support, Intel® Advanced Vector Extensions 512 (Intel® AVX-512), and built-in reliability, availability, and serviceability (RAS) capabilities can create headroom for intelligent query processing, vector search, and embedded analytics without disruptive infrastructure changes.

 

TL;DR

Refreshing from 3rd Gen Intel Xeon Scalable processor–based systems to HPE servers powered by Intel Xeon 6 processors can substantially improve open-source database performance and modernization readiness. Prowess Consulting tested MySQL and PostgreSQL workloads in Red Hat OpenShift virtualized environments using HammerDB OLTP benchmarks. The Intel Xeon 6 platform delivered up to 3.5x higher MySQL throughput and up to 3.6x higher PostgreSQL throughput, while supporting higher VM density, stronger scaling, and more consolidation headroom. These gains can help organizations meet rising transaction volumes, support AI-infused database features, and modernize with less operational disruption through a familiar Intel-to-Intel refresh path.

Evidence: See Results and Analysis, MySQL and PostgreSQL callout boxes, What Modernization Means for Enterprises, and Appendix: Methodology and Configurations.

 

FAQ

Q: Who is this paper for?
A: This paper is for data center architects, database architects, database administrators, line-of-business (LOB) managers, and technical subject-matter experts (SMEs) evaluating infrastructure modernization for open-source databases. It is especially relevant for enterprises already using Intel Xeon processor–based platforms that need more throughput, better consolidation, and AI-ready headroom without making disruptive architectural changes.

Q: What did Prowess Consulting test?
A: Prowess Consulting tested MySQL and PostgreSQL workloads running in Red Hat OpenShift virtualized environments. The study compared a prior-generation baseline using 3rd Gen Intel Xeon Scalable processors with an evaluation platform using Intel Xeon 6 processors in HPE® ProLiant® Compute DL380 Gen12 servers. HammerDB OLTP workloads measured aggregate throughput, scaling behavior, and VM density.

Q: What were the main performance results?
A: The main result was substantially higher open-source database throughput on Intel Xeon 6 processor–based systems. MySQL delivered approximately 2.5–3.5x higher aggregate transactions per minute (TPM), reaching up to 3.5x at higher load levels. PostgreSQL delivered approximately 1.5–3.6x higher aggregate TPM, reaching up to 3.6x as concurrency increased.

Evidence: MySQL and PostgreSQL callout boxes.

Q: Why does the paper emphasize Red Hat OpenShift?
A: The paper emphasizes Red Hat OpenShift because the workloads were tested in a modern virtualized environment aligned with common enterprise operations. OpenShift provided the virtualization layer for all tested configurations, showing that the Intel Xeon 6 processor performance and consolidation gains applied in an orchestrated operational model rather than an idealized standalone configuration.

Q: How does this refresh support AI-readiness?
A: The refresh supports AI-readiness by increasing sustained compute capacity, memory efficiency, and consolidation headroom for database environments. The paper connects those improvements to features such as intelligent query processing, vector search, and embedded analytics. Intel AVX-512, CXL support, Flat Memory Mode, and RAS capabilities further strengthen the modernization case for data-intensive environments.

Q: What is the migration implication for enterprises?
A: The migration implication is that an Intel-to-Intel refresh can provide a practical modernization path with lower operational disruption. The paper highlights platform continuity, ecosystem compatibility, and tools such as the Red Hat® Migration Toolkit for Virtualization as ways to preserve operational consistency, reduce retraining needs, and help teams capture performance and consolidation benefits faster.

Read other resources

Contact Us

Interested in working with us?

Ready to get started? The Prowess team would love to discuss the business challenges you’re facing and how we can put our experience into action for you.