Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 2 Topic 1 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 2 Topic 1 Discussion

1z0-908 Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 1

An existing asynchronous replication setup is running MySQL 8.

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


A.

Enable GTID by executing this on the master and the slave:

SET GLOBAL GTID_ENABLED=on;


B.

Execute this on the slave to enable GTID:

START SLAVE IO_THREAD WITH GTID;


C.

Restart MySQL (master and slave) with these options enabled:

--gtid_mode=ON

--log-bin

--log-slave-updates

--enforce-gtid-consistency


D.

Execute this on the slave to enable GTID:

RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;


E.

On the slave, alter the MySQL master connection setting with:

ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;


F.

On the slave, alter the MySQL master connection setting with:

CHANGE MASTER TO MASTER_AUTO_POSITION = 1;


Get Premium 1z0-908 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.