Questions about MySQL®
-
What MySQL® versions does Managed Service for MySQL® support?
-
Why is the cluster slow even though the computing resources are not used fully?
What MySQL® versions does Managed Service for MySQL® support?
Managed Service for MySQL® supports MySQL® 5.7 and MySQL® 8.
Are DB cluster backups enabled by default?
Yes, backup is enabled by default. For MySQL® clusters, a full backup takes place once a day and saves all DB cluster transaction logs. This allows you to restore the cluster state to any point in time during the backup storage period, except for the last 30 seconds.
Are MySQL® database cluster connections encrypted?
Connections between a database cluster and an application are always encrypted using SSL. You cannot disable cluster connection encryption.
What is a read-only replica in MySQL®?
A read-only replica is a host in a MySQL® DB cluster that can only be read. Its data is synced with the master host (if the cluster has more than one host). You can use a read-only replica to reduce the load on the DB master host with a large number of read requests.
What limitations are imposed on MySQL® database clusters?
For more information on Managed Service for MySQL® limits, see Quotas and limits. To learn about the properties of the clusters you can create using Managed Service for MySQL®, see Host classes.
Why is the cluster slow even though the computing resources are not used fully?
Perhaps, the maximum storage IOPS and bandwidth values are insufficient for processing the current number of requests. In this case, throttling is triggered and the performance of the entire cluster degrades.
The maximum IOPS and bandwidth values increase by a fixed value when the storage size increases by a certain step. The step and increment values depend on the disk type:
Disk type | Step, GB | Max IOPS increase (read/write) | Max bandwidth increase (read/write), MB/s |
---|---|---|---|
network-hdd |
256 | 300/300 | 30/30 |
network-ssd |
32 | 1,000/1,000 | 15/15 |
network-ssd-nonreplicated |
93 | 28,000/5,600 | 110/82 |
To increase the maximum IOPS and bandwidth values and make throttling less likely, increase the storage size when you update your cluster.
If you are using the network-hdd
storage type, consider switching to network-ssd
or network-ssd-nonreplicated
by restoring the cluster from a backup.