1. Patching Guide
  2. Patching Individual Components
  3. Patching the MySQL Cluster Database

Patching the MySQL Cluster Database

Caution:

Ensure that all preparation steps for system patching have been completed. For instructions, see Prepare for Patching.

The MySQL Cluster database is patched independently of the management node host operating system; the MySQL packages are deliberately kept separate from the Oracle Linux upgrade.

Note:

In software version 3.0.2-b892153 and later all patch operations are based on the upgrade plan, which is generated when the pre-upgrade command is executed. For more information, see Prepare for Patching. When a component is already at the required version, the patch operation is skipped. However, patching with the same version can be forced using the Service Web UI or Service CLI command option (force=True), if necessary.

Ensure you perform a system backup before you apply a patch. See the Backup and Restore section of the Oracle Private Cloud Appliance Administrator Guide.

Using the Service Web UI

  1. In the navigation menu, click Upgrade & Patching.

  2. In the top-right corner of the Upgrade Jobs page, click Create Upgrade or Patch.

    The Create Request window appears. Choose Patch as the Request Type.

  3. Select the appropriate patch request type: Patch MySQL.

  4. If required, fill out the patch request parameters:

    • ULN: Enter the fully qualified domain name of the ULN mirror in your data center. This parameter is deprecated in software version 3.0.2-b892153 and later.

    • Advanced Options JSON: Not available.

    • Log Level: Optionally, select a specific log level for the upgrade log file. The default log level is "Information". For maximum detail, select "Debug".

  5. Click Create Request.

    The new patch request appears in the Upgrade Jobs table.

Using the Service CLI

  1. Enter the patch command.

    PCA-ADMIN> patchMySQL
Command: patchMySQL
Status: Success
Time: 2022-01-24 18:46:56.849 UTC
Data: Service request has been submitted.  Upgrade Job ID = 1642593347925-mysql-40566 \
Upgrade Request ID = UWS-1ee38895-dedf-41c5-ab77-eebe294707ed

  2. Use the request ID and the job ID to check the status of the patch process.

    PCA-ADMIN> getupgradejobs
Command: getupgradejobs
Status: Success
Time: 2023-01-24 18:53:22,117 UTC
Data:
  id                               upgradeRequestId                           commandName   result
  --                               ----------------                           -----------   ------
  1642593347925-mysql-40566        UWS-1ee38895-dedf-41c5-ab77-eebe294707ed   mysql         Passed

PCA-ADMIN> getUpgradeJob upgradeJobId=1642593347925-mysql-40566
Command: getUpgradeJob upgradeJobId=1642593347925-mysql-40566
Status: Success
Time: 2023-01-24 18:54:05,408 UTC
Data:
  Upgrade Request Id = UWS-1ee38895-dedf-41c5-ab77-eebe294707ed
  Name = mysql
[...]