PXB安装体验

最新推荐文章于 2023-08-21 21:54:48 发布
最新推荐文章于 2023-08-21 21:54:48 发布
阅读量939 收藏 1
点赞数 1
分类专栏： Mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinat_33137351/article/details/109479560
版权

目录

安装软件

innobackupex命令调用

innobackupex备份前提

创建备份目录

执行备份    

删库恢复测试

修改目录属主

安装软件

[root@ocp ~]# yum localinstall percona-xtrabackup-24-2.4.11-1.el7.x86_64.rpm

Error: Package: percona-xtrabackup-24-2.4.12-1.el7.x86_64 (/percona-xtrabackup-24-2.4.12-1.el7.x86_64)

           Requires: libev.so.4()(64bit)

缺少依赖包，先安装依赖包

[root@ocp ~]# rpm -ivh libev4-4.24-8.1.x86_64.rpm

warning: libev4-4.24-8.1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 8b8f538f: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:libev4-4.24-8.1                  ################################# [100%]

[root@ocp ~]# yum -y localinstall percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm

Loaded plugins: fastestmirror

Examining percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm: percona-xtrabackup-24-2.4.12-1.el7.x86_64

Marking percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package percona-xtrabackup-24.x86_64 0:2.4.12-1.el7 will be installed

--> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.12-1.el7.x86_64

Loading mirror speeds from cached hostfile

--> Processing Dependency: perl(Digest::MD5) for package: percona-xtrabackup-24-2.4.12-1.el7.x86_64

--> Processing Dependency: rsync for package: percona-xtrabackup-24-2.4.12-1.el7.x86_64

--> Running transaction check

---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed

--> Processing Dependency: perl >= 5.005 for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(vars) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(strict) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(DynaLoader) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(Carp) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

--> Processing Dependency: perl(:MODULE_COMPAT_5.16.3) for package: perl-DBD-MySQL-4.023-5.el7.x86_64

---> Package perl-Digest-MD5.x86_64 0:2.52-3.el7 will be installed

--> Processing Dependency: perl(Digest::base) >= 1.00 for package: perl-Digest-MD5-2.52-3.el7.x86_64

--> Processing Dependency: perl(Exporter) for package: perl-Digest-MD5-2.52-3.el7.x86_64

---> Package rsync.x86_64 0:3.0.9-18.el7 will be installed

--> Running transaction check

---> Package perl.x86_64 4:5.16.3-292.el7 will be installed

--> Processing Dependency: perl-libs = 4:5.16.3-292.el7 for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Getopt::Long) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-292.el7.x86_64

--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-292.el7.x86_64

---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed

---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed

--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64

--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64

--> Processing Dependency: perl(Data::Dumper) for package: perl-DBI-1.627-4.el7.x86_64

---> Package perl-Digest.noarch 0:1.17-245.el7 will be installed

---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed

--> Running transaction check

---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed

---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed

---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed

---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed

---> Package perl-Getopt-Long.noarch 0:2.40-2.el7 will be installed

--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-2.el7.noarch

--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-2.el7.noarch

---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed

---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed

--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch

--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch

--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch

--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch

---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed

--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch

--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch

---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed

---> Package perl-Socket.x86_64 0:2.010-4.el7 will be installed

---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed

---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed

---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed

---> Package perl-constant.noarch 0:1.27-2.el7 will be installed

---> Package perl-libs.x86_64 4:5.16.3-292.el7 will be installed

---> Package perl-macros.x86_64 4:5.16.3-292.el7 will be installed

---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed

---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed

--> Running transaction check

---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed

---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed

--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch

--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch

---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed

---> Package perl-Pod-Escapes.noarch 1:1.04-292.el7 will be installed

---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed

--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch

--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch

---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed

--> Running transaction check

---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed

---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed

---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed

--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch

--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch

---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed

--> Running transaction check

