英文:
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 --prepare
d 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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论