副标题#e#
这篇文章主要讲解了“MySQL Xtrabackup搭建主从复制方法是什么”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL Xtrabackup搭建主从复制方法是什么”吧！
 
1、源端查看主库环境
 
[root@mysql1 ~]# uname -a
 
Linux mysql1 2.6.32-642.el6.x86_64 #1 SMP Tue May 10 17:27:01 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
 
[root@mysql1 ~]#
 
[root@mysql1 ~]# date
 
Wed Nov 21 06:45:15 CST 2018
 
[root@mysql1 ~]#
 
[root@mysql1 ~]# df -h
 
Filesystem            Size  Used Avail Use% Mounted on
 
/dev/mapper/VolGroup-LogVol00
 
                      533G  330G  177G  66% /
 
tmpfs                  32G   68K   32G   1% /dev/shm
 
/dev/sda1             477M   41M  411M   9% /boot
 
[root@mysql1 ~]#
 
[root@mysql1 soft]# ps -ef|grep mysql |grep 3306
 
mysql    165534      1  0 Apr08 ?        00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe –datadir=/opt/mysql/mysql_3306/data –pid-file=/opt/mysql/mysql_3306/data/mysql.pid
 
mysql    166977 165534  1 Apr08 ?        3-05:44:59 /usr/local/mysql/bin/mysqld –basedir=/usr/local/mysql –datadir=/opt/mysql/mysql_3306/data –plugin-dir=/usr/local/mysql/lib/plugin –log-error=/opt/mysql/mysql_3306/data/error.log –pid-file=/opt/mysql/mysql_3306/data/mysql.pid –socket=/opt/mysql/mysql_3306/mysql.sock –port=3306
 
[root@mysql1 soft]#
 
[root@mysql1 ~]# cat /etc/hosts
 
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
 
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
 
192.168.56.22mysql1
 
[root@mysql1 ~]#
 
[root@mysql1 mysql_3306]# cat my.cnf
 
[mysqld]
 
innodb_buffer_pool_size = 35G
 
innodb_buffer_pool_instances = 16
 
innodb_log_file_size    = 8589934592
 
log_error = /opt/mysql/mysql_3306/data/error.log
 
datadir = /opt/mysql/mysql_3306/data
 
basedir = /usr/local/mysql
 
log_bin = /opt/mysql/mysql_3306/logs/bin
 
log-bin-index  = /opt/mysql/mysql_3306/logs/bin.index
 
relay_log = /opt/mysql/mysql_3306/logs/relay
 
socket    = /opt/mysql/mysql_3306/mysql.sock
 
tmpdir = /opt/mysql/mysql_3306/tmp
 
server-id = 5622
 
port = 3306
 
pid-file = /opt/mysql/mysql_3306/data/mysql.pid
 
#event_scheduler = 1
 
########basic settings########
 
user = mysql
 
sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
 
interactive_timeout = 1800
 
wait_timeout = 1800
 
lock_wait_timeout=5
 
read_buffer_size = 16777216
 
read_rnd_buffer_size = 33554432
 
sort_buffer_size = 33554432
 
lower_case_table_names = 1
 
autocommit = 1
 
character_set_server=utf8mb4
 
skip_name_resolve = 1
 
max_connections = 1000
 
max_connect_errors = 10000000
 
transaction_isolation = READ-COMMITTED
 
explicit_defaults_for_timestamp = 1
 
join_buffer_size = 134217728
 
tmp_table_size = 67108864
 
max_allowed_packet = 1073741824
 
innodb_open_files               = 1024
 
table_open_cache                = 2048
 
table_definition_cache          = 1024
 
table_open_cache_instances      = 32
 
########log settings########
 
#log_error = error.log
 
log_error_verbosity=2
 
slow_query_log = 1
 
slow_query_log_file = slow.log
 
log_queries_not_using_indexes = 1
 
log_slow_admin_statements = 1
 
log_slow_slave_statements = 1
 
log_throttle_queries_not_using_indexes = 10
 
expire_logs_days = 15
 
long_query_time = 2
 
min_examined_row_limit = 10000
 
########innodb settings########
 
innodb_page_size = 16384
 
innodb_buffer_pool_load_at_startup = 1
 
innodb_buffer_pool_dump_at_shutdown = 1
 
innodb_lru_scan_depth = 2048
 
innodb_lock_wait_timeout = 5
 
innodb_io_capacity = 2000
 
innodb_io_capacity_max = 20000
 
innodb_flush_method = O_DIRECT
 
innodb_file_format = Barracuda         # is deprecated and will be removed
 
innodb_file_format_max = Barracuda     # is deprecated and will be removed
 
innodb_flush_neighbors = 0
 
innodb_log_files_in_group = 2
 
innodb_log_buffer_size = 16777216
 
innodb_purge_threads = 4
 
innodb_large_prefix = 1
 
innodb_thread_concurrency = 64
 
innodb_print_all_deadlocks = 1
 
innodb_online_alter_log_max_size=1G
 
innodb_strict_mode = 1
 
innodb_sort_buffer_size = 67108864
 
innodb_write_io_threads = 8
 
innodb_read_io_threads = 8
 
innodb_file_per_table = 1
 
########replication settings########
 
master_info_repository = TABLE
 
relay_log_info_repository = TABLE
 
sync_relay_log_info = 1
 
sync_master_info = 1
 
sync_binlog = 1
 
sync_relay_log = 1
 
gtid_mode = on
 
enforce_gtid_consistency = 1
 
log_slave_updates
 
binlog_format = ROW
 
binlog_rows_query_log_events = 1
 
relay_log_recovery = 1
 
binlog_gtid_simple_recovery = 1
 
slave_skip_errors = ddl_exist_errors
 
slave-parallel-type = LOGICAL_CLOCK
 
slave-parallel-workers = 8
 
slave_pending_jobs_size_max     = 128M
 
########semi sync replication settings########
 
plugin_dir=/usr/local/mysql/lib/plugin
 
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
 
rpl_semi_sync_master_enabled = 1
 
rpl_semi_sync_master_timeout = 5000
 
rpl_semi_sync_slave_enabled = 1
 
innodb_buffer_pool_dump_pct = 40
 
innodb_page_cleaners = 16
 
innodb_undo_log_truncate = 0
 
innodb_undo_logs = 128
 
innodb_undo_tablespaces = 3
 
innodb_max_undo_log_size = 2G
 
innodb_purge_rseg_truncate_frequency = 128
 
binlog_gtid_simple_recovery=1
 
log_timestamps=system
 
slave_transaction_retries=128
 
show_compatibility_56=on
 
slave_preserve_commit_order=1
 
######## PS ########
 
performance_schema_instrument                              = 'transaction=ON'                         # transaction
 
performance_schema_instrument                              = 'wait/lock/metadata/sql/mdl=ON'          # metadata
 
performance_schema_instrument                              = 'memory/%=COUNTED'                       # memory
 
performance_schema_consumer_events_statements_history_long = ON
 
performance_schema_consumer_events_transactions_current    = ON
 
performance_schema_consumer_events_transactions_history    = ON
 
performance_schema_max_sql_text_length                     = 2048                                     # for MEM QUAN
 
max_digest_length                                          = 2048                                     # for MEM QUAN
 
[mysql]
 
user=root
 
password=mysql1234
 
socket = /opt/mysql/mysql_3306/mysql.sock
 
default-character-set   = utf8
 
max_allowed_packet = 1073741824
 
prompt = [\\u@\\h@\\p][\\d][\\r:\\m:\\s]>\\_
 
no-auto-rehash
 
# Remove the next comment character if you are not familiar with SQL
 
#safe-updates
 
[root@mysql1 mysql_3306]#
 
[root@mysql1 mysql_3306]# free -m
 
             total       used       free     shared    buffers     cached
 
Mem:         64311      64005        306          2        232      13294
 
-/+ buffers/cache:      50478      13833
 
Swap:        15999       5045      10954
 
[root@mysql1 mysql_3306]#
 
2、源端查看mysql用户信息
 
[root@mysql1 soft]# id mysql
 
uid=501(mysql) gid=501(mysql) groups=501(mysql)
 
[root@mysql1 soft]#
 
3、源端主库binlog和字符集信息
 
[root@localhost@mysql.sock][(none)][06:52:51]> show variables like '%log%';
 
+—————————————–+—————————————-+
 
| Variable_name                           | Value                                  |
 
+—————————————–+—————————————-+
 
| back_log                                | 92                                     |
 
| binlog_cache_size                       | 32768                                  |
 
| binlog_checksum                         | CRC32                                  |
 
