nerdexam
Oracle

1Z0-908 · Question #81

An existing asynchronous replication setup is running MySQL 8. Which two steps are a part of implementing GTID replication? (Choose two.)

The correct answer is C. Restart MySQL (master and slave) with these options enabled: F. On the slave, alter the MySQL master connection setting with. https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html

Replication

Question

An existing asynchronous replication setup is running MySQL 8. Which two steps are a part of implementing GTID replication? (Choose two.)

Options

  • AEnable GTID by executing this on the master and the slave:
  • BExecute this on the slave to enable GTID:
  • CRestart MySQL (master and slave) with these options enabled:
  • DExecute this on the slave to enable GTID:
  • EOn the slave, alter the MySQL master connection setting with:
  • FOn the slave, alter the MySQL master connection setting with:

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    11% (3)
  • C
    81% (22)
  • D
    4% (1)

Explanation

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html

Topics

#GTID replication#gtid_mode#CHANGE MASTER TO#replication setup

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice