MYROCKS_HOTBACKUP(1) MariaDB Database System MYROCKS_HOTBACKUP(1)

myrocks_hotbackup - streaming backup for MariaDB MyRocks

Usage:

Backup: set -o pipefail; myrocks_hotbackup --user=root --password=pw --port=3306 --checkpoint_dir=<directory where temporary backup hard links are created> | ssh -o NoneEnabled=yes remote_server 'tar -xi -C <directory on remote server where backups will be sent>' . You need to execute backup command on a server where you take backups.

Backup using WDT: myrocks_hotbackup --user=root --password=pw --stream=wdt --checkpoint_dir=<directory where temporary backup hard links are created> --destination=<remote host name> --backup_dir=<remote directory name>. This has to be executed at the src host.

Move-Back: myrocks_hotbackup --move_back --datadir=<dest mysql datadir> --rocksdb_datadir=<dest rocksdb datadir> --rocksdb_waldir=<dest rocksdb wal dir> --backup_dir=<where backup files are stored> . You need to execute move-back command on a server where backup files are sent.

show this help message and exit
Number of seconds to renew checkpoint
Local directory name where checkpoints will be created.
backup mode: src MySQL datadir. move_back mode: dest MySQL datadir
Setting streaming backup options. Currently tar, WDT and xbstream are supported. Default is tar
Remote server name. Only used for WDT mode so far.
Average backup rate in MBytes/sec. WDT only.
Extra options for WDT sender
Extra options for WDT receiver
MySQL user name
MySQL password name
MySQL port number
MySQL socket path. Takes precedence over --port.
Moving MyRocks backup files to proper locations.
RocksDB target data directory where backup data files will be moved. Must be empty.
RocksDB target data directory where backup wal files will be moved. Must be empty.
backup mode for WDT: Remote directory to store backup. move_back mode: Locations where backup files are stored.
skipping to check if frm files are updated after starting backup.
debugging purpose: waiting until the specified file is created

For more information, please refer to the MariaDB Knowledge Base, available online at https://mariadb.com/kb/

MariaDB Foundation (http://www.mariadb.org/).

15 May 2020 MariaDB 10.11