An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
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.
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.
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