MySQL 8.0 Database Administrator — Question 74

Which three statements are true about MySQL replication? (Choose three.)

Answer options

• A. Replication can use only TCP/IP connections.
• B. Any instance can have multiple slaves, but it can have only one master.
• C. Each instance in a replication topology must have a unique server ID.
• D. Binary logs contain only transactions originating from a single MySQL instance.
• E. Each slave must have its own MySQL user for replication.
• F. Binary logging must be enabled on the master in order to replicate to other instances.
• G. A replication user must have the SELECT privilege for all tables that need to be replicated.

Correct answer: C, F, G

Explanation

Statement C is correct because each MySQL instance must have a unique server ID to avoid conflicts in replication. F is also true, as binary logging must be enabled on the master for replication to occur. G is correct since a replication user must have the necessary SELECT privileges on the tables to be replicated. The other options either present inaccuracies or do not apply universally to MySQL replication.