Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 35

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

    Correct Answer: C, F

    To implement GTID replication in MySQL, one of the steps is to restart MySQL on both the master and the slave with the GTID mode and other required options enabled. This includes --gtid_mode=ON, --log-bin, --log-slave-updates, and --enforce-gtid-consistency. Additionally, on the slave, the master connection must be set to use auto position, which is done with the command CHANGE MASTER TO MASTER_AUTO_POSITION = 1.

Discussion
marklvOptions: CD

C and maybe D https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html F doesn't start replication. D does. Not sure.

FelipeKOptions: CF

C. Restart MySQL (master and slave) with these options enabled: –gtid_mode=ON –log-bin –log-slave-updates –enforce-gtid-consistency F. On the slave, alter the MySQL master connection setting with: CHANGE MASTER TO MASTER_AUTO_POSITION = 1