nerdexam
Oracle

1Z0-908 · Question #37

You reconfigure and start a slave that was not replicating for several days. The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave…

The correct answer is A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-. https://bugs.mysql.com/bug.php?id=86643

Replication

Question

You reconfigure and start a slave that was not replicating for several days. The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

Exhibit

1Z0-908 question #37 exhibit

Options

  • AReplication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-
  • BReplication will fail because the master does not have the required transaction with bbbbbbbb-
  • CReplication will fail because the master has already purged transactions with cccccccc-cccc-cccc-
  • DReplication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc
  • EReplication will work.

How the community answered

(47 responses)
  • A
    68% (32)
  • B
    11% (5)
  • C
    2% (1)
  • D
    4% (2)
  • E
    15% (7)

Explanation

https://bugs.mysql.com/bug.php?id=86643

Topics

#GTID replication#gtid_purged#binary log purge#replication failure diagnosis

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice