Spec-Zone.ru › MySQL Enterprise Backup 9.2

4.2.2 Архивирование всего экземпляра MySQL

На следующем рисунке мы архивируем весь экземпляр MySQL в один файл, используя команду backup-to-image, которая отображается в конце примера команды. Мы указываем некоторые сведения о подключении к базе данных, используя параметры --user и --host (и, с помощью параметра --password, просим mysqlbackup запросить пароль пользователя). Местоположение и имя файла для архива одного файла указываются с помощью параметра --backup-image, а местоположение для пустой папки для хранения временных файлов предоставляется с помощью параметра --backup-dir.

Вывод отражает все параметры, используемые операцией архивирования, включая несколько, которые автоматически извлекаются с помощью подключения к базе данных. Уникальный идентификатор этой задачи архивирования записывается в специальные таблицы, которые mysqlbackup создает внутри экземпляра MySQL, позволяя отслеживать длительные архивации и просматривать информацию о предыдущих архивах. Заключительная часть вывода повторяет местоположение данных архива и предоставляет значения, которые вы можете использовать, когда будете выполнять следующее архивирование уже созданного.

$ mysqlbackup --user=mysqlbackup --password --host=127.0.0.1 --backup-dir=/home/meb/mysql/backup-temp \
   --backup-image=/home/meb/mysql/backups/testback3.mbi --with-timestamp backup-to-image
MySQL Enterprise Backup  Ver 8.4.0-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starting with following command line ...
mysqlbackup
--user=mysqlbackup
--password
--host=127.0.0.1
--backup-dir=/home/meb/mysql/backup-temp
--backup-image=/home/meb/mysql/backups/testback3.mbi
--with-timestamp
backup-to-image

IMPORTANT: Please check that mysqlbackup run completes successfully.
           At the end of a successful 'backup-to-image' run mysqlbackup
           prints "mysqlbackup completed OK!".

Enter password:
240426 13:01:23 MAIN     INFO: Establishing connection to server.
240426 13:01:23 MAIN     INFO: No SSL options specified.
240426 13:01:23 MAIN     INFO: MySQL server version is '8.4.0-commercial'
240426 13:01:23 MAIN     INFO: MySQL server compile os version is 'Linux'
240426 13:01:23 MAIN     INFO: SSL/TLS version used for connection is TLSv1.3
240426 13:01:23 MAIN     INFO: Got some server configuration information from running server.

240426 13:01:23 MAIN     INFO: Establishing connection to server for locking.
240426 13:01:23 MAIN     INFO: No SSL options specified.
240426 13:01:23 MAIN     INFO: Backup directory created: '/home/meb/mysql/backup-temp/2024-04-26_13-01-23'
240426 13:01:23 MAIN     INFO: MySQL server version_comment is 'MySQL Enterprise Server - Commercial'
240426 13:01:23 MAIN     INFO: Mysqlbackup component not installed.
240426 13:01:23 MAIN     INFO: MEB logfile created at /home/meb/mysql/backup-temp/2024-04-26_13-01-23/meta/MEB_2024-04-26.13-01-23_backup-to-image.log

240426 13:01:23 MAIN     INFO: The MySQL server has no active keyring.
--------------------------------------------------------------------
                       Server Repository Options:
--------------------------------------------------------------------
  datadir                        = /home/admin/mysql/mysql-datadir/
  innodb_data_home_dir           =
  innodb_data_file_path          = ibdata1:12M:autoextend
  innodb_log_group_home_dir      = /home/admin/mysql/mysql-datadir/
  innodb_undo_directory          = /home/admin/mysql/mysql-datadir/
  innodb_undo_tablespaces        = 2
  innodb_buffer_pool_filename    = ib_buffer_pool
  innodb_page_size               = 16384
  innodb_checksum_algorithm      = crc32

--------------------------------------------------------------------
                       Backup Config Options:
--------------------------------------------------------------------
  datadir                        = /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir
  innodb_data_home_dir           = /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir
  innodb_data_file_path          = ibdata1:12M:autoextend
  innodb_log_group_home_dir      = /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir
  innodb_undo_directory          = /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir
  innodb_undo_tablespaces        = 2
  innodb_buffer_pool_filename    = ib_buffer_pool
  innodb_page_size               = 16384
  innodb_checksum_algorithm      = crc32

