Exam 1z0-908 topic 1 question 18 discussion

For D, https://dev.mysql.com/doc/refman/8.3/en/replication-options-reference.html relay_log_recovery: Whether automatic recovery of relay log files from source at startup is enabled; must be enabled for crash-safe replica. Not F,https://dev.mysql.com/doc/refman/8.3/en/replication-multi-source-configuration.html Sources in a multi-source replication topology can be configured to use either GTID-based replication, or binary log position-based replication.

E. Multi-source replication in MySQL does not attempt to detect or resolve replication conflicts. Conflicts need to be handled by the application or by using other mechanisms outside the scope of multi-source replication. F. Multi-source replication in MySQL 8.0 requires the use of Global Transaction Identifiers (GTID) for replication. GTID helps in uniquely identifying transactions across different servers, which is essential for multi-source replication to work effectively.

The correct answers are: D. It relies on relay_log_recovery for resilient operations. E. It does not attempt to detect or resolve replication conflicts. In a multi-source replication setup, MySQL relies on the relay_log_recovery option to enable or disable automatic relay log recovery just after server startup, which helps in resilient operations. Also, MySQL does not have a built-in mechanism to detect or resolve conflicts if the same data is modified by transactions from different sources. It’s the responsibility of the database administrators to ensure that the data modified by each source is distinct to avoid conflicts.

DE are it