Shulou(Shulou.com)06/01 Report--

Red Hat Enterprise Linux Server release 6.6 (Santiago)

[root@mysqlgc opt] # tar-xvf Percona-XtraBackup-2.4.6-r8ec05b7-el6-x86_64-bundle.tar

Percona-xtrabackup-24-2.4.6-2.el6.x86_64.rpm

Percona-xtrabackup-24-debuginfo-2.4.6-2.el6.x86_64.rpm

Percona-xtrabackup-test-24-2.4.6-2.el6.x86_64.rpm

[root@mysqlgc opt] # yum localinstall percona-xtrabackup-*

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Setting up Local Package Process

Examining percona-xtrabackup-test-24-2.4.6-2.el6.x86_64.rpm: percona-xtrabackup-test-24-2.4.6-2.el6.x86_64

Marking percona-xtrabackup-test-24-2.4.6-2.el6.x86_64.rpm to be installed

Resolving Dependencies

-> Running transaction check

-> Package percona-xtrabackup-test-24.x86_64 0RU 2.4.6-2.el6 will be installed

-- > Processing Dependency: percona-xtrabackup-24 = 2.4.6-2.el6 for package: percona-xtrabackup-test-24-2.4.6-2.el6.x86_64

-> Finished Dependency Resolution

Error: Package: percona-xtrabackup-test-24-2.4.6-2.el6.x86_64 (/ percona-xtrabackup-test-24-2.4.6-2.el6.x86_64)

Requires: percona-xtrabackup-24 = 2.4.6-2.el6

You could try using-skip-broken to work around the problem

You could try running: rpm-Va-nofiles-nodigest

Install libev-4.15-1.el6.rf.x86_64.rpm and then install xtrabackup OK

Http://www.cnblogs.com/kerrycode/p/5308719.html

Http://ftp.tu-chemnitz.de/pub/linux/dag/redhat/el6/en/x86_64/rpmforge/RPMS/

[root@mysqlgc opt] # rpm-ivh libev-4.15-1.el6.rf.x86_64.rpm

[root@mysqlgc opt] # yum localinstall percona-xtrabackup-*

[root@mysqlgc bak] # innobackupex-- socket=/data/mysql/mysql.sock-u root-p Oracle123 $/ data/bak/-- no-timestamp

170317 13:39:10 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!".

170317 13:39:11 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/data/mysql/mysql.sock' as' root' (using password: YES).

170317 13:39:11 version_check Connected to MySQL server

170317 13:39:11 version_check Executing a version check against the server...

170317 13:39:11 version_check Done.

170317 13:39:11 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: / data/mysql/mysql.sock

Using server version 5.7.16-log

Innobackupex version 2.4.6 based on MySQL server 5.7.13 Linux (x86 / 64) (revision id: 8ec05b7)

Xtrabackup: uses posix_fadvise ().

Xtrabackup: cd to / data/mysql

Xtrabackup: open files limit requested 0, set to 1024

Xtrabackup: using the following InnoDB configuration:

Xtrabackup: innodb_data_home_dir =.

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 = 50331648

InnoDB: Number of pools: 1

170317 13:39:11 > > log scanned up to (4492 4089203)

Xtrabackup: Generating a list of tablespaces

InnoDB: Allocated tablespace ID 4 for mysql/help_topic, old maximum was 0

170317 13:39:11 [01] Copying. / ibdata1 to / data/bak/ibdata1

170317 13:39:12 > > log scanned up to (4492 4089203)

170317 13:39:13 > > log scanned up to (4492 4089203)

170317 13:39:14 > > log scanned up to (4492 4089203)

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/help_topic.ibd to / data/bak/mysql/help_topic.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/plugin.ibd to / data/bak/mysql/plugin.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/slave_relay_log_info.ibd to / data/bak/mysql/slave_relay_log_info.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/help_keyword.ibd to / data/bak/mysql/help_keyword.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/slave_worker_info.ibd to / data/bak/mysql/slave_worker_info.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/slave_master_info.ibd to / data/bak/mysql/slave_master_info.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/server_cost.ibd to / data/bak/mysql/server_cost.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/time_zone_transition.ibd to / data/bak/mysql/time_zone_transition.ibd

