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:

   • Restore a Galera cluster and database automatically
   • Restore a Galera cluster manually