Patching MySQL Cloud Service

Purpose

This tutorial shows how to apply a patch to your MySQL Cloud Service instance to bring the MySQL server up to a newer version.

Time to Complete

10 minutes

Background

Updates for the MySQL database application software are generally released about every quarter. If you have not patched your instance for several months, more than one patch might be available. Unless you have some reason otherwise, you generally patch to the most current version available. Some reasons for not patching to the most recent version would be that you need to meet some prerequisite for a patch or that there is a change in the latest release that you have to account for before applying that patch.

Scenario

At least one patch is available for the MySQL Cloud Service instance. After verifying that the instance meets any prerequisites, apply the latest patch available. View the option to Roll Back the patch.

What Do You Need?

An Oracle Cloud account with an Oracle MySQL Cloud Service instance.

1. Log in to your Oracle Cloud account. Enter your Identity Domain, User Name, and Password.

2. From the MySQL Cloud Service Action menu, open the Service Console for MySQL Cloud Service.

   View Image

   

3. In the list of services, select a service that displays a message that one or more patches are available.

   View Image

   

4. Select the Administration tile to view the patch or patches available.

   View Image

   

   On the Patching tab, the patches available are listed. Depending on how long it has been since you patched, you might have one or more patches available.

   View Image

   

Before applying a patch, you can check for prerequisites. The prerequisite checking operation (precheck) confirms that the patch is available for download, verifies that there is enough storage space to apply the patch and compares the patch's prerequisites to the database deployment. You can also check the release notes, which might provide some issues you should address either before or after patching.

1. From the Quarterly menu, select Precheck.

   View Image

   

2. While the precheck is in progress, click Refresh occasionally to update the status.

   View Image

   

3. When the precheck completes, click the Precheck summary link to view the results of the precheck.

   View Image

   

4. Depending on the results of the precheck, perform one of the following steps:

   • Conflicts listed: Click OK and resolve the conflicts before attempting to patch.
   • No conflicts found: Click OK and continue with the next steps to apply the patch.

   View Image

   

5. Expand Readme and click the link for the release notes.

   View Image

   

6. Check the release notes for any issues you might need to address either before or after you complete the patch. Then close the tab for the release notes.

   View Image

   

After completing the precheck, viewing the release notes, and addressing any issues, you can proceed with the patch.

1. From the menu, select Patch.

   View Image

   

2. In the Notes dialog box, enter any notes to be maintained in the patch history and click Patch.

   View Image

   

3. To check the progress of the patch, click the details icon.

   View Image

   

   The details include what steps have taken place so far.

   View Image

   

4. Refresh occasionally to update the status of the patch.

   View Image

   

5. When the patch completes, and the Available Patches indicates no patches are available, expand Patch and Rollback History to view the new patch in the history.

   View Image

   

After a patch has completed, the system displays a Roll Back button in the Patch and Rollback History. If you have a problem with the new patch you can roll back to the previous version.

1. To view the options for rolling back, click Roll Back.

   View Image

   

2. Depending on whether you want to proceed with the rollback:

   • Continue to roll back to previous version: Enter notes to display in the Patch and Rollback History and click Roll Back.
   • Remain at current patch without rolling back: Click Cancel.

   View Image

   

• Using Oracle MySQL Cloud Service in the Oracle Help Center