Purpose: To ensure MySQL service stability across all servers by locking the MySQL version at 8.0.37 due to known issues in subsequent releases. This policy outlines the rationale, implementation steps, and review schedule for version-locking MySQL packages.
Packages Covered Under Lock
-
mysql-community-server
-
mysql-community-client
-
mysql-community-common
-
mysql-community-libs
-
mysql-community-devel
-
mysql-community-client-plugins
-
mysql-community-icu-data-files
-
mysql80-community-release
Rationale for Locking at 8.0.37
-
MySQL versions 8.0.38 and above have critical issues, including:
-
mysqld crashes when restarting with a large number of tables.
-
performance_schema inconsistencies and memory issues.
-
replication instabilities reported by multiple users.
-
-
These bugs are publicly acknowledged on community forums and have not yet been fully addressed by Oracle.
-
Source references:
Implementation Steps
1. Confirm Installed Version
rpm -q mysql-community-serverExpected:
mysql-community-server-8.0.37-1.el82. Install Version Lock Plugin (if not present)
dnf install python3-dnf-plugin-versionlock -y3. Lock All Related MySQL Packages
dnf versionlock add mysql-community-server-8.0.37*
dnf versionlock add mysql-community-client-8.0.37*
dnf versionlock add mysql-community-common-8.0.37*
dnf versionlock add mysql-community-libs-8.0.37*
dnf versionlock add mysql-community-devel-8.0.37*
dnf versionlock add mysql-community-client-plugins-8.0.37*
dnf versionlock add mysql-community-icu-data-files-8.0.37*
dnf versionlock add mysql80-community-release-8.0.37*4. Confirm Lock
dnf versionlock list | grep mysqlReview Schedule
Frequency: Every 3 months (Quarterly)
Next Review Due: [Auto-fill next quarter date based on current quarter]
Review Tasks:
-
Check MySQL official release notes.
-
Monitor vendor bug tracker / forums for fixes.
-
Validate newer versions in staging before unlocking.
Unlock Procedure (Once Safe Version is Confirmed)
dnf versionlock delete mysql-community-server
# repeat for each package as needed
dnf update mysql-community-serverMaintainer Note: This lock policy is critical for stability of multi-tenant hosting environments and should not be bypassed without change control approval.
Responsible Team: Linux Server Administration Contact: [email protected]