- MySQL OCP 是 Oracle公司提供的面向中、高级DBA人员的技能认证。要考证，私信，oldguo有优惠，获得全套原题及解析。
Question 1:
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication?
A) On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
B) Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT = AUTOMATIC;
C) Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED = on;
D) Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency
E) On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
F) Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;