---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed

---> Package perl-parent.noarch 1:0.225-244.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

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

Package                                            Arch                              Version                                        Repository                                                             Size

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

Installing:

percona-xtrabackup-24                              x86_64                            2.4.12-1.el7                                   /percona-xtrabackup-24-2.4.12-1.el7.x86_64                             31 M

Installing for dependencies:

perl                                               x86_64                            4:5.16.3-292.el7                               local_server                                                          8.0 M

perl-Carp                                          noarch                            1.26-244.el7                                   local_server                                                           19 k

perl-Compress-Raw-Bzip2                            x86_64                            2.061-3.el7                                    local_server                                                           32 k

perl-Compress-Raw-Zlib                             x86_64                            1:2.061-4.el7                                  local_server                                                           57 k

perl-DBD-MySQL                                     x86_64                            4.023-5.el7                                    local_server                                                          140 k

perl-DBI                                           x86_64                            1.627-4.el7                                    local_server                                                          802 k

perl-Data-Dumper                                   x86_64                            2.145-3.el7                                    local_server                                                           47 k

perl-Digest                                        noarch                            1.17-245.el7                                   local_server                                                           23 k

perl-Digest-MD5                                    x86_64                            2.52-3.el7                                     local_server                                                           30 k

perl-Encode                                        x86_64                            2.51-7.el7                                     local_server                                                          1.5 M

perl-Exporter                                      noarch                            5.68-3.el7                                     local_server                                                           28 k

perl-File-Path                                     noarch                            2.09-2.el7                                     local_server                                                           26 k

perl-File-Temp                                     noarch                            0.23.01-3.el7                                  local_server                                                           56 k

perl-Filter                                        x86_64                            1.49-3.el7                                     local_server                                                           76 k

perl-Getopt-Long                                   noarch                            2.40-2.el7                                     local_server                                                           56 k

perl-HTTP-Tiny                                     noarch                            0.033-3.el7                                    local_server                                                           38 k

perl-IO-Compress                                   noarch                            2.061-2.el7                                    local_server                                                          260 k

perl-Net-Daemon                                    noarch                            0.48-5.el7                                     local_server                                                           51 k

perl-PathTools                                     x86_64                            3.40-5.el7                                     local_server                                                           82 k

perl-PlRPC                                         noarch                            0.2020-14.el7                                  local_server                                                           36 k

perl-Pod-Escapes                                   noarch                            1:1.04-292.el7                                 local_server                                                           51 k

perl-Pod-Perldoc                                   noarch                            3.20-4.el7                                     local_server                                                           87 k

perl-Pod-Simple                                    noarch                            1:3.28-4.el7                                   local_server                                                          216 k

perl-Pod-Usage                                     noarch                            1.63-3.el7                                     local_server                                                           27 k

perl-Scalar-List-Utils                             x86_64                            1.27-248.el7                                   local_server                                                           36 k

perl-Socket                                        x86_64                            2.010-4.el7                                    local_server                                                           49 k

perl-Storable                                      x86_64                            2.45-3.el7                                     local_server                                                           77 k

perl-Text-ParseWords                               noarch                            3.29-4.el7                                     local_server                                                           14 k

perl-Time-HiRes                                    x86_64                            4:1.9725-3.el7                                 local_server                                                           45 k

perl-Time-Local                                    noarch                            1.2300-2.el7                                   local_server                                                           24 k

perl-constant                                      noarch                            1.27-2.el7                                     local_server                                                           19 k

perl-libs                                          x86_64                            4:5.16.3-292.el7                               local_server                                                          688 k

perl-macros                                        x86_64                            4:5.16.3-292.el7                               local_server                                                           43 k

perl-parent                                        noarch                            1:0.225-244.el7                                local_server                                                           12 k

perl-podlators                                     noarch                            2.5.1-3.el7                                    local_server                                                          112 k

perl-threads                                       x86_64                            1.87-4.el7                                     local_server                                                           49 k

