- 浏览: 981356 次
文章分类
- 全部博客 (428)
- Hadoop (2)
- HBase (1)
- ELK (1)
- ActiveMQ (13)
- Kafka (5)
- Redis (14)
- Dubbo (1)
- Memcached (5)
- Netty (56)
- Mina (34)
- NIO (51)
- JUC (53)
- Spring (13)
- Mybatis (17)
- MySQL (21)
- JDBC (12)
- C3P0 (5)
- Tomcat (13)
- SLF4J-log4j (9)
- P6Spy (4)
- Quartz (12)
- Zabbix (7)
- JAVA (9)
- Linux (15)
- HTML (9)
- Lucene (0)
- JS (2)
- WebService (1)
- Maven (4)
- Oracle&MSSQL (14)
- iText (11)
- Development Tools (8)
- UTILS (4)
- LIFE (8)
最新评论
-
Donald_Draper:
Donald_Draper 写道刘落落cici 写道能给我发一 ...
DatagramChannelImpl 解析三(多播) -
Donald_Draper:
刘落落cici 写道能给我发一份这个类的源码吗Datagram ...
DatagramChannelImpl 解析三(多播) -
lyfyouyun:
请问楼主,执行消息发送的时候,报错:Transport sch ...
ActiveMQ连接工厂、连接详解 -
ezlhq:
关于 PollArrayWrapper 状态含义猜测:参考 S ...
WindowsSelectorImpl解析一(FdMap,PollArrayWrapper) -
flyfeifei66:
打算使用xmemcache作为memcache的客户端,由于x ...
Memcached分布式客户端(Xmemcached)
Percona安装:http://donald-draper.iteye.com/admin/blogs/2314832
命令介绍:
The database user used to connect to the server and its password are specified by the --user and --password option,
$ innobackupex --user=DBUSER --password=SECRET /path/to/backup/dir/
$ innobackupex --user=LUKE --password=US3TH3F0RC3 --stream=tar ./ | bzip2 -
$ xtrabackup --user=DVADER --password=14MY0URF4TH3R --backup --target-dir=/data/bkps/
If you don’t use the --user option, Percona XtraBackup will assume
the database user whose name is the system user executing it.
Other Connection Options
According to your system, you may need to specify one or more of the following options to connect to the server:
Option Description
–port The port to use when connecting to the database server with TCP/IP.
–socket The socket to use when connecting to the local database.
–host The host to use when connecting to the database server with TCP/IP.
innobackupex
a wrapper script that provides functionality to backup a
whole MySQL database instance with MyISAM, InnoDB, and XtraDB tables.
xtrabackup
a compiled C binary, which copies only InnoDB and XtraDB data
xbstream
new utility that allows streaming and extracting files to/from the xbstream format.
It is possible to use the xtrabackup binary alone, however,
the recommend way is using it through the innobackupex wrapper script and
let it execute xtrabackup for you. It might be helpful to first learn
how to use innobackupex, and then learn how to use xtrabackup for
having a better low-level understanding or control of the tool if needed.
---------------------------------------------------------------------------
命令实例:
# --defaults-file指定mysql配置文件
# innobackupex --defaults-file=/etc/my.cnf --user=donald --password=123456 /home/test/base
备份, 添加--no-timestamp选项,无时间戳,直接备份在base中,否则在base以时间戳建一个文件夹
innobackupex --user=donald --password=123456 --no-timestamp /home/test/base
准备还原:--use-memory 使用内存
innobackupex --apply-log --use-memory=100M /home/test/base
开始:
innobackupex --copy-back /home/test/base
注意:innobackupex备份的时候,innobackupex必须可以访问mysql datafile目录
以下是全量备份实验:
我的mysqldata数据目录是msyqldata
修改mysql数据目录权限:
[donald@test home]$ ls -al
total 12
drwxr-xr-x. 7 root root 79 Aug 3 10:48 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxrwxr-x. 5 mysql mysql 4096 Aug 5 11:37 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
[donald@test home]$ sudo chmod -R 777 mysqldata
[donald@test home]$ ls -al
total 12
drwxr-xr-x. 7 root root 79 Aug 3 10:48 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 11:37 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
备份:
donald@test home]$ innobackupex --user=donald --password=123456 /home/test/base
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.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
....
查看生成的文件:
[donald@test base]$ ls
2016-08-05_16-08-30
[donald@test base]$ cd 2016-08-05_16-08-30/
[donald@test 2016-08-05_16-08-30]$ ls -al
total 274468
drwxr-xr-x 5 donald user 4096 Aug 5 16:08 .
drwx------ 3 donald user 32 Aug 5 16:10 ..
-rw-r--r-- 1 donald user 295 Aug 5 16:08 backup-my.cnf
-rw-r----- 1 donald user 281018368 Aug 5 16:08 ibdata1
drwx------ 2 donald user 4096 Aug 5 16:08 mysql
drwxr-xr-x 2 donald user 4096 Aug 5 16:08 performance_schema
drwx------ 2 donald user 4096 Aug 5 16:08 test
-rw-r--r-- 1 donald user 22 Aug 5 16:08 xtrabackup_binlog_info
-rw-r----- 1 donald user 97 Aug 5 16:08 xtrabackup_checkpoints
-rw-r--r-- 1 donald user 573 Aug 5 16:08 xtrabackup_info
-rw-r----- 1 donald user 2560 Aug 5 16:08 xtrabackup_logfile
查看检查点文件:
[donald@test 2016-08-05_16-08-30]$ cat xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 13194628771
last_lsn = 13194628771
compact = 0
准备恢复:
[donald@test home]$ innobackupex --apply-log /home/test/base/2016-08-05_16-08-30
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.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
160805 16:13:09 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
转移mysql数据文件:
[donald@test home]$ sudo service mysql stop
Shutting down MySQL.. SUCCESS!
[donald@test home]$ sudo mv mysqldata mysqldata2
[donald@test home]$ ls
donald= mysqldata1 mysqldata2 mysqllog test
全量恢复:
[donald@test home]$ sudo innobackupex --copy-back /home/test/base/2016-08-05_16-08-30/
.....
innobackupex: Starting to copy InnoDB log files
innobackupex: in '/home/test/base/2016-08-05_16-08-30'
innobackupex: back to original InnoDB log directory '/home/mysqldata'
innobackupex: Copying '/home/test/base/2016-08-05_16-08-30/ib_logfile1' to '/home/mysqldata/ib_logfile1'
innobackupex: Copying '/home/test/base/2016-08-05_16-08-30/ib_logfile0' to '/home/mysqldata/ib_logfile0'
innobackupex: Finished copying back files.
160805 16:22:57 innobackupex: completed OK!
[donald@test home]$ ls
donald= mysqldata mysqldata1 mysqldata2 mysqllog test
[donald@test home]$ ls -al
total 16
drwxr-xr-x. 8 root root 96 Aug 5 16:21 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxr-xr-x 5 root root 4096 Aug 5 16:22 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 16:19 mysqldata2
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
恢复mysql数据目录权限
[donald@test home]$ sudo chown -R mysql:mysql mysqldata
[donald@test home]$ ls -al
total 16
drwxr-xr-x. 8 root root 96 Aug 5 16:21 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxr-xr-x 5 mysql mysql 4096 Aug 5 16:22 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 16:19 mysqldata2
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
[donald@test home]$ sudo service mysql start
Starting MySQL.. SUCCESS!
至此全量恢复完成,注意在备份恢复的过程中,mysql目录文件夹的权限。
命令介绍:
The database user used to connect to the server and its password are specified by the --user and --password option,
$ innobackupex --user=DBUSER --password=SECRET /path/to/backup/dir/
$ innobackupex --user=LUKE --password=US3TH3F0RC3 --stream=tar ./ | bzip2 -
$ xtrabackup --user=DVADER --password=14MY0URF4TH3R --backup --target-dir=/data/bkps/
If you don’t use the --user option, Percona XtraBackup will assume
the database user whose name is the system user executing it.
Other Connection Options
According to your system, you may need to specify one or more of the following options to connect to the server:
Option Description
–port The port to use when connecting to the database server with TCP/IP.
–socket The socket to use when connecting to the local database.
–host The host to use when connecting to the database server with TCP/IP.
innobackupex
a wrapper script that provides functionality to backup a
whole MySQL database instance with MyISAM, InnoDB, and XtraDB tables.
xtrabackup
a compiled C binary, which copies only InnoDB and XtraDB data
xbstream
new utility that allows streaming and extracting files to/from the xbstream format.
It is possible to use the xtrabackup binary alone, however,
the recommend way is using it through the innobackupex wrapper script and
let it execute xtrabackup for you. It might be helpful to first learn
how to use innobackupex, and then learn how to use xtrabackup for
having a better low-level understanding or control of the tool if needed.
---------------------------------------------------------------------------
命令实例:
# --defaults-file指定mysql配置文件
# innobackupex --defaults-file=/etc/my.cnf --user=donald --password=123456 /home/test/base
备份, 添加--no-timestamp选项,无时间戳,直接备份在base中,否则在base以时间戳建一个文件夹
innobackupex --user=donald --password=123456 --no-timestamp /home/test/base
准备还原:--use-memory 使用内存
innobackupex --apply-log --use-memory=100M /home/test/base
开始:
innobackupex --copy-back /home/test/base
注意:innobackupex备份的时候,innobackupex必须可以访问mysql datafile目录
以下是全量备份实验:
我的mysqldata数据目录是msyqldata
修改mysql数据目录权限:
[donald@test home]$ ls -al
total 12
drwxr-xr-x. 7 root root 79 Aug 3 10:48 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxrwxr-x. 5 mysql mysql 4096 Aug 5 11:37 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
[donald@test home]$ sudo chmod -R 777 mysqldata
[donald@test home]$ ls -al
total 12
drwxr-xr-x. 7 root root 79 Aug 3 10:48 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 11:37 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
备份:
donald@test home]$ innobackupex --user=donald --password=123456 /home/test/base
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.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
....
查看生成的文件:
[donald@test base]$ ls
2016-08-05_16-08-30
[donald@test base]$ cd 2016-08-05_16-08-30/
[donald@test 2016-08-05_16-08-30]$ ls -al
total 274468
drwxr-xr-x 5 donald user 4096 Aug 5 16:08 .
drwx------ 3 donald user 32 Aug 5 16:10 ..
-rw-r--r-- 1 donald user 295 Aug 5 16:08 backup-my.cnf
-rw-r----- 1 donald user 281018368 Aug 5 16:08 ibdata1
drwx------ 2 donald user 4096 Aug 5 16:08 mysql
drwxr-xr-x 2 donald user 4096 Aug 5 16:08 performance_schema
drwx------ 2 donald user 4096 Aug 5 16:08 test
-rw-r--r-- 1 donald user 22 Aug 5 16:08 xtrabackup_binlog_info
-rw-r----- 1 donald user 97 Aug 5 16:08 xtrabackup_checkpoints
-rw-r--r-- 1 donald user 573 Aug 5 16:08 xtrabackup_info
-rw-r----- 1 donald user 2560 Aug 5 16:08 xtrabackup_logfile
查看检查点文件:
[donald@test 2016-08-05_16-08-30]$ cat xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 13194628771
last_lsn = 13194628771
compact = 0
准备恢复:
[donald@test home]$ innobackupex --apply-log /home/test/base/2016-08-05_16-08-30
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.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
160805 16:13:09 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
转移mysql数据文件:
[donald@test home]$ sudo service mysql stop
Shutting down MySQL.. SUCCESS!
[donald@test home]$ sudo mv mysqldata mysqldata2
[donald@test home]$ ls
donald= mysqldata1 mysqldata2 mysqllog test
全量恢复:
[donald@test home]$ sudo innobackupex --copy-back /home/test/base/2016-08-05_16-08-30/
.....
innobackupex: Starting to copy InnoDB log files
innobackupex: in '/home/test/base/2016-08-05_16-08-30'
innobackupex: back to original InnoDB log directory '/home/mysqldata'
innobackupex: Copying '/home/test/base/2016-08-05_16-08-30/ib_logfile1' to '/home/mysqldata/ib_logfile1'
innobackupex: Copying '/home/test/base/2016-08-05_16-08-30/ib_logfile0' to '/home/mysqldata/ib_logfile0'
innobackupex: Finished copying back files.
160805 16:22:57 innobackupex: completed OK!
[donald@test home]$ ls
donald= mysqldata mysqldata1 mysqldata2 mysqllog test
[donald@test home]$ ls -al
total 16
drwxr-xr-x. 8 root root 96 Aug 5 16:21 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxr-xr-x 5 root root 4096 Aug 5 16:22 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 16:19 mysqldata2
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
恢复mysql数据目录权限
[donald@test home]$ sudo chown -R mysql:mysql mysqldata
[donald@test home]$ ls -al
total 16
drwxr-xr-x. 8 root root 96 Aug 5 16:21 .
dr-xr-xr-x. 17 root root 4096 Jul 26 14:32 ..
drwx------. 18 donald user 4096 Aug 5 11:38 donald=
drwxr-xr-x 5 mysql mysql 4096 Aug 5 16:22 mysqldata
drwxr-xr-x 5 mysql mysql 119 Jul 26 15:51 mysqldata1
drwxrwxrwx. 5 mysql mysql 4096 Aug 5 16:19 mysqldata2
drwxrwxr-x. 2 mysql mysql 64 Jul 26 16:05 mysqllog
drwxr-x--- 4 donald user 30 Aug 5 15:00 test
[donald@test home]$ sudo service mysql start
Starting MySQL.. SUCCESS!
至此全量恢复完成,注意在备份恢复的过程中,mysql目录文件夹的权限。
发表评论
-
Deadlock found when trying to get lock; try restarting transaction解决方式
2017-07-18 23:00 2062MySQL 事务的学习整理:http://blog.csdn. ... -
MySQL慢日志
2017-05-18 16:05 1034The Slow Query Log:https://dev. ... -
The table is full问题解决过程
2017-05-06 15:29 7602The table‘xxxx’is full 设置临时表大小 ... -
百万级数据-程序迁移后续
2017-04-13 18:09 1635百万级数据-程序迁移:http://donald-draper ... -
Msyql日期字符串转换
2017-04-01 14:13 542Date和String的互相转换:http://www.tui ... -
Mysql添加约束
2017-03-31 16:28 901MySQL中对三种约束的支持:http://leekai.me ... -
Linux系统和用户线程数进程数限制查询
2017-02-23 19:30 3402#查系统支持的最大线程数,一般会很大,相当于理论值 Donal ... -
Mysql FEDERATED引擎
2016-11-29 15:51 605使用mysql federated引擎构建MySQL分布式数据 ... -
MySQL触发器
2016-11-24 19:04 718CHANGE MASTER:http://dev.mysql. ... -
Mysql主从配置
2016-11-11 18:31 5291、主从服务器分别作以下操作: 1)版本一致 2)初始 ... -
Linux的sftp命令教程
2016-10-29 17:27 1916sftp常用命令:http://www.cnblogs.com ... -
Linux Crontab 命令使用
2016-10-24 19:04 628Linux定时任务Crontab详解:http://blog. ... -
百万级数据-程序迁移
2016-09-29 19:03 2633JVM学习笔记:http://blog.csdn.net/cu ... -
安装完Ubuntu15.10要做的事情
2016-08-12 08:50 610安装Vmware-tools:http://donald-dr ... -
Ubuntu关闭Ipv6
2016-08-12 08:49 1323查看端口: donald_draper@rain:~$ net ... -
多账户登录ubuntu 15.10
2016-08-12 08:50 566编辑文件/usr/share/lightdm/lightdm. ... -
Ubuntu 桌面上角文字
2016-08-11 17:55 1079先为Ubuntu瘦身:http://blog.csdn.net ... -
Ubuntu安装 Vmware-tool
2016-08-11 17:46 1104参考:http://www.linuxdiyf.c ... -
Linux curl命令
2016-08-11 09:18 580参考:http://www.linuxdiyf.com/lin ... -
centos 添加sudo权限
2016-08-10 16:11 1528[zabbix@zabbix sbin]$ ls -al /e ...
相关推荐
总的来说,Xtrabackup作为一款强大的MySQL备份工具,以其高效的备份和恢复能力,以及对InnoDB引擎的优化,成为了许多企业和开发者的选择。通过合理配置和使用Xtrabackup,可以实现高效、安全的数据库备份,确保在...
总的来说,Percona XtraBackup是MySQL备份解决方案的有力选择,特别是在需要高效、安全、无中断备份的业务环境中。通过熟练掌握和使用这款工具,可以有效地保护数据,提高系统的可用性和可靠性。
内容概要:本文详细介绍了一套基于MySQL的全量与增量备份方案,具体涉及全量备份工具mysqldump以及增量备份使用的mysqlpump、mydumper、xtrabackup等工具的特点比较,并深入探讨了不同备份方法的工作原理,提供了...
`xtrabackup`是Percona公司开发的一款高效、无锁的MySQL和MariaDB热备份工具,它允许在不影响数据库服务的情况下进行全备和增量备份。本教程将详细介绍如何使用`xtrabackup`结合Shell脚本来实现MySQL数据库的备份与...
Xtrabackup是一个开源的物理备份工具,它能够创建数据库的增量或完整备份,并且在备份过程中不影响数据库的正常服务。它的优点在于能够进行在线备份,减少业务中断时间,同时支持快速恢复。 - **增量备份** 只备份...
Xtrabackup是一款开源的、针对InnoDB存储引擎的热备份工具,它能够在不锁定数据库的情况下进行完整备份。本文将详细探讨如何利用Xtrabackup结合Shell脚本来实现高效、灵活的备份与恢复操作。 一、Xtrabackup简介 ...
Xtrabackup是一款高效、开源的MySQL热备份工具,特别适用于InnoDB和XtraDB存储引擎。在这个主题中,我们将深入探讨Xtrabackup软件在MySQL备份中的应用及其重要特性。 首先,Xtrabackup由Percona公司开发,它允许在...
Xtrabackup是Percona公司开发的一款高效、免费的MySQL物理备份工具,尤其适用于MySQL 5.7及之前的版本。它以其对InnoDB存储引擎的出色支持和在备份过程中对数据库服务几乎零影响的特点,成为了数据库管理员的首选。 ...
Xtrabackup 2.4 是 Percona 公司开发的一款开源热备份工具,特别适用于 InnoDB 存储引擎的 MySQL 数据库,能够实现无中断的数据备份和恢复,保障业务连续性和数据安全性。 首先,让我们深入了解 MySQL 5.7.28 的...
三、MySQL备份工具 1. mysqldump:MySQL官方提供的命令行工具,可以执行全量和增量备份。例如,执行全量备份的命令为: ``` mysqldump -u username -p password database_name > backup.sql ``` 2. Percona ...
在本测试报告中,主要涉及了全量备份和增量备份的恢复过程,并对恢复后的数据进行了验证。以下是对这些知识点的详细说明: 1. **全量备份**:全量备份是数据库备份的一种方式,它会完整地复制数据库的所有数据。在...
AutoMySQLBackup是一款开源的、免费的MySQL数据库自动备份工具,它允许用户设置定期任务,对MySQL数据库进行全量备份。这款工具对于系统管理员来说非常实用,因为它可以确保数据的安全,避免因意外情况导致的数据...
原文链接:...2、可根据指定备份日期进行全库物理恢复
这里我们将深入探讨MySQL备份工具及其相关知识点。 1. **手动备份与自动备份** - **手动备份**:一般通过命令行或者图形界面工具(如MySQL Workbench)执行`mysqldump`命令来导出数据库。例如,`mysqldump -...
在MySQL中,可以使用`mysqldump`工具进行全量备份。`mysqldump`是一个命令行实用程序,它可以将MySQL数据库结构和数据转换为SQL语句,然后保存到文本文件中,这就是压缩包中的`mysqldump.txt`文件。执行全量备份的...
MySQL_xtrabackup是Percona公司开发的一款开源免费的MySQL数据库备份工具,它基于InnoDB存储引擎的特性,实现了对MySQL数据库的高效热备份。Xtrabackup能够在不锁定表的情况下进行备份,对数据库业务影响极小,支持...
Xtrabackup 是一款专为 MySQL 和 Percona Server 设计的高效、高性能备份工具,尤其擅长对 InnoDB 存储引擎进行热备份(即在数据库正常运行时进行备份)。它由 Percona 公司开发,并支持多种备份模式,包括完全备份...
MySQL备份通常包括全量备份、增量备份和差异备份。全量备份是备份所有数据库或表,它是其他类型备份的基础。增量备份只备份自上次备份以来发生更改的数据,而差异备份则备份自上次全量备份以来发生变化的数据。这三...
总结来说,Xtrabackup是一款强大的MySQL备份工具,尤其适用于需要保持高可用性的大型InnoDB数据库。其特性使得它在备份和恢复过程中能够兼顾效率、数据完整性和资源利用率,是数据库管理中的重要工具。
Xtrabackup是InnoDB存储引擎的热备份工具,由Percona公司开发。它可以在不锁定MySQL数据库的情况下进行完整或增量备份,这意味着在备份过程中,应用仍然可以正常运行,不影响业务。Xtrabackup支持备份到本地磁盘或...