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 limitations apply to MySQL® database clusters?What limitations apply to MySQL® database clusters?

For more on Managed Service for MySQL® limits, see Quotas and limits. 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 and reduce the risk of throttling, expand the storage size when updating your cluster.

For storage using the network-hdd disk type, we recommend switching to network-ssd or network-ssd-nonreplicated via a cluster restore from backup.