perl-threads-shared                                x86_64                            1.43-6.el7                                     local_server                                                           39 k

rsync                                              x86_64                            3.0.9-18.el7                                   local_server                                                          360 k

Transaction Summary

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

Install  1 Package (+38 Dependent packages)

Total size: 45 M

Total download size: 13 M

Installed size: 72 M

Downloading packages:

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total                                                                                                                                                                             60 MB/s |  13 MB  00:00:00     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

  Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                           1/39

  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                            2/39

  Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                            3/39

  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                           4/39

  Installing : 1:perl-Pod-Escapes-1.04-292.el7.noarch                                                                                                                                                       5/39

  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                       6/39

  Installing : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                                7/39

  Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                             8/39

  Installing : 4:perl-macros-5.16.3-292.el7.x86_64                                                                                                                                                          9/39

  Installing : 4:perl-libs-5.16.3-292.el7.x86_64                                                                                                                                                           10/39

  Installing : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                             11/39

  Installing : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                             12/39

  Installing : perl-constant-1.27-2.el7.noarch                                                                                                                                                             13/39

  Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                         14/39

  Installing : perl-Socket-2.010-4.el7.x86_64                                                                                                                                                              15/39

  Installing : perl-Carp-1.26-244.el7.noarch                                                                                                                                                               16/39

  Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                       17/39

  Installing : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                            18/39

  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                                  19/39

  Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                         20/39

  Installing : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                            21/39

  Installing : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                       22/39

  Installing : perl-threads-1.87-4.el7.x86_64                                                                                                                                                              23/39

  Installing : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                               24/39

  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                         25/39

  Installing : perl-Getopt-Long-2.40-2.el7.noarch                                                                                                                                                          26/39

  Installing : 4:perl-5.16.3-292.el7.x86_64                                                                                                                                                                27/39

  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                                  28/39

  Installing : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                                           29/39

  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                                         30/39

  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                                                 31/39

  Installing : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                                         32/39

  Installing : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                                             33/39

  Installing : perl-DBI-1.627-4.el7.x86_64                                                                                                                                                                 34/39

  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                                                                                                                                           35/39

  Installing : perl-Digest-1.17-245.el7.noarch                                                                                                                                                             36/39

  Installing : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                                                                           37/39

  Installing : rsync-3.0.9-18.el7.x86_64                                                                                                                                                                   38/39

  Installing : percona-xtrabackup-24-2.4.12-1.el7.x86_64                                                                                                                                                   39/39

  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                            1/39

  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                        2/39

  Verifying  : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                              3/39

  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                                          4/39

  Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                              5/39

  Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                                                                              6/39

  Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                             7/39

  Verifying  : 4:perl-macros-5.16.3-292.el7.x86_64                                                                                                                                                          8/39

  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                                   9/39

  Verifying  : rsync-3.0.9-18.el7.x86_64                                                                                                                                                                   10/39

  Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                          11/39

  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                                           12/39

  Verifying  : 4:perl-5.16.3-292.el7.x86_64                                                                                                                                                                13/39

  Verifying  : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                                                                           14/39

  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                         15/39

  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                         16/39

  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                         17/39

  Verifying  : 4:perl-libs-5.16.3-292.el7.x86_64                                                                                                                                                           18/39

  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                          19/39

  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                                                                                                                                           20/39

  Verifying  : perl-Socket-2.010-4.el7.x86_64                                                                                                                                                              21/39

  Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                                                                               22/39

  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                                         23/39

  Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                       24/39

  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                                  25/39

  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                                                 26/39

  Verifying  : 1:perl-Pod-Escapes-1.04-292.el7.noarch                                                                                                                                                      27/39

  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                                             28/39

  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                            29/39

  Verifying  : perl-DBI-1.627-4.el7.x86_64                                                                                                                                                                 30/39

  Verifying  : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                               31/39

  Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                           32/39

  Verifying  : perl-Getopt-Long-2.40-2.el7.noarch                                                                                                                                                          33/39

  Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                            34/39

  Verifying  : perl-threads-1.87-4.el7.x86_64                                                                                                                                                              35/39

  Verifying  : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                               36/39

  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                      37/39

  Verifying  : percona-xtrabackup-24-2.4.12-1.el7.x86_64                                                                                                                                                   38/39

  Verifying  : perl-Digest-1.17-245.el7.noarch                                                                                                                                                             39/39

