MySQL/MariaDB
To create a new application for MySQL database backup, go to the tab: Applications -> Instances
Then select the Create button. The Creating an Application Definition section will be displayed, which needs to be completed.
This is a description of how your script is going to be invoked - you need to specify:
Name - unique name of the application in the Storware Backup & Recovery system.
Choose Node Config - select which node should perform the task.
Backup policy - specify which backup policy should be used for this application.
Command execution configuration - select a prepared template for MySQL backup or create a new one yourself.
On the SSH access subtab, complete the following fields:
Host - set the address of the host where the MySQL instance exists.
Port - set the host port.
Next, select OS Credentials or create a new one and provide the following information:
Name - unique name of the OS Credentials.
User - indicate a user for SSH connection.
Password - enter the connection password.
SSH key path - alternatively, you can specify the SSH key path for authorization.
After saving the application configuration, define the following environment variables:
Environment Variables
VP_MYSQL_DBLIST
string
Comma-separated list of database names to back up.
VP_MYSQL_SCRIPTPATH
string
Path to the backup script on the target MySQL/MariaDB host. Copy the appropriate script from /opt/vprotect/server/scripts/application to the database host. Then provide its destination path here.
VP_MYSQL_STOREPATH
string
Path on the MySQL/MariaDB server for the temporary backup file. Store no other files there. Storware Backup & Recovery removes all files after the backup finishes.
VP_MYSQL_USER
string
MySQL/MariaDB login username.
VP_MYSQL_LOGFILE
string
Path on the MySQL/MariaDB server for the backup job log file.
VP_MYSQL_PASSWORD
string
Database user password.
Last updated