After you create a backup schedule as described in Enable a backup schedule for a MySQL database, you may also need to create an instant backup of a MySQL database.
To create an instant backup automatically:
Log in to the Jenkins web UI.
Open the Galera database backup pipeline.
Specify the required parameters:
Parameter | Description and values |
---|---|
SALT_MASTER_URL | Define the IP address of your Salt Master node host and the
salt-api port. For example, http://172.18.170.27:6969 . |
SALT_MASTER_CREDENTIALS | Define credentials_id as credentials for the connection. |
OVERRIDE_BACKUP_NODE | Fill in the name of the node to back up if you want to override
the automatic node selection.
The default value is none that triggers the automatic node
selection workflow. |
Click Deploy.
The pipeline workflow:
Primary component location and node selection. The pipeline locates the current primary component and selects one of its nodes to use as a source of data for the backup.
Note
The pipeline skips this stage if the
OVERRIDE_BACKUP_NODE
parameter is defined with a preferred
node name.
Backup preparation. Several necessary steps are run to verify that the openssh and xtrabackup states are up to date.
Backup.
Cleanup. The cleanup script is triggered to clean the temporary directories and old backups.
Verify that the backup has been created and, in case of the remote backup storage, moved correctly.