Backup Image Path = /home/meb/mysql/backups/testback3.mbi
240426 13:01:23 MAIN     INFO: Unique generated backup id for this is 17141508838810794

240426 13:01:23 MAIN     INFO: Copying the server config file '/home/admin/mysql/mysql-datadir/auto.cnf'
240426 13:01:23 MAIN     INFO: Creating 14 buffers each of size 16777216.
240426 13:01:23 MAIN     INFO: The server is not configured for redo log archiving. The system variable innodb_redo_log_archive_dirs is not set.
240426 13:01:23 MAIN     INFO: Found checkpoint at lsn 20525419.
240426 13:01:23 MAIN     INFO: Starting log scan from lsn = 20525056 at offset = 870763 and checkpoint = 20525419 in file /home/admin/mysql/mysql-datadir/#innodb_redo/#ib_redo6.
240426 13:01:23 MAIN     INFO: Full Image Backup operation starts with following threads
                               1 read-threads    6 process-threads    1 write-threads
240426 13:01:23 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/backup-my.cnf.
240426 13:01:23 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/meta/backup_create.xml.
240426 13:01:23 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir/backup-auto.cnf.
240426 13:01:23 RLP1     INFO: Starting to parse redo log at lsn = 20525297, whereas checkpoint_lsn = 20525419 and start_lsn = 20525056.
240426 13:01:23 RDR1     INFO: Starting to copy all innodb files...
240426 13:01:23 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/ibdata1.
240426 13:01:24 RDR1     INFO: Starting to copy all undo files...
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/undo_002.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/undo_001.
240426 13:01:24 RDR1     INFO: Starting to lock instance for backup...
240426 13:01:24 RDR1     INFO: The server instance is locked for backup.
240426 13:01:24 RDR1     INFO: The server instance is unlocked after 0.003 seconds.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/sys/sys_config.ibd.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/pets/cats.ibd.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/mysql/backup_progress.ibd.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/mysql/backup_history.ibd.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/mysql.ibd.
240426 13:01:24 RDR1     INFO: Completing the copy of innodb files.
240426 13:01:24 RDR1     INFO: Requesting a dump of the InnoDB buffer pool
240426 13:01:24 RDR1     INFO: Waiting for the dump of the InnoDB buffer pool to complete
240426 13:01:24 RDR1     INFO: The dump of the InnoDB buffer pool completed
240426 13:01:24 RDR1     INFO: Binary Log Basename: '/home/admin/mysql/mysql-datadir/binlog'
240426 13:01:24 RDR1     INFO: Binary Log Index:    '/home/admin/mysql/mysql-datadir/binlog.index'
240426 13:01:24 RDR1     INFO: Relay Channel:      'group_replication_applier'
240426 13:01:24 RDR1     INFO: Relay Log Basename: '/home/admin/mysql/mysql-datadir/admin-XBox3-relay-bin-group_replication_applier'
240426 13:01:24 RDR1     INFO: Relay Channel:      'group_replication_recovery'
240426 13:01:24 RDR1     INFO: Relay Log Basename: '/home/admin/mysql/mysql-datadir/admin-XBox3-relay-bin-group_replication_recovery'
240426 13:01:24 RDR1     INFO: Starting to copy Binlog files.
240426 13:01:24 RDR1     INFO: Starting to lock instance for backup...
240426 13:01:24 RDR1     INFO: The server instance is locked for backup.
240426 13:01:24 RDR1     INFO: The MySQL server has no active keyring.
240426 13:01:24 RDR1     INFO: Requesting flush of redo log reading after LSN 20530626.
240426 13:01:24 RDR1     INFO: Requesting flush of redo log processing after LSN 20530626.
240426 13:01:24 RDR1     INFO: Completed flush of redo log reading after LSN 20531088.
240426 13:01:24 RDR1     INFO: Completed flush of redo log processing after LSN 20531088.
240426 13:01:24 RDR1     INFO: Starting to read-lock tables...
240426 13:01:24 RDR1     INFO: No tables to read-lock.
240426 13:01:24 RDR1     INFO: Opening backup source directory '/home/admin/mysql/mysql-datadir'
240426 13:01:24 RDR1     INFO: Starting to copy non-innodb files in subdirs of '/home/admin/mysql/mysql-datadir'
240426 13:01:24 WTR1     INFO: Adding database directory: datadir/mysql
240426 13:01:24 WTR1     INFO: Adding database directory: datadir/performance_schema
240426 13:01:24 RDR1     INFO: Completing the copy of all non-innodb files.
240426 13:01:24 WTR1     INFO: Adding database directory: datadir/pets
240426 13:01:24 WTR1     INFO: Adding database directory: datadir/sys
240426 13:01:24 RDR1     INFO: Requesting consistency information...
240426 13:01:24 RDR1     INFO: Locked the consistency point for 1902 microseconds.
240426 13:01:24 RDR1     INFO: Consistency point server_uuid 'c6d42eaa-03e9-11ef-ae5e-0800276c22b0'.
240426 13:01:24 RDR1     INFO: Consistency point gtid_executed ''.
240426 13:01:24 RDR1     INFO: Consistency point binary_log_file 'binlog.000001'.
240426 13:01:24 RDR1     INFO: Consistency point binary_log_position 3807.
240426 13:01:24 RDR1     INFO: Consistency point InnoDB lsn 20531571.
240426 13:01:24 RDR1     INFO: Consistency point InnoDB lsn_checkpoint 20525419.
240426 13:01:24 RDR1     INFO: Requesting completion of redo log copy after LSN 20531571.
240426 13:01:24 RLW1     INFO: A copied database page was modified at 20529721. (This is the highest lsn found on a page)
240426 13:01:24 RLW1     INFO: Scanned log up to lsn 20531571.
240426 13:01:24 RLW1     INFO: Was able to parse the log up to lsn 20531571.
240426 13:01:24 RLW1     INFO: Copied redo log
                               log_start_lsn    20525056
                               start_checkpoint 20525419
                               start_lsn        20525419
                               last_checkpoint  20525419
                               consistency_lsn  20531571
                               log_end_lsn      20531571
