1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ204

Installation and Configuration

You must configure multi-source replication with GTIDs enabled.

You use mysqldump to create the slave.

Which two statements are correct?

Choose two
  • A You must restore each dump file and execute RESET MASTER on the slave.
  • B You must restore each dump sequentially with the exact included gtid_purged statement.
  • C You must execute multiple CHANGE MASTER statements to create replication channels.
  • D You must always have all or no channels active to maintain a consistent gtid_purged.
  • E You must execute a single CHANGE MASTER statement to create the replication channels.
  • F You must apply the gtid_purged values manually on the slave to start replication.
Explanation

GTID-based multi-source replication requires a separate replication channel for every source, configured using a separate CHANGE MASTER TO statement. When provisioning from multiple mysqldump files, the gtid_purged statement in each dump cannot be applied as-is; after importing appropriately edited dumps, gtid_purged must be manually set on the replica to the union of the GTID sets from all sources.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!