{"id":1222,"date":"2011-06-30T18:44:49","date_gmt":"2011-06-30T15:44:49","guid":{"rendered":"http:\/\/avz.org.ua\/wp\/?p=1222"},"modified":"2016-07-15T12:15:33","modified_gmt":"2016-07-15T09:15:33","slug":"percona-xtrabackup","status":"publish","type":"post","link":"https:\/\/avz.org.ua\/wp\/2011\/06\/30\/percona-xtrabackup\/","title":{"rendered":"\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0435\u043a\u0430\u043f\u0430 mysql-\u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e Percona xtrabackup"},"content":{"rendered":"<p><div id=\"attachment_1350\" style=\"width: 210px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/mysql-logo-200px.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1350\" src=\"https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/mysql-logo-200px.jpg\" alt=\"\u043b\u043e\u0433\u043e\u0442\u0438\u043f mysql\" title=\"mysql-logo-200px\" width=\"200\" height=\"146\" class=\"size-full wp-image-1350\" \/><\/a><p id=\"caption-attachment-1350\" class=\"wp-caption-text\">\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0435\u043a\u0430\u043f\u0430 mysql-\u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/p><\/div>\u0414\u043b\u044f \u043e\u0447\u0435\u043d\u044c \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0441\u0440\u0435\u0434\u0441\u0442\u0432 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0431\u0435\u043a\u0430\u043f\u043e\u0432, \u0442\u0430\u043a\u0438\u0445 \u043a\u0430\u043a mysqldump, \u0441\u043e\u043f\u0440\u044f\u0436\u0435\u043d\u043e \u0441 \u0440\u044f\u0434\u043e\u043c \u0442\u0440\u0443\u0434\u043d\u043e\u0441\u0442\u0435\u0439:<\/p>\n<p>1. \u041f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043b\u043e\u0447\u0430\u0442\u0441\u044f \u043d\u0430 \u0437\u0430\u043f\u0438\u0441\u044c --- \u043d\u0430 \u0432\u0440\u0435\u043c\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u043d\u0435\u043b\u044c\u0437\u044f \u043f\u0438\u0441\u0430\u0442\u044c \u0432 \u0431\u0430\u0437\u0443. \u0414\u043b\u044f mission-critical \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u044d\u0442\u043e \u043d\u0435\u043f\u0440\u0438\u0435\u043c\u043b\u0438\u043c\u043e. \u041e\u0434\u043d\u0430\u043a\u043e, \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 InnoDB \u044d\u0442\u043e \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u043c\u043e\u0436\u043d\u043e \u043e\u0431\u043e\u0439\u0442\u0438 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043a\u043b\u044e\u0447\u0430 mysqldump <strong>--single-transaction<\/strong>.<\/p>\n<p>2. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0434\u0430\u043c\u043f\u0430 \u0438 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438\u0437 \u043d\u0435\u0433\u043e \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 \u043e\u0447\u0435\u043d\u044c \u043c\u043d\u043e\u0433\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0438. \u0422\u0430\u043a, \u0434\u043b\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u0431\u0430\u0437, \u0441 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043c\u043d\u0435 \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u043b\u043e\u0441\u044c \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0442\u044c\u0441\u044f, \u0434\u0430\u043c\u043f \u0440\u0430\u0437\u043c\u0435\u0440\u043e\u043c 50\u0413\u0411 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u043b\u0441\u044f 5 \u0447\u0430\u0441\u043e\u0432 (\u0438 \u044d\u0442\u043e \u043d\u0430 \u0441\u043e\u0432\u0441\u0435\u043c \u043d\u0435 \u0441\u043b\u0430\u0431\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 - 256\u0413\u0411 RAM, \u0447\u0435\u0442\u044b\u0440\u0435 6-\u0442\u0438-\u044f\u0434\u0435\u0440\u043d\u044b\u0445 CPU Xeon E7540 2.0GHz c HT). \u0412\u043b\u0438\u0432\u0430\u043d\u0438\u0435 \u044d\u0442\u043e\u0433\u043e \u0434\u0430\u043c\u043f\u0430 \u043d\u0430\u0437\u0430\u0434 \u0432 \u0431\u0430\u0437\u0443 \u0437\u0430\u043d\u044f\u043b\u043e \u0431\u044b \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0441\u0442\u043e\u043b\u044c\u043a\u043e \u0436\u0435 \u0432\u0440\u0435\u043c\u0435\u043d\u0438.<\/p>\n<p>Percona xtrabackup \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0431\u0443\u043a\u0432\u0430\u043b\u044c\u043d\u043e \u0434\u0432\u0443\u043c\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u043c\u0438 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0440\u0430\u0431\u043e\u0447\u0443\u044e \u043a\u043e\u043f\u0438\u044e \u0431\u0430\u0437\u044b \u0431\u0435\u0437 \u043a\u0430\u043a\u043e\u0433\u043e-\u043b\u0438\u0431\u043e \u043f\u0440\u0435\u0440\u044b\u0432\u0430\u043d\u0438\u044f \u0440\u0430\u0431\u043e\u0442\u044b MySQL-\u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u043f\u0440\u0438\u0447\u0451\u043c \u043d\u0430\u043c\u043d\u043e\u0433\u043e \u0431\u044b\u0441\u0442\u0440\u0435\u0435, \u0447\u0435\u043c mysqldump. \u041f\u0440\u0438\u043c\u0435\u0440:<\/p>\n<pre lang=\"bash\">\r\n# rpm -ivh xtrabackup-1.6-245.rhel5.x86_64.rpm\r\n[admin@master] $ innobackupex \/backups\r\n\r\nInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy\r\nand Percona Inc 2009-2011.  All Rights Reserved.\r\n\r\nThis software is published under\r\nthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.\r\n\r\n110623 11:59:51  innobackupex: Starting mysql with options:  --unbuffered --\r\n110623 11:59:51  innobackupex: Connected to database with mysql child process (pid=3685)\r\n110623 11:59:57  innobackupex: Connection to database server closed\r\nIMPORTANT: Please check that the backup run completes successfully.\r\n           At the end of a successful backup run innobackupex\r\n           prints \"completed OK!\".\r\n\r\ninnobackupex: Using mysql  Ver 14.14 Distrib 5.5.13, for Linux (x86_64) using readline 5.1\r\ninnobackupex: Using mysql server version Copyright (c) 2000, 2010, Oracle and\/or its affiliates. All rights reserved.\r\n\r\ninnobackupex: Created backup directory \/backups\/2011-06-23_11-59-57\r\n110623 11:59:57  innobackupex: Starting mysql with options:  --unbuffered --\r\n110623 11:59:57  innobackupex: Connected to database with mysql child process (pid=3712)\r\n110623 12:00:01  innobackupex: Connection to database server closed\r\n\r\n110623 12:00:01  innobackupex: Starting ibbackup with command: xtrabackup_55 --backup --suspend-at-end --target-dir=\/backups\/2011-06-23_11-59-57\r\ninnobackupex: Waiting for ibbackup (pid=3724) to suspend\r\ninnobackupex: Suspend file '\/backups\/2011-06-23_11-59-57\/xtrabackup_suspended'\r\n\r\nxtrabackup_55  Ver 1.6 Rev 245 for 5.5.9 Linux (x86_64)\r\nxtrabackup: uses posix_fadvise().\r\nxtrabackup: cd to \/var\/lib\/mysql\r\nxtrabackup: Target instance is assumed as followings.\r\nxtrabackup:   innodb_data_home_dir = .\/\r\nxtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend\r\nxtrabackup:   innodb_log_group_home_dir = .\/\r\nxtrabackup:   innodb_log_files_in_group = 2\r\nxtrabackup:   innodb_log_file_size = 5242880\r\n110623 12:00:01 InnoDB: Using Linux native AIO\r\n>> log scanned up to (15576575786)\r\n[01] Copying .\/ibdata1\r\n     to \/backups\/2011-06-23_11-59-57\/ibdata1\r\n>> log scanned up to (15576821168)\r\n>> log scanned up to (15576993781)\r\n>> log scanned up to (15577223204)\r\n>> log scanned up to (15577401335)\r\n>> log scanned up to (15577646737)\r\n>> log scanned up to (15577864382)\r\n>> log scanned up to (15578032411)\r\n>> log scanned up to (15578302721)\r\n>> log scanned up to (15578496370)\r\n>> log scanned up to (15578695368)\r\n>> log scanned up to (15578966232)\r\n>> log scanned up to (15579121683)\r\n>> log scanned up to (15579340135)\r\n>> log scanned up to (15579572684)\r\n>> log scanned up to (15579801008)\r\n>> log scanned up to (15579918009)\r\n>> log scanned up to (15580129220)\r\n>> log scanned up to (15580377234)\r\n>> log scanned up to (15580543590)\r\n>> log scanned up to (15580811908)\r\n>> log scanned up to (15580992609)\r\n>> log scanned up to (15581162267)\r\n>> log scanned up to (15581314789)\r\n>> log scanned up to (15581469774)\r\n>> log scanned up to (15581662444)\r\n>> log scanned up to (15581858152)\r\n>> log scanned up to (15582046357)\r\n>> log scanned up to (15583450833)\r\n>> log scanned up to (15584545328)\r\n>> log scanned up to (15584847700)\r\n>> log scanned up to (15585508334)\r\n>> log scanned up to (15587171262)\r\n>> log scanned up to (15588573028)\r\n[01]        ...done\r\n\r\n110623 12:03:15  innobackupex: Continuing after ibbackup has suspended\r\n110623 12:03:15  innobackupex: Starting mysql with options:  --unbuffered --\r\n110623 12:03:15  innobackupex: Connected to database with mysql child process (pid=4879)\r\n>> log scanned up to (15591908670)\r\n110623 12:03:19  innobackupex: Starting to lock all tables...\r\n>> log scanned up to (15597590433)\r\n>> log scanned up to (15598452337)\r\n110623 12:03:29  innobackupex: All tables locked and flushed to disk\r\n\r\n110623 12:03:29  innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,\r\ninnobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in\r\ninnobackupex: subdirectories of '\/var\/lib\/mysql'\r\ninnobackupex: Backing up files '\/var\/lib\/mysql\/mysql\/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)\r\ninnobackupex: Backing up files '\/var\/lib\/mysql\/performance_schema\/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)\r\ninnobackupex: Backing up files '\/var\/lib\/mysql\/salesdb\/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (210 files)\r\n>> log scanned up to (15598452487)\r\n>> log scanned up to (15598452783)\r\n110623 12:03:43  innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files\r\n\r\ninnobackupex: Resuming ibbackup\r\n\r\n>> log scanned up to (15598452993)\r\nxtrabackup: The latest check point (for incremental): '15594901984'\r\n>> log scanned up to (15598452993)\r\nxtrabackup: Stopping log copying thread.\r\nxtrabackup: Transaction log of lsn (15574068024) to (15598452993) was copied.\r\n110623 12:03:46  innobackupex: All tables unlocked\r\n110623 12:03:46  innobackupex: Connection to database server closed\r\n\r\ninnobackupex: Backup created in directory '\/backups\/2011-06-23_11-59-57'\r\ninnobackupex: MySQL binlog position: filename 'mysql-bin.000009', position 537035213            mysql\r\n110623 12:03:46  innobackupex: completed OK!\r\n<\/pre>\n<p>\u0414\u0430\u043b\u0435\u0435 \"\u043f\u0440\u0438\u0433\u043e\u0442\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c\" \u0431\u0435\u043a\u0430\u043f \u043f\u0443\u0442\u0435\u043c \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043b\u043e\u0433\u0430 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0430 \u044d\u0442\u043e\u043c \u044d\u0442\u0430\u043f\u0435 \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 \u0444\u0430\u0439\u043b\u0435 xtrabackup_logfile.<\/p>\n<pre lang=\"bash\">\r\n[admin@master] $ innobackupex --apply-log \/backups\/2011-06-23_11-59-57\/\r\n\r\nInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy\r\nand Percona Inc 2009-2011.  All Rights Reserved.\r\n\r\nThis software is published under\r\nthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.\r\n\r\nIMPORTANT: Please check that the apply-log run completes successfully.\r\n           At the end of a successful apply-log run innobackupex\r\n           prints \"completed OK!\".\r\n\r\n110623 12:31:28  innobackupex: Starting ibbackup with command: xtrabackup_55\r\n--prepare --target-dir=\/backups\/2011-06-23_11-59-57\r\n\r\nxtrabackup_55  Ver 1.6 Rev 245 for 5.5.9 Linux (x86_64)\r\nxtrabackup: cd to \/backups\/2011-06-23_11-59-57\r\nxtrabackup: This target seems to be not prepared yet.\r\nxtrabackup: xtrabackup_logfile detected: size=27443200,start_lsn=(15574068024)\r\nxtrabackup: Temporary instance for recovery is set as followings.\r\nxtrabackup:   innodb_data_home_dir = .\/\r\nxtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend\r\nxtrabackup:   innodb_log_group_home_dir = .\/\r\nxtrabackup:   innodb_log_files_in_group = 1\r\nxtrabackup:   innodb_log_file_size = 27443200\r\n110623 12:31:28 InnoDB: Using Linux native AIO\r\nxtrabackup: Starting InnoDB instance for recovery.\r\nxtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter\r\n110623 12:31:28 InnoDB: The InnoDB memory heap is disabled\r\n110623 12:31:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n110623 12:31:28 InnoDB: Compressed tables use zlib 1.2.3\r\n110623 12:31:28 InnoDB: Using Linux native AIO\r\n110623 12:31:28 InnoDB: Warning: innodb_file_io_threads is deprecated. Please\r\nuse innodb_read_io_threads and innodb_write_io_threads instead\r\n110623 12:31:28 InnoDB: Initializing buffer pool, size = 100.0M\r\n110623 12:31:28 InnoDB: Completed initialization of buffer pool\r\n110623 12:31:28 InnoDB: highest supported file format is Barracuda.\r\nInnoDB: Log scan progressed past the checkpoint lsn 15574068024\r\n110623 12:31:28  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Doing recovery: scanned up to log sequence number 15579310592 (21 %)\r\nInnoDB: Doing recovery: scanned up to log sequence number 15584553472 (42 %)\r\nInnoDB: Doing recovery: scanned up to log sequence number 15589796352 (64 %)\r\nInnoDB: Doing recovery: scanned up to log sequence number 15595039232 (85 %)\r\n110623 12:31:29  InnoDB: Starting an apply batch of log records to the\r\ndatabase...\r\nInnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18\r\n19 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\r\n45 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\r\n71 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\r\n97 98 99\r\nInnoDB: Apply batch completed\r\nInnoDB: Doing recovery: scanned up to log sequence number 15598452993 (99 %)\r\n110623 12:31:38  InnoDB: Starting an apply batch of log records to the\r\ndatabase...\r\nInnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18\r\n19 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\r\n45 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\r\n71 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\r\n97 98 99\r\nInnoDB: Apply batch completed\r\nInnoDB: Last MySQL binlog file position 0 537035213, file name .\/mysql-bin.000009\r\n110623 12:31:39  InnoDB: Waiting for the background threads to start\r\n110623 12:31:40 Percona XtraDB (http:\/\/www.percona.com) 1.1.5-20.0 started;\r\nlog sequence number 15598452993\r\n\r\n[notice (again)]\r\n  If you use binary log and don't use any hack of group commit,\r\n  the binary log position seems to be:\r\nInnoDB: Last MySQL binlog file position 0 537035213, file name\r\n.\/mysql-bin.000009\r\n\r\nxtrabackup: starting shutdown with innodb_fast_shutdown = 1\r\n110623 12:31:40  InnoDB: Starting shutdown...\r\n110623 12:31:44  InnoDB: Shutdown completed; log sequence number 15598454344\r\n\r\n110623 12:31:44  innobackupex: Restarting xtrabackup with command:\r\nxtrabackup_55 --prepare --target-dir=\/backups\/2011-06-23_11-59-57\r\nfor creating ib_logfile*\r\n\r\nxtrabackup_55  Ver 1.6 Rev 245 for 5.5.9 Linux (x86_64)\r\nxtrabackup: cd to \/backups\/2011-06-23_11-59-57\r\nxtrabackup: This target seems to be already prepared.\r\nxtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.\r\nxtrabackup: Temporary instance for recovery is set as followings.\r\nxtrabackup:   innodb_data_home_dir = .\/\r\nxtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend\r\nxtrabackup:   innodb_log_group_home_dir = .\/\r\nxtrabackup:   innodb_log_files_in_group = 2\r\nxtrabackup:   innodb_log_file_size = 5242880\r\n110623 12:31:44 InnoDB: Using Linux native AIO\r\nxtrabackup: Starting InnoDB instance for recovery.\r\nxtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory\r\nparameter)\r\n110623 12:31:44 InnoDB: The InnoDB memory heap is disabled\r\n110623 12:31:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins\r\n110623 12:31:44 InnoDB: Compressed tables use zlib 1.2.3\r\n110623 12:31:44 InnoDB: Using Linux native AIO\r\n110623 12:31:44 InnoDB: Warning: innodb_file_io_threads is deprecated. Please\r\nuse innodb_read_io_threads and innodb_write_io_threads instead\r\n110623 12:31:44 InnoDB: Initializing buffer pool, size = 100.0M\r\n110623 12:31:44 InnoDB: Completed initialization of buffer pool\r\n110623 12:31:44  InnoDB: Log file .\/ib_logfile0 did not exist: new to be\r\ncreated\r\nInnoDB: Setting log file .\/ib_logfile0 size to 5 MB\r\nInnoDB: Database physically writes the file full: wait...\r\n110623 12:31:45  InnoDB: Log file .\/ib_logfile1 did not exist: new to be\r\ncreated\r\nInnoDB: Setting log file .\/ib_logfile1 size to 5 MB\r\nInnoDB: Database physically writes the file full: wait...\r\n110623 12:31:46 InnoDB: highest supported file format is Barracuda.\r\nInnoDB: The log sequence number in ibdata files does not match\r\nInnoDB: the log sequence number in the ib_logfiles!\r\n110623 12:31:46  InnoDB: Database was not shut down normally!\r\nInnoDB: Starting crash recovery.\r\nInnoDB: Reading tablespace information from the .ibd files...\r\nInnoDB: Last MySQL binlog file position 0 537035213, file name .\/mysql-bin.000009\r\n110623 12:31:46  InnoDB: Waiting for the background threads to start\r\n110623 12:31:47 Percona XtraDB (http:\/\/www.percona.com) 1.1.5-20.0 started;\r\nlog sequence number 15598454796\r\n\r\n[notice (again)]\r\n  If you use binary log and don't use any hack of group commit,\r\n  the binary log position seems to be:\r\nInnoDB: Last MySQL binlog file position 0 537035213, file name .\/mysql-bin.000009\r\n\r\nxtrabackup: starting shutdown with innodb_fast_shutdown = 1\r\n110623 12:31:47  InnoDB: Starting shutdown...\r\n110623 12:31:52  InnoDB: Shutdown completed; log sequence number 15598455780\r\n110623 12:31:52  innobackupex: completed OK!\r\n<\/pre>\n<p>\u0421\u043a\u0440\u0438\u043f\u0442 \u0434\u043b\u044f \u0441\u0432\u043e\u0435\u0439 \u0440\u0430\u0431\u043e\u0442\u044b \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u043d\u0430\u043b\u0438\u0447\u0438\u044f \u043e\u043f\u0446\u0438\u0438 datadir (\u043e\u0431\u044b\u0447\u043d\u043e \u0435\u0451 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \"\/var\/lib\/mysql\") \u0432 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u043c \u0444\u0430\u0439\u043b\u0435 my.cnf. \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0432 \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438 \/backups\/2011-06-23_11-59-57 \u043f\u043e\u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u043b\u043d\u043e\u0441\u0442\u044c\u044e \u0440\u0430\u0431\u043e\u0447\u0430\u044f \u0431\u0438\u043d\u0430\u0440\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0432\u0441\u0435\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0441 \u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u043e\u0433\u043e \u0442\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u0431\u0435\u043a\u0430\u043f\u0430 \u043d\u0443\u0436\u043d\u043e \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c mysqld, \u0441\u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438 \/backups\/2011-06-23_11-59-57 \u0432 \/var\/lib\/mysql \u0438 \u0432\u043d\u043e\u0432\u044c \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c mysqld. <\/p>\n<div style=\"text-align: center; margin-top: -20px; margin-bottom: 5px\">\n<script type=\"text\/javascript\"><!--\ngoogle_ad_client = \"ca-pub-9566425191373950\";\n\/* afisha_468x60_20110909 *\/\ngoogle_ad_slot = \"4382811110\";\ngoogle_ad_width = 468;\ngoogle_ad_height = 60;\n\/\/-->\n<\/script><br \/>\n<script type=\"text\/javascript\"\nsrc=\"\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\n<\/script>\n<\/div>\n<p>\u041e\u0442 \u043f\u0440\u043e\u0441\u0442\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0433\u043e \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \/var\/lib\/mysql \u0434\u0430\u043d\u043d\u044b\u0439 \u043f\u043e\u0434\u0445\u043e\u0434 \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u0442\u0435\u043c, \u0447\u0442\u043e \u0434\u0430\u043d\u043d\u044b\u0435 \u043a\u043e\u043f\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u043e\u0441\u043e\u0431\u044b\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c, \u0442\u0430\u043a\u0438\u043c \u0436\u0435, \u043a\u0430\u043a \u0441 \u043d\u0438\u043c\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0434\u0432\u0438\u0436\u043e\u043a InnoDB \u0438 \u0432\u043c\u0435\u0441\u0442\u0435 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u043a\u043e\u043f\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u043b\u043e\u0433-\u0444\u0430\u0439\u043b\u044b. \u041d\u0430 2-\u043e\u043c \u044d\u0442\u0430\u043f\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0438 (prepare) xtrabackup \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0439 \u0432 \u043d\u0435\u0433\u043e \u0441\u043b\u0435\u0433\u043a\u0430 \u043c\u043e\u0434\u0438\u0444\u0438\u0446\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 InnoDB-\u0434\u0432\u0438\u0436\u043e\u043a \u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 crash-recovery, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0438\u0437 \u043b\u043e\u0433-\u0444\u0430\u0439\u043b\u043e\u0432. \u042d\u0442\u043e\u0442 \u0448\u0430\u0433 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c, \u043f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0435 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f mysql-\u0441\u0435\u0440\u0432\u0435\u0440 \u043f\u0440\u043e\u0434\u043e\u043b\u0436\u0430\u0435\u0442 \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u0431\u0430\u0437\u0443 \u0438 \u0431\u0435\u0437 \u043d\u0435\u0433\u043e \u0431\u044b\u043b\u0430 \u0431\u044b \u043d\u0430\u0440\u0443\u0448\u0435\u043d\u0430 \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n<p>\u041f\u0440\u0438\u043c\u0435\u0440 \u0438\u0437 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0438: \u0431\u0430\u0437\u0430 \u0440\u0430\u0437\u043c\u0435\u0440\u043e\u043c 80\u0413\u0411 (du -sh \/var\/lib\/mysql) \u043f\u0435\u0440\u0432\u043e\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043b\u0430\u0441\u044c 36 \u043c\u0438\u043d\u0443\u0442, \u0432\u0442\u043e\u0440\u0430\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u043e\u0442\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u043b\u0430 (\u0442\u0430\u043c \u0433\u0434\u0435 <strong>--apply-log<\/strong>) 39 \u043c\u0438\u043d\u0443\u0442. \u041f\u043e \u0441\u0435\u0442\u0438 \u0444\u0430\u0439\u043b\u044b \u043f\u0435\u0440\u0435\u043b\u0438\u0432\u0430\u043b\u0438\u0441\u044c \u0441 master-\u0430 \u043d\u0430 slave 43 \u043c\u0438\u043d\u0443\u0442\u044b. \u0418\u0442\u043e\u0433\u043e \u043d\u0430 \u043f\u043e\u0434\u043d\u044f\u0442\u0438\u0435 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0443\u0448\u043b\u043e 118 \u043c\u0438\u043d\u0443\u0442 (2 \u0447\u0430\u0441\u0430). \u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e, \u0432 \u0440\u0430\u0437\u044b \u0431\u044b\u0441\u0442\u0440\u0435\u0435, \u0447\u0435\u043c \u0431\u044b\u043b\u043e \u0431\u044b \u0441 mysqldump-\u043e\u043c \u0438 \u0431\u0435\u0437 \u043a\u0430\u043a\u043e\u0433\u043e-\u043b\u0438\u0431\u043e downtime.<\/p>\n<p>\u0412\u043e\u0442 \u0431\u043e\u043b\u0435\u0435 \u0443\u0434\u043e\u0431\u043d\u044b\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f, \u0443\u043a\u043e\u0440\u044f\u044e\u0449\u0438\u0439 \u043f\u0435\u0440\u0435\u043d\u043e\u0441 \u0431\u0430\u0437\u044b c master-\u0430 (\u0441 IP-\u0430\u0434\u0440\u0435\u0441\u043e\u043c 10.11.12.12) \u043d\u0430 \u043d\u043e\u0432\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0435\u0442 slave-\u043e\u043c (\u0441 IP-\u0430\u0434\u0440\u0435\u0441\u043e\u043c 10.11.12.13). \u041f\u0430\u043a\u0435\u0442 xtrabackup \u0434\u043e\u043b\u0436\u0435\u043d \u0431\u044b\u0442\u044c \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d \u043d\u0430 \u043e\u0431\u043e\u0438\u0445 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445.<\/p>\n<pre lang=\"bash\" class=\"1\">\r\n[avz@slave] mkdir \/tmp\/db\r\n[avz@master] innobackupex --defaults-file=\/etc\/my2.cnf --socket=\/var\/lib\/mysql2\/mysql.sock --remote-host=avz@10.11.12.13 --tmpdir=\/tmp \/tmp\/db \r\n[avz@slave] innobackupex --defaults-file=\/etc\/my2.cnf --apply-log --ibbackup=xtrabackup_55 \/tmp\/db\/2011-06-23_12-52-23\r\n[root@slave] service mysqld stop ; mv \/var\/lib\/mysql \/var\/lib\/mysql.old\r\n[root@slave] mv \/tmp\/db\/2011-06-23_12-52-23 \/var\/lib\/mysql\r\n[root@slave] chown -R mysql.mysql \/var\/lib\/mysql\r\n[root@slave] service mysqld start\r\n<\/pre>\n<pre lang=\"sql\" class=\"8\">\r\nmaster> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'10.11.12.13' IDENTIFIED BY 'SomePassw';\r\nslave> CHANGE MASTER TO MASTER_HOST='10.11.12.12', MASTER_PORT=3307, MASTER_USER='repl', MASTER_PASSWORD='SomePassw', MASTER_LOG_FILE='master-bin.001269', MASTER_LOG_POS=517948556;\r\nslave> START SLAVE;\r\n<\/pre>\n<p>\u041a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432\u043e \u0432\u0442\u043e\u0440\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0435 \u043a\u043e\u043f\u0438\u0440\u0443\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438 InnoDB-\u043b\u043e\u0433-\u0444\u0430\u0439\u043b\u044b \u0441\u0440\u0430\u0437\u0443 \u043d\u0430 \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u044b\u0439 slave-\u0441\u0435\u0440\u0432\u0435\u0440 \u0441 \u0430\u0434\u0440\u0435\u0441\u043e\u043c 10.11.12.13 \u0432 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \/tmp\/db \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e scp. \u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b <strong>--defaults-file<\/strong> \u0438 <strong>--socket<\/strong> \u043d\u0443\u0436\u043d\u044b \u0432 \u0442\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u043d\u0430 master-\u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u043e\u0432 mysqld &ndash; \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u044d\u0442\u0438\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u044f\u0432\u043d\u043e \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u043a\u0430\u043a\u043e\u0439 \u043a\u043e\u043d\u0444\u0438\u0433-\u0444\u0430\u0439\u043b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0438 \u043a \u043a\u0430\u043a\u043e\u043c\u0443 \u0438\u043c\u0435\u043d\u043d\u043e \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u0443 \u043d\u0443\u0436\u043d\u043e \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0442\u044c\u0441\u044f. \u041e\u0447\u0435\u043d\u044c \u0436\u0435\u043b\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u0442\u044c SSH-\u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u044e \u043d\u0430 \u043a\u043b\u044e\u0447\u0430\u0445, \u0447\u0442\u043e\u0431\u044b \u043c\u043e\u0436\u043d\u043e \u0431\u044b\u043b\u043e \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0442\u044c\u0441\u044f \u0441 master-\u0430 \u043d\u0430 slave \u0431\u0435\u0437 \u0432\u0432\u043e\u0434\u0430 \u043f\u0430\u0440\u043e\u043b\u044f. \u041d\u0430 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u043a\u0430\u0442\u0430\u043b\u043e\u0433 \/tmp\/db \u0434\u043e\u043b\u0436\u0435\u043d \u0431\u044b\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u043d \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u043e. \u041a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432 \u0442\u0440\u0435\u0442\u044c\u0435\u0439 \u0441\u0442\u0440\u043e\u0447\u043a\u0435, \u0437\u0430\u043f\u0443\u0449\u0435\u043d\u043d\u0430\u044f \u0443\u0436\u0435 \u043d\u0430 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0435, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0438\u0437 log-\u0444\u0430\u0439\u043b\u043e\u0432. <\/p>\n<p>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <strong>--ibbackup<\/strong> \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u0432 \u0442\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u043d\u0430 \u043c\u043e\u043c\u0435\u043d\u0442 \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u044d\u0442\u043e\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u044b \u043d\u0430 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0435\u0449\u0435 \u043d\u0435 \u0437\u0430\u043f\u0443\u0449\u0435\u043d mysqld. \u041e\u043d\u0430 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u043a\u0430\u043a\u043e\u0439 \u0438\u043c\u0435\u043d\u043d\u043e \u0431\u0438\u043d\u0430\u0440\u043d\u0438\u043a xtrabackup \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c (\u0432 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u0439 \u043d\u0430 \u0434\u0430\u043d\u043d\u043e\u0439 \u043c\u043e\u043c\u0435\u043d\u0442 \u0432\u0435\u0440\u0441\u0438\u0438 \u0438\u0445 \u0442\u0440\u0438 &ndash; xtrabackup, xtrabackup_51 \u0438 xtrabackup_55). \u0415\u0441\u043b\u0438 \u0436\u0435 mysql-\u0441\u0435\u0440\u0432\u0435\u0440 \u043d\u0430 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0431\u044b\u043b \u0437\u0430\u043f\u0443\u0449\u0435\u043d \u0434\u043e \u0442\u043e\u0433\u043e, \u043a\u0430\u043a \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0438\u0437 \u0441\u0442\u0440\u043e\u043a\u0438 3, \u0442\u043e \u0432\u0435\u0440\u0441\u0438\u044f \u043d\u0443\u0436\u043d\u043e\u0433\u043e \u0431\u0438\u043d\u0430\u0440\u043d\u0438\u043a\u0430 \u043e\u0431\u044b\u0447\u043d\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <strong>--ibbackup<\/strong> \u043d\u0443\u0436\u0434\u044b \u043d\u0435 \u0432\u043e\u0437\u043d\u0438\u043a\u0430\u0435\u0442. \u041f\u043e\u0441\u043b\u0435 \"innobackupex --apply-log ...\" \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u0442\u0430\u044e\u0442 \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c \u0438 \u0433\u043e\u0442\u043e\u0432\u044b \u043a \u0440\u0430\u0431\u043e\u0442\u0435. <\/p>\n<p>\u0416\u0435\u043b\u0430\u0442\u0435\u043b\u044c\u043d\u043e, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u0434 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 innobackupex, \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0431\u0430\u0437\u0435 \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u043b\u043e \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u044f. \u0418\u043d\u0430\u0447\u0435 \u0432\u043e\u0437\u043d\u0438\u043a\u0430\u0435\u0442 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0432 1-\u0443\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u0443 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b <strong>--user<\/strong> \u0438 <strong>--password<\/strong>.<\/p>\n<p>\u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u043b\u044f MASTER_LOG_FILE \u0438 MASTER_LOG_POS \u043d\u0430 9-\u043c \u0448\u0430\u0433\u0435 \u0431\u0435\u0440\u0443\u0442\u0441\u044f \u0438\u0437 \u0432\u044b\u0432\u043e\u0434\u0430 \u043a\u043e\u043c\u0430\u043d\u0434 \u043d\u0430 2-\u043c \u0438\u043b\u0438 3-\u043c \u0448\u0430\u0433\u0435.<\/p>\n<p>\u0415\u0449\u0435 \u043f\u0440\u0438\u043c\u0435\u0440 \u0438\u0437 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0438: \u0441\u0443\u043c\u043c\u0430\u0440\u043d\u044b\u0439 \u0440\u0430\u0437\u043c\u0435\u0440 \u0444\u0430\u0439\u043b\u043e\u0432 \u0431\u0430\u0437\u044b: 255\u0413\u0411 (du -sh \/var\/lib\/mysql), \u0440\u0430\u0437\u043c\u0435\u0440 \u0437\u0430\u0430\u0440\u0445\u0438\u0432\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0433\u043e gzip-\u043e\u043c SQL-\u0434\u0430\u043c\u043f\u0430 &ndash; 33\u0413\u0411. \u041f\u0435\u0440\u0432\u044b\u0439 \u044d\u0442\u0430\u043f (\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0438\u0437 2-\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438) \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0441\u044f 7 \u0447\u0430\u0441\u043e\u0432 10 \u043c\u0438\u043d\u0443\u0442 (\u0441\u044e\u0434\u0430 \u0432\u0445\u043e\u0434\u0438\u0442 \u0438 \u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u043f\u043e \u0441\u0435\u0442\u0438 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e scp, \u043a \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043e\u0431\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u044b \u043d\u0430 \u0441\u043a\u043e\u0440\u043e\u0441\u0442\u0438 1\u0413\u0431\u0438\u0442\/\u0441\u0435\u043a). \u0412\u0442\u043e\u0440\u043e\u0439 \u044d\u0442\u0430\u043f (\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0438\u0437 3-\u0435\u0439 \u0441\u0442\u0440\u043e\u043a\u0438) \u0437\u0430\u043d\u044f\u043b 13 \u043c\u0438\u043d\u0443\u0442. \u041f\u043e\u0441\u043b\u0435 \u0437\u0430\u043f\u0443\u0441\u043a\u0430 mysqld \u043d\u0430 slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0438 \u043a\u043e\u043c\u0430\u043d\u0434 \"CHANGE MASTER TO...\" + \"START SLAVE\" \u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c, \u0447\u0442\u043e slave \u043e\u0442\u0441\u0442\u0430\u0451\u0442 \u043e\u0442 master-\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u043d\u0430 \u043f\u043e\u043b-\u0447\u0430\u0441\u0430. \u042d\u0442\u043e \u043e\u0442\u0441\u0442\u0430\u0432\u0430\u043d\u0438\u0435 slave \u043d\u0430\u0433\u043d\u0430\u043b \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0437\u0430 7 \u043c\u0438\u043d\u0443\u0442. \u0418\u0422\u041e\u0413\u041e: \u0432\u0435\u0441\u044c \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u044f \u0440\u0435\u043f\u043b\u0438\u043a\u0438 \u0441\u043e \u0441\u0442\u0430\u0440\u0442\u0430 \u0434\u043e \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f \u0440\u0430\u0431\u043e\u0447\u0435\u0433\u043e slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0441 \u0438\u0434\u0435\u043d\u0442\u0438\u0447\u043d\u044b\u043c\u0438 master-\u0443 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0437\u0430\u043d\u044f\u043b 7 \u0447\u0430\u0441\u043e\u0432 30 \u043c\u0438\u043d\u0443\u0442. \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u0432 \u044d\u0442\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435: 4 x Intel Xeon E7540 @2.00GHz (\u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u0440 6-\u0442\u0438 \u044f\u0434\u0435\u0440\u043d\u044b\u0439, \u0432 \/proc\/cpuinfo \u0432\u0438\u0434\u043d\u043e 48 \u044f\u0434\u0435\u0440), RAM 256\u0413\u0411, \u0434\u0438\u0441\u043a\u0438 4x500\u0413\u0411 SSD \u0432 RAID-10.<\/p>\n<p><strong>UPDATE \u043e\u0442 04.09.2013.<\/strong><\/p>\n<p>\u0412 \u0432\u0435\u0440\u0441\u0438\u0438 2.1.4 \u0443\u0436\u0435 \u0432\u0441\u0451 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043f\u043e\u043c\u0435\u043d\u044f\u043b\u043e\u0441\u044c (\u043c\u043e\u0436\u0435\u0442 \u0438 \u0440\u0430\u043d\u044c\u0448\u0435, \u044d\u0442\u043e \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u0435\u0440\u0432\u0430\u044f \u0438\u0437 2-\u0439 \u0432\u0435\u0442\u043a\u0438, \u0441 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u044f \u0438\u043c\u0435\u043b \u0434\u0435\u043b\u043e). \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u0441\u0440\u0430\u0437\u0443 \u043d\u0430 \u0434\u0440\u0443\u0433\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435 \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0442\u0430\u043a:<\/p>\n<pre lang=\"bash\" class=\"1\">\r\n[avz@slave] mkdir \/tmp\/db\r\n[avz@master] innobackupex --defaults-file=\/etc\/my2.cnf --socket=\/var\/lib\/mysql2\/mysql.sock --tmpdir=\/tmp \/tmp\/db --compress --stream=xbstream .\/ | ssh avz@slave \"cd \/tmp\/db; xbstream -x\"\r\n[avz@slave] for bf in `find \/tmp\/db -iname \"*\\.qp\"`; do echo \"processing $bf\" ; qpress -d $bf $(dirname $bf) && rm -f $bf; done\r\n[avz@slave] xtrabackup --prepare --target-dir=\/tmp\/db\r\n[avz@slave] innobackupex --defaults-file=\/etc\/my2.cnf --apply-log \/tmp\/db\r\n[root@slave] # service mysqld stop ; mv \/var\/lib\/mysql \/var\/lib\/mysql.old\r\n[root@slave] # mv \/tmp\/db\/* \/var\/lib\/mysql\r\n[root@slave] # chown -R mysql.mysql \/var\/lib\/mysql\r\n[root@slave] # service mysqld start\r\n<\/pre>\n<p><div id=\"attachment_1517\" style=\"width: 550px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/avz.org.ua\/wp\/2011\/06\/30\/percona-xtrabackup\/xtrabackup-stage-1-network-trafic\/\" rel=\"attachment wp-att-1517\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1517\" src=\"https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/xtrabackup-stage-1-network-trafic-540x221.png\" alt=\"\u0421\u0435\u0442\u0435\u0432\u043e\u0439 \u0442\u0440\u0430\u0444\u0438\u043a - \u044d\u0442\u0430\u043f 1 (\u0433\u0438\u0433\u0430\u0431\u0438\u0442\u043d\u044b\u0439 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441)\" width=\"540\" height=\"221\" class=\"size-large wp-image-1517\" srcset=\"https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/xtrabackup-stage-1-network-trafic-540x221.png 540w, https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/xtrabackup-stage-1-network-trafic-200x82.png 200w, https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/xtrabackup-stage-1-network-trafic-300x123.png 300w, https:\/\/avz.org.ua\/wp\/wp-content\/uploads\/2011\/06\/xtrabackup-stage-1-network-trafic.png 600w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/a><p id=\"caption-attachment-1517\" class=\"wp-caption-text\">\u0421\u0435\u0442\u0435\u0432\u043e\u0439 \u0442\u0440\u0430\u0444\u0438\u043a - \u044d\u0442\u0430\u043f 1 (\u0433\u0438\u0433\u0430\u0431\u0438\u0442\u043d\u044b\u0439 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441)<\/p><\/div><br \/>\n\u0414\u043b\u044f \u0431\u0430\u0437\u044b \u0440\u0430\u0437\u043c\u0435\u0440\u043e\u043c 135\u0413\u0411 (du -sh \/var\/lib\/mysql) \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b \u0431\u044b\u043b\u0430 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439:<\/p>\n<ul>\n<li>\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 2 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0430\u0441\u044c 67 \u043c\u0438\u043d\u0443\u0442;<\/li>\n<li>\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 3 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0430\u0441\u044c 11 \u043c\u0438\u043d\u0443\u0442 12 \u0441\u0435\u043a\u0443\u043d\u0434;<\/li>\n<li>\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 4 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0430\u0441\u044c 1 \u043c\u0438\u043d\u0443\u0442\u0443 10 \u0441\u0435\u043a\u0443\u043d\u0434;<\/li>\n<li>\u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 5 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0430\u0441\u044c 5 \u0441\u0435\u043a\u0443\u043d\u0434;<\/li>\n<\/ul>\n<p>\u0422\u0430\u043a\u0436\u0435 \u0432\u0430\u0436\u043d\u043e \u043e\u0442\u043c\u0435\u0442\u0438\u0442\u044c, \u0447\u0442\u043e \u0441\u0436\u0430\u0442\u0438\u0435 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043e\u043f\u0446\u0438\u0438 <strong>--compress<\/strong> \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442 \u043a \u0443\u043c\u0435\u043d\u044c\u0448\u0435\u043d\u0438\u044e \u0440\u0430\u0437\u043c\u0435\u0440\u0430 ibd-\u0444\u0430\u0439\u043b\u043e\u0432 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0432 2 \u0440\u0430\u0437\u0430.<\/p>\n<p>\u0417\u0434\u0435\u0441\u044c \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u0436\u0435\u043b\u0435\u0437\u0430 \u0431\u044b\u043b\u0430 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439.<br \/>\n<strong>Master:<\/strong> CPU Intel Xeon E7540 @2.00GHz, RAM 256GB, RAID-10 \u043d\u0430 4-x SSD-\u0434\u0438\u0441\u043a\u0430\u0445 INTEL SSDSA2CW600G3<br \/>\n<strong>Slave:<\/strong> CPU Intel Xeon E5-2650 0 @2.00GHz, RAM 256GB, RAID-10 \u043d\u0430 4-x SSD-\u0434\u0438\u0441\u043a\u0430\u0445 EDGE Boost Pro<\/p>\n<p>\u0423\u0442\u0438\u043b\u0438\u0442\u0443 qpress \u0438 \u0441\u0430\u043c xtrabackup \u0443\u0434\u043e\u0431\u043d\u0435\u0435 \u0432\u0441\u0435\u0433\u043e \u0431\u0440\u0430\u0442\u044c \u0432 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u043c <a href=\"https:\/\/www.percona.com\/downloads\/percona-release\/redhat\/latest\/\" title=\"\u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0439 Percona\" rel=\"nofollow\">\u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438 Percona<\/a>.<\/p>\n<p>\u0414\u0430\u043d\u043d\u044b\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0443 open-source \u0438 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u043c, \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u043f\u0440\u043e\u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d \u043c\u043d\u043e\u0439 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u0445 \u0443\u0441\u043b\u043e\u0432\u0438\u044f\u0445 \u0438 \u0437\u0430\u043c\u0435\u0447\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043a\u0430\u043a \u0434\u043b\u044f \u043f\u0440\u043e\u0441\u0442\u043e\u0433\u043e \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f, \u0442\u0430\u043a \u0438 \u0434\u043b\u044f \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0441 \u0446\u0435\u043b\u044c\u044e \u043f\u043e\u0434\u043d\u044f\u0442\u0438\u044f slave-\u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0434\u043b\u044f \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u044f \u043d\u0430\u0445\u043e\u0436\u0443 Percona xtrabackup \u0432\u0435\u0441\u044c\u043c\u0430 \u0446\u0435\u043d\u043d\u043e\u0439 \u0448\u0442\u0443\u043a\u043e\u0439, \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u044f \u0447\u0442\u043e \u0441\u0430\u043c Oracle \u0441\u043e\u0444\u0442 \u0441 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0437\u0430 \u0434\u0435\u043d\u044c\u0433\u0438.<\/p>\n<p><strong>UPDATE \u043e\u0442 2015-09-10.<\/strong><br \/>\n\u041f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0439 \u0440\u0430\u0437 \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u043f\u043e\u0434\u043d\u044f\u043b slave \u0442\u0430\u043a\u043e\u0439 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e \u043a\u043e\u043c\u0430\u043d\u0434:<\/p>\n<pre lang=\"bash\" class=\"1\">\r\n[avz@slave] mkdir \/tmp\/db\r\n[avz@master] innobackupex --defaults-file=\/etc\/my.cnf --socket=\/var\/lib\/mysql\/mysql.sock --tmpdir=\/tmp --compress --compress-threads=8 --stream=xbstream --parallel=4 --lock-wait-timeout=120 --password=xxxxxx .\/ | ssh avz@slave \"xbstream -x -C \/tmp\/db\"\r\n[avz@slave] for bf in `find \/tmp\/db -iname \"*\\.qp\"`; do echo \"processing $bf\" ; qpress -d $bf $(dirname $bf) && rm -f $bf; done\r\n[avz@slave] innobackupex --defaults-file=\/etc\/my.cnf --apply-log --use-memory=190G \/tmp\/db\r\n[root@slave] # service mysqld stop ; mv \/var\/lib\/mysql \/var\/lib\/mysql.old\r\n[root@slave] # mv \/tmp\/db\/* \/var\/lib\/mysql\r\n[root@slave] # chown -R mysql.mysql \/var\/lib\/mysql\r\n[root@slave] # service mysqld start\r\n<\/pre>\n<p>\u0412\u0435\u0440\u0441\u0438\u044f MySQL: 5.6.23. \u0412\u0435\u0440\u0441\u0438\u044f percona-xtrabackup: 2.2.12. \u0420\u0430\u0437\u043c\u0435\u0440 \u0431\u0430\u0437\u044b 240GB (\u043f\u043e \u0434\u0430\u043d\u043d\u044b\u043c du -sh). \u041e\u0431\u044a\u0435\u043c \u043f\u0430\u043c\u044f\u0442\u0438 \u043d\u0430 \u043c\u0430\u0441\u0442\u0435\u0440\u0435 \u0438 \u0441\u043b\u0435\u0439\u0432\u0435 - 192GB. \u041f\u0440\u043e\u0446\u0435\u0441\u0441 \u0437\u0430\u043d\u044f\u043b \u0447\u0430\u0441\u0430 4. Lock \u0442\u0430\u0431\u043b\u0438\u0446 \u043d\u0430 \u043c\u0430\u0441\u0442\u0435\u0440\u0435 \u043f\u0440\u043e\u0434\u043b\u0438\u043b\u0441\u044f \u0447\u0443\u0442\u044c \u0431\u043e\u043b\u0435\u0435 5-\u0442\u0438 \u043c\u0438\u043d\u0443\u0442:<\/p>\n<pre lang=\"text\">\r\n150907 13:55:32  innobackupex: Executing FLUSH TABLES WITH READ LOCK...\r\n150907 14:00:50  innobackupex: All tables unlocked\r\n<\/pre>\n<p>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 --lock-wait-timeout=120 \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442, \u0447\u0442\u043e xtrabackup \u0431\u0443\u0434\u0435\u0442 \u0436\u0434\u0430\u0442\u044c \u0443\u0434\u043e\u0431\u043d\u044b\u0439 \u043c\u043e\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \"FLUSH TABLES WITH READ LOCK\", \u043a\u043e\u0433\u0434\u0430 \u043d\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u044e\u0449\u0438\u0445\u0441\u044f \u0434\u043b\u0438\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041d\u043e \u0436\u0434\u0430\u0442\u044c \u0442\u0430\u043a\u043e\u0439 \u043c\u043e\u043c\u0435\u043d\u0442 \u043e\u043d \u0431\u0443\u0434\u0435\u0442 \u043d\u0435 \u0431\u043e\u043b\u0435\u0435 120 \u0441\u0435\u043a\u0443\u043d\u0434. \u0415\u0441\u043b\u0438 \u0437\u0430 120 \u0441\u0435\u043a\u0443\u043d\u0434 \u043d\u0435 \u0434\u043e\u0436\u0434\u0435\u0442\u0441\u044f, \u0442\u043e \u043e\u0442\u0432\u0430\u043b\u0438\u0442\u0441\u044f \u0441 \u043e\u0448\u0438\u0431\u043a\u043e\u0439. \u0415\u0441\u043b\u0438 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u043d\u0435 \u0443\u043a\u0430\u0437\u0430\u0442\u044c, \u0442\u043e \"\u0443\u0434\u043e\u0431\u043d\u044b\u0439 \u043c\u043e\u043c\u0435\u043d\u0442\" \u0432\u044b\u0431\u0438\u0440\u0430\u0442\u044c\u0441\u044f \u043d\u0435 \u0431\u0443\u0434\u0435\u0442. \u0412\u044b\u0434\u0435\u0440\u0436\u043a\u0430 \u0438\u0437 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438:<\/p>\n<blockquote><p>Waiting for queries to finish. Good moment to issue a global lock is the moment when there are no long queries running. But waiting for a good moment to issue the global lock for extended period of time isn\u2019t always good approach, as it can extend the time needed for backup to take place. To prevent innobackupex from waiting to issue FLUSH TABLES WITH READ LOCK for too long, new option has been implemented: --lock-wait-timeout option can be used to limit the waiting time. If the good moment to issue the lock did not happen during this time, innobackupex <strong>will give up and exit with an error message<\/strong> and backup will not be taken. Zero value for this option turns off the feature (which is default).\n<\/p><\/blockquote>\n<p><strong>UPDATE \u043e\u0442 2016-07-15.<\/strong><br \/>\n\u0415\u0441\u043b\u0438 \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0438\u043c\u0435\u0442\u044c \u0434\u0435\u043b\u043e \u0441 MySQL \u0432\u0435\u0440\u0441\u0438\u0438 5.7.x, \u0442\u043e \u043d\u0443\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u0430\u043a\u0435\u0442 percona-xtrabackup-24 (\u0430 \u043d\u0435 percona-xtrabackup \u043a\u0430\u043a \u0431\u044b\u043b\u043e \u0440\u0430\u043d\u0435\u0435). \u0415\u0441\u0442\u044c \u0432\u0441\u0435 \u0432 \u0442\u043e\u043c \u0436\u0435 <a href=\"https:\/\/www.percona.com\/downloads\/percona-release\/redhat\/latest\/\" rel=\"nofollow\">\u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438<\/a>.<\/p>\n<div class=\"ac_lix\">\n\u041a\u0441\u0442\u0430\u0442\u0438, \u0435\u0441\u043b\u0438 \u043a\u043e\u043c\u0443 \u043d\u0430\u0434\u043e: \u041d\u0430\u0433\u0440\u0435\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u043a\u0430\u0431\u0435\u043b\u044c \u0434\u043b\u044f \u043e\u0431\u043e\u0433\u0440\u0435\u0432\u0430 \u0432 \u0414\u043e\u043d\u0435\u0446\u043a\u0435, \u041e\u0434\u0435\u0441\u0441\u0435 <a href=\"http:\/\/www.tepliypol.com.ua\/\">tepliypol.com.ua<\/a><\/p>\n<p>\u0418\u043d\u0442\u0435\u0440\u0435\u0441\u0443\u0435\u0442 <a href=\"http:\/\/meatec.ru\/catalog\/provolochno-vyreznye-stanki\/dk77.html\">meatec.ru - \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u044d\u0440\u043e\u0437\u0438\u043e\u043d\u043d\u044b\u0439 \u043f\u0440\u043e\u0432\u043e\u043b\u043e\u0447\u043d\u044b\u0439 \u0441\u0442\u0430\u043d\u043e\u043a<\/a> \u0437\u0432\u043e\u043d\u0438\u0442\u0435: +7 495 626-99-87\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0414\u043b\u044f \u043e\u0447\u0435\u043d\u044c \u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0441\u0440\u0435\u0434\u0441\u0442\u0432 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0431\u0435\u043a\u0430\u043f\u043e\u0432, \u0442\u0430\u043a\u0438\u0445 \u043a\u0430\u043a mysqldump, \u0441\u043e\u043f\u0440\u044f\u0436\u0435\u043d\u043e \u0441 \u0440\u044f\u0434\u043e\u043c \u0442\u0440\u0443\u0434\u043d\u043e\u0441\u0442\u0435\u0439: 1. \u041f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043b\u043e\u0447\u0430\u0442\u0441\u044f \u043d\u0430 \u0437\u0430\u043f\u0438\u0441\u044c --- \u043d\u0430 \u0432\u0440\u0435\u043c\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0431\u0435\u043a\u0430\u043f\u0430 \u043d\u0435\u043b\u044c\u0437\u044f \u043f\u0438\u0441\u0430\u0442\u044c \u0432 \u0431\u0430\u0437\u0443. \u0414\u043b\u044f mission-critical \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u044d\u0442\u043e \u043d\u0435\u043f\u0440\u0438\u0435\u043c\u043b\u0438\u043c\u043e. \u041e\u0434\u043d\u0430\u043a\u043e, \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 InnoDB \u044d\u0442\u043e \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u043c\u043e\u0436\u043d\u043e \u043e\u0431\u043e\u0439\u0442\u0438 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043a\u043b\u044e\u0447\u0430 mysqldump --single-transaction. 2. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,21],"tags":[14,124,139],"class_list":["post-1222","post","type-post","status-publish","format-standard","hentry","category-nix","category-tips-and-tricks","tag-linux","tag-mysql","tag-replication"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/posts\/1222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/comments?post=1222"}],"version-history":[{"count":0,"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/posts\/1222\/revisions"}],"wp:attachment":[{"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/media?parent=1222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/categories?post=1222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avz.org.ua\/wp\/wp-json\/wp\/v2\/tags?post=1222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}