| binlog_direct_non_transactional_updates | OFF                                    |
 
| binlog_error_action                     | ABORT_SERVER                           |
 
| binlog_format                           | ROW                                    |
 
| binlog_group_commit_sync_delay          | 0                                      |
 
| binlog_group_commit_sync_no_delay_count | 0                                      |
 
| binlog_gtid_simple_recovery             | ON                                     |
 
| binlog_max_flush_queue_time             | 0                                      |
 
| binlog_order_commits                    | ON                                     |
 
| binlog_row_image                        | FULL                                   |
 
| binlog_rows_query_log_events            | ON                                     |
 
| binlog_stmt_cache_size                  | 32768                                  |
 
| expire_logs_days                        | 15                                     |
 
| general_log                             | OFF                                    |
 
| general_log_file                        | /opt/mysql/mysql_3306/data/mysql1.log  |
 
| innodb_api_enable_binlog                | OFF                                    |
 
| innodb_flush_log_at_timeout             | 1                                      |
 
| innodb_flush_log_at_trx_commit          | 1                                      |
 
| innodb_locks_unsafe_for_binlog          | OFF                                    |
 
| innodb_log_buffer_size                  | 16777216                               |
 
| innodb_log_checksums                    | ON                                     |
 
| innodb_log_compressed_pages             | ON                                     |
 
| innodb_log_file_size                    | 8589934592                             |
 
| innodb_log_files_in_group               | 2                                      |
 
| innodb_log_group_home_dir               | ./                                     |
 
| innodb_log_write_ahead_size             | 8192                                   |
 
| innodb_max_undo_log_size                | 2147483648                             |
 
| innodb_online_alter_log_max_size        | 1073741824                             |
 
| innodb_undo_log_truncate                | OFF                                    |
 
| innodb_undo_logs                        | 128                                    |
 
| log_bin                                 | ON                                     |
 
| log_bin_basename                        | /opt/mysql/mysql_3306/logs/bin         |
 
| log_bin_index                           | /opt/mysql/mysql_3306/logs/bin.index   |
 
| log_bin_trust_function_creators         | OFF                                    |
 
| log_bin_use_v1_row_events               | OFF                                    |
 
| log_builtin_as_identified_by_password   | OFF                                    |
 
| log_error                               | /opt/mysql/mysql_3306/data/error.log   |
 
| log_error_verbosity                     | 2                                      |
 
| log_output                              | FILE                                   |
 
| log_queries_not_using_indexes           | ON                                     |
 
| log_slave_updates                       | ON                                     |
 
| log_slow_admin_statements               | ON                                     |
 
| log_slow_slave_statements               | ON                                     |
 
| log_statements_unsafe_for_binlog        | ON                                     |
 
| log_syslog                              | OFF                                    |
 
| log_syslog_facility                     | daemon                                 |
 
| log_syslog_include_pid                  | ON                                     |
 
| log_syslog_tag                          |                                        |
 
| log_throttle_queries_not_using_indexes  | 10                                     |
 
| log_timestamps                          | SYSTEM                                 |
 
| log_warnings                            | 1                                      |
 
| max_binlog_cache_size                   | 18446744073709547520                   |
 
| max_binlog_size                         | 1073741824                             |
 
| max_binlog_stmt_cache_size              | 18446744073709547520                   |
 
| max_relay_log_size                      | 0                                      |
 
| relay_log                               | /opt/mysql/mysql_3306/logs/relay       |
 
| relay_log_basename                      | /opt/mysql/mysql_3306/logs/relay       |
 
| relay_log_index                         | /opt/mysql/mysql_3306/logs/relay.index |
 
| relay_log_info_file                     | relay-log.info                         |
 
| relay_log_info_repository               | TABLE                                  |
 
| relay_log_purge                         | ON                                     |
 
| relay_log_recovery                      | ON                                     |
 
| relay_log_space_limit                   | 0                                      |
 
| slow_query_log                          | ON                                     |
 
| slow_query_log_file                     | slow.log                               |
 
| sql_log_bin                             | ON                                     |
 
| sql_log_off                             | OFF                                    |
 
| sync_binlog                             | 1                                      |
 
| sync_relay_log                          | 1                                      |
 
| sync_relay_log_info                     | 1                                      |
 
+—————————————–+—————————————-+
 
72 rows in set (0.00 sec)
 
