Percona Server 5.6.12：XtraBackup 2.2.13
Percona Server 5.6.12，对应的XtraBackup为2.2.13。
URL： https://www.percona.com/downloads/XtraBackup/LATEST/
安装Percona的YUM REPO：
|
1 |
rpm -ivh http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm |
如果试图安装更高版本，则可能遇到这样的报错：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
[root@mysql_5612 software_me]# yum install percona-xtrabackup-24 Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed --> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 --> Running transaction check ---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 ---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed --> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.013-3.el6.x86_64 --> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.013-3.el6.x86_64 --> 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 Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.625.rhel6 will be installed ---> Package percona-xtrabackup-24.x86_64 0:2.4.7-2.el6 will be installed --> Processing Dependency: libev.so.4()(64bit) for package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed --> Finished Dependency Resolution Error: Package: percona-xtrabackup-24-2.4.7-2.el6.x86_64 (percona-release-x86_64) Requires: libev.so.4()(64bit) You could try using --skip-broken to work around the problem ** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) [root@mysql_5612 software_me]# |
系统中存在的【libmysqlclient】：
|
1 2 3 4 5 6 7 8 9 10 11 |
[root@mysql_5612 software_me]# find / -name "*libmysqlclient*" /usr/lib64/libmysqlclient.so.18.0.0 /usr/lib64/libmysqlclient_r.so.18 /usr/lib64/libmysqlclient_r.so /usr/lib64/libmysqlclient_r.so.18.0.0 /usr/lib64/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so [root@mysql_5612 software_me]# [root@mysql_5612 software_me]# rpm -qf /usr/lib64/libmysqlclient.so.18.0.0 Percona-Server-shared-56-5.6.12-rc60.4.393.rhel6.x86_64 [root@mysql_5612 software_me]# |
安装XtraBackup22：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 |
[root@mysql_5612 software_me]# yum list | grep xtrabackup percona-xtrabackup-22.x86_64 2.2.13-1.el6 @percona-release-x86_64 percona-xtrabackup.x86_64 2.3.8-1.el6 percona-release-x86_64 percona-xtrabackup-20.x86_64 2.0.8-587.rhel6 percona-release-x86_64 percona-xtrabackup-20-debuginfo.x86_64 2.0.8-587.rhel6 percona-release-x86_64 percona-xtrabackup-20-test.x86_64 2.0.8-587.rhel6 percona-release-x86_64 percona-xtrabackup-21.x86_64 2.1.9-746.rhel6 percona-release-x86_64 percona-xtrabackup-21-debuginfo.x86_64 2.1.9-746.rhel6 percona-release-x86_64 percona-xtrabackup-22-debuginfo.x86_64 2.2.13-1.el6 percona-release-x86_64 percona-xtrabackup-24.x86_64 2.4.7-2.el6 percona-release-x86_64 percona-xtrabackup-24-debuginfo.x86_64 2.4.7-2.el6 percona-release-x86_64 percona-xtrabackup-debuginfo.x86_64 2.3.8-1.el6 percona-release-x86_64 percona-xtrabackup-test.x86_64 2.3.8-1.el6 percona-release-x86_64 percona-xtrabackup-test-21.x86_64 2.1.9-746.rhel6 percona-release-x86_64 percona-xtrabackup-test-22.x86_64 2.2.13-1.el6 percona-release-x86_64 percona-xtrabackup-test-24.x86_64 2.4.7-2.el6 percona-release-x86_64 [root@mysql_5612 software_me]# [root@mysql_5612 software_me]# yum install percona-xtrabackup-22 Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package percona-xtrabackup-22.x86_64 0:2.2.13-1.el6 will be installed --> Processing Dependency: perl(DBD::mysql) for package: percona-xtrabackup-22-2.2.13-1.el6.x86_64 --> Processing Dependency: perl(Time::HiRes) for package: percona-xtrabackup-22-2.2.13-1.el6.x86_64 --> Running transaction check ---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed --> Processing Dependency: perl(DBI::Const::GetInfoType) for package: perl-DBD-MySQL-4.013-3.el6.x86_64 --> Processing Dependency: perl(DBI) for package: perl-DBD-MySQL-4.013-3.el6.x86_64 --> 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 ---> Package perl-Time-HiRes.x86_64 4:1.9721-144.el6 will be installed --> Processing Dependency: perl = 4:5.10.1-144.el6 for package: 4:perl-Time-HiRes-1.9721-144.el6.x86_64 --> Running transaction check ---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.625.rhel6 will be installed ---> Package perl.x86_64 4:5.10.1-141.el6_7.1 will be updated --> Processing Dependency: perl = 4:5.10.1-141.el6_7.1 for package: 1:perl-Module-Pluggable-3.90-141.el6_7.1.x86_64 --> Processing Dependency: perl = 4:5.10.1-141.el6_7.1 for package: 3:perl-version-0.77-141.el6_7.1.x86_64 --> Processing Dependency: perl = 4:5.10.1-141.el6_7.1 for package: 4:perl-libs-5.10.1-141.el6_7.1.x86_64 --> Processing Dependency: perl = 4:5.10.1-141.el6_7.1 for package: 1:perl-Pod-Escapes-1.04-141.el6_7.1.x86_64 --> Processing Dependency: perl = 4:5.10.1-141.el6_7.1 for package: 1:perl-Pod-Simple-3.13-141.el6_7.1.x86_64 ---> Package perl.x86_64 4:5.10.1-144.el6 will be an update ---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed --> Running transaction check ---> Package perl-Module-Pluggable.x86_64 1:3.90-141.el6_7.1 will be updated ---> Package perl-Module-Pluggable.x86_64 1:3.90-144.el6 will be an update ---> Package perl-Pod-Escapes.x86_64 1:1.04-141.el6_7.1 will be updated ---> Package perl-Pod-Escapes.x86_64 1:1.04-144.el6 will be an update ---> Package perl-Pod-Simple.x86_64 1:3.13-141.el6_7.1 will be updated ---> Package perl-Pod-Simple.x86_64 1:3.13-144.el6 will be an update ---> Package perl-libs.x86_64 4:5.10.1-141.el6_7.1 will be updated ---> Package perl-libs.x86_64 4:5.10.1-144.el6 will be an update ---> Package perl-version.x86_64 3:0.77-141.el6_7.1 will be updated ---> Package perl-version.x86_64 3:0.77-144.el6 will be an update --> Finished Dependency Resolution Dependencies Resolved ================================================================================================================= Package Arch Version Repository Size ================================================================================================================= Installing: percona-xtrabackup-22 x86_64 2.2.13-1.el6 percona-release-x86_64 4.8 M Installing for dependencies: Percona-Server-shared-51 x86_64 5.1.73-rel14.12.625.rhel6 percona-release-x86_64 2.1 M perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k perl-DBI x86_64 1.609-4.el6 base 705 k perl-Time-HiRes x86_64 4:1.9721-144.el6 base 49 k Updating for dependencies: perl x86_64 4:5.10.1-144.el6 base 10 M perl-Module-Pluggable x86_64 1:3.90-144.el6 base 41 k perl-Pod-Escapes x86_64 1:1.04-144.el6 base 33 k perl-Pod-Simple x86_64 1:3.13-144.el6 base 213 k perl-libs x86_64 4:5.10.1-144.el6 base 579 k perl-version x86_64 3:0.77-144.el6 base 52 k Transaction Summary ================================================================================================================= Install 5 Package(s) Upgrade 6 Package(s) Total size: 19 M Total download size: 2.4 M Is this ok [y/N]: y Downloading Packages: (1/2): Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64.rpm | 2.1 MB 00:07 (2/2): perl-Pod-Simple-3.13-144.el6.x86_64.rpm | 213 kB 00:00 ----------------------------------------------------------------------------------------------------------------- Total 304 kB/s | 2.4 MB 00:07 warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Percona Importing GPG key 0xCD2EFD2A: Userid : Percona MySQL Development Team <mysql-dev@percona.com> Package: percona-release-0.1-3.noarch (installed) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-Percona Is this ok [y/N]: y Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows: 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16()(64bit) 2:postfix-2.6.6-6.el6_7.1.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit) Updating : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 1/17 Updating : 4:perl-libs-5.10.1-144.el6.x86_64 2/17 Updating : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 3/17 Updating : 1:perl-Pod-Simple-3.13-144.el6.x86_64 4/17 Updating : 3:perl-version-0.77-144.el6.x86_64 5/17 Updating : 4:perl-5.10.1-144.el6.x86_64 6/17 Installing : perl-DBI-1.609-4.el6.x86_64 7/17 Installing : 4:perl-Time-HiRes-1.9721-144.el6.x86_64 8/17 Installing : Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64 9/17 Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 10/17 Installing : percona-xtrabackup-22-2.2.13-1.el6.x86_64 11/17 Cleanup : 1:perl-Module-Pluggable-3.90-141.el6_7.1.x86_64 12/17 Cleanup : 1:perl-Pod-Escapes-1.04-141.el6_7.1.x86_64 13/17 Cleanup : 1:perl-Pod-Simple-3.13-141.el6_7.1.x86_64 14/17 Cleanup : 4:perl-libs-5.10.1-141.el6_7.1.x86_64 15/17 Cleanup : 4:perl-5.10.1-141.el6_7.1.x86_64 16/17 Cleanup : 3:perl-version-0.77-141.el6_7.1.x86_64 17/17 Verifying : 3:perl-version-0.77-144.el6.x86_64 1/17 Verifying : Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64 2/17 Verifying : 4:perl-libs-5.10.1-144.el6.x86_64 3/17 Verifying : 4:perl-5.10.1-144.el6.x86_64 4/17 Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 5/17 Verifying : 1:perl-Pod-Escapes-1.04-144.el6.x86_64 6/17 Verifying : perl-DBI-1.609-4.el6.x86_64 7/17 Verifying : 4:perl-Time-HiRes-1.9721-144.el6.x86_64 8/17 Verifying : percona-xtrabackup-22-2.2.13-1.el6.x86_64 9/17 Verifying : 1:perl-Module-Pluggable-3.90-144.el6.x86_64 10/17 Verifying : 1:perl-Pod-Simple-3.13-144.el6.x86_64 11/17 Verifying : 1:perl-Module-Pluggable-3.90-141.el6_7.1.x86_64 12/17 Verifying : 1:perl-Pod-Simple-3.13-141.el6_7.1.x86_64 13/17 Verifying : 1:perl-Pod-Escapes-1.04-141.el6_7.1.x86_64 14/17 Verifying : 3:perl-version-0.77-141.el6_7.1.x86_64 15/17 Verifying : 4:perl-libs-5.10.1-141.el6_7.1.x86_64 16/17 Verifying : 4:perl-5.10.1-141.el6_7.1.x86_64 17/17 Installed: percona-xtrabackup-22.x86_64 0:2.2.13-1.el6 Dependency Installed: Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.625.rhel6 perl-DBD-MySQL.x86_64 0:4.013-3.el6 perl-DBI.x86_64 0:1.609-4.el6 perl-Time-HiRes.x86_64 4:1.9721-144.el6 Dependency Updated: perl.x86_64 4:5.10.1-144.el6 perl-Module-Pluggable.x86_64 1:3.90-144.el6 perl-Pod-Escapes.x86_64 1:1.04-144.el6 perl-Pod-Simple.x86_64 1:3.13-144.el6 perl-libs.x86_64 4:5.10.1-144.el6 perl-version.x86_64 3:0.77-144.el6 Complete! [root@mysql_5612 software_me]# |
安装完成后，查看版本：
|
1 2 3 4 5 6 |
[root@mysql_5612 software_me]# whereis xtrabackup xtrabackup: /usr/bin/xtrabackup /usr/share/man/man1/xtrabackup.1.gz [root@mysql_5612 software_me]# [root@mysql_5612 software_me]# xtrabackup -v xtrabackup version 2.2.13 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 70f4be3) [root@mysql_5612 software_me]# |
执行一个备份：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 |
[root@mysql_5612 mysql_backup_data]# innobackupex --user=root --password=abcd1234 /software_me/mysql_backup_data 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 resources: http://www.percona.com/xb/p 170718 20:11:33 innobackupex: Executing a version check against the server... 170718 20:11:33 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 170718 20:11:33 innobackupex: Connected to MySQL server 170718 20:11:33 innobackupex: Done. 170718 20:11:33 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES). 170718 20:11:33 innobackupex: Connected to MySQL server 170718 20:11:33 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!". innobackupex: Using server version 5.6.12-56-log innobackupex: Created backup directory /software_me/mysql_backup_data/2017-07-18_20-11-33 170718 20:11:33 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/software_me/mysql_backup_data/2017-07-18_20-11-33 --innodb_log_file_size="50331648" --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp --extra-lsndir='/tmp' innobackupex: Waiting for ibbackup (pid=57538) to suspend innobackupex: Suspend file '/software_me/mysql_backup_data/2017-07-18_20-11-33/xtrabackup_suspended_2' xtrabackup version 2.2.13 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 70f4be3) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/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 >> log scanned up to (689358154) xtrabackup: Generating a list of tablespaces [01] Copying ./ibdata1 to /software_me/mysql_backup_data/2017-07-18_20-11-33/ibdata1 [01] ...done >> log scanned up to (689358154) [01] Copying ./milly/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_links.ibd [01] ...done [01] Copying ./milly/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_postmeta.ibd [01] ...done [01] Copying ./milly/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./milly/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_users.ibd [01] ...done [01] Copying ./milly/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_commentmeta.ibd [01] ...done [01] Copying ./milly/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_term_relationships.ibd [01] ...done [01] Copying ./milly/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_term_taxonomy.ibd [01] ...done [01] Copying ./milly/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_termmeta.ibd [01] ...done [01] Copying ./milly/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_slim_events.ibd [01] ...done [01] Copying ./milly/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_posts.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./milly/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./milly/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_comments.ibd [01] ...done [01] Copying ./milly/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_slim_events_archive.ibd [01] ...done [01] Copying ./milly/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_slim_stats.ibd [01] ...done [01] Copying ./milly/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_terms.ibd [01] ...done [01] Copying ./milly/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_options.ibd [01] ...done [01] Copying ./milly/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_cn_track_post.ibd [01] ...done [01] Copying ./milly/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/milly/wp_usermeta.ibd [01] ...done [01] Copying ./datacenter/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_links.ibd [01] ...done [01] Copying ./datacenter/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_postmeta.ibd [01] ...done [01] Copying ./datacenter/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./datacenter/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_users.ibd [01] ...done [01] Copying ./datacenter/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_commentmeta.ibd [01] ...done [01] Copying ./datacenter/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_term_relationships.ibd [01] ...done [01] Copying ./datacenter/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_term_taxonomy.ibd [01] ...done [01] Copying ./datacenter/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_termmeta.ibd [01] ...done [01] Copying ./datacenter/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_slim_events.ibd [01] ...done [01] Copying ./datacenter/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_posts.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./datacenter/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./datacenter/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_comments.ibd [01] ...done [01] Copying ./datacenter/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_slim_events_archive.ibd [01] ...done [01] Copying ./datacenter/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_slim_stats.ibd [01] ...done [01] Copying ./datacenter/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_terms.ibd [01] ...done [01] Copying ./datacenter/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_options.ibd [01] ...done [01] Copying ./datacenter/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_cn_track_post.ibd [01] ...done [01] Copying ./datacenter/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/datacenter/wp_usermeta.ibd [01] ...done [01] Copying ./lenka/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_links.ibd [01] ...done [01] Copying ./lenka/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_postmeta.ibd [01] ...done [01] Copying ./lenka/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./lenka/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_users.ibd [01] ...done [01] Copying ./lenka/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_commentmeta.ibd [01] ...done [01] Copying ./lenka/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_term_relationships.ibd [01] ...done [01] Copying ./lenka/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_term_taxonomy.ibd [01] ...done [01] Copying ./lenka/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_termmeta.ibd [01] ...done [01] Copying ./lenka/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_slim_events.ibd [01] ...done [01] Copying ./lenka/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_posts.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./lenka/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./lenka/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_comments.ibd [01] ...done [01] Copying ./lenka/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_slim_events_archive.ibd [01] ...done [01] Copying ./lenka/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_slim_stats.ibd [01] ...done [01] Copying ./lenka/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_terms.ibd [01] ...done [01] Copying ./lenka/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_options.ibd [01] ...done [01] Copying ./lenka/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_cn_track_post.ibd [01] ...done [01] Copying ./lenka/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/lenka/wp_usermeta.ibd [01] ...done [01] Copying ./he/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_links.ibd [01] ...done [01] Copying ./he/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_postmeta.ibd [01] ...done [01] Copying ./he/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./he/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_users.ibd [01] ...done [01] Copying ./he/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_commentmeta.ibd [01] ...done [01] Copying ./he/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_term_relationships.ibd [01] ...done [01] Copying ./he/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_term_taxonomy.ibd [01] ...done [01] Copying ./he/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_termmeta.ibd [01] ...done [01] Copying ./he/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_slim_events.ibd [01] ...done [01] Copying ./he/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_posts.ibd >> log scanned up to (689358154) >> log scanned up to (689358154) [01] ...done [01] Copying ./he/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./he/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_comments.ibd [01] ...done [01] Copying ./he/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_slim_events_archive.ibd [01] ...done [01] Copying ./he/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_slim_stats.ibd [01] ...done [01] Copying ./he/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_terms.ibd [01] ...done [01] Copying ./he/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_options.ibd [01] ...done [01] Copying ./he/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_cn_track_post.ibd [01] ...done [01] Copying ./he/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/he/wp_usermeta.ibd [01] ...done [01] Copying ./she/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_links.ibd [01] ...done [01] Copying ./she/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_postmeta.ibd [01] ...done [01] Copying ./she/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./she/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_users.ibd [01] ...done [01] Copying ./she/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_commentmeta.ibd [01] ...done [01] Copying ./she/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_term_relationships.ibd [01] ...done [01] Copying ./she/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_term_taxonomy.ibd [01] ...done [01] Copying ./she/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_termmeta.ibd [01] ...done [01] Copying ./she/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_slim_events.ibd [01] ...done [01] Copying ./she/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_posts.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./she/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./she/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_comments.ibd [01] ...done [01] Copying ./she/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_slim_events_archive.ibd [01] ...done [01] Copying ./she/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_slim_stats.ibd [01] ...done [01] Copying ./she/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_terms.ibd [01] ...done [01] Copying ./she/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_options.ibd [01] ...done [01] Copying ./she/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_cn_track_post.ibd [01] ...done [01] Copying ./she/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/she/wp_usermeta.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_links.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_postmeta.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_users.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_commentmeta.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_term_relationships.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_term_taxonomy.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_termmeta.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_slim_events.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_posts.ibd >> log scanned up to (689358154) >> log scanned up to (689358154) [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_post_views.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_comments.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_slim_events_archive.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_slim_stats.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_terms.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_options.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_cn_track_post.ibd [01] ...done [01] Copying ./dprototy_wordpress_adamhuan/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/dprototy_wordpress_adamhuan/wp_usermeta.ibd [01] ...done [01] Copying ./me/wp_links.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_links.ibd [01] ...done [01] Copying ./me/wp_postmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_postmeta.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./me/wp_slim_stats_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_slim_stats_archive.ibd [01] ...done [01] Copying ./me/wp_users.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_users.ibd [01] ...done [01] Copying ./me/wp_commentmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_commentmeta.ibd [01] ...done [01] Copying ./me/wp_term_relationships.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_term_relationships.ibd [01] ...done [01] Copying ./me/wp_term_taxonomy.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_term_taxonomy.ibd [01] ...done [01] Copying ./me/wp_termmeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_termmeta.ibd [01] ...done [01] Copying ./me/wp_slim_events.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_slim_events.ibd [01] ...done [01] Copying ./me/wp_posts.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_posts.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./me/wp_post_views.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_post_views.ibd >> log scanned up to (689358154) [01] ...done [01] Copying ./me/wp_comments.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_comments.ibd [01] ...done [01] Copying ./me/wp_slim_events_archive.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_slim_events_archive.ibd [01] ...done [01] Copying ./me/wp_slim_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_slim_stats.ibd [01] ...done [01] Copying ./me/wp_terms.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_terms.ibd [01] ...done [01] Copying ./me/wp_options.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_options.ibd [01] ...done [01] Copying ./me/wp_cn_track_post.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_cn_track_post.ibd [01] ...done [01] Copying ./me/wp_usermeta.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/me/wp_usermeta.ibd [01] ...done [01] Copying ./mysql/slave_relay_log_info.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/mysql/slave_relay_log_info.ibd [01] ...done [01] Copying ./mysql/slave_worker_info.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/mysql/slave_worker_info.ibd [01] ...done [01] Copying ./mysql/slave_master_info.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/mysql/slave_master_info.ibd [01] ...done [01] Copying ./mysql/innodb_index_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/mysql/innodb_index_stats.ibd [01] ...done [01] Copying ./mysql/innodb_table_stats.ibd to /software_me/mysql_backup_data/2017-07-18_20-11-33/mysql/innodb_table_stats.ibd [01] ...done >> log scanned up to (689358154) xtrabackup: Creating suspend file '/software_me/mysql_backup_data/2017-07-18_20-11-33/xtrabackup_suspended_2' with pid '57538' 170718 20:11:52 innobackupex: Continuing after ibbackup has suspended 170718 20:11:52 innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG TABLES... 170718 20:11:52 innobackupex: Executing FLUSH TABLES WITH READ LOCK... 170718 20:11:52 innobackupex: All tables locked and flushed to disk 170718 20:11:52 innobackupex: Starting to backup non-InnoDB tables and files innobackupex: in subdirectories of '/var/lib/mysql/' innobackupex: Backing up files '/var/lib/mysql//milly/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) innobackupex: Backing up files '/var/lib/mysql//datacenter/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) >> log scanned up to (689358154) innobackupex: Backing up files '/var/lib/mysql//lenka/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) innobackupex: Backing up files '/var/lib/mysql//he/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) innobackupex: Backing up files '/var/lib/mysql//she/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) innobackupex: Backing up files '/var/lib/mysql//dprototy_wordpress_adamhuan/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files) innobackupex: Backing up files '/var/lib/mysql//me/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (103 files) >> log scanned up to (689358154) innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files) 170718 20:11:54 innobackupex: Finished backing up non-InnoDB tables and files 170718 20:11:54 innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... 170718 20:11:54 innobackupex: Waiting for log copying to finish xtrabackup: The latest check point (for incremental): '689358154' xtrabackup: Stopping log copying thread. .>> log scanned up to (689358154) xtrabackup: Creating suspend file '/software_me/mysql_backup_data/2017-07-18_20-11-33/xtrabackup_log_copied' with pid '57538' xtrabackup: Transaction log of lsn (689358154) to (689358154) was copied. 170718 20:11:55 innobackupex: All tables unlocked innobackupex: Backup created in directory '/software_me/mysql_backup_data/2017-07-18_20-11-33' innobackupex: MySQL binlog position: filename 'master.000004', position 120 170718 20:11:55 innobackupex: Connection to database server closed 170718 20:11:55 innobackupex: completed OK! [root@mysql_5612 mysql_backup_data]# [root@mysql_5612 mysql_backup_data]# [root@mysql_5612 mysql_backup_data]# ls -ltr total 4 drwxr-xr-x 12 root root 4096 Jul 18 20:11 2017-07-18_20-11-33 [root@mysql_5612 mysql_backup_data]# |
————————————————
Done。
还可以用EPEL安装:
[root@dg12c1 ~]# yum list | grep percona
Repository base is listed more than once in the configuration
Repository updates is listed more than once in the configuration
Repository extras is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration
percona-xtrabackup.x86_64 2.3.6-1.el7 epel
percona-xtrabackup-test.x86_64 2.3.6-1.el7 epel
[root@dg12c1 ~]#