with IBM Spectrum Protect
There are several ways to protect MariaDB databases, where we are going to focus on using the mariabackup tool.

1.Install the IBM Spectrum Protect Client API
# rpm -ivh gsk*.rpm
# rpm –ivh *api*.rpm
# dpkg -i gsk*.deb
# dpkg –i *api*.deb
2. Install the SPFS software
# rpm -ivh spfs*.rpm
# rpm –ivh spictera*.rpm
# dpkg -i spfs*.deb
# dpkg –i spictera*.deb
3. Configure the Spectrum Protect client
# vi /opt/tivoli/tsm/client/api/bin64/dsm.sys
SERVERNAME spfs
TCPSERVERADDRESS tsm.backupserver.com
ERRORLOGNAME /var/log/dsmerror_spfs.log
4. Register the node on the backup server
TSM> REGISTER NODE SPFS secret DOMAIN=SPFS
5. Configure the SPFS file system
5.1 Create option file
# echo SERVERNAME spfs > /etc/spfs/dsm.opt
5.2 set initial password
# setpassword /etc/spfs/TSM.PWD <<< secret
5.3 Create spfs configuration
# vi /etc/spfs/spfs.opt
MOUNTPOINT /backup
NODENAME spfs
NODEPWDFILE /etc/spfs/TSM.PWD
OPTIONFILE /etc/spfs/dsm.opt
6. mounting the SPFS file system
# mkdir /backup
# mount.spfs /backup
You are now ready to start using Spectrum Protect as a file system, storing and retrieving backup data of MariaDB
Full Backup of MariaDB
# mariadb-backup — backup — user=backup— password=secret — parallel=10 — stream=xbstream > /backup/bu.stream
It is also possible to use the command, if you want each database file to be separate
# mariabackup –user=backup –password=secretpwd \
— parallel=6 –backup –target-dir=/backup/$(date +%Y-%m-%d.%H:%M:%S)
Incremental backup of MariaDB
# mariabackup –prepare –target-dir=/backup/2021-12-27.00:10:00 –incremental-dir=/backup/$(date +%Y-%m-%d.%H:%M:%S)
Restoring from backup
Step 1: stop MariaDB
# systemctl stop mariadb
Step 2: remove data files
# cd /var/lib/mysql
# rm -rf *
Step 3: restore data files
# mbstream -x < /backup/bu.stream
Or if you used the second example, than one can use
# mariabackup –copy-back –target-dir=/backup/201-12-27.00:10:00 –parallel=8
Step 4: prepare
# mariabackup –prepare –target-dir=/var/lib/mysql
Step 5: change ownerships of files
# chown -R mysql.mysql /var/lib/mysql
Step 6: start MariaDB
# systemctl start mariadb
If you want to restore from an older version, than one can change step 3 to the version of interest. Eg previous backup version
# mbstream -x < “/backup/bu.stream(-1)”