实战:xtrabackup for mysql 5.6-ocpyang
----1.编译安装percona-xtrabackupyum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr \
bison libtool ncurses-devel zlib-devel libgcrypt-devel
wget http://www.percona.com/downloads/XtraBackup/XtraBackup-2.1.9/source/percona-xtrabackup-2.1.9.tar.gz
tar xvzf percona-xtrabackup-2.1.9.tar.gz
mkdir -p /usr/local/xtrabackup/
mv percona-xtrabackup-2.1.9 /usr/local/xtrabackup/
cd /usr/local/xtrabackup/percona-xtrabackup-2.1.9
AUTO_DOWNLOAD="yes" ./utils/build.sh innodb56
/*****重新安装需要
rm -rf /usr/bin/innobackupex
rm -rf /usr/bin/xtrabackup
***********/
cp innobackupex /usr/bin/
cp src/xtrabackup_56/usr/bin/
ln -s /usr/local/mysql/bin/* /usr/bin/
---2.安装相关插件
wget http://www.percona.com/downloads/percona-toolkit/LATEST/RPM/percona-toolkit-2.2.8-1.noarch.rpm
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
rpm -ivh percona-toolkit-2.2.8-1.noarch.rpm
*****************************************************************
普通备份和还原
*****************************************************************
----1.备份
create table t1
(
sid int not null ,
sname varchar(100)not null
)engine=innodb ;
DELIMITER //
create PROCEDURE proc1()
BEGIN
DECLARE i int DEFAULT 0;
set i=1 ;
set autocommit=0;
WHILE i
页:
[1]