General questions about Managed Service for MySQL®

• What is Managed Service for MySQL®?

• What is the role of Managed Service for MySQL® in database management and maintenance?

• When should I use Managed Service for MySQL®, and when should I use VMs running databases?

• What is a database host and database cluster?

• How do I get started with Managed Service for MySQL®?

• How many database hosts can be in a cluster?

• How can I access a running database host?

• How many clusters can I create within a single cloud?

• How are database clusters maintained?

• Which MySQL® version does Managed Service for MySQL® use?

• What happens when a new DBMS version is released?

• What happens when a DBMS version becomes deprecated?

• How do you calculate usage cost for a database host?

• How can I change the computing resources and storage size for a database cluster?

• Are database host backups enabled by default?

• When does a backup run? Is a database cluster available during backups?

• Can I change the retention period for automatic backups?

• What metrics and processes can be monitored?

• How do I get the logs of my activity in the Yandex Cloud services?

What is Managed Service for MySQL®?What is Managed Service for MySQL®?

Managed Service for MySQL® is a solution that helps you create, operate, and scale MySQL® databases in the cloud.

With Managed Service for MySQL®, you can:

• Create databases with performance settings tailored to your needs.
• Scale your database compute and dedicated storage capacity as needed.
• Get database logs.

Managed Service for MySQL® takes over time-consuming MySQL® infrastructure administration tasks:

• Provides monitoring of your resource consumption.
• Automatically backs up your databases.
• Ensures fault tolerance through automatic failover to standby replicas.
• Keeps your DBMS software updated.

You work with a Managed Service for MySQL® database cluster just like with your local database. This allows you to fine-tune your database’s internal settings to meet your application’s specific requirements.

What is the role of Managed Service for MySQL® in database management and maintenance?What is the role of Managed Service for MySQL® in database management and maintenance?

When you create clusters, Managed Service for MySQL® allocates resources, installs the DBMS, and creates databases.

For all created and running databases, Managed Service for MySQL® automatically creates backups and applies fixes and updates.

Furthermore, Managed Service for MySQL® ensures data replication between database hosts, both within and across availability zones, with automatic failover to a standby replica if a failure occurs.

Be mindful of what is what is controlled by the service, and what by the Yandex Cloud customer. Understanding these control zones will help you use your cloud resources effectively and avoid potential database-related problems. For more information, see Zones of control between managed database (MDB) service users and Yandex Cloud.

When should I use Managed Service for MySQL®, and when should I use VMs running databases?When should I use Managed Service for MySQL®, and when should I use VMs running databases?

Yandex Cloud offers two ways to work with databases:

• With Managed Service for MySQL®, you can use template databases, with no administrative effort required.
• Alternatively, with Yandex Compute Cloud virtual machines, you can create and customize your own databases. This approach enables you to use any database management system, access databases over SSH, and more.

What is a database host and database cluster?What is a database host and database cluster?

A database host is a cloud-based isolated database environment with dedicated computing resources and reserved storage capacity.

A database cluster consists of one or more database hosts with configurable replication between them.

How do I get started with Managed Service for MySQL®?How do I get started with Managed Service for MySQL®?

Managed Service for MySQL® is available to all registered Yandex Cloud users.

Before creating a database cluster in Managed Service for MySQL®, you need to decide on its configuration:

• Host class that will determine your computing power, such as vCPUs, RAM, and more.
• Storage size (fully reserved when creating the cluster).
• Network for your cluster.
• Number of hosts in your cluster and availability zone for each host.

For more information, see Getting started.

How many database hosts can be in a cluster?How many database hosts can be in a cluster?

The minimum number of hosts depends on the selected storage type:

• A minimum of three hosts is required for the following disk types:

  • Local SSDs (local-ssd)
  • Non-replicated SSDs (network-ssd-nonreplicated)