240426 13:01:24 RLR1     INFO: Redo log reader waited 87 times for a total of 435.00 ms for logs to generate.
240426 13:01:24 RDR1     INFO: Truncating binary log index '/home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir/binlog.index' to 16.
240426 13:01:24 RDR1     INFO: Truncating binary log 'binlog.000001' to 3807.
240426 13:01:24 RDR1     INFO: Copying /home/admin/mysql/mysql-datadir/binlog.000001.
240426 13:01:24 RDR1     INFO: Completed the copy of binlog files...
240426 13:01:24 RDR1     INFO: The server instance is unlocked after 0.130 seconds.
240426 13:01:24 RDR1     INFO: Reading all global variables from the server.
240426 13:01:24 RDR1     INFO: Completed reading of all 623 global variables from the server.
240426 13:01:24 RDR1     INFO: Writing server defaults files 'server-my.cnf' and 'server-all.cnf' for server '8.4.0-commercial' in '/home/meb/mysql/backup-temp/2024-04-26_13-01-23'.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/meta/backup_variables.txt.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/datadir/ibbackup_logfile.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/server-all.cnf.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/server-my.cnf.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/meta/backup_content.xml.
240426 13:01:24 RDR1     INFO: Copying meta file /home/meb/mysql/backup-temp/2024-04-26_13-01-23/meta/image_files.xml.
240426 13:01:24 MAIN     INFO: Full Image Backup operation completed successfully.
240426 13:01:24 MAIN     INFO: Backup image created successfully.
240426 13:01:24 MAIN     INFO: Image Path = /home/meb/mysql/backups/testback3.mbi
240426 13:01:24 MAIN     INFO: MySQL binlog position: filename binlog.000001, position 3807.

-------------------------------------------------------------
   Parameters Summary
-------------------------------------------------------------
   Start LSN                  : 20525056
   Last Checkpoint LSN        : 20525419
   End LSN                    : 20531571
-------------------------------------------------------------

mysqlbackup completed OK!

© 2025 Oracle
Licensed under the GPLv2 License.
https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-8.4-en/mysqlbackup.backup.html

Spec-Zone.ru

Настройки Оффлайн Что нового Помощь О нас
Spec-Zone .ru
спецификации, руководства, описания, API