1、插入数据，并查看pos值
插入数据之后，pos值增加到206329194
2、增量备份
增量备份输出
3、查看备份信息
备份类型为incremental，而lsn从1048637327到1048637674
这里的信息与全备份除备份时间和lsn有区别，其他基本一致
-
[root@localhost:test][10:53:30am] MySQL-> insert into t1 select null,'mysql';
-
Query OK, 1 row affected (0.03 sec)
-
Records: 1 Duplicates: 0 Warnings: 0
-
-
[root@localhost:test][10:53:39am] MySQL-> show master status\G
-
*************************** 1. row ***************************
-
File: pm1-bin.000005
-
Position: 206329194
-
Binlog_Do_DB:
-
Binlog_Ignore_DB:
-
Executed_Gtid_Set:
- 1 row in set (0.00 sec)
2、增量备份
- root@pm1:/root# innobackupex --user=root --password=111 --database=test --incremental --incremental-basedir=/backup/2015-08-02_10-23-40 /backup
-
innobackupex: Backup created in directory '/backup/2015-08-02_11-05-13'
-
innobackupex: MySQL binlog position: filename 'pm1-bin.000005', position 206329194
-
150802 11:05:20 innobackupex: Connection to database server closed
- 150802 11:05:20 innobackupex: completed
-
root@pm1:/backup/2015-08-02_11-05-13# cat xtrabackup_checkpoints
-
backup_type = incremental
-
from_lsn = 1048637327
-
to_lsn = 1048637674
-
last_lsn = 1048637674
- compact = 0
-
root@pm1:/backup/2015-08-02_11-05-13# cat xtrabackup_info
-
uuid = 4f3988e3-38c3-11e5-ac42-08002760d8fe
-
name =
-
tool_name = innobackupex
-
tool_command = --user=root --password=... --database=test --incremental --incremental-basedir=/backup/2015-08-02_10-23-40 /backup
-
tool_version = 1.5.1-xtrabackup
-
ibbackup_version = xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
-
server_version = 5.6.25-73.0-log
-
start_time = 2015-08-02 11:05:13
-
end_time = 2015-08-02 11:05:20
-
lock_time = 1
-
binlog_pos = filename 'pm1-bin.000005', position 206329194
-
innodb_from_lsn = 1048637327
-
innodb_to_lsn = 1048637674
-
partial = Y
-
incremental = Y
-
format = file
-
compact = N
-
compressed = N
- encrypted = N
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12219480/viewspace-1763390/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
MySQL主主复制
请登录后发表评论
登录
全部评论
最新文章
- InnoDB: Failing assertion: format != 0
- MySQL 5.7 GR Multi-Primary
- MySQL 5.7 GR Single Primary测试
- MySQL GR(group replication) Single Primary
- GDB调试MySQL
- Phoenix安装配置
- 使用jmap查看HRegionServer的heap信息
- Hive报错，NoSuchMethodError: org.apache.hadoop.mapred.JobConf.unset
- Hbase表export和import
- Hbase手工dumping和splitting WAL
