MariaDB Backup
Before taking database backup for your MariaDB database server, a lightweight agent needs to be installed on the database server, please refer to Agents for how to install agents on your database servers.
After the agents had been installed and licensed for database backup, please follow the below steps to create database backup job.
Configure Application
After the installation of Vinchin physical backup agent on MariaDB database server, users have to license the agent with database backup module.
When done installation and licensing, please open Vinchin Backup Server web console and go to Resources > Agents page, find the target agent, click on Options and then select Application to configure application settings for database backup.
Click on Configure Application button to configure the application settings.
In the Application Type dropdown list, please select MariaDB and then click on Next.
In the Applications Settings screen, please configure the following settings.
In the CNF File Location field, please type in the file path of MariaDB cnf file. Providing database administrator username and password.
Vinchin provides two authentication modes: tcp/ip authentication and sock file authentication. If connecting to MySQL via tcp/ip authentication, default IP address is 127.0.0.1, default port is 3306 (please fill the IP address and port based on actual situation). If connecting to MySQL via sock file authentication, the default host name is localhost, and the sock file path is filled in according to the actual situation.
Leave the IP Address and Port number with default value and click on OK to complete the application configuration.
When MariaDB application is successfully configured, you should see the agent in the agents list.
Before Backing Up MariaDB Database
If you want to run MariaDB log backup, MariaDB database needs binary logging enabled. You can check with below command from MariaDB database command line interface.
show variables like ‘%log_bin%’;
If you got log_bin value as on, which means binary logging is enabled.
If binary logging is not enabled, it needs the database administrator to enable it.
Create Backup Job
To create database backup jobs, please go to Physical Backup > Database Backup > Backup page. There are 4 steps to create a database backup job.
Step 1: Backup Source
First select backup source from left column, then select MariaDB database instance you wish to backup, in the right column will show which instance you selected.
Step 2: Backup Destination
A backup destination (backup storage) should be associated with this backup job.
In the Target Node dropdown list, you can select a backup node on which you want the backup data to be processed and stored.
In the Target Storage dropdown list, the storages belong to the selected backup node can be selected.
Step 3. Configure Backup Strategies
General Strategy
In the General Strategy, you can configure the time schedule of the backup job, you can configure the job as a Backup as Scheduled job or a Once-off Backup job.
For a once-off backup job, the job will only run for once, and only full backup will be performed. You only have to appoint a time of when to start the backup job, in the Start Time field.
For backup job type, you can schedule Full Backup, Incremental Backup and Log Backup. Please set the backup mode and backup schedule as per your actual demands.
Throttling Policy settings are optional, only if the backup jobs will bring network or I/O overload to your production environment, you can configure the throttling policy accordingly otherwise leave it unconfigured.
An As Scheduled policy can be configured to limit the backup speed on Daily, Weekly and Monthly basis.
A Permanent policy will always limit the backup speed within the specified Max Speed.
There are 3 options in Data Storage Policy section, Data Deduplication, Data Compression and Data Encryption.
By enabling Data Deduplication and Data Compression, you can save the bandwidth and storage resources for transmitting and storing the backup data.
By enabling Data Encryption, the backup data will be encrypted and then stored into the backup storage. A password needs to be specified to secure the data encryption, when creating a database restore job, password verification is required to perform database restore.
For the Retention Policy of the database backup, there are 2 retention mode, retain the database backups according to Number of Restore Points or Number of Days.
For the retention mode Number of Restore Points, the restore points will be counted by full restore points, including the incremental backups and log backups dependent on this full backup.
For retention mode Number of Days, Vinchin Backup Server will save the restore points within the specified number of days.
When the retention policy is triggered, the outdated restore points will be purged to comply with the retention policy.
Transmission Strategy
In the Transmission Strategy, you can choose to enable Encrypted Transmission for data safety. The backup data will be transferred through LAN by default, and you can set the transmission network for data transfer.
Step 4: Review & Confirm
After completing the above-mentioned settings, you are able to review and confirm the settings in one screen.
A job name can be specified for identification of the database backup job, and by clicking on the Submit button to create the backup job.