An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;
Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;
Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
Submit