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.
−h, −−help
show this help message and exit
−i CHECKPOINT_INTERVAL, −−interval=CHECKPOINT_INTERVAL
Number of seconds to renew checkpoint
−c CHECKPOINT_DIRECTORY, −−checkpoint_dir=CHECKPOINT_DIRECTORY
Local directory name where checkpoints will be created.
−d DATADIR, −−datadir=DATADIR
backup mode: src MySQL datadir. move_back mode: dest MySQL datadir
−s OUTPUT_STREAM, −−stream=OUTPUT_STREAM
Setting streaming backup options. Currently tar, WDT and xbstream are supported. Default is tar
−−destination=DESTINATION
Remote server name. Only used for WDT mode so far.
−−avg_mbytes_per_sec=AVG_MBYTES_PER_SEC
Average backup rate in MBytes/sec. WDT only.
−−extra_wdt_sender_options=EXTRA_WDT_SENDER_OPTIONS
Extra options for WDT sender
−−extra_wdt_receiver_options=EXTRA_WDT_RECEIVER_OPTIONS
Extra options for WDT receiver
−u MYSQL_USER, −−user=MYSQL_USER
MySQL user name
−p MYSQL_PASSWORD, −−password=MYSQL_PASSWORD
MySQL password name
−P MYSQL_PORT, −−port=MYSQL_PORT
MySQL port number
−S MYSQL_SOCKET, −−socket=MYSQL_SOCKET
MySQL socket path. Takes precedence over −−port.
−m, −−move_back
Moving MyRocks backup files to proper locations.
−r ROCKSDB_DATADIR, −−rocksdb_datadir=ROCKSDB_DATADIR
RocksDB target data directory where backup data files will be moved. Must be empty.
−w ROCKSDB_WALDIR, −−rocksdb_waldir=ROCKSDB_WALDIR
RocksDB target data directory where backup wal files will be moved. Must be empty.
−b BACKUPDIR, −−backup_dir=BACKUPDIR
backup mode for WDT: Remote directory to store backup. move_back mode: Locations where backup files are stored.
−f, −−skip_check_frm_timestamp
skipping to check if frm files are updated after starting backup.
−D DEBUG_SIGNAL_FILE, −−debug_signal_file=DEBUG_SIGNAL_FILE
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/).