Mariabackup备份数据的日期时间是什么?

huangapple go评论56阅读模式
英文:

what is the Mariabackup date time of the backup data?

问题

完成Mariabackup时,备份数据的日期时间是多少?
当Mariabackup正在运行时,用户可以添加事务,因此备份日期时间将包含从备份开始到完成的数据。

提前致谢,
Adelino。

备份数据的Mariabackup日期时间是多少?

英文:

When we complete a Mariabackup, what is the date time of backup data ?
When the Mariabackup is running transactions can be added by users, so the backup datetime will contains data just until the backup begins or until is complete.

Thanks in Advance,
Adelino.

what is the Mariabackup date time of the backup data ?

答案1

得分: 2

在备份目录中有一个名为 xtrabackup_info 的文件,其中包含备份的开始时间和结束时间。

例如:

$ more xtrabackup_backupfiles/xtrabackup_info 
uuid = c2c8de3f-dd77-11ed-bed6-f47b09a650a9
name = 
tool_name = mariabackup
tool_command = --no-defaults -S /tmp/build-mariadb-server-10.6.sock --user dan --backup
tool_version = 10.6.13-MariaDB
ibbackup_version = 10.6.13-MariaDB
server_version = 10.6.13-MariaDB
start_time = 2023-04-18 09:29:53
end_time = 2023-04-18 09:29:55
lock_time = 0
binlog_pos = 
innodb_from_lsn = 0
innodb_to_lsn = 41380
partial = N
incremental = N
format = file
compressed = N

由于重做日志的保存方式,当使用 --prepare 选项进行备份时,反映的是备份完成时间。更准确地说,反映的是重做日志中最后一个已提交的 InnoDB 事务的 innodb_to_lsn 值。

英文:

In the backup directory there is a xtrabackup_info file that contains the start and end time of the backup.

e.g:

$ more xtrabackup_backupfiles/xtrabackup_info 
uuid = c2c8de3f-dd77-11ed-bed6-f47b09a650a9
name = 
tool_name = mariabackup
tool_command = --no-defaults -S /tmp/build-mariadb-server-10.6.sock --user dan --backup
tool_version = 10.6.13-MariaDB
ibbackup_version = 10.6.13-MariaDB
server_version = 10.6.13-MariaDB
start_time = 2023-04-18 09:29:53
end_time = 2023-04-18 09:29:55
lock_time = 0
binlog_pos = 
innodb_from_lsn = 0
innodb_to_lsn = 41380
partial = N
incremental = N
format = file
compressed = N

Because of the way the redo log is saved, the backup, when --prepared reflects the time of the completion of the backup. Or more accurately, to the innodb_to_lsn value representing the last committed innodb transaction in the redo log.

huangapple
  • 本文由 发表于 2023年4月17日 21:10:36
  • 转载请务必保留本文链接:https://go.coder-hub.com/76035536.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定