Upgrading to MySQL 9.7 LTS: A Step-by-Step Guide to Oracle's Latest Long-Term Support Release

By • min read

Introduction

MySQL 9.7.0 has officially gone GA, marking the first major Long-Term Support (LTS) release since MySQL 8.4. This release brings several enterprise-grade features to the Community Edition, although it arrives amid community discussions about Oracle's development commitment and overall MySQL activity. This step-by-step guide will walk you through upgrading to MySQL 9.7 LTS, whether you're moving from MySQL 8.4 or an earlier version, and help you take advantage of the new capabilities while ensuring a smooth transition. Follow each step carefully to minimize downtime and risk.

Upgrading to MySQL 9.7 LTS: A Step-by-Step Guide to Oracle's Latest Long-Term Support Release — Source: www.infoq.com

What You Need

A running MySQL instance (preferably 8.0 or later; can be 8.4 if upgrading directly)
Root or administrative access to the MySQL server
Sufficient disk space for backup and upgrade files (at least 2x the current data size)
A recent backup of all databases (logical dump or filesystem-level)
Access to Oracle's official MySQL downloads page
A test environment (recommended) to validate the upgrade before production
Basic familiarity with MySQL command-line tools and configuration

Step-by-Step Upgrade Guide

Step 1: Evaluate Your Current Environment

Before upgrading, thoroughly audit your existing MySQL setup. Check your current version, storage engines used, replication topology, database character sets, and any custom plugins or extensions. Run SELECT VERSION(); and SHOW VARIABLES LIKE 'innodb_version';. Verify that your operating system and hardware meet the new requirements for MySQL 9.7. Review the MySQL 9.7 release notes for deprecations and removals – particularly features that may be removed and affect your workloads.

Step 2: Create a Full Backup

This is the most critical step. Use mysqldump to create a logical backup of all databases, or take a filesystem snapshot if using InnoDB with mysqlbackup. Run: mysqldump --all-databases --routines --events --triggers --single-transaction > full_backup.sql. For large databases, consider mysqlpump or Percona XtraBackup. Store the backup in a secure, off-server location. Without a valid backup, you risk irreversible data loss.

Step 3: Download MySQL 9.7.0 LTS

Visit the official MySQL downloads page and select the appropriate package for your operating system (Linux, Windows, macOS). Choose the LTS release labeled 9.7.0. Download the installation archive or repository package. Also download the MySQL Shell and MySQL Router if you use them. Verify the file checksums to ensure integrity.

Step 4: Install or Upgrade the MySQL Server

The installation method depends on your current setup. If you're using a package manager (like APT or YUM), add the MySQL 9.7 repository and update. Alternatively, perform an in-place upgrade using the binary tarball. Always stop the MySQL service first: sudo systemctl stop mysql. Then run the upgrade process: for RPM-based systems use yum localinstall mysql-9.7.0-*.rpm; for DEB use dpkg -i mysql-9.7.0-*.deb. After installation, start the server and run mysql_upgrade to update system tables and check compatibility. Follow any prompts.

Step 5: Configure New Enterprise Features

MySQL 9.7 LTS brings several enterprise features to the Community Edition, including improved InnoDB performance, enhanced security roles, and extended monitoring capabilities. Evaluate which features are beneficial for your use case:

New security roles: Use CREATE ROLE and GRANT to implement fine-grained access control without duplication.
Performance schema enhancements: Enable additional consumers and instruments to gain deeper insight.
InnoDB parallel read and write improvements: Adjust innodb_parallel_read_threads if applicable.
New audit plugin options: Configure logging for compliance.

Review the my.cnf file and adjust innodb_buffer_pool_size and other memory parameters based on new defaults. Do not blindly copy old config values – many may have changed.

Step 6: Test Applications and Queries

Before pointing production traffic to the upgraded server, thoroughly test your applications. Use a staging environment or a duplicated instance. Run your complete test suite, including:

Basic CRUD operations
Stored procedures and triggers
Replication (if applicable) with a test replica
High-concurrency scenarios

Monitor query execution plans – MySQL 9.7 includes optimizer changes that may alter performance. Use EXPLAIN ANALYZE to understand execution details. If queries slow down, consider updating statistics or adding indexes. Keep an eye on error logs for any deprecation warnings.

Step 7: Monitor and Optimize Performance

After the upgrade is live, implement continuous monitoring. Use MySQL Enterprise Monitor or open-source alternatives like Prometheus + mysqld_exporter. Pay attention to:

Connection counts and thread pool behavior
Query response times
Disk I/O and buffer pool hit ratio
Replication lag (if using replication)

Adjust system variables accordingly. MySQL 9.7 LTS is designed for long-term stability, so you gain from extended support while having access to enterprise capabilities. Some community members remain cautious about Oracle's involvement, but the LTS designation assures at least five years of updates.

Tips for a Successful Upgrade

Always back up before upgrading – even a minor version change can cause unexpected issues. Keep the backup for at least a week after the upgrade.
Test in a non-production environment first – replicate your production setup as closely as possible to identify incompatibilities.
Review the official MySQL 9.7 release notes for all deprecations, removals, and behavior changes.
Monitor community forums for real-world experiences – Oracle's release may have undiscovered issues that early adopters report.
Leverage the new enterprise features to simplify security and monitoring, but avoid enabling everything at once. Gradual adoption reduces risk.
Plan for a rollback – have a procedure to revert to the previous version if critical failures occur. This may require restoring the backup.
Keep your MySQL shell and clients updated to the 9.7 versions for best compatibility.

By following these steps and tips, you can confidently upgrade to MySQL 9.7 LTS and benefit from Oracle's latest innovations while maintaining a stable, secure database environment.