NetWorker: "binlog" 파일이 없으면 MySQL 백업이 실패함

MySQL 데이터베이스에 "binlog" 파일이 없으면 MySQL 첫 번째 백업이 종료되지 않습니다.

MySQL "binlog" 파일이 없으므로 NetWorker Client는 백업 작업을 계속하지 않습니다.

NetWorker Client에서 NetWorker 로그 파일(기본 위치: /nsr/logs 디렉토리)에서 해당 MySQL 데이터베이스의 "binlog"가 누락되었다고 보고합니다.

mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000331' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000332' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000333' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000334' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000335' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000336' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000337' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000338' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000339' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000340' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.000341' does not exist. It could have been purged. PITR will not be possible from this backup.
  ...
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.004583' does not exist. It could have been purged. PITR will not be possible from this backup.
  mysqlbackup: WARNING: binlog file '/data/mysql/mysql-bin.004584' does not exist. It could have been purged. PITR will not be possible from this backup.
 200901 14:37:32 mysqlbackup: INFO: Copying /data/mysql/mysql-bin.004585. <-- Activity log stuck in this step and backup does not send any new data.The backup job must be canceled manually or wait to timeout (in this case it was after 8 hours running).
 mysqlbackup: Progress in MB: 383400
 mysqlbackup: ERROR: Signal 15 received.

이 문제를 해결하려면 사용 가능한 첫 번째 "binlog"가 나올 때까지 이전에 누락된 모든 "binlog"를 제거합니다.

절차

1. MySQL 서버에 "루트" 사용자로 로그인합니다.

2. MySQL 데이터베이스 콘솔에 연결합니다.

3. 다음 명령을 실행하여 "binlog"의 현재 사용 가능 여부를 확인합니다.

   mysql> show master logs;  <-- Name of the DB that contains the information from the logs missed.
   
   | mysql-bin.004580 |          0 |
   | mysql-bin.004581 |          0 |
   | mysql-bin.004582 |          0 |
   | mysql-bin.004583 |          0 |
   | mysql-bin.004584 |          0 | <-- Last missed log.
   | mysql-bin.004585 | 1064394753 |

4. 다음 명령을 실행하여 사용 가능한 첫 번째 "binlog" 이전에 누락된 모든 "binlog"를 제거합니다.

   참고: 이 경우 "mysql-bin.004585"는 사용 가능한 첫 번째 "binlog"입니다.

   mysql> purge binary logs to 'mysql-bin.004585';
   Query OK, 0 rows affected, 4584 warnings (10.12 sec)

5. 백업 작업을 다시 실행하여 오류 없이 완료되었는지 확인합니다.

   • 백업 작업이 성공했다는 증거(클라이언트 측의 NetWorker 로그에 표시됨):

   200903 09:38:14 mysqlbackup: INFO: Backup image created successfully.
   mysqlbackup: INFO: Image Path = sbt:MYSQL:/MySQLTest
   200903 09:38:14 mysqlbackup: INFO: MySQL binlog position: filename mysql-bin.004957, position 154
   
   -------------------------------------------------------------
      Parameters Summary
   -------------------------------------------------------------
      Start LSN                  : 15597868102656
      End LSN                    : 15597868102712
   -------------------------------------------------------------
   mysqlbackup completed OK! with 2 warnings.