Questions about MySQL®

• Which MySQL® versions does Managed Service for MySQL® support?

• Is database cluster backup enabled by default?

• Is encryption enabled for MySQL® database cluster connections?

• What is a read-only replica in MySQL®?

• What restrictions are placed on MySQL® database clusters?

• Why is my cluster slow even though the computing resources are not fully utilized?

Which MySQL® versions does Managed Service for MySQL® support?Which MySQL® versions does Managed Service for MySQL® support?

Managed Service for MySQL® supports MySQL® 5.7 and MySQL® 8.

Is database cluster backup enabled by default?Is database cluster backup enabled by default?

Yes, backups are enabled by default. The MySQL® cluster backup policies provide full daily backups and continuous transaction log archiving. This enables you to restore your cluster to any point in time within the backup retention period, except for the last 30 seconds.

Is encryption enabled for MySQL® database cluster connections?Is encryption enabled for MySQL® database cluster connections?

Connections between your database cluster and application are always encrypted with SSL. You cannot disable encryption for cluster connections.

What is a read-only replica in MySQL®?What is a read-only replica in MySQL®?

A read-only replica is a MySQL® database cluster host available only for reads that synchronizes its data with the master host. This applies only to clusters with more than one host. You can use a read-only replica to reduce the load on the master host experiencing high read traffic to its database.

What restrictions are placed on MySQL® database clusters?What restrictions are placed on MySQL® database clusters?

For details, see Quotas and limits for Managed Service for MySQL®. To learn about the properties of the clusters you can create with Managed Service for MySQL®, see Host classes.

Why is my cluster slow even though the computing resources are not fully utilized?Why is my cluster slow even though the computing resources are not fully utilized?

Your storage may have insufficient maximum IOPS and bandwidth to process the current number of requests. In this case, throttling occurs, which degrades the entire cluster performance.

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:

To increase the maximum IOPS and bandwidth values and make throttling less likely, increase the storage size when updating your cluster.

If you are using the network-hdd storage, consider switching to network-ssd or network-ssd-nonreplicated by restoring the cluster from a backup.