重庆思庄Oracle、Redhat认证学习论坛

标题: xtrabackup备份mysql容器 [打印本页]

作者: huangte    时间: 2023-6-2 17:41
标题: xtrabackup备份mysql容器
本帖最后由 huangte 于 2023-6-2 17:41 编辑

背景:1、在宿主机系统上安装的xtrabackup( version 8.0.31-24 based on MySQL server 8.0.31 Linux (x86_64) )         
2、宿主机上有docker 容器mysql(8.0.31 MySQL Community Server - GPL),容器已做了存储持久化。
用xtrabackup备份mysql容器报错,日志如下:
xtrabackup version 8.0.31-24 based on MySQL server 8.0.31 Linux (x86_64) (revision id: f0754edb)
230602 11:15:30  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=12306' as 'root'  (using password: YES).
230602 11:15:30  version_check Connected to MySQL server
230602 11:15:30  version_check Executing a version check against the server...

# A software update is available:
230602 11:15:33  version_check Done.
2023-06-02T11:15:33.090064+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: 127.0.0.1, user: root, password: set, port: 12306, socket: not set
2023-06-02T11:15:33.131293+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.31
2023-06-02T11:15:33.195751+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK INSTANCE FOR BACKUP ...
2023-06-02T11:15:33.207000+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2023-06-02T11:15:33.207101+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /var/lib/mysql
2023-06-02T11:15:33.207133+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 65535
2023-06-02T11:15:33.207221+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2023-06-02T11:15:33.207296+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2023-06-02T11:15:33.207305+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2023-06-02T11:15:33.207345+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2023-06-02T11:15:33.207357+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2023-06-02T11:15:33.207371+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
2023-06-02T11:15:33.288759+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2023-06-02T11:15:33.448735+08:00 0 [ERROR] [MY-013894] [InnoDB] Found redo log file ./ib_logfile0 which has format (v103) and is stored outside #innodb_redo.
百度了后,有说法是xtrabackup和mysql需要在同一个容器里?







作者: 郑全    时间: 2023-6-3 17:36
xtrabackup 就是一个物理备份,应该放在一处。




欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2