[root@localhost@mysql.sock][(none)][06:53:22]>
 
[root@localhost@mysql.sock][(none)][06:54:52]> show variables like '%char%';
 
+————————–+———————————-+
 
| Variable_name            | Value                            |
 
+————————–+———————————-+
 
| character_set_client     | utf8                             |
 
| character_set_connection | utf8                             |
 
| character_set_database   | utf8mb4                          |
 
| character_set_filesystem | binary                           |
 
| character_set_results    | utf8                             |
 
| character_set_server     | utf8mb4                          |
 
| character_set_system     | utf8                             |
 
| character_sets_dir       | /usr/local/mysql/share/charsets/ |
 
+————————–+———————————-+
 
8 rows in set (0.00 sec)
 
[root@localhost@mysql.sock][(none)][06:55:07]>
 
[root@mysql1 ~]#
 
4、源端查看迁移的数据量或者备份的数据量
 
–数据库统计信息记录的数据量
 
[root@192.168.56.22@3306][(none)][06:34:03]> show databases;
 
+——————–+
 
| Database           |
 
+——————–+
 
| information_schema |
 
| cho                |
 
| cns                |
 
| mysql              |
 
| performance_schema |
 
| srn                |
 
| sys                |
 
+——————–+
 
7 rows in set (0.00 sec)
 
[root@192.168.56.22@3306][(none)][06:34:35]>
 
[root@192.168.56.22@3306][information_schema][06:37:53]> use information_schema                                                                          
 
Database changed
 
[root@192.168.56.22@3306][information_schema][06:38:00]> select concat(round(sum(data_length/1024/1024/1024),2),'GB') as data from tables where table_schema='srn';
 
+———+
 
| data    |
 
+———+
 
| 98.19GB |
 
+———+
 
1 row in set (0.00 sec)
 
[root@192.168.56.22@3306][information_schema][06:38:05]>
 
–数据文件的数据量
 
[root@mysql1 soft]# cd /opt/mysql/mysql_3306/data
 
[root@mysql1 data]# ls
 
auto.cnf  error.log       ib_logfile0  mysql               slow.log         sys      undo003
 
cho       ib_buffer_pool  ib_logfile1  mysql.pid           slow_report.log  undo001  xtrabackup_binlog_pos_innodb
 
cns       ibdata1         ibtmp1       performance_schema  srn              undo002  xtrabackup_info
 
[root@mysql1 data]# du -sh srn
 
164Gsrn
 
[root@mysql1 data]#
 
–由于数据库统计数据量有近100GB，数据文件存储量有164GB，因此采用xtrabackup进行主从备份和恢复
 
5、源端主库创建复制用户
 
[mysql@mysql1 backup]$ mysql -uroot -p  -S /opt/mysql/mysql_3306/mysql.sock
 
Enter password:
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
 
Your MySQL connection id is 27184
 
Server version: 5.7.18-log Source distribution
 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
 
affiliates. Other names may be trademarks of their respective
 
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
[root@192.168.56.22@3306][(none)][11:55:06]> show databases;
 
7 rows in set (0.00 sec)
 
[root@192.168.56.22@3306][(none)][11:55:08]
 
[root@192.168.56.22@3306][(none)][11:55:28]  GRANT REPLICATION SLAVE ON *.* TO 'myrepl'@'192.168.56.%' IDENTIFIED BY 'mysql1234';
 
Query OK, 0 rows affected, 1 warning (0.00 sec)
 
[root@192.168.56.22@3306][(none)][11:55:48]  flush privileges;
 
Query OK, 0 rows affected (0.01 sec)
 
6、目标端从库主机环境
 
[root@idc-srn-mysql2 ~]# uname -a
 
Linux idc-srn-mysql2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
 
[root@idc-srn-mysql2 ~]# id mysql
 
uid=1000(mysql) gid=1000(mysql) groups=1000(mysql)
 
[root@idc-srn-mysql2 ~]# df -h
 
Filesystem                 Size  Used Avail Use% Mounted on
 
/dev/mapper/centos-root     84G   26G   59G  31% /
 
devtmpfs                   7.8G     0  7.8G   0% /dev
 
tmpfs                      7.8G     0  7.8G   0% /dev/shm
 
tmpfs                      7.8G  8.5M  7.8G   1% /run
 
tmpfs                      7.8G     0  7.8G   0% /sys/fs/cgroup
 
