Exam 1z0-908 topic 1 question 35 discussion

Actual exam question from Oracle's 1z0-908

Question #: 35
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;

Show Suggested Answer

Suggested Answer: CF 🗳️

by FelipeK at Oct. 15, 2023, 7:01 p.m.

Comments

Submit Cancel

marklv

7 months, 4 weeks ago

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.

upvoted 1 times

...

FelipeK

9 months, 3 weeks ago

Selected Answer: CF

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

upvoted 1 times

...

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Exam 1z0-908 topic 1 question 35 discussion

Comments

marklv

FelipeK

SY0-701