170317 13:39:14 [01]... done

170317 13:39:14 [01] Copying. / mysql/servers.ibd to / data/bak/mysql/servers.ibd

170317 13:39:14 [01]... done

170317 13:40:37 Finished backing up non-InnoDB tables and files

170317 13:40:37 [00] Writing xtrabackup_binlog_info

170317 13:40:37 [00]... done

170317 13:40:37 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...

Xtrabackup: The latest check point (for incremental): '44924089194'

Xtrabackup: Stopping log copying thread.

.170317 13:40:37 > > log scanned up to (44924089203)

170317 13:40:37 Executing UNLOCK TABLES

170317 13:40:37 All tables unlocked

170317 13:40:37 [00] Copying ib_buffer_pool to / data/bak/ib_buffer_pool

170317 13:40:37 [00]... done

170317 13:40:37 Backup created in directory'/ data/bak/'

MySQL binlog position: filename 'mysql-bin.000016', position' 452'

170317 13:40:37 [00] Writing backup-my.cnf

170317 13:40:37 [00]... done

170317 13:40:37 [00] Writing xtrabackup_info

170317 13:40:37 [00]... done

Xtrabackup: Transaction log of lsn (44924089194) to (44924089203) was copied.

170317 13:40:38 completed OK!

Incremental share

[root@vSWHVMSDBTE01 bak] # innobackupex-- socket=/var/lib/mysql/mysql.sock-u root-p Oracle123 $/ data/bak/-- no-timestamp

[root@vSWHVMSDBTE01 bak] # innobackupex-socket=/var/lib/mysql/mysql.sock-u root-p Oracle123 $--incremental / data/bak_incr/-- incremental-basedir=/data/bak-- no-timestamp

Incremental recovery

[root@vSWHVMSDBTE01 lib] # service mysqld stop

[root@vSWHVMSDBTE01 lib] # mv / var/lib/mysql / var/lib/mysql_old

[root@vSWHVMSDBTE01 lib] # mkdir / var/lib/mysql

[root@vSWHVMSDBTE01 lib] # chown-R mysql.mysql mysql

Restore full-share Read only model

[root@vSWHVMSDBTE01 bak] # innobackupex-- apply-log-- redo-only / data/bak

The last incremental restore does not require read only

[root@vSWHVMSDBTE01 bak_incr] # innobackupex-- apply-log / data/bak-- incremental-dir=/data/bak_incr

Restore full share, return unsubmitted service

[root@vSWHVMSDBTE01 bak_incr] # innobackupex-- apply-log / data/bak

[root@vSWHVMSDBTE01 mysql] # innobackupex-- copy-back / data/bak

[root@vSWHVMSDBTE01 mysql] # chown-R mysql.mysql / var/lib/mysql

[root@vSWHVMSDBTE01 mysql] # service mysqld start

Case

Mysql 5.6 restored to Mysql 5.7

Share a share

0 3 * root / backup/mysql/mysql-full-backup.sh 1 > > / backup/mysql/mysql_full_backup.log 2 > > / backup/mysql/mysql_full_backup.bad

#! / bin/bash

# export MYSQL_HOME=/usr/local/Percona-Server-5.5.21-rel25.0-227.Linux.x86_64/

# export PATH=$MYSQL_HOME/bin:$PATH

Mysql_backup_dir=/backup/mysql/

Mysql_username= "root"

Mysql_password= "root"

Cd $mysql_backup_dir

TimeStart=$ (date'+% Y% m% d% H% M% S')

Backupfile=full-$timeStart.tar.gz

Logfile=full-$timeStart.log

Innobackupex-defaults-file=/etc/my.cnf-stream=tar / tmp-user=$mysql_username-password=$mysql_password | gzip-> "$backupfile"

Tar-xizf full-20170315220514.tar.gz

Warning

To extract Percona XtraBackup's archive you must use tar with-I option:

$tar-xizf backup.tar.gz

Restore the disease

# tar-zvfx full-20170315220514.tar.gz

# innobackupex-- apply-log / data/bak_test/

# innobackupex-- copy-back / data/bak_test

# chown-R mysql.mysql mysql

# vi / etc/my.cnf password-less login

[mysqld]

Skip-grant-tables

# service mysqld start

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.