Protecting Clickhouse database
with IBM Spectrum Protect
This litterature would try to explain the flexibility to use spictera SPFS in combination with IBM Spectrum Protect. spictera is a company that creates innovative data protection solutions, using simple and easy to use interface. This example here will show the strenght, and flexibility of using SPFS.
ClickHouse® is a column-oriented database management system (DBMS) for online analytical processing of queries (OLAP).Clockhouse is a database.
Spectrum Protect Installation
# rpm -i gsk*.rpm
# rpm -i TIVsm-API64*.rpm
Or
# dpkg -i gsk*.deb
# dpkg -i tivsm-api64*.deb
Spictera Installation
# rpm -i spictera*.rpm
# rpm -i spfs*.rpm
Or
# dpkg -i spictera*.deb
# dpkg -i spfs*.deb
Spectrum Protect Server configuration
SP> DEFINE DOMAIN spfs
SP> DEFINE POLICYSET spfs standard
SP> DEFINE COPYGROUP spfs standard 30days TYPE=ARCHIVE DESTINATION=archivepool RETVER=30
SP> ACTIVATE POLICYSET spfs standard standard
SP> REGISTER NODE spfs secretpwd
Spectrum Protect Client API configuration
# vi /opt/tivoli/tsm/client/api/bin64/dsm.sys
SERVERNAME spfs
TCPSERVERADDRESS tsm.backup.com
ERRORLOGNAME /var/log/dsmerror_spfs.log
# echo SERVERNAME spfs > /etc/spfs/dsm.opt
Spictera configuration
# vi /etc/spfs/spfs.opt
MOUNTPOINT /archive
NODENAME spfs
NODEPWDFILE /etc/spfs/TSM.PWD
OPTIONFILE /etc/spfs/dsm.opt
DATATYPE ARCHIVE
# setpassword /etc/spfs/TSM.PWD <<< secretpwd
# mkdir /archive
# mount.spfs /archive
Your are now ready to perform your backups
$ clickhouse-copier --daemon --config zookeeper.xml --task-path /task/path --base-dir /archive
