MySQL Group Replication & InnoDB Cluster Quiz

1. In Group Replication, which consistency model ensures that a transaction is applied on all members before returning control to the client?

Eventual consistency

Strong consistency (group_replication_consistency = STRONG)

Weak consistency

Eventual strong consistency

2. What is the role of the group_replication_bootstrap_group variable?

Enable parallel query execution

Allow the first member to bootstrap and start the replication group

Configure automatic backup scheduling

Set the replication heartbeat interval

3. Which MySQL Shell command is used to create a new InnoDB Cluster?

Dba.createCluster()

Cluster.createCluster()

Mysql.createCluster()

Shell.createCluster()

4. What is the primary advantage of using InnoDB Cluster over manual Group Replication setup?

Significantly lower hardware requirements

Automated provisioning, monitoring, and management

Better performance on single-server deployments

Reduced need for database backups

5. What is the primary purpose of MySQL Group Replication?

Enable automatic backup of all databases

Provide data consistency and high availability through coordinated replication

Replace traditional master-slave replication entirely

Reduce storage requirements across servers

6. What does the group_replication_flow_control_mode variable regulate?

Replication lag between members

The rate at which transactions are applied on followers

Binary log file size limits

Network bandwidth allocation

7. In InnoDB Cluster, what is the purpose of the metadata schema (_mysql_innodb_cluster_metadata)?

Store user authentication credentials

Track cluster topology, member status, and configuration

Archive binary logs for disaster recovery

Monitor real-time query performance

8. What is the minimum number of members required in a Group Replication cluster to maintain quorum?

1

2

3

5

9. Which component of InnoDB Cluster is responsible for directing client connections to appropriate cluster members?

MySQL Shell

MySQL Router

Group Replication Manager

InnoDB Storage Engine

10. What does InnoDB Cluster automatically manage that a standalone Group Replication setup requires manual configuration for?

Database backup scheduling

MySQL Shell connectivity and routing

Router provisioning, metadata, and topology awareness

Binary log rotation

11. Which system variable controls the maximum number of parallel applier threads in Group Replication?

Slave_parallel_workers

Group_replication_parallel_appliers

Slave_parallel_max_threads

Group_replication_applier_threads

12. Which Group Replication mode allows transactions to commit even if a member becomes unreachable?

Single-primary mode

Multi-primary mode

Quorum-free mode

Asynchronous mode

13. In Group Replication, a member enters which state when it is joining the replication group but has not yet caught up?

OFFLINE

RECOVERING

ONLINE

ERROR

14. In single-primary Group Replication mode, which member handles all write transactions?

The member with the lowest server ID

The designated primary member

All members simultaneously

Randomly selected members

15. What does the group_replication_single_primary_mode variable control?

Whether only one member can serve read queries

Whether the group operates in single-primary or multi-primary mode

The timeout for detecting primary member failure

The replication lag threshold

16. In Group Replication, what happens when a member detects a network partition and becomes isolated?

It continues processing transactions normally

It enters RECOVERING state indefinitely

It goes offline if it cannot reach a quorum

It automatically promotes itself to primary

17. In Group Replication, which consistency mode offers the best performance but may result in temporary inconsistency?

STRONG

BEFORE_ON_PRIMARY_FAILOVER

EVENTUAL

SYNCHRONOUS

18. What is the primary function of the group_replication_group_seeds variable?

Define which members can join the replication group

Specify the seed members for initial group communication

Set the authentication credentials for group members

Configure automatic failover priorities

19. In InnoDB Cluster, MySQL Router uses which protocol to communicate with cluster members?

HTTP

X Protocol (X DevAPI)

MQTT

GRPC

20. In Group Replication, which plugin must be installed on all cluster members?

Mysql_native_password

Group_replication

Innodb_cluster_manager

Replication_heartbeat

MySQL DBA Group Replication and InnoDB Cluster Quiz