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
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)- A68% (32)
- B11% (5)
- C2% (1)
- D4% (2)
- E15% (7)
Explanation
Topics
#GTID replication#gtid_purged#binary log purge#replication failure diagnosis
Community Discussion
No community discussion yet for this question.
