Ubuntu MySQL Update: USN-9046-1 Maintenance Checks

Ubuntu's MySQL notice USN-9046-1 raises two practical questions before maintenance. Which package will APT install, and can the application connect to the resulting database server? Check both, especially on a host with several database clients installed.

Identify the server and its packaging source

SELECT VERSION() AS server_version, @@version_comment AS distribution;

Run the query against the application's database endpoint. The shell command mysql --version reports the client version. MariaDB, Oracle's MySQL packages and Ubuntu's MySQL packages each need the advisory from their own distribution channel.

cat /etc/os-release
dpkg-query -W 'mysql-server*'
apt-cache policy mysql-server
apt-get -s install --only-upgrade mysql-server

The final command simulates an upgrade for an Ubuntu installation managed through mysql-server. Use the actual installed package name if yours differs. Review the proposed version and accompanying package changes. Compare the complete revision with the notice entry for your Ubuntu release. Ubuntu MySQL notice

Validate recovery and test an application connection

Replacing packages can interrupt database connections. Before maintenance, have a backup with a tested restore procedure and a window that allows for interruption. If the upgrade crosses a release branch, consult its upgrade documentation for compatibility and recovery options.

After maintenance, run the version query again. Perform a small read through the application's normal connection, check that scheduled jobs can reconnect, and inspect database errors recorded since maintenance. For persistent disconnects, compare their timing and scope with the MySQL disconnect guide.