Percona
我可以在我的桌面上執行 Percona xtrabackup 嗎?
我已經在數據庫伺服器上成功執行 xtracbackup,但我真的想在另一台機器上執行備份(不是執行 MySQL 的機器)。
給定主機/埠選項,我嘗試在桌面上執行 xtrabackup 工具,但出現以下錯誤:
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. 150424 16:40:59 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=192.168.33.10;port=3306' as 'vagrant' (using password: YES). 150424 16:40:59 innobackupex: Connected to MySQL server IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". innobackupex: Using mysql server version 5.6.22-72.0 innobackupex: Created backup directory /home/WorkSpace/xtrabackup 150424 16:40:59 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --extra-lsndir='/tmp' --stream=tar innobackupex: Waiting for ibbackup (pid=10463) to suspend innobackupex: Suspend file '/tmp/xtrabackup_suspended_2' xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: ) xtrabackup: uses posix_fadvise(). xtrabackup: Can't change dir to '/var/lib/mysql' (Errcode: 2 - No such file or directory) xtrabackup: cannot my_setwd /var/lib/mysql innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672.
我可以在另一台機器上執行備份嗎?如果是,我還需要安裝什麼?謝謝!
不,您不能在另一台機器上執行它,因為它直接讀取數據文件,而不是通過 mysql 伺服器程序。
但是,您可以在數據庫主機上掛載另一台機器的磁碟空間,並將該空間用作備份的目標目錄。
如果您將另一台機器作為要備份的伺服器的 mysql 從屬伺服器,則可以在該機器上使用 xtrabackup。