MySQL 8.0 Database Administrator — Question 45

Which three requirements must be enabled for group replication? (Choose three.)

Answer options

• A. slave updates logging
• B. semi-sync replication plugin
• C. primary key or primary key equivalent on every table
• D. binary log checksum
• E. binary log ROW format
• F. binary log MIXED format
• G. replication filters

Correct answer: B, C, G

Explanation

The semi-sync replication plugin (B) ensures that transactions are acknowledged by the majority of nodes before proceeding. A primary key or its equivalent (C) is essential for ensuring data consistency across the group. Replication filters (G) are needed to control which data is replicated. The other options do not meet the specific requirements for enabling group replication.