Installed:

  percona-xtrabackup-24.x86_64 0:2.4.12-1.el7                                                                                                                                                                    

Dependency Installed:

  perl.x86_64 4:5.16.3-292.el7                          perl-Carp.noarch 0:1.26-244.el7                perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7          perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7         

  perl-DBD-MySQL.x86_64 0:4.023-5.el7                   perl-DBI.x86_64 0:1.627-4.el7                  perl-Data-Dumper.x86_64 0:2.145-3.el7                 perl-Digest.noarch 0:1.17-245.el7                   

  perl-Digest-MD5.x86_64 0:2.52-3.el7                   perl-Encode.x86_64 0:2.51-7.el7                perl-Exporter.noarch 0:5.68-3.el7                     perl-File-Path.noarch 0:2.09-2.el7                  

  perl-File-Temp.noarch 0:0.23.01-3.el7                 perl-Filter.x86_64 0:1.49-3.el7                perl-Getopt-Long.noarch 0:2.40-2.el7                  perl-HTTP-Tiny.noarch 0:0.033-3.el7                 

  perl-IO-Compress.noarch 0:2.061-2.el7                 perl-Net-Daemon.noarch 0:0.48-5.el7            perl-PathTools.x86_64 0:3.40-5.el7                    perl-PlRPC.noarch 0:0.2020-14.el7                   

  perl-Pod-Escapes.noarch 1:1.04-292.el7                perl-Pod-Perldoc.noarch 0:3.20-4.el7           perl-Pod-Simple.noarch 1:3.28-4.el7                   perl-Pod-Usage.noarch 0:1.63-3.el7                  

  perl-Scalar-List-Utils.x86_64 0:1.27-248.el7          perl-Socket.x86_64 0:2.010-4.el7               perl-Storable.x86_64 0:2.45-3.el7                     perl-Text-ParseWords.noarch 0:3.29-4.el7            

  perl-Time-HiRes.x86_64 4:1.9725-3.el7                 perl-Time-Local.noarch 0:1.2300-2.el7          perl-constant.noarch 0:1.27-2.el7                     perl-libs.x86_64 4:5.16.3-292.el7                   

  perl-macros.x86_64 4:5.16.3-292.el7                   perl-parent.noarch 1:0.225-244.el7             perl-podlators.noarch 0:2.5.1-3.el7                   perl-threads.x86_64 0:1.87-4.el7                    

  perl-threads-shared.x86_64 0:1.43-6.el7               rsync.x86_64 0:3.0.9-18.el7                   

Complete!

innobackupex命令调用

[root@ocp ~]# innobackupex

xtrabackup: recognized server arguments: --datadir=/data/mysql/data

200307 21:37:47 innobackupex: Missing argument

innobackupex备份前提

user password

socket位置

datadir

vim /etc/my.cnf

[client]

socket=/tmp/mysql57.sock

 

创建备份目录

mkdir -p /data/pbk

执行备份    

innobackupex --defaults-file=/etc/my.cnf --user=root --no-timestamp /data/pbk/full_`date +%F`

[root@ocp ~]# innobackupex --defaults-file=/etc/my.cnf --user=root --no-timestamp /data/pbk/full_`date +%F`

xtrabackup: recognized server arguments: --datadir=/data/mysql/data

xtrabackup: recognized client arguments: --datadir=/data/mysql/data

200307 21:56:40 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!".

... ...

200307 21:56:42 [00] Writing /data/pbk/full_2020-03-07/backup-my.cnf

200307 21:56:42 [00]        ...done

200307 21:56:42 [00] Writing /data/pbk/full_2020-03-07/xtrabackup_info

200307 21:56:42 [00]        ...done

xtrabackup: Transaction log of lsn (3177320) to (3177329) was copied.

200307 21:56:42 completed OK!

 

innobackupex --apply-log  /data/pbk/full_2020-03-07

删库恢复测试

删除

[root@ocp data]# rm -rf /data/mysql/data/*

恢复命令    

innobackupex --defaults-file=/etc/my.cnf --copy-back /data/pbk/full_2020-03-07

[root@ocp ~]# innobackupex --defaults-file=/etc/my.cnf --copy-back /data/pbk/full_2020-03-07

xtrabackup: recognized server arguments: --datadir=/data/mysql/data

xtrabackup: recognized client arguments: --datadir=/data/mysql/data

200307 22:04:14 innobackupex: Starting the copy-back operation

IMPORTANT: Please check that the copy-back run completes successfully.

           At the end of a successful copy-back run innobackupex

           prints "completed OK!".

innobackupex version 2.4.12 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 170eb8c)

200307 22:04:14 [01] Copying ibdata1 to /data/mysql/data/ibdata1

200307 22:04:15 [01]        ...done

200307 22:04:15 [01] Copying ./mysql/plugin.ibd to /data/mysql/data/mysql/plugin.ibd

200307 22:04:15 [01]        ...done

200307 22:04:15 [01] Copying ./mysql/servers.ibd to /data/mysql/data/mysql/servers.ibd

200307 22:04:15 [01]        ...done

... ...

200307 22:04:15 [01]        ...done

200307 22:04:15 [01] Copying ./ib_buffer_pool to /data/mysql/data/ib_buffer_pool

200307 22:04:15 [01]        ...done

200307 22:04:15 [01] Copying ./xtrabackup_info to /data/mysql/data/xtrabackup_info

200307 22:04:15 [01]        ...done

200307 22:04:15 completed OK!

修改目录属主

最后别忘了修改目录属主

[root@ocp data]# chown mysql.mysql -R *

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

