MySQL semi-sync versions and configurations
Versions
MySQL semi-sync version 8 is supported.
Node configurations
At creating a cloud database cluster MySQL semi-sync you can select the number of vCPUs, RAM and size for nodes local disk.
Two types of configurations are available:
- fixed configurations — several ranges with different specifications, in which the resource ratio is fixed;
- arbitrary configurations — any resource ratio can be specified.
Processors used depend on the selected configuration.
About 5 GB of local disk space in all configurations is reserved for the operating system, service components, and log storage. The remaining space is available for database storage.
Once the cluster is created, you can reconfigure nodes.
Processors
The fixed-configuration and random-configuration product lines differ in available processors. Processor frequency affects the speed of processing user requests, executing complex algorithms and data operations.
To see the availability of configurations in the regions, see the availability matrix Cloud databases.
* At 100% cloud server load, the processor runs with Turbo Boost technology and a maximum frequency of 3.6 GHz for the HighFreq lineup and 3.9 GHz for the Dedicated lineup. Since the processor is emulated, the test will display 3.00 GHz for the HighFreq lineup and 2.6 GHz for the Dedicated lineup.
Fixed configurations
To see the availability of configurations in the regions, see the availability matrix Cloud databases.
The fixed configuration can be selected when creation or scaling cluster in the control panel and through Terraform.
Standard
A line of fixed configurations with a balanced vCPU:RAM ratio, suitable for most DBMSs. We recommend using this lineup if you do not know the load profile.
Intel® Xeon® Scalable or AMD EPYC™ 2.2-2.4 GHz processors are used. To see the processor frequency in different configurations, see the table below Processors.
CPU
A line of fixed configurations with a balanced vCPU:RAM ratio. Suitable for workload profiles that are computationally demanding. For example, if the database is running analytic queries, multiple nested queries, or data encryption. One way to determine such a load profile is to track metrics Load Averagewhich shows the average system utilization over one, five or 15 minutes.
Intel® Xeon® Scalable or AMD EPYC™ 2.2-2.4 GHz processors are used. To see the processor frequency in different configurations, see the table below Processors.
Memory
A line of fixed configurations with a balanced vCPU:RAM ratio. Suitable for workload profiles that are cache-intensive. For example, if a database runs multiple, infrequent queries on different parts of tables. One way to determine such a load profile is to track metrics Попадание в кэш (Cash_hit_ratio)which shows the percentage of data in the query that is read from the cache.
Intel® Xeon® Scalable or AMD EPYC™ 2.2-2.4 GHz processors are used. To see the processor frequency in different configurations, see the table below Processors.
HighFreq
A line of fixed configurations with a balanced vCPU:RAM ratio.
High-performance Enterprise-level equipment is used:
- Intel® Xeon® Gold 6354 processors with Turbo Boost frequency up to 3.6 GHz. To see the processor frequency in different configurations, see the table below Processors;
- RAM ECC Reg 3.2 GHz;
- SSD NVMe disks with enhanced performance.
Dedicated
A line of fixed configurations with cluster nodes on separate cloud servers. Each cloud server occupies the entire dedicated host (physical server). Suitable for users who require physical isolation of databases from other clients, maximum performance and maximum size of available resources.
High-performance Enterprise-level equipment is used:
- one Intel® Xeon® Gold 6240 processor with Turbo Boost speed up to 3.9 GHz. To see the processor frequency in different configurations, please refer to the table below Processors;
- RAM 64 GB DDR4 ECC Reg;
- two SSD NVMe disks in RAID 1;
- two 2 × 25 GE NICs for the main network + MC-LAG with 25 Gbps connection speed for the service network (for backup, monitoring, data replication in the cluster).
* To increase the performance of the DBMS cluster, Hyper-Threading Technology is used. This technology allows you to use 34 vCPUs on the basis of physical 18 CPUs. This performance is suitable for highly loaded systems or analytical load profile.
** One slice of RAM is reserved for the services that maintain the physical server.
*** To provide additional fault tolerance, the disks are placed in RAID 1. This is an array of disks with mirroring, so 50% of the disk space is available for the database. Part of the disk space is also reserved for services that maintain the physical server.
Arbitrary configurations
You can see the availability of configurations in the regions in the availability matrix Cloud databases.
Intel® Xeon® Scalable or AMD EPYC™ processors with the frequency of 2.2-2.4 GHz are used in arbitrary configurations. You can see the processor frequency in different configurations in the table below Processors.
An arbitrary configuration can be selected by creation or scaling cluster in the control panel and through Terraform.
Values of arbitrary configurations
In arbitrary configurations, you can choose the resource ratio. When selecting a configuration, consider:
- vCPU:RAM ratio should be at least 1:4. For example, 4 vCPUs require at least 16 GB of RAM;
- vCPU:Local disk ratio should be at least 1:32. For example, 4 vCPUs require a disk size of at least 128 GB.
The available values depend on pool.