Prepare for a Galera cluster restoration

Prepare for a Galera cluster restoration

The restoration of the Galera cluster is fully dependent on the correct Xtrabackup configuration. The service misconfiguration or skipping the data backup stage may lead to the restoration failure.

To prepare for the Galera cluster restoration:

  1. Log in to the Salt Master node.

  2. Configure Xtrabackup by setting the parameters as required in cluster/openstack/database/init.yml. For example:

    Note

    You will need to revert the Xtrabackup configuration after the Galera cluster is restored.

    parameters:
      xtrabackup:
        client:
          enabled: true
          restore_full_latest: 1
          restore_from: remote
    

    The available values for the configurable parameters include:

    • restore_full_latest can have the following values:

      1

      Restore the database from the last complete backup and its increments.

      2

      Restore the database from the second latest complete backup and its increments.

    • restore_from can have the following values:

      local

      Restore from the local storage

      remote

      Use scp to get the files from the xtrabackup server.

  3. Create a data backup using the Xtrabackup service as described in Create an instant backup of a MySQL database. The backup data will be used after the restart is completed.

  4. Proceed with one of the following options: