ApsaraDB for MyBase provides the following types of data storage: local SSDs and enhanced SSDs (ESSDs). This topic describes a comparison between the storage types and provides suggestions for purchasing suitable disks.

Overview

Storage typeDescription
ESSD
ESSDs are a new type of high-performance disks developed by Alibaba Cloud based on the next-generation distributed block storage architecture. Each ESSD uses the 25 Gigabit Ethernet technology and the remote direct memory access (RDMA) technology to provide up to one million random IOPS and reduce one-way latency. ESSDs are classified into the following types based on the performance level (PL):
  • PL1 ESSD: This is an ESSD of the PL1 type.
  • PL2 ESSD: A PL2 ESSD can provide approximately twice the IOPS and throughput that are provided by a PL1 ESSD.
  • PL3 ESSD: A PL3 ESSD can provide up to 20 times the IOPS that is provided by a PL1 ESSD. A PL3 ESSD can also provide 11 times the throughput that is provided by a PL1 ESSD. PL3 ESSDs are suitable for scenarios in which highly concurrent I/O requests need to be processed at low read and write latency.
Local SSD

Local SSDs are SSDs that are deployed on the same node as the database engine. You can use local SSDs to reduce I/O latency.

View the storage type of an ApsaraDB for MyBase instance

Log on to the ApsaraDB for MyBase console and go to the Basic Information page of your ApsaraDB for MyBase instance. In the Basic Information section of the page, view Storage Type.

Comparison between storage types

Table 1. Performance comparison
Storage typeI/O performanceFlexible specificationsScalability
Local SSD

★★★★★

Provides low I/O latency and high I/O performance.

★★★★★

Provides various configuration options and allows you to increase the storage capacity of each disk. You cannot reduce the storage capacity.

★★★

May require a few hours to copy data when you scale up the database system.

ESSD (recommended)

★★★★★

Provides higher I/O performance than standard SSDs.

★★★★★

Supports online scale-up and scale-out that can be completed within a few minutes.

Storage types supported by database engines

Database engineHost storage type
MySQL
  • Local SSD
  • ESSD
SQL Server
  • ESSD
  • PL2 ESSD
  • PL3 ESSD
PostgreSQL

ESSD