General questions about Managed Service for MySQL®
-
What part of database management and maintenance is Managed Service for MySQL® responsible for?
-
Which tasks are best addressed using Managed Service for MySQL®, and which using VMs with databases?
-
How can I change the computing resources and storage size for a database cluster?
-
When are backups performed? Is a database cluster available during a backup?
What is Managed Service for MySQL®?
Managed Service for MySQL® is a service that helps you create, operate, and scale MySQL® databases in a cloud infrastructure.
With Managed Service for MySQL®, you can:
- Create a database with the required performance characteristics.
- Scale processing power and storage dedicated for your databases as needed.
- Get database logs.
Managed Service for MySQL® takes on time-consuming MySQL® infrastructure administration tasks:
- Monitors resource usage.
- Automatically creates DB backups.
- Provides fault tolerance through automatic failover to backup replicas.
- Keeps database software updated.
You interact with database clusters in Managed Service for MySQL® the same way you interact with regular databases in your local infrastructure. This allows you to manage internal database settings to meet your app requirements.
What part of database management and maintenance is Managed Service for MySQL® responsible for?
When you create clusters, Managed Service for MySQL® allocates resources, installs the DBMS, and creates databases.
For the created and running databases, Managed Service for MySQL® automatically creates backups and applies fixes and updates to the DBMS.
Managed Service for MySQL® also allows you to replicate data between database hosts (both within and across availability zones) and automatically routes the load to a backup replica in the event of a failure.
Which tasks are best addressed using Managed Service for MySQL®, and which using VMs with databases?
Yandex Cloud offers two ways to work with databases:
- Managed Service for MySQL® allows you to operate template databases with no need to worry about administration.
- Yandex Compute Cloud virtual machines allow you to create and configure your own databases. This approach allows you to use any database management systems, access databases via SSH, etc.
What is a database host and database cluster?
A database host is an isolated database environment in the cloud infrastructure with dedicated computing resources and reserved data storage.
A database cluster is one or more database hosts between which replication can be configured.
How do I get started with Managed Service for MySQL®?
Managed Service for MySQL® is available to any registered Yandex Cloud user.
To create a database cluster in Managed Service for MySQL®, you need to define its parameters:
- Host class (performance characteristics, such as CPUs, RAM, etc.).
- Storage size (reserved to the full extent when you create a cluster).
- Network your cluster will be connected to.
- Number of hosts for the cluster and the availability zone for each host.
For more information, see Getting started.
How many database hosts can there be in one cluster?
The minimum number of hosts depends on the selected type of storage:
- If you use non-replicated SSD (
ssd-network-nonreplicated) or local SSD (local-ssd) storage, the minimum number of hosts is 3. - If you use network SSD (
network-ssd) or network HDD (network-hdd) storage, you can create a single-host cluster.
The maximum number of hosts in a cluster is only limited by the requested computing resources and the size of the storage for the cluster.
For more information, see Quotas and limits.
How can I access a running DB host?
You can connect to Managed Service for MySQL® databases using standard DBMS methods.
Learn more about connecting to clusters.
How many clusters can I create within a single cloud?
For more information on MDB technical and organizational limitations, see Quotas and limits.
How are DB clusters maintained?
In Managed Service for MySQL®, maintenance implies:
- Automatic installation of DBMS updates and revisions for DB hosts (including disabled clusters).
- Changes to 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?
Managed Service for MySQL® supports MySQL® 5.7 and MySQL® 8.
What happens when a new DBMS version is released?
The database software is updated when new minor versions are released. Owners of the affected DB clusters are notified of expected work times and DB availability in advance.
What happens when a DBMS version becomes deprecated?
One month after the database version becomes deprecated, Managed Service for MySQL® automatically sends email notifications to the owners of DB clusters created with this 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 versions and one month after notification for major versions. Deprecated major versions are going to be upgraded even if you have disabled automatic updates.
How do you calculate usage cost for a database host?
In Managed Service for MySQL®, the usage cost is calculated based on the following parameters:
- Selected host class.
- Size of the storage reserved for the database host.
- Size of the database cluster backups. Backup size equal to the storage size is free of charge. Backup storage that exceeds this size is charged at special rates.
- Number of hours of database host operation. Partial hours are rounded to an integer value. You can find the cost per hour data for each host class in the Pricing policy section.
How can I change the computing resources and storage size for a database cluster?
You can change computing resources and storage size in the management console. All you need to do is choose a different host class for the required cluster.
The cluster characteristics change within 30 minutes. During this period, other maintenance activities may also be enabled for the cluster, such as installing updates.
Is database host backup enabled by default?
Yes, backup is enabled by default. For MySQL®, 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.
By default, backups are stored for seven days.
When are backups performed? Is a database cluster available during backup?
The backup window is an interval during which a full daily backup of the DB cluster is performed. The backup window is from 01:00 to 05:00 (UTC+3).
Clusters remain fully accessible during the backup window.
Can I change the retention period of automatic backups?
You can set the retention period for automatic backups when creating or modifying a cluster.
What metrics and processes can be tracked using monitoring?
For all DBMS types, you can track:
- CPU, memory, network, or disk usage, in absolute terms.
- Memory, network, or disk usage as a percentage of the set limits for the corresponding cluster host class.
- Amount of data in the DB cluster and the remaining free space in the data storage.
For DB hosts, you can track metrics specific to the corresponding type of DBMS. For example, for MySQL®, you can track:
- Average query execution time.
- Number of queries per second.
- Number of errors in logs, etc.
Monitoring can be performed with a minimum granularity of 5 seconds.
Does the service meet the requirements under Russian Federation Federal Law No. 152-FZ on Personal Data
?
Yes, it does. You can read the full security audit conclusion.
Can I get logs of my operations with services?
Yes, you can request log records about your resources from Yandex Cloud services. For more information, see Data requests.