Disks in MySQL sync cluster

Local and network disks can be used in the MySQL sync Managed Database cluster. The type of disk used depends on the configuration line selected.

You can select a configuration lineup with the desired disk type and disk size when creating a Managed Database cluster. After the cluster is created, you can change the lineup to another lineup with the same disk type and increase the disk size - scale the cluster.

You can see the performance and throughput of the disks in different line configurations in the Performance and Throughput table.

Local disks

Configuration lines	Standard; CPU; Memory; HighFreq; Dedicated; Flex
Disk type	SSD NVMe disk
Technical features	The disk subsystem is configured in RAID 1 for the Dedicated line and RAID 10 for the Standard, CPU, Memory, HighFreq and Flex lines
Advantages	Low latency of data access
Utilization	Suitable for tasks that are sensitive to read and write speeds
Number of disks in the DBMS	1
Configuration change	in all configuration lines with local disk, except Flex, you can't increase only local disk, you can change the whole configuration of nodes - scale the cluster; You can change the local disk configuration lineup to a network disk lineup only during cluster recovery.
Disconnecting the disk	✗
Connecting to another database	✗
Creating another disk, snapshot or backup	✗
Deletion	Deleted with all data when the cluster is deleted

Network disks

Configuration lines	Flex
Disk type	SSD NVMe disk
Technical features	Managed by Software-Defined Storage (SDS) - Ceph
Advantages	triple replication of disk volumes; network disk size is independent of the number of vCPUs
Utilization	Not recommended for systems that are sensitive to network latency and response time (latency). For example, suitable for archival data storage
Number of disks in the DBMS	1
Configuration change	there is no down time when changing the disk size; when changing the number of vCPUs and RAM, the down time depends on the number of nodes in the cluster: in single-node clusters the down time is equal to the time of rebooting a node (one or two minutes), and in multi-node clusters - to the time of switching to another node (less than one minute); You can change the configuration lineup with a network disk to the local disk lineup only during cluster recovery
Disconnecting the disk	✗
Connecting to another database	✗
Creating another disk, snapshot or backup	✗
Deletion	Deleted with all data when the cluster is deleted

Performance and throughput

Standard

	Disks up to 256 GB	Disks 512 GB	Disks 768 GB.	Disks 1 TB	Disks 1.5 TB	Disks 2 TB.
Throughput	400 MB/s.	500 MB/s	600 MB/s	700 MB/s.	800 MB/s	900 MB/s.
Performance (reading)	25,600 IOPS	40,000 IOPS	50,000 IOPS	60,000 IOPS	70,000 IOPS	80,000 IOPS
Performance (recording)	12,800 IOPS	20,000 IOPS	25,000 IOPS	30,000 IOPS	35,000 IOPS	40,000 IOPS

CPU

	Disks up to 256 GB	Disks 512 GB	Disks 768 GB.	Disks 1 TB	Disks 1.5 TB	Disks 2 TB.
Throughput	400 MB/s.	500 MB/s	600 MB/s	700 MB/s.	800 MB/s	900 MB/s.
Performance (reading)	25,600 IOPS	40,000 IOPS	50,000 IOPS	60,000 IOPS	70,000 IOPS	80,000 IOPS
Performance (recording)	12,800 IOPS	20,000 IOPS	25,000 IOPS	30,000 IOPS	35,000 IOPS	40,000 IOPS

Memory

	Disks up to 256 GB	Disks 512 GB	Disks 768 GB.	Disks 1 TB	Disks 1.5 TB	Disks 2 TB.
Throughput	400 MB/s.	500 MB/s	600 MB/s	700 MB/s.	800 MB/s	900 MB/s.
Performance (reading)	25,600 IOPS	40,000 IOPS	50,000 IOPS	60,000 IOPS	70,000 IOPS	80,000 IOPS
Performance (recording)	12,800 IOPS	20,000 IOPS	25,000 IOPS	30,000 IOPS	35,000 IOPS	40,000 IOPS

HighFreq

	Disks 128 GB	Disks 256 GB	Disks 512 GB	Disks 768 GB.	Disks 962 GB.	Disks 1.22 TB.	Disks 1.5 TB
Throughput	400 MB/s.	500 MB/s	600 MB/s	700 MB/s.	800 MB/s	900 MB/s.	1,000 MB/s
Performance (reading)	25,600 IOPS	40,000 IOPS	50,000 IOPS	60,000 IOPS	70,000 IOPS	80,000 IOPS	90,000 IOPS
Performance (recording)	12,800 IOPS	20,000 IOPS	25,000 IOPS	30,000 IOPS	35,000 IOPS	40,000 IOPS	45,000 IOPS

Dedicated

	Micro, Extra Small	Small, Medium, Large, Extra Large, Mega
Throughput	7,000 MB/s.	7,000 MB/s.
Performance (reading)	700,000 IOPS	1,500,000 IOPS
Performance (recording)	180,000 IOPS	750,000 IOPS

Flex

	Local disk	Network disk
Throughput	300 MB/s.	500 MB/s
Performance (reading)	12,800 IOPS	25,000 IOPS
Performance (recording)	6,400 IOPS	15,000 IOPS