MySQL 8.0 Database Administrator — Question 121

Which two statements are true about MySQL server multi-source replication? (Choose two.)

Answer options

• A. It is not compatible with auto-positioning.
• B. It needs to be re-instanced after a crash to maintain consistency.
• C. It uses only time-based replication conflict resolution.
• D. It relies on relay_log_recovery for resilient operations.
• E. It does not attempt to detect or resolve replication conflicts.
• F. It must use GTID replication.

Correct answer: D, E

Explanation

Option D is correct because multi-source replication utilizes relay_log_recovery to ensure operations remain resilient. Option E is also correct since this type of replication does not attempt to detect or resolve conflicts. The other options are incorrect as they misrepresent the functionalities and requirements of MySQL server multi-source replication.