myrocks_hotbackup(1) — Linux manual page

MYROCKS_HOTBACKUP(1)     MariaDB Database System    MYROCKS_HOTBACKUP(1)

NAME         top

       myrocks_hotbackup - streaming backup for MariaDB MyRocks

DESCRIPTION         top

       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.

OPTIONS         top

       -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

SEE ALSO         top

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

AUTHOR         top

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

COLOPHON         top

       This page is part of the MariaDB (MariaDB database server)
       project.  Information about the project can be found at 
       ⟨http:https://mariadb.org/⟩.  If you have a bug report for this manual
       page, see ⟨https://mariadb.com/kb/en/mariadb/reporting-bugs/⟩.
       This page was obtained from the project's upstream Git repository
       ⟨https://github.com/MariaDB/server⟩ on 2023-12-22.  (At that
       time, the date of the most recent commit that was found in the
       repository was 2023-05-11.)  If you discover any rendering
       problems in this HTML version of the page, or you believe there
       is a better or more up-to-date source for the page, or you have
       corrections or improvements to the information in this COLOPHON
       (which is not part of the original manual page), send a mail to
       [email protected]

MariaDB 10.8                   15 May 2020          MYROCKS_HOTBACKUP(1)

HTML rendering created 2023-12-22 by Michael Kerrisk, author of The Linux Programming Interface. For details of in-depth Linux/UNIX system programming training courses that I teach, look here. Hosting by jambit GmbH.