/dev/mapper/vgdata-lvdata  493G   73M  467G   1% /mysql_data
 
/dev/sda1                  497M  126M  372M  26% /boot
 
tmpfs                      1.6G     0  1.6G   0% /run/user/0
 
[root@idc-srn-mysql2 ~]# date
 
Wed Nov 21 06:47:34 CST 2018
 
[root@idc-srn-mysql2 ~]#
 
[root@idc-srn-mysql2 mysql_3306]# free -m
 
              total        used        free      shared  buff/cache   available
 
Mem:          15886         265       15031           8         589       15288
 
Swap:         15999           0       15999
 
[root@idc-srn-mysql2 mysql_3306]#
 
7、目标端根据要求创建从库的文件目录
 
创建预安装目录
 
mkdir -p /mysql_data/mysql/mysql_3306/data
 
mkdir -p /mysql_data/mysql/mysql_3306/logs/
 
mkdir -p /mysql_data/mysql/mysql_3306/tmp
 
chown -R mysql:mysql /mysql_data/mysql
 
chmod 755 /mysql_data/mysql
 
8、目标端根据要求修改主机参数，mysql一定要进行初始化测试mysql运行环境是否有问题，否则备库恢复完成无法启动
 
环境参数调整
 
vi /etc/security/limits.conf
 
mysql soft nproc 2047
 
mysql hard nproc 16384
 
mysql soft nofile 1024
 
mysql hard nofile 65536
 
–取源端主库控制文件做为从库的控制文件，修改/opt/mysql/mysql_3306/my.cnf
 
[mysqld]
 
innodb_buffer_pool_size = 4G
 
innodb_buffer_pool_instances = 2
 
server_id = 5630
 
–注意mysql用户退出xshell连接重新登陆，否则启动数据库报错：
 
[root@idc-srn-mysql2 data]# more error.log
 
2018-11-20T23:23:07.455526Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5106)
 
2018-11-20T23:23:07.455624Z 0 [Warning] Changed limits: max_connections: 214 (requested 1000)
 
2018-11-20T23:23:07.455629Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 2048)
 
2018-11-21T07:23:07.630418+08:00 0 [ERROR] Can't find error-message file '/mysql_data/mysql/local/mysql/share/errmsg.sys'. Check error-message file loc
 
ation and 'lc-messages-dir' configuration directive.
 
2018-11-21T07:23:07.634855+08:00 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See ht
 
tp://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
 
2018-11-21T07:23:07.634894+08:00 0 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. Se
 
e http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
 
2018-11-21T07:23:08.002148+08:00 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: ./ibdata1, Space ID:0, Flags: 0. Please refer to htt
 
p://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
 
2018-11-21T07:23:08.002337+08:00 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the d
 
oublewrite buffer.
 
2018-11-21T07:23:08.002418+08:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
 
2018-11-21T07:23:08.603233+08:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
 
2018-11-21T07:23:08.603303+08:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
 
2018-11-21T07:23:08.603322+08:00 0 [ERROR] Failed to initialize plugins.
 
2018-11-21T07:23:08.603336+08:00 0 [ERROR] Aborting
 
9、确认备机从库能正常启动
 
[mysql@idc-srn-mysql2 mysql_3306]$ ps -ef|grep mysql
 
root     17084 15422  0 09:22 pts/0    00:00:00 su – mysql
 
mysql    17085 17084  0 09:22 pts/0    00:00:00 -bash
 
mysql    17273 17085  0 09:35 pts/0    00:00:01 mysqld –defaults-file=/opt/mysql/mysql_3306/my.cnf –user=mysql
 
mysql    17388 17085  0 09:44 pts/0    00:00:00 ps -ef
 
mysql    17389 17085  0 09:44 pts/0    00:00:00 grep –color=auto mysql
 
[mysql@idc-srn-mysql2 mysql_3306]$
 
[mysql@idc-srn-mysql2 mysql_3306]$ mysql -uroot -p  -S /mysql_data/mysql/mysql_3306/mysql.sock
 
Enter password:
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
 
Your MySQL connection id is 3
 
Server version: 5.7.18-log Source distribution
 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
 
affiliates. Other names may be trademarks of their respective
 
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
[root@localhost@mysql.sock][(none)][09:56:49]>
 
[root@localhost@mysql.sock][(none)][09:56:49]>
 
