Yandex Managed Service for MySQL release notes
Written by
Updated at June 26, 2024
This section contains Managed Service for MySQL release notes.
Labels next to the revision description let you see in what interface it is supported: the management console, CLI, API, Terraform, or SQL.
May 2024
Q4 2023
- A new MySQL version is available: 8.0.31
.
Q2 2023
- New MySQL versions are now available: 5.7.39
and 8.0.30 . - MySQL 5.7 now supports analyzing queries using
query_response_time_stats
. For more information, see the Percona documentation . - Added new global user permissions:
FLUSH_OPTIMIZER_COSTS
andSHOW_ROUTINE
.
Q4 2022
-
The status of a host on the Hosts page now changes to
READ-ONLY
in the management console if data writes to the host are disabled.Management console
-
You can now move a cluster to a different folder using Terraform.
-
Added new DBMS settings:
Backup retain period days
- Lock wait timeout
- Max prepared stmt count
- Optimizer search depth
- Optimizer switch
Q3 2022
- Added the
Free space
plot on the cluster monitoring tab and anInode usage
plot on the host monitoring page.Management console
- Added the Binlog transaction dependency tracking setting.
Q2 2022
- In the Terraform configuration files, we removed the
database
and theuser
sections; instead, we added theyandex_mdb_mysql_database
and theyandex_mdb_mysql_user
resources.Terraform
- Added the Innodb compression level setting.
- Accelerated the process of restoring replicas from a backup by using WAL-G with subsequent synchronization of data from the master host.
- Fixed the display of long queries on the Performance diagnostics tab.
Management console
Q1 2022
- You can now edit the Innodb strict mode, Max digest length, and Max sp recursion depth settings.
Management console
CLI
API
Terraform
- Added a section on MySQL cluster performance in Terraform.
Terraform
- You can now manage the settings of the performance diagnostics service.
Management console
CLI
API
Terraform
- Updated the master failover mechanism: you can no longer switch to a replica that is lagging far behind or change the master if there is no quorum. The maximum lag for a replica is set by the Mdb priority choice max lag setting.
- You can now set a priority for selecting a master host if the master changes.
Management console
CLI