Oracle Exam 1Z0-908 Topic 12 Question 29 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 29
Topic #: 12

An existing asynchronous replication setup is running MySQL 8.

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

AEnable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;

BExecute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;

CRestart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency

DExecute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

EOn the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

FOn the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Show Suggested Answer

Suggested Answer: C, F

by Dean at May 09, 2022, 07:04 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!