mysql5.1 xtrabackup_编译支持mysql-5.1.73版本的xtrabackup

一、基础介绍

mysql5.1在源码中配备了两个版本的innodb存储引擎源码：innobase和innodb_plugin，编译安装的时候可以通过参数–with-plugins=innobase,innodb_plugin来指定是否将innodb存储引擎引入，具体这两个参数引入对编译后的mysql产生怎样的差异，后面再做解析。然而对于PerconaXtraBackup，在release版本中有2.0，2.1，2.2三个大版本，然后每个版本都是与mysql发布的innodb存储引擎版本对应，举例来说：

percona-xtrabackup-2.0.8在BUILD.txt中指定了utils/build.sh参数如下：

The script needs the codebase for which the building is targeted, you must

provide it with one of the following values or aliases:

================== ========= =============================================

Value Alias Server

================== ========= =============================================

innodb51_builtin 5.1 build against built-in InnoDB in MySQL 5.1

innodb51 plugin build against InnoDB plugin in MySQL 5.1

innodb55 5.5 build against InnoDB in MySQL 5.5

xtradb51 xtradb build against Percona Server with XtraDB 5.1

xtradb55 xtradb55 build against Percona Server with XtraDB 5.5

innodb56 5.6 build against InnoDB in MySQL 5.6

================== ========= =============================================

而在percona-xtrabackup-2.1.9在BUILD.txt中指定了utils/build.sh参数如下：

The script needs the codebase for which the building is targeted, you must

provide it with one of the following values or aliases:

================== ========= =============================================

Value Alias Server

================== ========= =============================================

innodb51 plugin build against InnoDB plugin in MySQL 5.1

innodb55 5.5 build against InnoDB in MySQL 5.5

xtradb51 xtradb build against Percona Server with XtraDB 5.1

xtradb55 xtradb55 build against Percona Server with XtraDB 5.5

innodb56 5.6 build against InnoDB in MySQL 5.6

================== ========= =============================================

解释一下：从percona-xtrabackup2.1开始取消对innodb built-in版本支持，即：用Percona-Xtrabackup2.1备份5.1built-in版本将会出现如下报错：

innobackupex: Error: Support for MySQL 5.1 with builtin InnoDB (not the plugin) was removed in Percona XtraBackup 2.1. The last version to support MySQL 5.1 with builtin InnoDB was Percona XtraBackup 2.0.

二、Percona-Xtrabackup2.0.8编译安装

cd /tmp

wget https://github.com/percona/percona-xtrabackup/archive/percona-xtrabackup-2.0.8.tar.gz

tar xf percona-xtrabackup-2.0.8.tar.gz

cd percona-xtrabackup-percona-xtrabackup-2.0.8

wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.59.tar.gz

./utils/build.sh 5.1

编译安装完，备份工具保存在 src/xtrabackup_51，打包xtrabackup_51和innobackupex 到目的服务器的/usr/local/bin目录下，即可执行备份