[root@localhost@mysql.sock][(none)][09:56:49]>
 
[root@localhost@mysql.sock][(none)][09:57:20]> show databases;
 
+——————–+
 
| Database           |
 
+——————–+
 
| information_schema |
 
| mysql              |
 
| performance_schema |
 
| sys                |
 
+——————–+
 
4 rows in set (0.00 sec)
 
[root@localhost@mysql.sock][(none)][09:57:28]>
 
10、源端主库备份的过程
 
[mysql@mysql1 backup]$ innobackupex –user=root –password=mysql1234 –socket=/opt/mysql/mysql_3306/mysql.sock –compres   /opt/backup
 
181121 19:04:19 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!".
 
181121 19:04:19  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/opt/mysql/mysql_3306/mysql.sock' as 'root'  (using password: YES).
 
181121 19:04:19  version_check Connected to MySQL server
 
181121 19:04:19  version_check Executing a version check against the server…
 
181121 19:04:19  version_check Done.
 
181121 19:04:19 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /opt/mysql/mysql_3306/mysql.sock
 
Using server version 5.7.18-log
 
innobackupex version 2.4.2 based on MySQL server 5.7.11 Linux (x86_64) (revision id: 8e86a84)
 
xtrabackup: uses posix_fadvise().
 
xtrabackup: cd to /opt/mysql/mysql_3306/data/
 
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 = 8589934592
 
InnoDB: Number of pools: 1
 
181121 19:04:19 >> log scanned up to (184399824350)
 
InnoDB: Opened 3 undo tablespaces
 
InnoDB: 0 undo tablespaces made active
 
xtrabackup: Generating a list of tablespaces
 
InnoDB: Allocated tablespace ID 233 for cns/checksums, old maximum was 3
 
181121 19:04:20 [01] Copying ./ibdata1 to /opt/backup/2018-11-21_19-04-19/ibdata1
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./undo001 to /opt/backup/2018-11-21_19-04-19/undo001
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./undo002 to /opt/backup/2018-11-21_19-04-19/undo002
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./undo003 to /opt/backup/2018-11-21_19-04-19/undo003
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./cns/checksums.ibd to /opt/backup/2018-11-21_19-04-19/cns/checksums.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./cho/cho.ibd to /opt/backup/2018-11-21_19-04-19/cho/cho.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/time_zone.ibd to /opt/backup/2018-11-21_19-04-19/mysql/time_zone.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/slave_master_info.ibd to /opt/backup/2018-11-21_19-04-19/mysql/slave_master_info.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/gtid_executed.ibd to /opt/backup/2018-11-21_19-04-19/mysql/gtid_executed.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/time_zone_name.ibd to /opt/backup/2018-11-21_19-04-19/mysql/time_zone_name.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/servers.ibd to /opt/backup/2018-11-21_19-04-19/mysql/servers.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/innodb_index_stats.ibd to /opt/backup/2018-11-21_19-04-19/mysql/innodb_index_stats.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/server_cost.ibd to /opt/backup/2018-11-21_19-04-19/mysql/server_cost.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/time_zone_transition.ibd to /opt/backup/2018-11-21_19-04-19/mysql/time_zone_transition.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/engine_cost.ibd to /opt/backup/2018-11-21_19-04-19/mysql/engine_cost.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/help_topic.ibd to /opt/backup/2018-11-21_19-04-19/mysql/help_topic.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/innodb_table_stats.ibd to /opt/backup/2018-11-21_19-04-19/mysql/innodb_table_stats.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/time_zone_leap_second.ibd to /opt/backup/2018-11-21_19-04-19/mysql/time_zone_leap_second.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/slave_relay_log_info.ibd to /opt/backup/2018-11-21_19-04-19/mysql/slave_relay_log_info.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/time_zone_transition_type.ibd to /opt/backup/2018-11-21_19-04-19/mysql/time_zone_transition_type.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/plugin.ibd to /opt/backup/2018-11-21_19-04-19/mysql/plugin.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/help_category.ibd to /opt/backup/2018-11-21_19-04-19/mysql/help_category.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/help_keyword.ibd to /opt/backup/2018-11-21_19-04-19/mysql/help_keyword.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/slave_worker_info.ibd to /opt/backup/2018-11-21_19-04-19/mysql/slave_worker_info.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./mysql/help_relation.ibd to /opt/backup/2018-11-21_19-04-19/mysql/help_relation.ibd
 