• A minimum of one host is required for the following disk types:

  • Network HDDs (network-hdd)
  • Network SSDs (network-ssd)
  • Ultra high-speed network SSDs with three replicas (network-ssd-io-m3)

The maximum number of hosts per cluster cannot exceed the set limits.

For more information, see Quotas and limits.

How can I access a running database host?How can I access a running database host?

You can connect to Managed Service for MySQL® databases using standard DBMS connection methods.

Learn more about connecting to clusters in this guide.

How many clusters can I create within a single cloud?How many clusters can I create within a single cloud?

To learn about MDB quotas and limits, see this article.

How are database clusters maintained?How are database clusters maintained?

In Managed Service for MySQL®, maintenance implies:

• Automatic installation of DBMS updates and fixes for database hosts (including for stopped clusters).
• Changes in the host class and storage size.
• Other Managed Service for MySQL® maintenance activities.

For more information, see Maintenance.

Which MySQL® version does Managed Service for MySQL® use?Which MySQL® version does Managed Service for MySQL® use?

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

What happens when a new DBMS version is released?What happens when a new DBMS version is released?

The database software is updated with each new minor release. In advance of the scheduled updates, we notify the owners of the affected database clusters about the maintenance window and any expected downtimes.

What happens when a DBMS version becomes deprecated?What happens when a DBMS version becomes deprecated?

One month after a DBMS version becomes deprecated, Managed Service for MySQL® automatically sends email notifications to the owners of database clusters created with that version.

New hosts can no longer be created using deprecated DBMS versions. Database clusters are automatically upgraded to the next supported version seven days after notification for minor releases and one month after notification for major ones. Deprecated major versions will be upgraded even if you disabled automatic updates.

How do you calculate usage cost for a database host?How do you calculate usage cost for a database host?

In Managed Service for MySQL®, the usage cost is calculated based on the following:

• Selected host class.
• Reserved storage capacity for the database host.
• Size of the database cluster backups. You are not charged for storing backups up to your storage size. Additional backup storage is charged according to our pricing policy.
• Database host uptime in hours. Partial hours are rounded up to the nearest whole hour. For the cost per hour of operation for each host class, see our pricing policy.

How can I change the computing resources and storage size for a database cluster?How can I change the computing resources and storage size for a database cluster?

You can scale your computing resources and storage size directly in the management console by selecting a different host class for your cluster.

The cluster settings will update within 30 minutes. This period may also include other cluster maintenance activities, such as installing updates.

Are database host backups enabled by default?Are database host backups enabled by default?

Yes, backups are enabled by default. The MySQL® 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.

By default, backups are retained for seven days.

When does a backup run? Is a database cluster available during backups?When does a backup run? Is a database cluster available during backups?

The backup window, the scheduled time for the database cluster’s full daily backup, is from 01:00 to 05:00 (UTC+3).

Clusters remain fully available during the backup window.

Can I change the retention period for automatic backups?Can I change the retention period for automatic backups?

You can set the retention period for automatic backups when creating or updating the cluster.

What metrics and processes can be monitored?What metrics and processes can be monitored?

For all DBMS types, you can monitor:

• Absolute CPU, memory, network, and disk utilization.
• Memory, network, and disk usage as a percentage of the set limits for the relevant cluster host class.
• Amount of data in a database cluster and the remaining free space in your data storage.

For all database hosts, you can monitor metrics specific to their DBMS type. For example, for MySQL®, you can monitor:

• Average query execution time.
• Number of queries per second.
• Number of errors in logs, and more.

You can monitor metrics with a minimum granularity of five seconds.

Does the service meet the requirements of the Russian Federation Federal Law 152-FZ on personal data?Does the service meet the requirements of the Russian Federation Federal Law 152-FZ on personal data?

Yes, it does. You can read the full security audit conclusion here.

Can I get logs of my operations in Yandex Cloud?Can I get logs of my operations in Yandex Cloud?

Yes, you can request information about operations with your resources from Yandex Cloud logs. Do it by contacting support.