MySQL Xtrabackup搭建主从复制办法是什么
发布时间：2021-12-22 02:45:55 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要讲解了MySQL Xtrabackup搭建主从复制方法是什么，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习MySQL Xtrabackup搭建主从复制方法是什么吧！ 1、源端查看主库环境 [root@mysql1 ~]# uname -a Lin
|
副标题[/!--empirenews.page--]
这篇文章主要讲解了“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 （编辑：辽源站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |