My Oracle Support Banner

Tips for Minor MySQL Upgrade on an Oracle Big Data Appliance (Doc ID 2855403.1)

Last updated on MARCH 15, 2022

Applies to:

Big Data Appliance Integrated Software - Version 5.1.0 to 5.2.0 [Release 5.0]
Linux x86-64

Purpose

Oracle Big Data Appliance (BDA) clusters support minor MySQL version upgrades.  From, Frequently Asked Questions on using MySQL on Oracle Big Data Appliance with Hadoop Components (Doc ID 1542128.1),  it is possible to upgrade MySQL as long as the major version (5.7) is the same, following the MySQL upgrade docs. There may be health check warnings because of a newer MySQL version e.g. from bdachecksw or bdacheckcluster but these can be ignored.  Therefore upgrading MySQL 5.7.27 or 5.7.32 or an older MySQL 5.7 version to MySQL 5.7.33 or MySQL 5.7.34 is supported.

To perform a minor MySQL upgrade on a BDA cluster follow the MySQL upgrade documentation. For an understanding of the MySQL upgrade process some relevant documents are:

  1. Upgrading MySQL: https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
  2. Before you Begin: https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
  3. Upgrade Paths: https://dev.mysql.com/doc/refman/5.7/en/upgrade-paths.html
  4. Changes in MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
  5. Upgrading MySQL Binary or Package-based Installations on Unix/Linux: https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
  6. Upgrading MySQL with Directly-Downloaded RPM Packages: https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html

Additionally see the Knowledge Articles:

  1. Complete Upgrade Process for your Existing MySQL Server to Newer Versions (Doc ID 1319877.1).
  2. How to Upgrade MySQL Server Using RPMs (Doc ID 1991640.1).

This MOS note provides an example of upgrading MySQL 5.7.32 to MySQL 5.7.34 on BDA 5.2/OL7.9 and provides some tips for minor MySQL upgrades on the BDA.

Scope

 To perform a MySQL 5.7 minor version upgrade on an Oracle Big Data Appliance cluster.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Prerequisites
 Download the MySQL Patch for the MySQL Minor Upgrade
 Perform the Minor MySQL Upgrade
 Stop the Cluster
 Backup MySQL
 Stop MySQL on Both the Master and Slave
 Upgrade the RPMs on Each Cluster Host
 Start and Upgrade the MySQL Slave
 Start and Upgrade the MySQL Master
 Confirm MySQL Replication
 Start the Cluster
 Post MySQL Upgrade Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.