数据库打工人
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
关于percona-xtrabackup 安装的小纠结
Silence-墨轩的博客
04-08 4044
今天本来打算小装一个percona的xtrabackup来测试一把MySQL热备的实验，然后就在percona官网下载了一个最新版的2.4.6版本的xtrabackup 然后先在Redhat 6.4系统上进行安装，将包传上去以后解压安装，然而报了 然后就在Google上查了一下： https://bugs.launchpad.net/percona-xtrabackup/+bug/1
数据库备份工具innobackupex
qq_32273965的博客
01-08 2427
一、了解innobackupex 1、mysqldump mysql逻辑备份工具，作用于服务器本地，不需要额外安装插件 可以单表备份，备份为sql文件形式、方便，在多个场景通用 可通过shell命令实现定时备份，<font color="Red">但备份时如果用户有操作，容易造成脏数据</font> 将数据库备份到服务器本地sql文件，属于逻辑备份，不受数据库引擎限制 只能...
《MYSQL备份与恢复》之 Innodb与 MyISAM引擎
03-20
《MYSQL备份与恢复》之 Innodb与 MyISAM引擎 一、系统环境 1.1 ubuntu 12.0.4 X86_64 1.2 percona-xtrabackup-2.0.3.tar.gz 1.3 xtrabackup简介 xtrabackup是一个对InnoDB做数据备份的工具，支持在线热备份(备份时不影响数据读写)，是商业备份工具InnoDB Hotbackup的一个很好的替代品。 xtrabackup有两个主要的工具：xtrabackup、innobackupex （1）xtrabackup只能备份InnoDB和XtraDB两种数据表，而不能备份MyISAM数据表 （2）innobackupex是参考了InnoDB Hotbackup的innoback脚本修改而来的，innobackupex是一个perl脚本封装，封装了xtrabackup，所以能同时备份处理innodb和myisam，但在处理myisam时需要加一个读锁。并且加入了一些使用的选项,如slave-info可以记录备份恢复后，作为slave需要的一些信息，根据这些信息，可以很方便的利用备份来重做slave。 （3）使用帮助：http://www.percona.com/docs/wiki/percona-xtrabackup:start 　（4）Xtrabackup可以做什么 　　在线(热)备份整个库的InnoDB、 XtraDB表 　　在xtrabackup的上一次整库备份基础上做增量备份(innodb only) 　　以流的形式产生备份，可以直接保存到远程机器上(本机硬盘空间不足时很有用) 　　MySQL数据库本身提供的工具并不支持真正的增量备份，二进制日志恢复是point-in-time(时间点)的恢复而不是增量备份。Xtrabackup工具支持对InnoDB存储引擎的增量备份，工作原理如下： xtrabackup备份原理 　　xtraBackup基于InnoDB的crash-recovery功能。它会复制innodb的data file，由于不锁表，复制出来的数据是不一致的，在恢复的时候使用crash-recovery，使得数据恢复一致。 　　InnoDB维护了一个redo log，又称为transaction log，事务日志，它包含了innodb数据的所有改动情况。当InnoDB启动的时候，它会先去检查data file和transaction log，并且会做二步操作： 　　xtraBackup在备份的时候， 一页一页地复制innodb的数据，而且不锁定表，与此同时，XtraBackup还有另外一个线程监视着transactions log，一旦log发生变化，就把变化过的log pages复制走。为什么要急着复制走呢？ 因为transactions log文件大小有限，写满之后，就会从头再开始写，所以新数据可能会覆盖到旧的数据。 　　在prepare过程中，XtraBackup使用复制到的transactions log对备份出来的innodb data file进行crash recovery。
Xtrabackup备份MySQL最佳实践
sqlora的专栏
10-27 768
xtrabackup备份
XtraBackup实践(一)备份
weixin_34221073的博客
01-05 728
title: XtraBackup实践(一)备份 tags: xtrabackup mysql 热备 物理备份 categories: mysql date: 2017-10-28 16:31:16 背景 目前随着用户越来越多 db的实时性和稳定性也提出了新的要求 之前的备份逻辑时逻辑备份 随着磁盘的扩容 也考虑目前再加上物理备份 详细区别可以从参考下文 逻辑备份 逻辑备份是备份sql语...
CentOS 6.6安装Xtrabackup RPM提示缺少libev.so.4()
weixin_34040079的博客
03-22 272
在CentOS Release 6.6安装percona-xtrabackup-2.3.4时，遇到下面错误信息 rpm -ivh percona-xtrabackup-2.3.4-1.el6.x86_64.rpm 在 https://bugs.launchpad.net/percona-xtrabackup/+bug/1526636上看到，这个是一个bug来着，在 percona-xtraba...
mysql主从搭建-pxb全备
02-26
mysql主从搭建-pxb全备
电子测量中的安捷伦科技显著增强PXB基带发生器和通道仿真器的性能
11-08
安捷伦科技的N5106A PXB基带发生器和通道仿真器是一款集多功能于一体的电子测量设备，特别适合于产品研发、集成、验证和预一致性测试等多个环节。这款设备通过一系列增强特性，显著提升了其在电子测量领域的性能表现...
pxb-database：可通过Github API访问的数据存储
02-13
pxb数据库 此存储库包含文档网站中使用的数据。 该数据库可以JSON格式访问，并使用Typescript进行强制和构建。 我们的数据库可通过Github API获得： ...
安捷伦科技显著增强PXB基带发生器和通道仿真器的性能
01-20
安捷伦科技公司日前宣布，其N5106A PXB 带发生器和通道仿真器新增加了多种增强特性，可以极大地扩展其在研发周期中的使用范围，适用于设计、集成、验证和预先一致性测试等各个阶段。借助这些增强特性，PXB 能够在一...
CxGrid里面画迷你图_PXB
11-03
为了提高用户体验，可以为迷你图添加鼠标悬停提示，显示具体数值或百分比，甚至支持点击后放大查看详细信息。 6. **性能优化**： 考虑到大量数据的渲染，优化绘图算法和数据处理是非常重要的。可以考虑预处理数据...
基于Innobackupex的MySQL备份脚本
乐沙弥的世界
01-12 6339
Innobackupex是Xtrabackup的一部分，其实质也是调用xtrabackup。主要的不同是Xtrabackup除了支持innodb引擎外还支持xtradb引擎。本文主要封装了Innobackupex到shell脚本进行定期备份，供大家参考。 1、脚本描述a、支持增量备份以及全备b、需要传递到备份脚本(如备份路径，连接相关参数等)c、基于周日，周三的全量备份，其他增量备份d、可根据需要
安装xtrabackup时，缺少了libev.so.4()
qq_43297410的博客
05-14 3744
在安装 percona-xtrabackup 软件时，出现错误 “libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.6-2.el6.x86_64”。 这是缺少了libev.so.4()，要对其进行安装 解决方法：安装 wget ftp://rpmfind.net/linux/atrpms/el6-x86_64/atrpms/sta...
MySQL数据备份之实战：innobackupex实时增量备份和还原
最新发布
白话机器学习
08-21 212
Installed:Complete!Installed:Complete!”.
解决 libev.so.4()(64bit) is needed by percona-xtrabackup-2.3.4-1.el6.x86_64案例
热门推荐
GreyHat OMDBA
05-17 1万+
在mysql主从同步时经常会用到Xtra, XtraBackup可以说是一个相对完美的免费开源数据备份工具，支持在线无锁表同步复制和可并行高效率的安全备份恢复机制相比mysqldump来说优势较大, 在RHEL6中安装XtraBackup时发生缺少依赖包的现象，本人针对缺少依赖包现象进行解决 1.本实验环境 [root@master ~]# uname -r 2.6.32-573.el6.x
达梦数据库-备份还原 （联机备份）
达梦数据库技术贴
09-07 1888
达梦数据库备份还原的分类：物理备份还原，逻辑备份还原。 本章介绍一下使用达梦数据管理工具、SQL进行备份还原（物理） 物理备份还原是对数据库的操作系统物理文件（如数据文件、控制文件和日志文件等）的备份还原。 物理备份还原： 冷备：叫做脱机备份数据库实例服务是关闭的 热备：叫做联机备份，数据库是打开的，数据库要开归档) 备份 一、首先查看DmAPService服务是否开启（切记一定开启服务） 如过无法启动服务：请转到-------达梦数数据库入门之安装、卸载、常见故障问题 链接：https://blog
mysql之 xtrabackup-2.4.12 安装
weixin_34260991的博客
09-25 336
版本说明：备份工具：percona-xtrabackup-2.4.12-Linux-x86_64.libgcrypt11os:centos 6.5 1、解压安装包tar zxvf percona-xtrabackup-2.4.12-Linux-x86_64.libgcrypt11.tar.gz 2、做软链接ln -s percona-xtrabackup-2.4.12-Linux-x86_64  ...
xtrabackup的安装
liuzhilong的博客
07-21 1032
xtrabackup安装。 在percona官网直接下载开源的xtrabackup工具 下载地址：https://www.percona.com/doc/percona-xtrabackup/8.0/installation/yum_repo.html [root@lzl soft]# yum install -y percona-xtrabackup-80-8.0.13-1.el6.x86_64.rpm Loaded plugins: product-id, refresh-packagekit.
mac 安装 apktool和dex2jar,jd-gui
06-25
dex2jar：https://github.com/pxb1988/dex2jar/releases jd-gui：http://jd.benow.ca/ 2. 下载完成之后，将 dex2jar 和 jd-gui 的压缩包解压到任意目录下（例如：/Users/xxx/tools）。 3. 接着需要在终端中输入...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值