[CASSANDRA-15921] 4.0 quality testing: Materialized View

• Type: Task
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Materialized Views
• Epic Link: 40_Quality_Test
• Change Category: Quality Assurance
• Complexity: Normal
• Platform: All
• Assignee: Zhao Yang
• Reporter: Zhao Yang

Authors

Zhao Yang

• Created: 03/Jul/20 09:02
• Updated: 07/Mar/23 10:54

Description

The main purpose of this ticket to get a better understanding about 4.0 MV status as a guideline for future improvements. I don't think it should block 4.0 release since it's already marked as experimental.

Main areas to test:

• Write perf: We expect to see 10% write throughput drop per MV added.
  • Attached C40_MV.png is alpha-4, 5-node, rf3 MV write tests: with 1 mv, throughput dropped 50%
• Read perf: identical to normal table
• Bootstrap/Decommision: no write-path required since CASSANDRA-13065
• Repair: write path required
• Chaos monkey: take down coordinator/base-replica/view-replica during read/write/token-movement and verify data consistency (may need a tool)
• Hint Replay: able to throttle if table has MV - CASSANDRA-13810
• Schema race: create/drop - CASSANDRA-15845/CASSANDRA-15918

Issue Links

• is a parent of: CASSANDRA-13810 Overload because of hint pressure + MVs
• is a parent of: CASSANDRA-12783 Break up large MV mutations to prevent OOMs
• is a parent of: CASSANDRA-12888 Incremental repairs broken for MVs and CDC
• is a parent of: CASSANDRA-14168 Throw error when attempting to mutate non-existant table
• is a parent of: CASSANDRA-12734 Materialized View schema file for snapshots created as tables
• is a parent of: CASSANDRA-16175 Avoid removing batch when it's not created during view replication
• is a parent of: CASSANDRA-16172 materialized view can return stale data even with R+W>N
• is a parent of: CASSANDRA-16174 During bootstrap streaming, skipping write path may create orphan MV rows
• is related to: CASSANDRA-16076 Batch schema statements to create multiple SASI and MV at once to reduce disk IO
• is related to: CASSANDRA-13826 Specialize row structure to support complex Materialized Views liveness