Scaling MySQL with Persistent Memory

Scaling MySQL with Persistent Memory

Scaling MySQL with Persistent Memory

Scaling cloud-based MySQL with Intel® Optane™ persistent memory helps data center managers break storage performance barriers & meet SLAs. Data center managers can deploy unmodified MySQL on servers based on 2nd Gen Intel® Xeon® Scalable processors.

Scaling MySQL in the cloud with Intel® Optane™ persistent memory helps data center managers meet the increasing demands of today's cloud-based services. Traditional storage solutions cannot provide the low latency that applications like credit card transactions and dynamic web page construction require.

Delivered with 2nd Generation Intel® Xeon® Scalable processors and available from leading server vendors today, Intel Optane persistent memory modules break the SSD performance barrier. Intel Optane persistent memory is a silicon solution that has performance and endurance characteristics similar to DRAM but stores data persistently like NAND SSDs. Data can be accessed using byte-addressable or block methods. The first generation of Intel Optane persistent memory modules are available in 128 GB, 256 GB, and 512 GB capacities, enabling per-server memory capacities up to 3 TB per CPU socket, not including DRAM. Intel Optane persistent memory is designed to meet data center reliability and memory endurance requirements and enable solutions with higher performance, endurance, and availability with lower cost than possible with existing solutions.

Current versions of MySQL on servers with Intel Optane persistent memory shipping today from leading vendors provide immediate performance scaling and cost benefits using unmodified MySQL versions. These benefits include improvements in latency response time, number of transactions per second, and increased CPU utilization.

Now that servers with Intel Optane persistent memory are widely available, MySQL developers are creating new releases that will add persistent memory features. Data center managers can expect future versions of MySQL that use Intel Optane persistent memory to have increased performance or deliver comparable performance with fewer hardware requirements. Improving both availability and data consistency can leverage Intel Optane persistent memory’s ability to retain data across power failures and maintenance windows, delivering fast restart times.

As cloud-hosted services continue to require more data that is accessible with low-latency SLAs, the demands on MySQL will continue to outpace traditional storage performance. Intel Optane persistent memory, a byte-addressable memory technology, can provide the leap in performance and capacity scaling that data center managers need to keep up with this demand while controlling infrastructure cost. Data center managers can achieve this capacity scaling benefit by deploying unmodified MySQL on servers shipping today based on Intel Xeon Scalable processors with Intel Optane persistent memory.

Read the white paper to find out more, or visit intel.com/optanedcpersistentmemory.

Related Videos