I. Description of the problem
In full backup with Xtrabackup online mysql times wrong:
[mysql@mvxl0782 ~]$ Innobackupex--defaults-file=/data/mysql/mysql3376/my3376.cnf--user=xtrabk--password= ' Onlybackup '/data/backup/
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:
http://www.percona.com/xb/p
160517 15:57:43 innobackupex:connecting to MySQL server with DSN
' Dbi:mysql:;mysql_read_default_file=/data/mysql/mysql3376/data/my3376.cnf;mysql_read_default_group=xtrabackup ' As ' XTRABK ' (using Password:yes).
Innobackupex:got a fatal error with the following stacktrace:at/usr/local/percona-xtrabackup-2.2.9-linux-x86_64/bin/ Innobackupex Line 2999
Main::mysql_connect (' Abort_on_error ', 1) called at/usr/local/percona-xtrabackup-2.2.9-linux-x86_64/bin/ Innobackupex Line 1539
innobackupex:Error:Failed to connect to MySQL server as Dbd::mysql module is not installed At/usr/local/percona-xtrabac Kup-2.2.9-linux-x86_64/bin/innobackupex Line
2999.
Second, the problem analysis
It is apparent from above that the DBD is not installed.
third, solve the problem:
[root@mvxl0782 local]# Yum Install Perl-dbd-mysql
Loaded Plugins:product-id, Refresh-packagekit, security, Subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Rhel6 | 4.0 KB 00:00
Setting up Install Process
Resolving dependencies
--> Running Transaction Check
---> Package perl-dbd-mysql.x86_64 0:4.013-3.el6 would be installed
--> processing dependency:libmysqlclient.so.16 (libmysqlclient_16) (64bit) for package: Perl-dbd-mysql-4.013-3.el6.x86_64
--> processing dependency:libmysqlclient.so.16 () (64bit) for package:perl-dbd-mysql-4.013-3.el6.x86_64
--> Running Transaction Check
---> Package mysql-libs.x86_64 0:5.1.61-4.el6 would be installed
--> finished Dependency resolution
Dependencies resolved
=============================================================================================================== =====================
Package Arch Version Repository Size
=============================================================================================================== =====================
Installing:
Perl-dbd-mysql x86_64 4.013-3.el6 rhel6 134 K
Installing for dependencies:
Mysql-libs x86_64 5.1.61-4.el6 rhel6 1.2 M
Transaction Summary
=============================================================================================================== =====================
Install 2 Package (s)
Total Download size:1.4 M
Installed size:4.4 M
Is this OK [y/n]: Y
Downloading Packages:
(1/2): mysql-libs-5.1.61-4.el6.x86_64.rpm | 1.2 MB 00:00
(2/2): perl-dbd-mysql-4.013-3.el6.x86_64.rpm | 134 KB 00:00
--------------------------------------------------------------------------------------------------------------- ---------------------
Total MB/s | 1.4 MB 00:00
Running Rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing:mysql-libs-5.1.61-4.el6.x86_64 1/2
Warning:/etc/my.cnf created as/etc/my.cnf.rpmnew
Installing:perl-dbd-mysql-4.013-3.el6.x86_64 2/2
Installed products updated.
Verifying:perl-dbd-mysql-4.013-3.el6.x86_64 1/2
verifying : mysql-libs-5.1.61-4.el6.x86_64 2/2
Installed:
perl-dbd-mysql.x86_64 0:4.013-3.el6
Dependency installed:
Mysql-libs.x86_64 0:5.1.61-4.el6
complete!
To perform a backup successfully
[mysql@mvxl0782 ~]$ Innobackupex--defaults-file=/data/mysql/mysql3376/my3376.cnf--user=xtrabk--password= ' Onlybackup '--slave-info/data/backup/