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

Last updated on APRIL 17, 2023

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:

Upgrading MySQL: https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
Before you Begin: https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
Upgrade Paths: https://dev.mysql.com/doc/refman/5.7/en/upgrade-paths.html
Changes in MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Upgrading MySQL Binary or Package-based Installations on Unix/Linux: https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
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:

Complete Upgrade Process for your Existing MySQL Server to Newer Versions (Doc ID 1319877.1).
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.