Upgrading Between Minor Versions with Galera Cluster

You are viewing an old version of this article. View the current version here.

To upgrade between minor versions of MariaDB (for example from MariaDB 10.3.12 to MariaDB 10.3.13) when Galera Cluster is being used, the best way to accomplish that with minimal downtime is usually to perform a rolling upgrade. The following rolling upgrade procedure is suggested:

First, take a backup of your database. This is always a good idea to do before an upgrade. We would recommend Mariabackup.

Then, for each node, perform the following steps:

  1. Stop MariaDB.
  2. Uninstall the old version of MariaDB and the Galera wsrep provider.
  3. Install the new version of MariaDB and the Galera wsrep provider.
  4. Make any desired changes to configuration options in option files, such as my.cnf.
  5. Start MariaDB.
  6. Run mysql_upgrade with the --skip-write-binlog option.
    • mysql_upgrade does two things:
      1. Ensures that the system tables in the mysql database are fully compatible with the new version.
      2. Does a very quick check of all tables and marks them as compatible with the new version of MariaDB .

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.