Which three statements correctly describe MySQL InnoDB Cluster?

Question

Options

• AThe cluster can be operated in multimaster mode with conflict detection for DML statements.
• BAll MySQL client programs and connectors can be used for executing queries.
• CIt provides fully synchronous replication between the nodes.
• DThere is support for automatic failover when one node fails.
• EThe data is automatically shared between the nodes.
• FEach query will be executed in parallel across the nodes.

• A
  4% (2)
• B
  71% (36)
• C
  6% (3)
• E
  20% (10)

Explanation

Note: The stated correct answer (B, D, F) appears to be incorrect. Based on MySQL InnoDB Cluster's actual behavior, the correct answers should be A, B, D. Here's why:

Why A, B, and D are correct:

• A - InnoDB Cluster can run in multi-primary (multi-master) mode via Group Replication, which includes built-in write conflict detection to handle concurrent DML on the same rows.
• B - MySQL Router sits transparently in front of the cluster, so all standard MySQL clients and connectors work without modification.
• D - Automatic failover is a core feature: when the primary node fails, MySQL Router and Group Replication elect a new primary and redirect traffic automatically.

Why the distractors (and F) are wrong:

• C - Group Replication is virtually synchronous (certification-based), not fully synchronous. The apply phase is asynchronous across nodes.
• E - InnoDB Cluster is a replication solution (every node has all the data), not a sharding solution. "Shared between nodes" implies sharding, which is MySQL NDB Cluster, not InnoDB Cluster.
• F - Individual queries are not split and executed in parallel across nodes. That describes MPP databases (like Greenplum or Redshift). InnoDB Cluster routes a query to one node.

Memory tip: Think of InnoDB Cluster as "smart replication + automatic routing" - it's about availability and failover, not parallelism or sharding. If an answer suggests data splitting or query distribution, it's describing the wrong product (NDB Cluster or a data warehouse).

No community discussion yet for this question.