181121 19:04:20 [01]        …done
 
181121 19:04:20 [01] Copying ./srn/t_srn_depart.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_depart.ibd
 
181121 19:04:20 >> log scanned up to (184399824350)
 
181121 19:04:21 >> log scanned up to (184399824350)
 
181121 19:04:22 >> log scanned up to (184399824350)
 
181121 19:04:23 [01]        …done
 
181121 19:04:23 [01] Copying ./srn/t_srn_receive_flag.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_receive_flag.ibd
 
181121 19:04:23 >> log scanned up to (184399837283)
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_error_send_bos_trace#P#p201711.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_error_send_bos_trace#P#p201711.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_omscn_receive#P#p201712.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_omscn_receive#P#p201712.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_store_check.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_store_check.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_error_send_bos_trace#P#p201810.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_error_send_bos_trace#P#p201810.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_error_send_bos_trace#P#p201708.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_error_send_bos_trace#P#p201708.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_omscn_receive#P#p201708.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_omscn_receive#P#p201708.ibd
 
181121 19:04:24 [01]        …done
 
181121 19:04:24 [01] Copying ./srn/t_srn_error_send_bos_trace#P#p201803.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_error_send_bos_trace#P#p201803.ibd
 
181121 19:04:24 >> log scanned up to (184399839648)
 
181121 19:04:25 >> log scanned up to (184399839648)
 
181121 19:04:26 >> log scanned up to (184399839724)
 
181121 19:04:27 >> log scanned up to (184399839733)
 
181121 19:04:28 >> log scanned up to (184399839733)
 
181121 19:04:29 >> log scanned up to (184399839733)
 
181121 19:04:30 [01]        …done
 
181121 19:04:30 [01] Copying ./srn/t_srn_dispatch.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_dispatch.ibd
 
181121 19:04:30 >> log scanned up to (184399839733)
 
181121 19:04:31 >> log scanned up to (184399839733)
 
181121 19:04:32 >> log scanned up to (184399839733)
 
181121 19:04:33 >> log scanned up to (184399839733)
 
181121 19:04:34 >> log scanned up to (184399839733)
 
181121 19:04:35 >> log scanned up to (184399839733)
 
181121 19:04:36 >> log scanned up to (184399839733)
 
181121 19:04:37 >> log scanned up to (184399844757)
 
181121 19:04:38 >> log scanned up to (184399846061)
 
181121 19:04:39 >> log scanned up to (184399847603)
 
181121 19:04:40 >> log scanned up to (184399847621)
 
181121 19:04:41 >> log scanned up to (184399847621)
 
181121 19:04:42 >> log scanned up to (184399847755)
 
181121 19:04:43 >> log scanned up to (184399847764)
 
181121 19:04:44 >> log scanned up to (184399847764)
 
181121 19:04:45 >> log scanned up to (184399847764)
 
181121 19:04:46 >> log scanned up to (184399847764)
 
181121 19:04:47 >> log scanned up to (184399847764)
 
181121 19:04:48 >> log scanned up to (184399856809)
 
181121 19:04:49 >> log scanned up to (184399856827)
 
181121 19:04:50 >> log scanned up to (184399857143)
 
181121 19:04:51 >> log scanned up to (184399858478)
 
181121 19:04:52 >> log scanned up to (184399858496)
 
181121 19:04:53 >> log scanned up to (184399858634)
 
181121 19:04:54 >> log scanned up to (184399858759)
 
181121 19:04:55 >> log scanned up to (184399858768)
 
181121 19:04:56 >> log scanned up to (184399871109)
 
181121 19:04:57 >> log scanned up to (184399871127)
 
181121 19:04:58 >> log scanned up to (184399871127)
 
181121 19:04:59 >> log scanned up to (184399871165)
 
181121 19:05:00 >> log scanned up to (184399871174)
 
181121 19:05:01 >> log scanned up to (184399871506)
 
181121 19:05:02 >> log scanned up to (184399871524)
 
181121 19:05:03 >> log scanned up to (184399871524)
 
181121 19:05:04 >> log scanned up to (184399871566)
 
181121 19:05:05 >> log scanned up to (184399871575)
 
181121 19:05:06 >> log scanned up to (184399876042)
 
181121 19:05:07 >> log scanned up to (184399876381)
 
