Which two statements are true about MySQL server multi-source replication? (Choose two.)
Which two statements are true about MySQL server multi-source replication? (Choose two.)
Multi-source replication in MySQL relies on relay_log_recovery for resilient operations. This option enables automatic recovery of relay log files from the source at startup, ensuring crash-safe replicas. Additionally, MySQL multi-source replication does not attempt to detect or resolve replication conflicts inherently. Conflicts need to be handled by the application or other mechanisms, as MySQL lacks built-in conflict resolution capabilities.
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
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.