前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >使用XtraBackup创建mysql slave6

使用XtraBackup创建mysql slave6

作者头像
franket
发布2022-05-04 22:34:34
4100
发布2022-05-04 22:34:34
举报
文章被收录于专栏:技术杂记

再次尝试备份master数据库

代码语言:javascript
复制
[root@master-qa ~]#  /usr/bin/innobackupex --defaults-file=/etc/my.cnf --user=root --password=xxxxxxx /data/fullbackup/ 

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

151012 15:24:06  innobackupex: Executing a version check against the server...
151012 15:24:06  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
151012 15:24:06  innobackupex: Connected to MySQL server
151012 15:24:06  innobackupex: Done.
151012 15:24:06  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
151012 15:24:06  innobackupex: Connected to MySQL server
151012 15:24:06  innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex:  Using server version 5.6.25-73.0-log

innobackupex: Created backup directory /data/fullbackup/2015-10-12_15-24-06

151012 15:24:06  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/fullbackup/2015-10-12_15-24-06 --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/var/tmp --extra-lsndir='/var/tmp'
innobackupex: Waiting for ibbackup (pid=3577) to suspend
innobackupex: Suspend file '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_suspended_2'

xtrabackup version 2.2.12 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 8726828)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 65536
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = /var/lib/mysql/
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 134217728
xtrabackup: using O_DIRECT
>> log scanned up to (76232231155)
xtrabackup: Generating a list of tablespaces
[01] Copying /var/lib/mysql/ibdata1 to /data/fullbackup/2015-10-12_15-24-06/ibdata1
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
...
...
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
[01]        ...done
[01] Copying ./food_qa/topic_pages.ibd to /data/fullbackup/2015-10-12_15-24-06/food_qa/topic_pages.ibd
[01]        ...done
>> log scanned up to (76232238365)
[01] Copying ./food_qa/food_compares.ibd to /data/fullbackup/2015-10-12_15-24-06/food_qa/food_compares.ibd
[01]        ...done
...
...
>> log scanned up to (76232242511)
151012 15:31:21  innobackupex: Finished backing up non-InnoDB tables and files

151012 15:31:21  innobackupex: Executing LOCK BINLOG FOR BACKUP...
151012 15:31:21  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
151012 15:31:21  innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '76232242511'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (76232242511)

xtrabackup: Creating suspend file '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_log_copied' with pid '3577'
xtrabackup: Transaction log of lsn (76232231155) to (76232242511) was copied.
151012 15:31:22  innobackupex: Executing UNLOCK BINLOG
151012 15:31:22  innobackupex: Executing UNLOCK TABLES
151012 15:31:22  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: MySQL binlog position: filename 'mysql-bin.000009', position 1509223
151012 15:31:22  innobackupex: Connection to database server closed
151012 15:31:22  innobackupex: completed OK!
[root@master-qa ~]# echo $?
0
[root@master-qa ~]# 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
数据库
云数据库为企业提供了完善的关系型数据库、非关系型数据库、分析型数据库和数据库生态工具。您可以通过产品选择和组合搭建,轻松实现高可靠、高可用性、高性能等数据库需求。云数据库服务也可大幅减少您的运维工作量,更专注于业务发展,让企业一站式享受数据上云及分布式架构的技术红利!
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档