181121 19:05:08 >> log scanned up to (184399876399)
 
181121 19:05:09 >> log scanned up to (184399876399)
 
181121 19:05:10 >> log scanned up to (184399876473)
 
181121 19:05:11 >> log scanned up to (184399876482)
 
181121 19:05:12 >> log scanned up to (184399876482)
 
181121 19:05:13 >> log scanned up to (184399876482)
 
181121 19:05:14 >> log scanned up to (184399876482)
 
181121 19:05:15 >> log scanned up to (184399876482)
 
181121 19:05:16 >> log scanned up to (184399877408)
 
181121 19:05:17 >> log scanned up to (184399877426)
 
181121 19:05:18 >> log scanned up to (184399878708)
 
181121 19:05:19 >> log scanned up to (184399878726)
 
181121 19:05:20 >> log scanned up to (184399878860)
 
181121 19:05:21 >> log scanned up to (184399878932)
 
181121 19:05:22 >> log scanned up to (184399878941)
 
181121 19:05:23 >> log scanned up to (184399878941)
 
181121 19:05:24 >> log scanned up to (184399878941)
 
181121 19:05:25 >> log scanned up to (184399878941)
 
181121 19:05:26 >> log scanned up to (184399878941)
 
181121 19:05:27 >> log scanned up to (184399878941)
 
181121 19:05:28 >> log scanned up to (184399878941)
 
181121 19:05:29 >> log scanned up to (184399878941)
 
181121 19:05:30 >> log scanned up to (184399878941)
 
181121 19:05:31 >> log scanned up to (184399879876)
 
181121 19:05:32 >> log scanned up to (184399880213)
 
181121 19:05:33 >> log scanned up to (184399881078)
 
181121 19:05:34 >> log scanned up to (184399881095)
 
181121 19:05:35 >> log scanned up to (184399881167)
 
181121 19:05:36 >> log scanned up to (184399881498)
 
181121 19:05:37 >> log scanned up to (184399881570)
 
181121 19:05:38 >> log scanned up to (184399881612)
 
181121 19:05:39 >> log scanned up to (184399881621)
 
181121 19:05:40 >> log scanned up to (184399881621)
 
181121 19:05:41 >> log scanned up to (184399881621)
 
181121 19:05:42 >> log scanned up to (184399881621)
 
181121 19:05:43 >> log scanned up to (184399881621)
 
181121 19:05:44 >> log scanned up to (184399881621)
 
181121 19:05:45 >> log scanned up to (184399881621)
 
181121 19:05:46 >> log scanned up to (184399881621)
 
181121 19:05:47 >> log scanned up to (184399881621)
 
181121 19:05:48 >> log scanned up to (184399881621)
 
181121 19:05:49 >> log scanned up to (184399881621)
 
181121 19:05:50 >> log scanned up to (184399881621)
 
181121 19:05:51 >> log scanned up to (184399881621)
 
181121 19:05:52 >> log scanned up to (184399881621)
 
181121 19:05:53 >> log scanned up to (184399881621)
 
181121 19:05:54 >> log scanned up to (184399881621)
 
181121 19:05:55 >> log scanned up to (184399881621)
 
181121 19:05:56 >> log scanned up to (184399881621)
 
181121 19:05:57 >> log scanned up to (184399881621)
 
181121 19:05:58 >> log scanned up to (184399881621)
 
181121 19:05:59 >> log scanned up to (184399881621)
 
181121 19:06:00 >> log scanned up to (184399881621)
 
181121 19:06:01 >> log scanned up to (184399881621)
 
181121 19:06:02 >> log scanned up to (184399882898)
 
181121 19:06:03 >> log scanned up to (184399882915)
 
181121 19:06:04 >> log scanned up to (184399882915)
 
181121 19:06:05 >> log scanned up to (184399882987)
 
181121 19:06:06 >> log scanned up to (184399882996)
 
181121 19:06:07 >> log scanned up to (184399882996)
 
181121 19:06:08 [01]        …done
 
181121 19:06:08 [01] Copying ./srn/t_srn_omscn_receive#P#p201801.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_omscn_receive#P#p201801.ibd
 
181121 19:06:08 [01]        …done
 
181121 19:06:08 [01] Copying ./srn/t_srn_dispatch_flag.ibd to /opt/backup/2018-11-21_19-04-19/srn/t_srn_dispatch_flag.ibd